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

Question 1

Which of the following is a potential challenge when developing conformed dimensions?

A. A developer may need to manually track changes to dimensional history by creating derivations. B. A DataStream must be manually created for each conformed dimension's data source. C. Dimensional keys may be different across source systems and need to be standardized. D. A developer may need to manually track changes to dimensional history by creating derived dimensions. E. A developer needs to build an operational data store (ODS) to contain the conformed dimensions.

Discussion 0

Correct Answer: C Vote an answer

Question 2

To reduce memory usage, what should be done when setting up dimension breaking for a fact build?

A. Disable late arriving facts processing for the fact build. B. Disable the hash table and page pool for the fact build. C. Specify at least one aggregate rule for each dimension element for which breaking is enabled. D. Ensure that each data source is sorted by the same set of dimensions, in the same sequence.

Discussion 0

Correct Answer: D Vote an answer

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. Fact build properties C. Template properties D. Hierarchy properties

Discussion 0

Correct Answer: C Vote an answer

Question 4

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 5

A developer wants to create a connection to a published Framework Manager package in a Data Manager catalog. Before this connection can be created successfully, what must the developer do?

A. Create a data source connection to the Cognos 8 data store. B. Add an LDAP or NTLM namespace in Cognos Configuration. C. Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs. D. Log on to Cognos Connection as a user in the Data Manager Authors role.

Discussion 0

Correct Answer: C Vote an answer

Question 6

What can be done to minimize memory consumption?

A. Disable dimension breaking on the fact build. B. Disable fact build logging. C. Enable auditing on the fact build. D. Enable dimension breaking on the fact build.

Discussion 0

Correct Answer: D Vote an answer

Question 7

What distinguishes an OLTP system from a data warehouse? (choose two)

A. A data warehouse captures and processes original business transactions, while an OLTP system does not. B. An OLTP system captures and processes original business transactions, while a data warehouse does not. C. An OLTP system is used to transform, clean, and combine operational data, while a data warehouse is not. D. A data warehouse is fully normalized, while an OLTP system is fully denormalized. E. A data warehouse is fully denormalized, while an OLTP system is fully normalized.

Discussion 0

Correct Answer: B,E Vote an answer

Question 8

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 9

Which of the following tasks can be completed with the Dimension Build wizard?

A. Creating a connection to hold the dimension tables. B. Specifying the folder in which the dimension build will be stored. C. Adding a custom schema to use for the dimension tables. D. Specifying surrogates and change tracking behaviors.

Discussion 0

Correct Answer: D Vote an answer