IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 31:

  A lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). If the incoming currency is not available through the lookup, what can be done to prevent the fact row from being rejected?

  A. Accept unmatched member identifiers.
  B. Create a derivation to insert a default value.
  C. Set the "value if null" property on the table delivery.
  D. Create a derived dimension to create a default value.
  A. Accept unmatched member identifiers.

• Question 32:

  A developer has created a fact build where separate summary tables will be created for monthly and quarterly data. What should be created on these fact deliveries to prevent monthly data from being delivered to the quarterly summary table?

  A. User-defined functions
  B. Derivations
  C. Level filters
  D. Output filters
  C. Level filters

• Question 33:

  A developer just wants to deliver dimension data to a table in a data mart. The dimensional framework has already been built. What should the developer create?

  A. Dimension build
  B. JobStream
  C. Metadata dimension
  D. Fact build
  A. Dimension build

• Question 34:

  Which of the following can a developer do with SQLTXT Designer?

  A. Select data from multiple tables using joins.
  B. Select data from multiple text files using joins.
  C. Specify row and column delimiters.
  D. Specify sort order for the flat file.
  C. Specify row and column delimiters.

• Question 35:

  A developer wants to be able to re-use a gross profit calculation in multiple builds. What should be created?

  A. Derived dimension
  B. User-defined function
  C. Derivation
  D. Measure
  E. Attribute
  B. User-defined function

• Question 36:

  Which of the following is are characteristics of surrogate keys? (choose three)

  A. Are numbers.
  B. Tend to be larger than keys from operational systems.
  C. Are text-based.
  D. Are replaced by business keys in the data warehouse.
  E. Have no intrinsic meaning.
  F. Are unique.
  A. Are numbers.
  E. Have no intrinsic meaning.
  F. Are unique.

• Question 37:

  When creating dimensions, what is commonly used to track historical changes?

  A. Level filters
  B. Surrogate keys
  C. Output filters
  D. Derived dimensions
  B. Surrogate keys

• Question 38:

  What is a difference between a measure element and an attribute element?

  A. Attribute values can be aggregated by Data Manager, while measure values cannot.
  B. Measure values can be merged by Data Manager, while attribute values cannot.
  C. Attribute values can be merged by Data Manager, while measure values cannot.
  D. Measure values can be aggregated by Data Manager, while attribute values cannot.
  D. Measure values can be aggregated by Data Manager, while attribute values cannot.

• Question 39:

  Which of the following tasks can be completed with the Dimension Build wizard?

  A. Adding a custom schema to use for the dimension tables.
  B. Specifying the folder in which the dimension build will be stored.
  C. Specifying surrogates and change tracking behaviors.
  D. Creating a connection to hold the dimension tables.
  C. Specifying surrogates and change tracking behaviors.

• Question 40:

  Which of the following is true of the Navigator?

  A. When searching for components, wildcards are not supported.
  B. When a component is selected, dependent components are shown.
  C. Library components (such as hierarchies) cannot be navigated.
  D. Components from different catalogs can be compared.
  B. When a component is selected, dependent components are shown.