0
Alien head

platforms and products Online Quiz - 58

Description: platforms and products Online Quiz - 58
Number of Questions: 20
Created by:
Tags: platforms and products
Attempted 0/20 Correct 0 Score 0

Select the possible connectivity methods for Xcelsius Engage used by Business Objects customers, from the available list.

  1. Query as a Web Service (QaaWS)

  2. Live Office

  3. InfoBurst-XDS

  4. All the above


Correct Option: D

Which among the following are possible data sources for Xcelsius Engage?

  1. Microsoft Excel

  2. XML databases

  3. SOAP-based Web services

  4. All the above


Correct Option: D

Xcelsius Engage provides end users with access to up-to-the-minute company data in a simple and actionable interface.

  1. True

  2. False


Correct Option: A

Xcelsius Enterprise was originally introduced by

  1. SAP

  2. BO

  3. Infommersion

  4. All the Above


Correct Option: C

The concept of ETL is mainly useful in

  1. High performance decision support environments

  2. Master Data Management hubs

  3. Online Transaction processing

  4. All the above


Correct Option: A,B

Data loading performance can be improved by

  1. Reducing the number of transformations

  2. Using conditional filters

  3. Droping Indexes & Key Constraints before loading

  4. Using Multi - pass reads from source


Correct Option: A,B,C

Which of the following is a Passive Transformation

  1. Aggregator

  2. Expression

  3. Normalizer

  4. Filter


Correct Option: B

Informatica PowerCenter can read data from an MS SQL database?

  1. True

  2. False


Correct Option: B

Enterprise Information Integration is described by

  1. the capability to access data from any source, regardless of format or system

  2. The ability to access data without proper authorization

  3. The ability to store data in one source without it being accessible to other systems

  4. The ability to manipulate data remotely


Correct Option: A

Filter Transformation is better than Router Transformation to direct the data to multiple output groups

  1. True

  2. False


Correct Option: B

Identify the Component that cannot be created in Powercenter's Mapping Designer

  1. Mapplet

  2. Transformations

  3. Mapping

  4. Task


Correct Option: D

Which one of the following doesn’t represent a 'Transform' component of ETL?

  1. Rounding decimal values to Integers

  2. Removing special characters from a Text field

  3. Defining Primary Key constraint on a Table

  4. Assigning a default value to a field.


Correct Option: C

Informatica PowerCenter's Workflow Monitor doesn’t support which of the following task?

  1. Start a Workflow

  2. Check Session Logs

  3. Delete Informatica Code Components

  4. Check Workflow status


Correct Option: C

A single Source qualifier can be used to pull the data from multiple Databases

  1. True

  2. False


Correct Option: B

Select ALL that are in scope of coding & unit testing for an ETL job

  1. Validation of all negative scenarios like handling of incorrect data type

  2. Testing the boundaries of each field to find any limitations

  3. Job not to be aborted at any cause - all abort scenarios must be handled in the code

  4. Cleansing of obvious data for any anomalies (even if its not specified in requirements)

  5. None of the above


Correct Option: A,B

ETL lifecycle includes which of the following task-type?

  1. Data Validation

  2. Data Mining

  3. Report Generation

  4. Data Modeling


Correct Option: A

According to Ten Guard Rails of PRPC,application performance need to be monitored

  1. Daily

  2. Weekly

  3. Monthly

  4. Once in 3 months


Correct Option: B

For short medium lists which change often following should be specified in TableEdit tab of Property

  1. Local List

  2. Field Value

  3. Remote List

  4. Prompt List


Correct Option: B

Class name can be maximum of

  1. 32 characters

  2. 64 characters

  3. 128 characters

  4. No length restriction


Correct Option: B

Style Sheet templates are stored in which class

  1. RULE-FILE-STYLE

  2. RULE-FILE-CSS

  3. RULE-FILE-TEXT

  4. RULE-FILE-BINARY


Correct Option: C
+ View questions