IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 41:

  When creating a lookup, what must be specified?

  A. Derivation
  B. Metadata dimension
  C. Template
  D. Derived dimension
  C. Template

• Question 42:

  What is depicted below?

  

  A. How the elements of the transformation model will be output to the columns of a dimension table.
  B. How the columns of the data source map to the elements of the transformation model.
  C. How the items in the DataStream will be output to the columns of a fact table.
  D. How the elements of the transformation model will be output to the columns of a fact table.
  E. How the items in the DataStream will be output to the columns of a dimension table.
  B. How the columns of the data source map to the elements of the transformation model.

• Question 43:

  In which Data Manager object does a developer specify the attributes of a conformed dimension, such as the surrogate keys that it contains?

  A. Reference dimension
  B. Connection
  C. Transformation model
  D. Template
  D. Template

• Question 44:

  How can a developer nest a JobStream within another JobStream?

  A. Execute the first JobStream from the command line, and reference the second JobStream in the command.
  B. Add a procedure node to the JobStream.
  C. Execute the first JobStream using the Data Movement Service, and include the second JobStream in the resulting task.
  D. Add a JobStream node to the JobStream.
  D. Add a JobStream node to the JobStream.

• Question 45:

  The following hierarchy has been created:

  

  Before executing the dimension build, the developer wants to ensure that duplicate rows are excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data

  sources will be executed in series.

  What should be done?

  A. Create a data integrity lookup for the hierarchy that will flag duplicate rows at each level.
  B. Specify that duplicate rows are to be rejected on the Audit tab of the dimension build's properties.
  C. Modify the SQL statement for the dimension build to use the SELECT DISTINCT clause.
  D. Specify that duplicate rows are to be rejected on the Features tab of the hierarchy's properties.
  D. Specify that duplicate rows are to be rejected on the Features tab of the hierarchy's properties.

• Question 46:

  Which of the following is true of conformed dimensions? (choose two)

  A. Conformed dimensions are created using the Fact Build wizard.
  B. A conformed dimension uses surrogate keys.
  C. A conformed dimension is specific to a single fact table.
  D. Conformed dimensions are created using the Hierarchy wizard.
  E. A conformed dimension is used by multiple fact tables.
  B. A conformed dimension uses surrogate keys.
  E. A conformed dimension is used by multiple fact tables.

• Question 47:

  When this JobStream is executed,

  

  what is the maximum number of nodes that will run in parallel at any one time?

  A. 3
  B. 4
  C. 7
  D. 8
  B. 4

• Question 48:

  When executing a fact build, a developer wants to estimate the amount of input resources that the build will require, but does not want to deliver any data. What execution mode should be selected?

  A. Test
  B. Check Only
  C. Object Creation
  D. Preproduction
  B. Check Only

• Question 49:

  A lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). What should be done?

  A. Reference the lookup in the properties of the affected dimension build(s).
  B. Create a measure dimension which references the conversion rate.
  C. Create a derivation which uses the reference atttributes of the lookup.
  D. Move the lookup to a fact build conversion map.
  C. Create a derivation which uses the reference atttributes of the lookup.

• Question 50:

  Below, what does Unknown Class (?Class) represent?

  

  A. Manual level
  B. Literal
  C. Foster parent
  D. Recursive level
  C. Foster parent