IBM Cognos 10 BI Data Warehouse Developer (COG-625) Free Practice Test

Question 1

Where can a variable be declared?

A. In a data source connection.

B. In a hierarchy.

C. In a Data Manager folder.

D. In a build specification.

Correct Answer: D

Question 2

A fact build has been created that will extract data for all of Europe. All of the data will be delivered to fact tables. The developer wants to direct United Kingdom-specific data into its own fact table. What must be created on the fact delivery?

A. Level filter

B. Data source filter

C. DataStream filter

D. Output filter

Correct Answer: D

Question 3

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 by one table for each hierarchy level. Each table will have a foreign key to the level above.

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

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

Correct Answer: B

Question 4

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

A. Select data from multiple tables using joins.

B. Specify row and column delimiters.

C. Specify sort order for the flat file.

D. Select data from multiple text files using joins.

Correct Answer: B

Question 5

Which of the following is a potential challenge when developing conformed dimensions?

A. A DataStream must be manually created for each conformed dimension's data source.

B. A developer may need to manually track changes to dimensional history by creating derivations.

C. A developer may need to manually track changes to dimensional history by creating derived dimensions.

D. A developer needs to build an operational data store (ODS) to contain the conformed dimensions.

E. Dimensional keys may be different across source systems and need to be standardized.

Correct Answer: E

Question 6

What is depicted below?

A. How the items in the DataStream 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 fact table.

C. How the columns of the data source map to the elements of the transformation model.

D. How the elements of the transformation model will be output to the columns of a dimension table.

E. How the items in the DataStream will be output to the columns of a dimension table.

Correct Answer: C

Question 7

Incoming records show the number of drink packs sold by date. This information is referenced by lookups. Each drink pack contains two or more individual drinks. The developer wants to add a column to the fact table that shows how many individual drinks have been sold, not how many drink packs have been sold. What should be created to accomplish this?

A. Derived dimension

B. Data source derivation

C. DataStream derivation

D. Derived measure

Correct Answer: A

Question 8

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

B. User

C. Detail

D. ExecutedSQL

Correct Answer: A

Question 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. 200

D. 700

Correct Answer: B

Welcome to TestSimulate

IBM Cognos 10 BI Data Warehouse Developer (COG-625) Free Practice Test