IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 71:

  A fact build has two data sources that need to undergo the same calculation for every input row, and the data will be merged. Where should the derivation be created?

  A. In the DataStream.
  B. In each data source.
  C. In the transformation model.
  D. In the output filter.
  A. In the DataStream.

• Question 72:

  Which of the following is a use for a fact build?

  A. To deliver fact data into a dimensional framework.
  B. To acquire and transform transactional data.
  C. To automate tasks related to the build process.
  D. To deliver fact data into a metadata star.
  B. To acquire and transform transactional data.

• Question 73:

  A developer is working with the following relational table data source:

  

  What should be done?

  A. Define how the data will be pivoted in the Delivery of the fact build.
  B. Create an output filter to flip the rows and columns.
  C. Define how the data will be pivoted in the DataStream of the fact build.
  D. Create a user-defined function to flip the rows and columns.
  C. Define how the data will be pivoted in the DataStream of the fact build.

• Question 74:

  A developer has created a derivation in a data source. When will this derivation be calculated?

  A. As each row is retrieved from the data source.
  B. After the source data is pivoted, but before it is merged and aggregated.
  C. After each row has been moved into the DataStream.
  D. Before the source data is pivoted, but after it is merged and aggregated.
  A. As each row is retrieved from the data source.

• Question 75:

  A developer is attempting to test a derivation.

  

  In the Input values section, what does the cross symbol beside Price indicate?

  A. No value has yet been defined for Price in the Output values section.
  B. The option in the Top box should be set to Price.
  C. The option in the Immediate box should be set to Price.
  D. A definition for Price has not been found.
  D. A definition for Price has not been found.

• Question 76:

  A dimension table contains the following data:

  

  If late arriving fact processing is enabled, what will be the value of the surrogate key assigned to the last row of fact data?

  A. 11110
  B. 11111
  C. 11112
  D. 11113
  B. 11111

• Question 77:

  A DataStream includes two different data sources: "Golf Equipment" and "Other Equipment." For each incoming row, the developer wants to add a value that indicates the data source that the row comes from. What should the developer do?

  A. Create a static member for each data source in the underlying hierarchy.
  B. Add a literal to each data source that references the data source name.
  C. Specify the source identity property for each data source in the DataStream.
  D. Add a derivation to the transformation model to create a new column.
  B. Add a literal to each data source that references the data source name.

• Question 78:

  Incoming fact data includes an audit reference column for each row. This column has been identified as an attribute in the transformation model. When executed, the fact build should designate this element as a key in the resulting fact table. This fact table will be created (not updated) by the fact build. What should the developer do?

  A. Convert the attribute element into a derived dimension element.
  B. Specify the column as a key in the table delivery properties.
  C. Specify the column as a key in the data source properties.
  D. Convert the attribute element into a derivation element.
  B. Specify the column as a key in the table delivery properties.

• Question 79:

  Without modifying any of the settings,

  

  what is the lowest level of granularity that will be shown in the Reference Explorer?

  A. AllStaff
  B. Staff
  C. Staff (H)
  D. SalesStaff
  B. Staff

• Question 80:

  What can Data Manager be used for?

  A. To create a content store.
  B. To extract operational data from multiple sources.
  C. To create a metric store.
  D. To build an IBM Cognos Planning application.
  B. To extract operational data from multiple sources.