IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 51:

  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..
  B. Method used to connect to the database.

• Question 52:

  A developer wants to deliver fact data to a relational table. When the fact build is executed, any new rows must be added to this table. However, if an incoming row has the same key as a row that already exists in this table, the existing row

  must be updated accordingly.

  What should the developer do?

  A. Set the refresh type for the relational table delivery module to UPDATE.
  B. Set the refresh type for the relational table delivery module to TRUNCATE.
  C. Set the refresh type for the relational table delivery module to UPDATE/INSERT.
  D. Set the refresh type for the relational table delivery module to REPLACE.
  E. Set the refresh type for the relational table delivery module to APPEND.
  F. Set the refresh type for the relational table delivery module to INSERT.
  C. Set the refresh type for the relational table delivery module to UPDATE/INSERT.

• Question 53:

  Where can a developer define variables in Data Manager?

  A. Metadata dimensions
  B. Connections
  C. JobStreams
  D. Metadata collections
  C. JobStreams

• Question 54:

  Several conformed dimensions have been defined and must now be delivered to the data warehouse. Which is the best way to do this?

  A. Deliver the dimension tables through dimension builds.
  B. Run the necessary CREATE TABLE statements in SQLTXT.
  C. Deliver the dimension tables as part of a metadata collection.
  D. Create a metadata dimension and add it to a metadata star.
  A. Deliver the dimension tables through dimension builds.

• Question 55:

  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.
  A. Ensure that each data source is sorted by the same set of dimensions, in the same sequence.

• Question 56:

  In the Dimension Build wizard, the developer has specified the schema type as "Star schema." What will be the result of this selection?

  A. 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.
  B. The dimension will be represented in a table that contains only the keys of all the levels of the delivered hierarchy. The descriptions of the higher levels will reside in other tables.
  C. The dimension will be represented by one table for each hierarchy level. Each table will have a foreign key to the level above.
  D. The dimension will be represented in a single table. Each row of this table will contain the ID of the member, together with the ID of its parent.
  A. 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.

• Question 57:

  When creating a Data Manager catalog which of the following must be specified? (choose two)

  A. IBM Cognos package name
  B. IBM Cognos content store name
  C. Location of .ctg file
  D. Database credentials
  E. Catalog name
  D. Database credentials
  E. Catalog name

• Question 58:

  A fact build is being manually created. What must the developer do to deliver the fact data to a relational table?

  A. Add a relational table delivery module to the Connections folder.
  B. Create a relational table delivery using SQLTerm.
  C. Add a relational table delivery module to the fact build.
  D. Modify the fact build DataStream to include a relational table delivery.
  C. Add a relational table delivery module to the fact build.

• Question 59:

  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 retrieved from a database table using SQL.
  B. All are static and are physically stored in the catalog.
  C. All are retrieved from a flat file using SQL.
  D. All are dynamic and are physically stored in the catalog.
  B. All are static and are physically stored in the catalog.

• Question 60:

  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. Hierarchy properties
  B. Template properties
  C. Fact build properties
  D. Connection properties
  B. Template properties