IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 21:

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

  

  The build has been set to merge records with duplicate keys. Both the Customer and Date columns represent dimension elements. If the merge behavior for the Amount column is set to SUM, what will be the value of Amount for the first row delivered for customer 2?

  A. 1200
  B. 200
  C. 500
  D. 700
  C. 500

• Question 22:

  A fact build has been created that will extract data for all of Europe. All of the data will be delivered to fact tables. The developer wants to direct United Kingdom-specific data into its own fact table. What must be created on the fact delivery?

  A. Level filter
  B. Data source filter
  C. DataStream filter
  D. Output filter
  D. Output filter

• Question 23:

  What kind of tool is Data Manager?

  A. CRM
  B. PDM
  C. ETL
  D. ERP
  C. ETL

• Question 24:

  Which of the following is true of packages in Data Manager?

  A. User-defined folders cannot be exported.
  B. During importing, duplicate components are automatically renamed.
  C. User-defined folders cannot be imported.
  D. During importing, dependent components are automatically selected.
  D. During importing, dependent components are automatically selected.

• Question 25:

  Which of the following is true of transformation model derivations?

  A. They can be created within a static member.
  B. They can consist of a string literal.
  C. They can be used as sources for an attribute element.
  D. They can be used as sources for a measure element.
  B. They can consist of a string literal.

• Question 26:

  Which of the following is a potential challenge when developing conformed dimensions?

  A. A developer may need to manually track changes to dimensional history by creating derived dimensions.
  B. A DataStream must be manually created for each conformed dimension's data source.
  C. A developer needs to build an operational data store (ODS) to contain the conformed dimensions.
  D. Dimensional keys may be different across source systems and need to be standardized.
  E. A developer may need to manually track changes to dimensional history by creating derivations.
  D. Dimensional keys may be different across source systems and need to be standardized.

• Question 27:

  A dimension table tracks employee data. If an employee's work location changes, the previous work location needs to be kept and a new record needs to be created. What kind of change is this?

  A. Type 0
  B. Type 1
  C. Type 2
  D. Type 3
  C. Type 2

• Question 28:

  A JobStream has been created that, when executed, will write status messages to the log file that indicate whether nodes have completed or failed to run. What type of node should be added to the JobStream?

  A. Alert
  B. Condition
  C. Procedure
  D. Email
  C. Procedure

• Question 29:

  Where can a variable be declared?

  A. In a build specification.
  B. In a hierarchy.
  C. In a data source connection.
  D. In a Data Manager folder.
  A. In a build specification.

• Question 30:

  A developer wants to execute a fact build in a test environment. In order to ensure optimum performance, the developer wants to see messages related to resource usage (such as paging information), in case the build needs to be modified. What type of messages are these?

  A. User
  B. ExecutedSQL
  C. Internal
  D. Detail
  C. Internal