Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-632

IBM C2090-632 Exam Practice Questions (P. 1)

  • Full Access (53 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source query subjects as little as possible?
  1. A
    To generate the most efficient SQL at run time and simplify model maintenance.
  2. B
    To prevent the exclusion of columns from a table that may be required in future reports.
  3. C
    To prevent improperly constructed SQL and reduce issues with model documentation and readability.
  4. D
    To provide authors with access to all columns in a database table which reduces requests to the modeler.

Correct Answer:
A
References:
http://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_fm.doc/c_cognos_sql.html#cognos_sql

Question #2
In order to create complex joins in Framework Manager, a modeler can use which of the following techniques?
  1. A
    Open the Relationship Definition Dialog, and then edit the join expression as required.
  2. B
    Select the relationship, and then from the Actions menu, select "Merge in New Query Subject".
  3. C
    Open the Relationship Expression dialog, and then change both cardinality settings to 0..n or 0..1.
  4. D
    Right-click a relationship in the Object diagram or Context Explorer and then select "Create Compound Join".

Correct Answer:
A
References:
IBM Redbooks: IBM Cognos Business Intelligence V10.1 Handbook. Page: 67

Question #3
In Cognos 10, which of the following is true of multi-fact results sets?
  1. A
    Only correlated result sets can have repeating fact values.
  2. B
    Only contiguous result can have repeating fact values.
  3. C
    Both contiguous and correlated lists can have repeating fact values.
  4. D
    Both contiguous and correlated lists cannot have repeating fact values.

Correct Answer:
C

Question #4
Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?
  1. A
    Resolve conflicting keys and indexes and generate minimized SQL.
  2. B
    Combine facts and dimensions for intuitive ad hoc business views.
  3. C
    Resolve reporting traps and simplify snowflake tables through consolidation.
  4. D
    Provide dimensional information through the use of determinants.

Correct Answer:
C
References:
IBM Redbooks: IBM Cognos Dynamic Query. Page: 36

Question #5
Which of the following join types does the generated SQL below illustrate? select
✑ Manager.Manager as Manager,
✑ Product.Product as Product
from
✑ datasource_name.database_name.schema.Manager Manager
✑ datasource_name.database_name.schema.Product Product
  1. A
    Inner join
  2. B
    Disjointed join
  3. C
    Outer join
  4. D
    Cross join

Correct Answer:
D

Next Questions

All Pages