IBM C2020-625 - IBM Cognos 10 BI Data Warehouse Developer Exam
Page: 3 / 17
Total 84 questions
Question #11 (Topic: )
A developer just wants to deliver dimension data to a table in a data mart. The dimensional
framework has already been built. What should the developer create?
framework has already been built. What should the developer create?
A. Dimension build
B. JobStream
C. Metadata dimension
D. Fact build
Answer: A
Question #12 (Topic: )
A developer has created a fact build to process the incoming data shown in the table:
The build has been set to merge records with duplicate keys. Both the Customer and Date
columns represent dimension elements. If the merge behavior for the Amount column is set
to SUM, what will be the value of Amount for the first row delivered for customer 2?
The build has been set to merge records with duplicate keys. Both the Customer and Date
columns represent dimension elements. If the merge behavior for the Amount column is set
to SUM, what will be the value of Amount for the first row delivered for customer 2?
A. 1200
B. 200
C. 500
D. 700
Answer: C
Question #13 (Topic: )
What kind of tool is Data Manager?
A. CRM
B. PDM
C. ETL
D. ERP
Answer: C
Question #14 (Topic: )
Which of the following is true of a dimension build?
A. It uses literals to define the behavior of each column of a dimension table.
B. It can generate PowerCubes, Framework Manager models, and Cognos 8 reports.
C. It can deliver data to a single, "private" data mart.
D. It uses a template to define the behavior of each column of a dimension table.
Answer: D
Question #15 (Topic: )
A developer wants to move a selection of components from a development environment to
a production environment. What should the developer do?
a production environment. What should the developer do?
A. Create a catalog backup file (.ctg).
B. Create a JobStream to transfer the components..
C. Create a package file (.pkg).
D. Create a SQL script to transfer the components.
Answer: C
