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

Style Sheet templates are stored in which class





Correct Option: C

Class name can be maximum of

  1. 32 characters

  2. 64 characters

  3. 128 characters

  4. No length restriction

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

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

ETL lifecycle includes which of the following task-type?

  1. Data Validation

  2. Data Mining

  3. Report Generation

  4. Data Modeling

Correct Option: A

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

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

  1. True

  2. False

Correct Option: B

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

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

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

  1. Mapplet

  2. Transformations

  3. Mapping

  4. Task

Correct Option: D

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

  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

Informatica PowerCenter can read data from an MS SQL database?

  1. True

  2. False

Correct Option: B

Which of the following is a Passive Transformation

  1. Aggregator

  2. Expression

  3. Normalizer

  4. Filter

Correct Option: 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

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

Xcelsius Enterprise was originally introduced by

  1. SAP

  2. BO

  3. Infommersion

  4. All the Above

Correct Option: C

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

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

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
- Hide questions