IBM COG-625 問題集

質問 1：
The following hierarchy has been created:

Before executing the dimension build, the developer wants to ensure that duplicate rows are
excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data sources will be executed in series. What should be done?
A. Create a data integrity lookup for the hierarchy that will flag duplicate rows at each level.
B. Specify that duplicate rows are to be rejected on the Audit tab of the dimension build's properties.
C. Modify the SQL statement for the dimension build to use the SELECT DISTINCT clause.
D. Specify that duplicate rows are to be rejected on the Features tab of the hierarchy's properties.
正解：D

質問 2：
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. Member determinant
B. Lookup
C. Dimensional determinant
D. Identifier
正解：B

質問 3：
A fact build is being manually created. What must the developer do to deliver the fact data to a relational table?
A. Add a relational table delivery module to the fact build.
B. Add a relational table delivery module to the Connections folder.
C. Modify the fact build DataStream to include a relational table delivery.
D. Create a relational table delivery using SQLTerm.
正解：A

質問 4：
Which of the following tasks can be completed with the Dimension Build wizard?
A. Adding a custom schema to use for the dimension tables.
B. Creating a connection to hold the dimension tables.
C. Specifying the folder in which the dimension build will be stored.
D. Specifying surrogates and change tracking behaviors.
正解：D

質問 5：
A developer has added a data source connection to a Data Manager catalog. This connection points to a relational database. The developer wants to view the contents of this database, such as the number of tables that it contains. What tool could the administrator use?
A. SQLTerm
B. Reference Explorer
C. SQLTXT Designer
D. ODBC Administrator
正解：A

質問 6：
A developer wants to deliver fact data to a relational table. When the fact build is executed, any new rows must be added to this table. However, if an incoming row has the same key as a row that already exists in this table, the existing row must be updated accordingly. What should the developer do?
A. Set the refresh type for the relational table delivery module to INSERT.
B. Set the refresh type for the relational table delivery module to TRUNCATE.
C. Set the refresh type for the relational table delivery module to REPLACE.
D. Set the refresh type for the relational table delivery module to UPDATE.
E. Set the refresh type for the relational table delivery module to APPEND.
F. Set the refresh type for the relational table delivery module to UPDATE/INSERT.
正解：F

質問 7：
Which of the following is true of conformed dimensions? (choose two)
A. Conformed dimensions are created using the Hierarchy wizard.
B. A conformed dimension uses surrogate keys.
C. A conformed dimension is specific to a single fact table.
D. A conformed dimension is used by multiple fact tables.
E. Conformed dimensions are created using the Fact Build wizard.
正解：B,D

質問 8：
A dimension table contains the following data:

If late arriving fact processing is enabled, what will be the value of the surrogate key assigned to the last row of fact data?
A. 11110
B. 11111
C. 11113
D. 11112
正解：B