IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 81:

  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.
  A. To create summary level rows.

• Question 82:

  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.
  B. Create a lookup to the dimension and reference the lookup in the Product Code element.

• Question 83:

  Why would an index be created on a fact table?

  A. To enable the rejecting of duplicate rows.
  B. To make it easier to drop and recreate the fact table.
  C. To enable the merging of duplicate rows.
  D. To improve update performance on a relational delivery.
  D. To improve update performance on a relational delivery.

• Question 84:

  Which would be reasons for modifying a hierarchy that was previously created using the Hierarchy wizard? (Choose two)

  A. To add an attribute to a hierarchy level.
  B. To add a measure element to the hierarchy.
  C. To specify a fact build for the hierarchy.
  D. To add a level to the hierarchy.
  E. To specify a metadata dimension for the hierarchy.
  F. To add a derived dimension element to the hierarchy.
  A. To add an attribute to a hierarchy level.
  D. To add a level to the hierarchy.