C2020-625 - IBM Cognos 10 BI Data Warehouse Developer Exam

Go back to IBM

Example Questions

Which of the following is true of a dimension build? 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? 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? 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? What can be done to minimize memory consumption? What is a difference between a measure element and an attribute element? Which of the following is true of the Navigator? Which of the following is true of packages in Data Manager? To reduce memory usage, what should be done when setting up dimension breaking for a fact build? A developer wants to move a selection of components from a development environment to a production environment. What should the developer do? Which of the following is a use for a fact build? 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? When creating dimensions, what is commonly used to track historical changes? Which of the following can a developer do with SQLTXT Designer? 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? 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? 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? 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?