Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

27
Students signed up in the last 24H

IBM C2090-632 Exam Actual Questions

The questions for C2090-632 were last updated on May 2, 2024.
  • Viewing page 1 out of 14 pages.
  • Viewing questions 1-4 out of 53 questions
 

Topic 1 - Single Topic

Question #1 Topic 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?

  • 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 and reduce 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.
Reveal Solution Hide Solution   Discussion  

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 Topic 1

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 the Relationship 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".
Reveal Solution Hide Solution   Discussion  

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

Question #3 Topic 1

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

  • A. Only correlated result sets can have repeating fact values.
  • B. Only contiguous result 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.
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #4 Topic 1

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.
Reveal Solution Hide Solution   Discussion  

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

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel