Which of the following is are characteristics of surrogate keys? (choose three)
A. Are numbers.
B. Have no intrinsic meaning.
C. Are unique.
D. Are text-based.
E. Tend to be larger than keys from operational systems.
F. Are replaced by business keys in the data warehouse.
正解:A,B,C
質問 2:
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. Modify the SQL for the reference structure to exclude the missing product codes.
B. Accept unmatched member identifiers in the measure element properties.
C. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.
D. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.
正解:D
質問 3:
A developer wants to ensure that each incoming row of fact data has a corresponding location code from a dimension table. What should the developer create?
A. Lookup
B. Identifier
C. Dimensional determinant
D. Member determinant
正解:A
質問 4:
A developer has geographical data from a data source where cities roll up into states, and states roll up into regions. What should the developer create in order to allow Data Manager to aggregate fact data to the region level?
A. Derivation
B. Derived dimension
C. Lookup
D. Dimension
E. Hierarchy
正解:E
質問 5:
A developer wants to create a connection to a database in a Data Manager catalog. When creating this connection, which of the following must the developer specify?
A. Method used to connect to the database.
B. Location of the .ctg file..
C. Names and port numbers of for Data Manager socket servers.
D. A default schema name.
正解:A
質問 6:
Which of the following is true of a derivation that has been created in the transformation model?
A. The derivation can be added to a dimension build delivery.
B. The derivation can be used to perform calculations in the SQL statement of a data source.
C. The derivation can be added to a fact build delivery.
D. The derivation cannot be disabled once it has been added to the transformation model.
正解:C
質問 7:
What can Data Manager be used for?
A. To create a content store.
B. To build an IBM Cognos Planning application.
C. To create a metric store.
D. To extract operational data from multiple sources.
正解:D