IBM Cognos 10 BI Data Warehouse Developer v6.0 (C2020-625)

Page:    1 / 6   
Total 84 questions

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 a second dimension 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 an attribute element in the transformation model that will check for valid product codes.
  • D. Create a template and reference the template in the Product Code element.
  • E. Create an output filter and reference the output filter in the Product Code element.


Answer : B

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. A default schema name.
  • B. Method used to connect to the database.
  • C. Names and port numbers of for Data Manager socket servers.
  • D. Location of the .ctg file..


Answer : B

Which of the following is a use for a fact build?

  • A. To deliver fact data into a dimensional framework.
  • B. To acquire and transform transactional data.
  • C. To automate tasks related to the build process.
  • D. To deliver fact data into a metadata star.


Answer : B

What distinguishes an OLTP system from a data warehouse? (choose two)

  • A. An OLTP system captures and processes original business transactions, while a data warehouse does not.
  • B. A data warehouse captures and processes original business transactions, while an OLTP system does not.
  • C. An OLTP system is used to transform, clean, and combine operational data, while a data warehouse is not.
  • D. A data warehouse is fully normalized, while an OLTP system is fully denormalized.
  • E. A data warehouse is fully denormalized, while an OLTP system is fully normalized.


Answer : A,E

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. User
  • B. ExecutedSQL
  • C. Internal
  • D. Detail


Answer : C

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. Cognos BI Mart (Snowflake)
  • B. Data transfer
  • C. Cognos BI Mart (Star)
  • D. Relational datamart


Answer : B

A developer has created a fact build where separate summary tables will be created for monthly and quarterly data. What should be created on these fact deliveries to prevent monthly data from being delivered to the quarterly summary table?

  • A. User-defined functions
  • B. Derivations
  • C. Level filters
  • D. Output filters


Answer : C

Why has the developer selected the Output box for the ProductLine row?

  • A. To create summary level rows.
  • B. To merge duplicate rows of incoming data at the ProductLine level.
  • C. To create detail level rows.
  • D. To allow duplicate rows of incoming data at the ProductLine level.


Answer : A

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?

  • A. Specify CR as the record delimiter.
  • B. Specify NL as the record delimiter.
  • C. Specify that the header row ignore limit is one.
  • D. Specify that the file contains one header line.


Answer : D

Which of the following is are characteristics of surrogate keys? (choose three)

  • A. Are numbers.
  • B. Tend to be larger than keys from operational systems.
  • C. Are text-based.
  • D. Are replaced by business keys in the data warehouse.
  • E. Have no intrinsic meaning.
  • F. Are unique.


Answer : A,E,F

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?

  • A. Run the Create Framework Manager Model wizard to create a project.
  • B. Create a Cognos 8 package in the Library area of the catalog.
  • C. Export the Data Manager metadata to XML for use in Framework Manager.
  • D. Publish a Cognos 8 package in the Metadata area of the catalog.


Answer : C

The data in the Product dimension table appears as follows:
What is one of the things that must be done to ensure that all of these records are delivered into the dimension table?

  • A. In the properties of the underlying hierarchy, set the Unbalanced Hierarchy feature to Accept.
  • B. In the properties of the dimension table, specify that late arriving dimension details are to be written to a table.
  • C. In the properties of the underlying hierarchy, set the Multiple Parents feature to Accept.
  • D. In the properties of the template that is used to deliver the dimension build, include an attribute with effective start date behavior.


Answer : D

When delivering fact data to a text file, what can be specified?

  • A. Line and field delimiters
  • B. Whether the file is in ASCII or EBCDIC format
  • C. Maximum number of rows to be stored in the file
  • D. Default text editor to use with the file


Answer : A

Which of the following is true of packages in Data Manager?

  • A. User-defined folders cannot be exported.
  • B. During importing, duplicate components are automatically renamed.
  • C. User-defined folders cannot be imported.
  • D. During importing, dependent components are automatically selected.


Answer : D

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

  • A. Ensure that each data source is sorted by the same set of dimensions, in the same sequence.
  • B. Specify at least one aggregate rule for each dimension element for which breaking is enabled.
  • C. Disable the hash table and page pool for the fact build.
  • D. Disable late arriving facts processing for the fact build.


Answer : A

Page:    1 / 6   
Total 84 questions