IBM C2020-632 Online Practice Questions and Exam Preparation

IBM C2020-632 Online Questions & Answers

• Question 1:

  Which of the following data structures typically contain normalized data?

  A. Cube
  B. Relational
  C. Operational
  D. Data Warehouse
  C. Operational

• Question 2:

  The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?

  A. Query items.
  B. Data sources.
  C. Relationships.
  D. Parameter maps.
  A. Query items.

• Question 3:

  When running an interactive HTML report, which of the following aggregation methods is used by default?

  A. Unspecified
  B. Running
  C. Unknown
  D. Extended
  B. Running

• Question 4:

  What must a modeler consider when modeling for drill-through between multiple datasources?

  A. Drill-through values must be cast.
  B. Drill-through values must be conformed.
  C. Drill-through values must be consolidated.
  D. Drill-through values must be identifiers.
  B. Drill-through values must be conformed.

• Question 5:

  Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?

  A. model
  B. folder
  C. namespace
  D. query subject folder
  C. namespace

• Question 6:

  An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total. What will the author see in the generated Cognos SQL for the Revenue footer column?

  A. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
  B. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2
  C. XSUM(XSUM(Sales_Fact.Revenue forTime_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
  D. XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1
  D. XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1

• Question 7:

  In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?

  A. Create stand-alone filters.
  B. Add performanceindicators to functions.
  C. Configure data sources in a project pointing to the same database instance to use the same connection.
  D. For a query item having an integer data type, set the Display Item Reference property to display an integer value.
  C. Configure data sources in a project pointing to the same database instance to use the same connection.

• Question 8:

  The illustration below represents which of the following data traps?

  

  A. Bridge
  B. Connection
  C. Parallel relationship
  D. Many-to-many relationship
  C. Parallel relationship

• Question 9:

  In Framework Manager, which of the following is a correct technique for model segmentation?

  A. Segment a project at the level ofan individual query subject.
  B. Define the repository type and path to the repository in Cognos Connection.
  C. Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location.
  D. Copy all segmented model files into one common folder before using Framework Manger's model merge feature.
  C. Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location.

• Question 10:

  In order to create complex joins in Framework Manager, a modeler can use which of the following techniques?

  A. Open the Relationship Definition dialog, and then edit the join expression as required.
  B. Select the relationship, and then from the Actions menu, select "Merge in New Query Subject".
  C. Open theRelationship Expression dialog, and then change both cardinality settings to 0..n or 0..1.
  D. Right-click a relationship in the Object diagram or Context Explorer, and then select "Create Compound Join".
  A. Open the Relationship Definition dialog, and then edit the join expression as required.