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

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

Answer: 4

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

Answer: 4

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

  1. True

  2. False

Answer: 1

Xcelsius Enterprise was originally introduced by

  1. SAP

  2. BO

  3. Infommersion

  4. All the Above

Answer: 3

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

Answer: 1,2

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

Answer: 1,2,3

Which of the following is a Passive Transformation

  1. Aggregator

  2. Expression

  3. Normalizer

  4. Filter

Answer: 2

Informatica PowerCenter can read data from an MS SQL database?

  1. True

  2. False

Answer: 2

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

Answer: 1

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

  1. True

  2. False

Answer: 2

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

  1. Mapplet

  2. Transformations

  3. Mapping

  4. Task

Answer: 4

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.

Answer: 3

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

Answer: 3

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

  1. True

  2. False

Answer: 2

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

Answer: 1,2

ETL lifecycle includes which of the following task-type?

  1. Data Validation

  2. Data Mining

  3. Report Generation

  4. Data Modeling

Answer: 1

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

  1. Daily

  2. Weekly

  3. Monthly

  4. Once in 3 months

Answer: 2

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

Answer: 2

Class name can be maximum of

  1. 32 characters

  2. 64 characters

  3. 128 characters

  4. No length restriction

Answer: 2

Style Sheet templates are stored in which class

  1. RULE-FILE-STYLE

  2. RULE-FILE-CSS

  3. RULE-FILE-TEXT

  4. RULE-FILE-BINARY

Answer: 3
+ View questions