C2090-625 by IBM Actual Free Exam Questions And Answers

Question 1

What kind of tool is Data Manager?

A. ERP

B. CRM

C. ETL

D. PDM

Discussion 0

Correct Answer: C Vote an answer

Question 2

What can be seen with Reference Explorer that cannot be seen when using SQLTerm to examine the data?

A. Number of rows in the data source used to build the hierarchy.

B. Number of tables in the data source used to build the hierarchy.

C. Hierarchical data from two database connections.

D. Columns from which the member data was obtained.

Discussion 0

Correct Answer: C Vote an answer

Question 3

To reduce memory usage, what should be done when setting up dimension breaking for a fact build?

A. Disable late arriving facts processing for the fact build.

B. Disable the hash table and page pool for the fact build.

C. Ensure that each data source is sorted by the same set of dimensions, in the same sequence.

D. Specify at least one aggregate rule for each dimension element for which breaking is enabled.

Discussion 0

Correct Answer: C Vote an answer

Question 4

What is depicted below?

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

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 elements of the transformation model will be output to the columns of a fact table.

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

Discussion 0

Correct Answer: A Vote an answer

Question 5

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

B. Derivation

C. Derived dimension

D. Dimension

E. Hierarchy

Discussion 0

Correct Answer: E Vote an answer

Question 6

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. Create an attribute element in the transformation model that will check for valid product codes.

B. Create a lookup to the dimension and reference the lookup in the Product Code element.

C. Create a second dimension element in the transformation model that will check for valid product codes.

D. Create an output filter and reference the output filter in the Product Code element.

E. Create a template and reference the template in the Product Code element.

Discussion 0

Correct Answer: B Vote an answer

Question 7

A developer wants to be able to re-use a gross profit calculation in multiple builds. What should be created?

A. Measure

B. User-defined function

C. Derivation

D. Attribute

E. Derived dimension

Discussion 0

Correct Answer: B Vote an answer

Question 8

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

A. Select data from multiple tables using joins.

B. Select data from multiple text files using joins.

C. Specify sort order for the flat file.

D. Specify row and column delimiters.

Discussion 0

Correct Answer: D Vote an answer

Question 9

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 static and are physically stored in the catalog.

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

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

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

Discussion 0

Correct Answer: A Vote an answer

IBM Cognos 10 BI Data Warehouse Developer - C2090-625 Exam Practice Test

Contact Us

Useful Links

Latest Updated