IBM Cognos 10 BI Data Warehouse Developer - C2090-625 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A fact build is being manually created. What must the developer do to deliver the fact data to a relational table?

A. Add a relational table delivery module to the Connections folder. B. Create a relational table delivery using SQLTerm. C. Add a relational table delivery module to the fact build. D. Modify the fact build DataStream to include a relational table delivery.

Discussion 0

Correct Answer: C Vote an answer

Question 2

In this JobStream, the action on failure setting for the SiteDim node has been set to TERMINATE.

What will happen if this node fails while the JobStream is executing?

A. Data Manager will remove the SiteDim node from the JobStream and restart the execution process. B. Data Manager will immediately stop processing the remaining dimension build nodes, and process the fact build node instead. C. Data Manager will stop all processing of all nodes in the JobStream, even if they are currently running. D. Data Manager will stop processing the SiteDim node, but will continue to process the remaining dimension build nodes.

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which element does Data Manager use to identify duplicate rows?

A. Measure B. Index C. Attribute D. Dimension

Discussion 0

Correct Answer: D Vote an answer

Question 4

When creating a lookup, what must be specified?

A. Derived dimension B. Metadata dimension C. Template D. Derivation

Discussion 0

Correct Answer: C Vote an answer

Question 5

Which of the following is true of a dimension build?

A. It can deliver data to a single, "private" data mart. B. It can generate PowerCubes, Framework Manager models, and Cognos 8 reports. C. It uses a template to define the behavior of each column of a dimension table. D. It uses literals to define the behavior of each column of a dimension table.

Discussion 0

Correct Answer: C Vote an answer

Question 6

A developer wants to be able to re-use a gross profit calculation in multiple builds. What should be created?

A. User-defined function B. Measure C. Derived dimension D. Attribute E. Derivation

Discussion 0

Correct Answer: A Vote an answer

Question 7

Which of the following is true of pivoting?

A. It decreases the number of output rows. B. Each data source column in the array must be mapped to a pivot derivation element. C. Each data source column in the array must be mapped to a corresponding pivot value. D. It increases the number of output columns.

Discussion 0

Correct Answer: C Vote an answer

Question 8

A developer is working with the following relational table data source:

What should be done?

A. Create an output filter to flip the rows and columns. B. Define how the data will be pivoted in the DataStream of the fact build. C. Create a user-defined function to flip the rows and columns. D. Define how the data will be pivoted in the Delivery of the fact build.

Discussion 0

Correct Answer: B Vote an answer

Question 9

When this JobStream is executed,

what is the maximum number of nodes that will run in parallel at any one time?

A. 3 B. 7 C. 8 D. 4

Discussion 0

Correct Answer: D Vote an answer