A developer has created a lookup using a template (not a data source) for data access. Why would the developer do this?
A. The lookup attribute names are different from the source column names.
B. The build will perform automatic surrogate key substitution.
C. Data must be accessed from more than one table.
D. A derivation has been added to the lookup.
正解:B
質問 2:
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. Template properties
B. Fact build properties
C. Hierarchy properties
D. Connection properties
正解:A
質問 3:
Where can a developer define variables in Data Manager?
A. JobStreams
B. Metadata dimensions
C. Metadata collections
D. Connections
正解:A
質問 4:
Which of the following is true of packages in Data Manager?
A. During importing, duplicate components are automatically renamed.
B. User-defined folders cannot be exported.
C. During importing, dependent components are automatically selected.
D. User-defined folders cannot be imported.
正解:C
質問 5:
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
質問 6:
Several conformed dimensions have been defined and must now be delivered to the data warehouse. Which is the best way to do this?
A. Deliver the dimension tables as part of a metadata collection.
B. Create a metadata dimension and add it to a metadata star.
C. Deliver the dimension tables through dimension builds.
D. Run the necessary CREATE TABLE statements in SQLTXT.
正解:C