IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 61:

  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. Accept unmatched member identifiers in the measure element properties.
  B. Modify the SQL for the reference structure to exclude the missing product codes.
  C. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.
  D. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.
  C. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.

• Question 62:

  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
  B. Data transfer

• Question 63:

  Incoming records show the number of drink packs sold by date. This information is referenced by lookups. Each drink pack contains two or more individual drinks. The developer wants to add a column to the fact table that shows how many individual drinks have been sold, not how many drink packs have been sold. What should be created to accomplish this?

  A. DataStream derivation
  B. Data source derivation
  C. Derived measure
  D. Derived dimension
  D. Derived dimension

• Question 64:

  A developer has created a fact build to process the incoming data shown in the table:

  

  The developer wants to create a monthly summary fact table. If the aggregate behavior for the Credit Limit column is set to LAST, what will be the value of Credit Limit for the first row delivered for Customer 2?

  A. 1500
  B. 500
  C. 1200
  D. 1100
  C. 1200

• Question 65:

  A developer wants to ensure that each incoming row of fact data has a corresponding location code from a dimension table. What should the developer create?

  A. Lookup
  B. Dimensional determinant
  C. Member determinant
  D. Identifier
  A. Lookup

• Question 66:

  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
  A. Line and field delimiters

• Question 67:

  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.
  D. In the properties of the template that is used to deliver the dimension build, include an attribute with effective start date behavior.

• Question 68:

  In this JobStream, the action on failure setting for the SiteDim node has been set to TERMINATE.

  

  What will happen if this node fails while the JobStream is executing?

  A. Data Manager will immediately stop processing the remaining dimension build nodes, and process the fact build node instead.
  B. Data Manager will stop processing the SiteDim node, but will continue to process the remaining dimension build nodes.
  C. Data Manager will stop all processing of all nodes in the JobStream, even if they are currently running.
  D. Data Manager will remove the SiteDim node from the JobStream and restart the execution process.
  B. Data Manager will stop processing the SiteDim node, but will continue to process the remaining dimension build nodes.

• Question 69:

  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. Slowly changing dimension
  B. Metadata dimension
  C. Reference dimension
  D. Slowly derived dimension
  A. Slowly changing dimension

• Question 70:

  A developer has created a fact build with two fact deliveries. What should be done to include only some of the elements of the transformation model in one of the deliveries, and some in the other delivery?

  A. Modify the properties of each fact delivery to exclude the relevant elements.
  B. Create an output filter to exclude the relevant elements from each delivery.
  C. Modify the SQL to exclude the relevant elements from each delivery.
  D. Create a level filter to exclude the relevant elements from each delivery.
  A. Modify the properties of each fact delivery to exclude the relevant elements.