IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 11:

  Which of the following is true of pivoting?

  A. Each data source column in the array must be mapped to a corresponding pivot value.
  B. It increases the number of output columns.
  C. It decreases the number of output rows.
  D. Each data source column in the array must be mapped to a pivot derivation element.
  A. Each data source column in the array must be mapped to a corresponding pivot value.

• Question 12:

  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?

  A. Add an LDAP or NTLM namespace in Cognos Configuration.
  B. Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs.
  C. Log on to Cognos Connection as a user in the Data Manager Authors role.
  D. Create a data source connection to the Cognos 8 data store.
  B. Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs.

• Question 13:

  Which of the following is true of a derivation that has been created in the transformation model?

  A. The derivation cannot be disabled once it has been added to the transformation model.
  B. The derivation can be added to a dimension build delivery.
  C. The derivation can be used to perform calculations in the SQL statement of a data source.
  D. The derivation can be added to a fact build delivery.
  D. The derivation can be added to a fact build delivery.

• Question 14:

  What can be done to minimize memory consumption?

  A. Disable dimension breaking on the fact build.
  B. Disable fact build logging.
  C. Enable dimension breaking on the fact build.
  D. Enable auditing on the fact build.
  C. Enable dimension breaking on the fact build.

• Question 15:

  A developer wants to move a selection of components from a development environment to a production environment. What should the developer do?

  A. Create a catalog backup file (.ctg).
  B. Create a JobStream to transfer the components..
  C. Create a package file (.pkg).
  D. Create a SQL script to transfer the components.
  C. Create a package file (.pkg).

• Question 16:

  During execution, a fact build generated the following messages in the log file:

  

  What can be done to avoid seeing the last three lines when the build is executed again?

  A. Increase the initial size of the hash table.
  B. Decrease the size of the page pool.
  C. Disable audit logging.
  D. Increase the amount of working memory (in megabytes).
  A. Increase the initial size of the hash table.

• Question 17:

  A developer has created a lookup using a template (not a data source) for data access. Why would the developer do this?

  A. Data must be accessed from more than one table.
  B. The lookup attribute names are different from the source column names.
  C. The build will perform automatic surrogate key substitution.
  D. A derivation has been added to the lookup.
  C. The build will perform automatic surrogate key substitution.

• Question 18:

  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.
  D. Specify that the file contains one header line.

• Question 19:

  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.
  C. Export the Data Manager metadata to XML for use in Framework Manager.

• Question 20:

  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?

  A. Type 3, non-standard
  B. Type 1
  C. Type 2
  D. Type 2, non-standard
  B. Type 1