IBM Cognos 10 BI Data Warehouse Developer - C2020-625 Exam Practice Test
What distinguishes an OLTP system from a data warehouse? (choose two)
Correct Answer: A,D
Vote an answer
End users must be able to create Cognos 8 reports using data from the data warehouse. To facilitate this, what can the developer do from within Data Manager?
Correct Answer: C
Vote an answer
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?
Correct Answer: C
Vote an answer
Which of the following is are characteristics of surrogate keys? (choose three)
Correct Answer: A,B,C
Vote an answer
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?
Correct Answer: D
Vote an answer
A dimension table contains the following data:
If late arriving fact processing is enabled, what will be the value of the surrogate key assigned to the last row of fact data?
If late arriving fact processing is enabled, what will be the value of the surrogate key assigned to the last row of fact data?
Correct Answer: B
Vote an answer
A developer is working with the following relational table data source:
What should be done?
What should be done?
Correct Answer: B
Vote an answer
A lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). If the incoming currency is not available through the lookup, what can be done to prevent the fact row from being rejected?
Correct Answer: C
Vote an answer