Download IBM.C2090-632.PassCertification.2019-02-28.53q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-632 |
| Exam Name: | IBM Cognos 10 BI Metadata Model Developer |
| Date: | Feb 28, 2019 |
| File Size: | 755 KB |
Demo Questions
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?
- To generate the most efficient SQL at run time and simplify model maintenance.
- To prevent the exclusion of columns from a table that may be required in future reports.
- To prevent improperly constructed SQL and reduce issues with model documentation and readability.
- To provide authors with access to all columns in a database table which reduces requests to the modeler.
Correct answer: A
Explanation:
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 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?
- Open the Relationship Definition Dialog, and then edit the join expression as required.
- Select the relationship, and then from the Actions menu, select “Merge in New Query Subject”.
- Open the Relationship Expression dialog, and then change both cardinality settings to 0..n or 0..1.
- Right-click a relationship in the Object diagram or Context Explorer and then select “Create Compound Join”.
Correct answer: A
Explanation:
References:IBM Redbooks: IBM Cognos Business Intelligence V10.1 Handbook. Page: 67 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?
- Only correlated result sets can have repeating fact values.
- Only contiguous result can have repeating fact values.
- Both contiguous and correlated lists can have repeating fact values.
- Both contiguous and correlated lists cannot have repeating fact values.
Correct answer: C
