IBM C2020-625 Online Practice Questions and Exam Preparation

IBM C2020-625 Online Questions & Answers

• Question 1:

  Which of the following is an advantage of using conformed dimensions in a data warehouse?

  A. Conformed dimensions do not require the use of surrogate keys.
  B. Conformed dimensions enable users to drill from one area of their business to another.
  C. Conformed dimensions enable database views to be reused across the data warehouse.
  D. Conformed dimensions do not require the use of lookups.
  B. Conformed dimensions enable users to drill from one area of their business to another.

• Question 2:

  An Employee hierarchy has been created using the Hierarchy wizard. However, employee names now need to be included in the hierarchy. What should be done?

  A. Select the hierarchy and rerun the Hierarchy wizard to add an attribute to it.
  B. Manually add the Employee Name attribute to the template and to the hierarchy.
  C. Add a derivation to the dimension build to include Employee Name.
  D. Create another dimension build to populate the hierarchy with an Employee Name attribute.
  B. Manually add the Employee Name attribute to the template and to the hierarchy.

• Question 3:

  A developer has geographical data from a data source where cities roll up into states, and states roll up into regions. What should the developer create in order to allow Data Manager to aggregate fact data to the region level?

  A. Derived dimension
  B. Lookup
  C. Derivation
  D. Hierarchy
  E. Dimension
  D. Hierarchy

• Question 4:

  Which element does Data Manager use to identify duplicate rows?

  A. Dimension
  B. Attribute
  C. Measure
  D. Index
  A. Dimension

• Question 5:

  What distinguishes an OLTP system from a data warehouse? (choose two)

  A. An OLTP system captures and processes original business transactions, while a data warehouse does not.
  B. A data warehouse captures and processes original business transactions, while an OLTP system does not.
  C. An OLTP system is used to transform, clean, and combine operational data, while a data warehouse is not.
  D. A data warehouse is fully normalized, while an OLTP system is fully denormalized.
  E. A data warehouse is fully denormalized, while an OLTP system is fully normalized.
  A. An OLTP system captures and processes original business transactions, while a data warehouse does not.
  E. A data warehouse is fully denormalized, while an OLTP system is fully normalized.

• Question 6:

  Which of the following is true of a dimension build?

  A. It uses literals to define the behavior of each column of a dimension table.
  B. It can generate PowerCubes, Framework Manager models, and Cognos 8 reports.
  C. It can deliver data to a single, "private" data mart.
  D. It uses a template to define the behavior of each column of a dimension table.
  D. It uses a template to define the behavior of each column of a dimension table.

• Question 7:

  When executed, what will the following command line string do?"c:\program files\cognos\c8\bin\rundsjob.exe" -P "ODBC" "DSN=DS_Advanced;DBMS=(other)" "Inventory_Fact_Data" VTRACE_VALUES=PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDSQL,USER,VARIA BLE

  A. Execute a fact build called Inventory_Fact_Data.
  B. Add tables (such as INTERNAL) to the Inventory_Fact_Data database.
  C. Execute a JobStream called Inventory_Fact_Data.
  D. Create a database called Inventory_Fact_Data and add a connection to it.
  C. Execute a JobStream called Inventory_Fact_Data.

• Question 8:

  What can be seen with Reference Explorer that cannot be seen when using SQLTerm to examine the data?

  A. Hierarchical data from two database connections.
  B. Number of rows in the data source used to build the hierarchy.
  C. Number of tables in the data source used to build the hierarchy.
  D. Columns from which the member data was obtained.
  A. Hierarchical data from two database connections.

• Question 9:

  A developer has created a hierarchy that uses multiple data sources. The developer wants to know if there are multiple parents or children without parents. What tool should the administrator use?

  A. Navigator
  B. SQLTXT Designer
  C. SQLTerm
  D. Reference Explorer
  E. Hierachy wizard
  D. Reference Explorer

• Question 10:

  A developer has added a data source connection to a Data Manager catalog. This connection points to a relational database. The developer wants to view the contents of this database, such as the number of tables that it contains. What tool could the administrator use?

  A. SQLTerm
  B. SQLTXT Designer
  C. ODBC Administrator
  D. Reference Explorer
  A. SQLTerm