C2020-625 - IBM Cognos 10 BI Data Warehouse Developer Exam
Go back to IBM
Which of the following is true of a dimension build?
It uses a template to define the behavior of each column of a dimension table.
A dimension table tracks employee data. If an employee's work location changes, the previous work location needs to be kept and a new record needs to be created. What kind of change is this?
A developer wants to copy data from one table to a table in another database. What type of fact build would be the most appropriate for the developer to specify in the Fact Build wizard?
A developer just wants to deliver dimension data to a table in a data mart. The dimensional framework has already been built. What should the developer create?
A developer wants to create a connection to a published Framework Manager package in a Data Manager catalog. Before this connection can be created successfully, what must the developer do?
Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs.
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?
Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.
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?
Which of the following tasks can be completed with the Dimension Build wizard?
Specifying surrogates and change tracking behaviors.
What can be done to minimize memory consumption?
Enable dimension breaking on the fact build.
What is a difference between a measure element and an attribute element?
Measure values can be aggregated by Data Manager, while attribute values cannot.
Which of the following is true of the Navigator?
When a component is selected, dependent components are shown.
Which of the following is true of packages in Data Manager?
During importing, dependent components are automatically selected.
To reduce memory usage, what should be done when setting up dimension breaking for a fact build?
Ensure that each data source is sorted by the same set of dimensions, in the same sequence.
A developer wants to move a selection of components from a development environment to a production environment. What should the developer do?
Create a package file (.pkg).
Which of the following is a use for a fact build?
To acquire and transform transactional data.
End users must be able to create Cognos 8 reports using data from the data warehouse. To facilitate this, what can the developer do from within Data Manager?
Export the Data Manager metadata to XML for use in Framework Manager.
When creating dimensions, what is commonly used to track historical changes?
Which of the following can a developer do with SQLTXT Designer?
Specify row and column delimiters.
When executing a fact build, a developer wants to estimate the amount of input resources that the build will require, but does not want to deliver any data. What execution mode should be selected?
A developer wants to ensure that the business keys in incoming source data are replaced with surrogate keys in the fact tables. To do this, what must be modified?
A developer wants to create a connection to a database in a Data Manager catalog. When creating this connection, which of the following must the developer specify?
Method used to connect to the database.
A text file contains a row at the top that only identifies the names of the columns. In order for this file to be processed successfully, what must the developer do in SQLTXT Designer?
Specify that the file contains one header line.
Over time, an employee may move from one office to another. The dimension table tracks these types of changes. What is this dimension an example of?
Slowly changing dimension
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?
In the Dimension Build wizard, the developer has specified the schema type as "Star schema." What will be the result of this selection?
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.