質問 1：
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
質問 2：
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?
A. Decrease the size of the page pool.
B. Increase the initial size of the hash table.
C. Disable audit logging.
D. Increase the amount of working memory (in megabytes).
正解：B
質問 3：
Which of the following is true of a dimension build?
A. It can generate PowerCubes, Framework Manager models, and Cognos 8 reports.
B. It can deliver data to a single, "private" data mart.
C. It uses literals to define the behavior of each column of a dimension table.
D. It uses a template to define the behavior of each column of a dimension table.
正解：D
質問 4：
Where can a variable be declared?
A. In a Data Manager folder.
B. In a hierarchy.
C. In a data source connection.
D. In a build specification.
正解：D
質問 5：
What is depicted below?
A. How the elements of the transformation model will be output to the columns of a fact table.
B. How the elements of the transformation model will be output to the columns of a dimension table.
C. How the items in the DataStream will be output to the columns of a fact table.
D. How the items in the DataStream will be output to the columns of a dimension table.
E. How the columns of the data source map to the elements of the transformation model.
正解：E
質問 6：
In the Dimension Build wizard, the developer has specified the schema type as "Star schema." What will be the result of this selection?
A. The dimension will be represented in a single table. Each row of this table will contain the ID of the member, together with the ID of its parent.
B. The dimension will be represented in a single table. Each level of the delivered hierarchy will be represented by one or more columns of this table.
C. The dimension will be represented by one table for each hierarchy level. Each table will have a foreign key to the level above.
D. The dimension will be represented in a table that contains only the keys of all the levels of the delivered hierarchy. The descriptions of the higher levels will reside in other tables.
正解：B
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
質問 2：
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?
A. Decrease the size of the page pool.
B. Increase the initial size of the hash table.
C. Disable audit logging.
D. Increase the amount of working memory (in megabytes).
正解：B
質問 3：
Which of the following is true of a dimension build?
A. It can generate PowerCubes, Framework Manager models, and Cognos 8 reports.
B. It can deliver data to a single, "private" data mart.
C. It uses literals to define the behavior of each column of a dimension table.
D. It uses a template to define the behavior of each column of a dimension table.
正解：D
質問 4：
Where can a variable be declared?
A. In a Data Manager folder.
B. In a hierarchy.
C. In a data source connection.
D. In a build specification.
正解：D
質問 5：
What is depicted below?
A. How the elements of the transformation model will be output to the columns of a fact table.
B. How the elements of the transformation model will be output to the columns of a dimension table.
C. How the items in the DataStream will be output to the columns of a fact table.
D. How the items in the DataStream will be output to the columns of a dimension table.
E. How the columns of the data source map to the elements of the transformation model.
正解：E
質問 6：
In the Dimension Build wizard, the developer has specified the schema type as "Star schema." What will be the result of this selection?
A. The dimension will be represented in a single table. Each row of this table will contain the ID of the member, together with the ID of its parent.
B. The dimension will be represented in a single table. Each level of the delivered hierarchy will be represented by one or more columns of this table.
C. The dimension will be represented by one table for each hierarchy level. Each table will have a foreign key to the level above.
D. The dimension will be represented in a table that contains only the keys of all the levels of the delivered hierarchy. The descriptions of the higher levels will reside in other tables.
正解：B
0 お客様のコメント