최신IBM Cognos 10 BI Data Warehouse Developer - C2090-625무료샘플문제
문제1
A fact build has been created that includes a Product Code dimension element. Each incoming product code must match a corresponding row in the Product dimension. What should the developer do?
A fact build has been created that includes a Product Code dimension element. Each incoming product code must match a corresponding row in the Product dimension. What should the developer do?
정답: B
문제2
Why would an index be created on a fact table?
Why would an index be created on a fact table?
정답: C
문제3
Which of the following tasks can be completed with the Dimension Build wizard?
Which of the following tasks can be completed with the Dimension Build wizard?
정답: C
문제4
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 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?
정답: C
문제5
During execution, a fact build generated the following messages in the log file:
What can be done to avoid seeing the last three lines when the build is executed again?
During execution, a fact build generated the following messages in the log file:
What can be done to avoid seeing the last three lines when the build is executed again?
정답: D
문제6
A developer wants to execute a fact build in a test environment. In order to ensure optimum performance, the developer wants to see messages related to resource usage (such as paging information), in case the build needs to be modified. What type of messages are these?
A developer wants to execute a fact build in a test environment. In order to ensure optimum performance, the developer wants to see messages related to resource usage (such as paging information), in case the build needs to be modified. What type of messages are these?
정답: D
문제7
To reduce memory usage, what should be done when setting up dimension breaking for a fact build?
To reduce memory usage, what should be done when setting up dimension breaking for a fact build?
정답: B
문제8
A developer has created a fact build where separate summary tables will be created for monthly and quarterly data. What should be created on these fact deliveries to prevent monthly data from being delivered to the quarterly summary table?
A developer has created a fact build where separate summary tables will be created for monthly and quarterly data. What should be created on these fact deliveries to prevent monthly data from being delivered to the quarterly summary table?
정답: B
문제9
A developer has created a fact build to process the incoming data shown in the table:
The developer wants to create a monthly summary fact table. If the aggregate behavior for the Credit Limit column is set to LAST, what will be the value of Credit Limit for the first row delivered for Customer 2?
A developer has created a fact build to process the incoming data shown in the table:
The developer wants to create a monthly summary fact table. If the aggregate behavior for the Credit Limit column is set to LAST, what will be the value of Credit Limit for the first row delivered for Customer 2?
정답: B