IBM C2020-632 Online Practice Questions and Exam Preparation

IBM C2020-632 Online Questions & Answers

• Question 21:

  When a modeler imports metadata into FrameworkManager, the Usage property for a non- indexed, numeric query item is set to which of the following?

  A. Fact
  B. Attribute
  C. Identifier
  D. Measure Dimension
  A. Fact

• Question 22:

  In Cognos 10, which of the following is true of multi-fact result sets?

  A. Only correlated result sets can have repeating fact values.
  B. Only contiguous result sets can have repeating fact values.
  C. Both contiguous and correlated lists can have repeating fact values.
  D. Both contiguous and correlated lists cannot have repeating fact values.
  C. Both contiguous and correlated lists can have repeating fact values.

• Question 23:

  The generated Cognos SQL below contains which one of the following joins?

  

  A. Inner join onRETURN_REASON_KEY.
  B. Outer join on RETURN_REASON_KEY.
  C. Left inner join on RETURN_REASON_KEY.
  D. Left outer join on RETURN_REASON_KEY.
  A. Inner join onRETURN_REASON_KEY.

• Question 24:

  In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap?

  A. Unwanted query splits (full outer joins).
  B. One query subject with several relationships.
  C. Multiple ambiguous joins betweentwo query subjects.
  D. Queries that reference two facts with no conformed dimension.
  C. Multiple ambiguous joins betweentwo query subjects.

• Question 25:

  Which of the following is true of an OLAP data structure?

  A. Comprised of normalized dimension and fact structures.
  B. Organizes dimension tables into hierarchies and levels.
  C. Allows "real time" analysis against disparate data sources.
  D. Cardinality must be defined.
  B. Organizes dimension tables into hierarchies and levels.

• Question 26:

  Which of the following is true regarding the operational data structure illustrated below?

  

  A. It illustrates a parallel relationship.
  B. It should be consolidated into one table.
  C. It shouldbe examined for a connection trap.
  D. The cardinality between the tables should be reversed.
  C. It shouldbe examined for a connection trap.

• Question 27:

  In Framework Manager, when using star schemagroupings in the business view, conformed dimensions can be identified by which one of the following?

  A. Using a different query subject icon for display in the studios.
  B. Viewing the properties of the query subjects in Report Studio.
  C. Viewing theproperties of the query subjects in Framework Manager.
  D. Using the same name for the dimension in each star schema grouping.
  D. Using the same name for the dimension in each star schema grouping.

• Question 28:

  A recursive relationship exists betweenSALES_STAFF_CODE and MANAGER_CODE in the SALES_STAFF data source query subject. This query subject is provided in a model to report authors. Using this query subject alone, report authors cannot create a report that includes management staff and the salesstaff that report to them. How can the existing recursive relationship in the model be modified to provide this ability to report authors?

  A. Import a query subject that does not contain a recursive relationship.
  B. Create a star schema grouping thatcontains the SALES_STAFF data source query subject and a shortcut to the SALES_STAFF data source query subject.
  C. Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both availableto report authors.
  D. Create a shortcut to the SALES_STAFF data source query subject, and report authors will use it instead of the underlying query subject to create the required report.
  C. Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both availableto report authors.

• Question 29:

  In Framework Manager, which of the following statements is correct when working with a multi-lingual project?

  A. The design language can be changed at any point.
  B. A project language cannot be deleted once defined inFramework Manager.
  C. A language must be added to the project before it can be published with a package.
  D. When a new language is added to a project, all locales for that language are added as well.
  C. A language must be added to the project before it can be published with a package.

• Question 30:

  After metadata is imported into Framework Manager or a new query subject is created, it is recommended to first verify which one of the following property settings?

  A. Usage
  B. Aggregate
  C. Data Type
  D. Semi-Aggregate
  A. Usage