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

Question 1

Which of the following is true of transformation model derivations?

A. They can be used as sources for an attribute element.

B. They can be created within a static member.

C. They can consist of a string literal.

D. They can be used as sources for a measure element.

Correct Answer: C

Question 2

Below, what does Unknown Class (?Class) represent?

A. Recursive level

B. Literal

C. Foster parent

D. Manual level

Correct Answer: C

Question 3

A developer wants to ensure that the business keys in incoming source data are replaced with surrogate keys in the fact tables. To do this, what must be modified?

A. Connection properties

B. Hierarchy properties

C. Template properties

D. Fact build properties

Correct Answer: C

Question 4

A developer has created a derivation in a data source. When will this derivation be calculated?

A. After each row has been moved into the DataStream.

B. As each row is retrieved from the data source.

C. After the source data is pivoted, but before it is merged and aggregated.

D. Before the source data is pivoted, but after it is merged and aggregated.

Correct Answer: B

Question 5

Which of the following is are characteristics of surrogate keys? (choose three)

A. Have no intrinsic meaning.

B. Are text-based.

C. Are replaced by business keys in the data warehouse.

D. Are numbers.

E. Tend to be larger than keys from operational systems.

F. Are unique.

Correct Answer: A,D,F

Question 6

What can Data Manager be used for?

A. To create a content store.

B. To create a metric store.

C. To extract operational data from multiple sources.

D. To build an IBM Cognos Planning application.

Correct Answer: C

Question 7

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 8

During execution, a fact build generated the following messages in the log file:

What can be done to avoid seeing the last three lines when the build is executed again?

A. Increase the amount of working memory (in megabytes).

B. Decrease the size of the page pool.

C. Disable audit logging.

D. Increase the initial size of the hash table.

Correct Answer: D

Question 9

What is depicted below?

A. How the items in the DataStream will be output to the columns of a fact table.

B. How the elements of the transformation model will be output to the columns of a fact table.

C. How the columns of the data source map to the elements of the transformation model.

D. How the elements of the transformation model will be output to the columns of a dimension table.

E. How the items in the DataStream will be output to the columns of a dimension table.

Correct Answer: C

Welcome to TestSimulate

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