The data in the Product dimension table appears as follows:
What is one of the things that must be done to ensure that all of these records are delivered into the dimension table?
A. In the properties of the underlying hierarchy, set the Multiple Parents feature to Accept.
B. In the properties of the template that is used to deliver the dimension build, include an attribute with effective start date behavior.
C. In the properties of the underlying hierarchy, set the Unbalanced Hierarchy feature to Accept.
D. In the properties of the dimension table, specify that late arriving dimension details are to be written to a table.
正解:B
質問 2:
A JobStream has been created that, when executed, will write status messages to the log file that indicate whether nodes have completed or failed to run. What type of node should be added to the JobStream?
A. Procedure
B. Condition
C. Alert
D. Email
正解:A
質問 3:
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?
A. 500
B. 200
C. 1200
D. 700
正解:A
質問 4:
In this JobStream, the action on failure setting for the SiteDim node has been set to TERMINATE.
What will happen if this node fails while the JobStream is executing?
A. Data Manager will stop all processing of all nodes in the JobStream, even if they are currently running.
B. Data Manager will stop processing the SiteDim node, but will continue to process the remaining dimension build nodes.
C. Data Manager will remove the SiteDim node from the JobStream and restart the execution process.
D. Data Manager will immediately stop processing the remaining dimension build nodes, and process the fact build node instead.
正解:B
質問 5:
A developer is working with the following relational table data source:
What should be done?
A. Create a user-defined function to flip the rows and columns.
B. Define how the data will be pivoted in the Delivery of the fact build.
C. Define how the data will be pivoted in the DataStream of the fact build.
D. Create an output filter to flip the rows and columns.
正解:C
質問 6:
A developer has created a derivation in a data source. When will this derivation be calculated?
A. After the source data is pivoted, but before it is merged and aggregated.
B. After each row has been moved into the DataStream.
C. As each row is retrieved from the data source.
D. Before the source data is pivoted, but after it is merged and aggregated.
正解:C
質問 7:
What kind of tool is Data Manager?
A. ETL
B. PDM
C. CRM
D. ERP
正解:A
質問 8:
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
具志** -
C2090-625問題集のPDF版だけを見ると合格できました。本当に嬉しいです。ありがとうございました。