C2090-632

Review 53 C2090-632 practice questions with answer explanations and community insights.

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. To generate the most efficient SQL at run time and simplify model maintenance.
  2. To prevent the exclusion of columns from a table that may be required in future reports.
  3. To prevent improperly constructed SQL and reduce issues with model documentation and readability.
  4. To provide authors with access to all columns in a database table which reduces requests to the modeler.

Question 2

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

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

Question 3

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

  1. Only correlated result sets can have repeating fact values.
  2. Only contiguous result can have repeating fact values.
  3. Both contiguous and correlated lists can have repeating fact values.
  4. Both contiguous and correlated lists cannot have repeating fact values.

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. Resolve conflicting keys and indexes and generate minimized SQL.
  2. Combine facts and dimensions for intuitive ad hoc business views.
  3. Resolve reporting traps and simplify snowflake tables through consolidation.
  4. Provide dimensional information through the use of determinants.

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. Inner join
  2. Disjointed join
  3. Outer join
  4. Cross join
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.