IBM Cognos 10 BI Data Warehouse Developer (C2090-625) Free Practice Test

Question 1

The following hierarchy has been created:

Before executing the dimension build, the developer wants to ensure that duplicate rows are
excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data sources will be executed in series. What should be done?

A. Specify that duplicate rows are to be rejected on the Features tab of the hierarchy's properties.

B. Modify the SQL statement for the dimension build to use the SELECT DISTINCT clause.

C. Create a data integrity lookup for the hierarchy that will flag duplicate rows at each level.

D. Specify that duplicate rows are to be rejected on the Audit tab of the dimension build's properties.

Correct Answer: A

Question 2

Which of the following is a use for a fact build?

A. To deliver fact data into a metadata star.

B. To acquire and transform transactional data.

C. To automate tasks related to the build process.

D. To deliver fact data into a dimensional framework.

Correct Answer: B

Question 3

Incoming records show the number of drink packs sold by date. This information is referenced by lookups. Each drink pack contains two or more individual drinks. The developer wants to add a column to the fact table that shows how many individual drinks have been sold, not how many drink packs have been sold. What should be created to accomplish this?

A. Derived dimension

B. Data source derivation

C. DataStream derivation

D. Derived measure

Correct Answer: A

Question 4

In which Data Manager object does a developer specify the attributes of a conformed dimension, such as the surrogate keys that it contains?

A. Transformation model

B. Connection

C. Reference dimension

D. Template

Correct Answer: D

Question 5

A developer has created a date hierarchy using the Date Hierarchy wizard. Which of the following is true of all the members in this hierarchy?

A. All are retrieved from a flat file using SQL.

B. All are static and are physically stored in the catalog.

C. All are retrieved from a database table using SQL.

D. All are dynamic and are physically stored in the catalog.

Correct Answer: B

Question 6

Where can a variable be declared?

A. In a data source connection.

B. In a hierarchy.

C. In a Data Manager folder.

D. In a build specification.

Correct Answer: D

Question 7

A developer has created a fact build with two fact deliveries. What should be done to include only some of the elements of the transformation model in one of the deliveries, and some in the other delivery?

A. Create an output filter to exclude the relevant elements from each delivery.

B. Create a level filter to exclude the relevant elements from each delivery.

C. Modify the SQL to exclude the relevant elements from each delivery.

D. Modify the properties of each fact delivery to exclude the relevant elements.

Correct Answer: D

Question 8

Some incoming fact data has invalid product codes. The developer wants to accept this fact data and assign the necessary surrogate keys in the dimension table. What can be done to accomplish this?

A. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.

B. Accept unmatched member identifiers in the measure element properties.

C. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.

D. Modify the SQL for the reference structure to exclude the missing product codes.

Correct Answer: C

Question 9

A fact build has been created that will extract data for all of Europe. All of the data will be delivered to fact tables. The developer wants to direct United Kingdom-specific data into its own fact table. What must be created on the fact delivery?

A. Level filter

B. Data source filter

C. DataStream filter

D. Output filter

Correct Answer: D

Welcome to TestSimulate

IBM Cognos 10 BI Data Warehouse Developer (C2090-625) Free Practice Test