IBM C2020-632 Online Practice Questions and Exam Preparation

IBM C2020-632 Online Questions & Answers

• Question 31:

  In Framework Manager, which of the following is a correct technique for maintaining packages?

  A. Edit the contents of a package by including or excluding model objects such as namespaces,folders, and query subjects.
  B. Publish packages to the network as well as to the content store in order to maintain model versioning and prevent report errors.
  C. Perform an impact analysis on a package to identify the impact of changing the cardinality of a relationship between two query subjects included in the package.
  D. When publishing packages, use file system version control so that reports created based on one version of a model will always run against that same version of the model regardless of how many times the package is published.
  A. Edit the contents of a package by including or excluding model objects such as namespaces,folders, and query subjects.

• Question 32:

  What does a star schema database structuretypically consist of?

  A. De-normalized hierarchy of dimension tables and fact tables.
  B. Normalized dimension tables and detailed fact tables.
  C. Normalized dimension tables and summarized fact tables.
  D. De-normalized dimension tables and fact tables.
  D. De-normalized dimension tables and fact tables.

• Question 33:

  With respect to Cognos 10 security, which of the following is true of the Cognos namespace?

  A. Only contains predefined groups and roles.
  B. Can be used to create custom groups, roles and users.
  C. Can be used to create Cognos 10 specific groups and roles.
  D. Can be deleted if a different namespace is used to secure the environment.
  C. Can be used to create Cognos 10 specific groups and roles.

• Question 34:

  What technique can Framework Manager modelers useto implement a time dimension for models that lack a time dimension?

  A. Create relationships from date fields in one dimension to date fields in another dimension.
  B. Use parameter maps to map date values in one query subject to date values in anotherquery subject.
  C. Use the Time Dimension wizard to generate a time dimension and create the appropriate relationships.
  D. Identify a time dimension table source, import into the model and create relationships to fact query subjects.
  D. Identify a time dimension table source, import into the model and create relationships to fact query subjects.

• Question 35:

  In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change?

  A. Level MUN
  B. Level identifier
  C. Member MUNs
  D. Member aliases
  C. Member MUNs

• Question 36:

  To create a report inReport Studio, a report author accesses which object?

  A. A report specification.
  B. A development model from Framework Manager.
  C. The runtime version of a Framework Manager model.
  D. A file that contains query subjects externalized from Framework Manager.
  C. The runtime version of a Framework Manager model.

• Question 37:

  To ensure a query subject is recognized as a fact by the Cognos 10 query engine in all query scenarios, the query subject requires which cardinality rule?

  A. One instance of attached cardinality must be 1..1.
  B. One instance of attached cardinality must be 1..n.
  C. All instances of attached cardinality must be either 1..n or 0..n.
  D. All instances of attached cardinality must be either 1..1 or 0..n.
  C. All instances of attached cardinality must be either 1..n or 0..n.

• Question 38:

  Which of the following iscorrect regarding the Cognos 10 security environment?

  A. Cognos 10 must be configured to use only one authentication provider at a time.
  B. To perform authentication of users, a connection to the Cognos namespace must be defined.
  C. In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.
  D. In Framework Manager, object security is implemented by defining access to objects for groups and roles (of which usersare members), not individual users.
  C. In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.

• Question 39:

  Which column is most likely a non-conformed or non-shared dimension from the SQL below?

  

  A. D2.DAY_DATE
  B. D2.ORDER_METHOD
  C. D3.RETURN_QUANTITY
  D. D3.REASON_DESCRIPTION
  D. D3.REASON_DESCRIPTION

• Question 40:

  When importing metadata into Framework Manager from a relationaldatabase, which of the following can be controlled by the modeler performing the import?

  A. Specifying the item names in various languages.
  B. Specifying the usage property for generated query items.
  C. Converting inner joins in the database to outerjoins in the model.
  D. Generating relationships based on existing primary and foreign key relationships in the database.
  D. Generating relationships based on existing primary and foreign key relationships in the database.