IBM C2020-632 Online Practice Questions and Exam Preparation

IBM C2020-632 Online Questions & Answers

• Question 41:

  Which of the following are proven practices for organizing the objects in a project?

  A. When importing metadata from more than one data source, include all imported objects in the root namespace.
  B. When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.
  C. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
  D. Whenimporting metadata from more than one data source, do not override the relationships defined between the data sources at the time of import.
  C. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.

• Question 42:

  In Framework Manager, it is recommended to model operational metadata as a virtual star schema for which one of the following reasons?

  A. Provides stability to the underlying data structure.
  B. Creates an easy-to-read data dictionary for end users.
  C. Ensures inner joins between data source query subjects.
  D. Helps to remove ambiguity and provide predictable results.
  D. Helps to remove ambiguity and provide predictable results.

• Question 43:

  Which of the following is true for 0..n cardinality?

  A. The cardinality is optional and a union will be performed.
  B. The cardinality is optional and an inner join will be performed.
  C. The cardinality is optional and an outer join will be performed.
  D. The cardinality is required and an outer join will be performed.
  C. The cardinality is optional and an outer join will be performed.

• Question 44:

  Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?

  A. Resolve conflicting keys and indexes and generate minimized SQL.
  B. Combine facts and dimensions for intuitive ad hoc business views.
  C. Resolve reporting traps and simplify snowflake tables through consolidation.
  D. Provide dimensional information through the use of determinants.
  C. Resolve reporting traps and simplify snowflake tables through consolidation.

• Question 45:

  What is true of a Framework Manager model of an operational database lacking a time dimension?

  A. Virtual star schema models require a time dimensionfor multi-fact queries.
  B. Report authors cannot create multi-fact, time-based queries.
  C. Time-based rollups for multi-fact queries may be difficult to handle.
  D. Report authors cannot create multi-fact, time-based queries unless using a union.
  C. Time-based rollups for multi-fact queries may be difficult to handle.

• Question 46:

  What question should adata modeler answer before accepting this proposed operational data structure?

  

  A. Should all three tables be consolidated into one?
  B. Should a role playing dimension be created?
  C. Are Branch and Employee dimension tables or fact tables?
  D. Isthere a direct relationship between Branch and Employee?
  D. Isthere a direct relationship between Branch and Employee?

• Question 47:

  In Cognos 10, what are the two distinct model types authors can publish from Framework Manager?

  A. OLAP and DMR
  B. Dimensional and DMR
  C. Relational and SAP BW
  D. Relational and Dimensional
  D. Relational and Dimensional

• Question 48:

  In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available toauthors?

  A. Import the stored procedure, add it as a model calculation, and then publish it as part of a package.
  B. Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it aspart of a package.
  C. Import the stored procedure, use it to create a calculation in the expression editor and then publish the calculation as part of a package.
  D. Import the stored procedure, set the type to Data Modification, provide values that satisfythe procedure's arguments, retrieve a projection list and then publish it as part of a package.
  B. Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it aspart of a package.

• Question 49:

  In Framework Manager, which of the following will have a negative impact on query performance?

  A. Enable the Allow Enhanced Model Portability governor.
  B. Set the Cross-product joins and Outer Joins governors to Deny.
  C. Add filters and calculations to model query subjects rather than data source query subjects.
  D. Ensure that, where required, queries are executed against materialized views which contain only aggregated data rather than base tables that contain all the data.
  A. Enable the Allow Enhanced Model Portability governor.

• Question 50:

  In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source querysubjects as little as possible?

  A. To generate the most efficient SQL at run time and simplify model maintenance.
  B. To prevent the exclusion of columns from a table that may be required in future reports.
  C. To prevent improperly constructed SQL andreduce issues with model documentation and readability.
  D. To provide authors with access to all columns in a database table which reduces requests to the modeler?
  A. To generate the most efficient SQL at run time and simplify model maintenance.