最新的IBM COG-625免費考試真題

問題1

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. Reference Explorer

B. SQLTerm

C. SQLTXT Designer

D. ODBC Administrator

正確答案: B

問題2

A developer has created a date hierarchy using the Date Hierarchy wizard. Which of the following is true of all the members in this hierarchy?

A. All are retrieved from a database table using SQL.

B. All are retrieved from a flat file using SQL.

C. All are static and are physically stored in the catalog.

D. All are dynamic and are physically stored in the catalog.

正確答案: C

問題3

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. Identifier

B. Member determinant

C. Lookup

D. Dimensional determinant

正確答案: C

問題4

A dimension table tracks employee data. If an employee's phone number changes, the old phone number does not need to be kept. What kind of change is this?

A. Type 1

B. Type 2, non-standard

C. Type 2

D. Type 3, non-standard

正確答案: A

問題5

Why would an index be created on a fact table?

A. To enable the merging of duplicate rows.

B. To enable the rejecting of duplicate rows.

C. To make it easier to drop and recreate the fact table.

D. To improve update performance on a relational delivery.

正確答案: D

問題6

A developer has geographical data from a data source where cities roll up into states, and states roll up into regions. What should the developer create in order to allow Data Manager to aggregate fact data to the region level?

A. Derived dimension

B. Lookup

C. Derivation

D. Dimension

E. Hierarchy

正確答案: E

問題7

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. Specify that duplicate rows are to be rejected on the Features tab of the hierarchy's properties.

B. Create a data integrity lookup for the hierarchy that will flag duplicate rows at each level.

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 Audit tab of the dimension build's properties.

正確答案: A

問題8

Which of the following can a developer do with SQLTXT Designer?

A. Specify sort order for the flat file.

B. Select data from multiple text files using joins.

C. Select data from multiple tables using joins.

D. Specify row and column delimiters.

正確答案: D

問題9

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. 1200

B. 500

C. 700

D. 200

正確答案: B

最新的IBM Cognos 10 BI Data Warehouse Developer - COG-625免費考試真題

聯系我們

站內鏈接

最新更新