File Info
| Exam | IBM Cognos 10 BI Metadata Model Developer |
| Number | C2090-632 |
| File Name | IBM.C2090-632.PassCertification.2019-02-28.53q.vcex |
| Size | 591 KB |
| Posted | Feb 28, 2019 |
| Download | IBM.C2090-632.PassCertification.2019-02-28.53q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
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?
- Resolve conflicting keys and indexes and generate minimized SQL.
- Combine facts and dimensions for intuitive ad hoc business views.
- Resolve reporting traps and simplify snowflake tables through consolidation.
- Provide dimensional information through the use of determinants.
Correct answer: C
Explanation:
References:IBM Redbooks: IBM Cognos Dynamic Query. Page: 36 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
- Inner join
- Disjointed join
- Outer join
- Cross join
Correct answer: D
Question 6
In Framework Manager, which of the following statements is correct when working with a multi-lingual project?
- The design languages can be changed at any point.
- A project language cannot be deleted once defined in Framework Manager.
- A language must be added to the project before it can be published with a package.
- When a new language is added to a project, all locales for that language are added as well.
Correct answer: C
Explanation:
References:https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_fm.doc/t_specifylanguages.html References:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_fm.doc/t_specifylanguages.html
Question 7
Which of the following is true regarding the operational data structure illustrated below?
- It illustrates a parallel relationship.
- It should be consolidated into one table.
- It should be examined for a connection trap.
- The cardinality between the tables should be reversed.
Correct answer: C
Explanation:
References:IBM Cognos Framework Manager: Design Metadata Models (v10.1). Volume 1 Student Guide: Section 2-21. References:
IBM Cognos Framework Manager: Design Metadata Models (v10.1). Volume 1 Student Guide: Section 2-21.
Question 8
Which of the following are proven practices for organizing the objects in a project?
- When importing metadata from more than once data source, include all imported objects in the root namespace.
- When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.
- When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
- When importing metadata from more than one data source, do not override the relationships defined between the data source at the time of import.
Correct answer: C
Explanation:
References:http://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_fm.doc/c_importingmetadata.html References:
http://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_fm.doc/c_importingmetadata.html
Question 9
In Framework Manager, which of the following is the true about verifying your model?
- The entire model must be verified, individual objects cannot be verified.
- The model can only be verified through the Publish Package wizard.
- The model can be verified from Cognos Connection or through the Publish Packages wizard.
- It is possible to select to automatically repair certain issues that have been detected.
Correct answer: D
Explanation:
References:http://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_fm.doc/t_checkproject.html References:
http://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_fm.doc/t_checkproject.html
Question 10
Which technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?
- Create relationships from date fields in one dimension to date fields in another dimension.
- Use parameter maps to map date values in one query subject to date values in another query subject.
- Use the Time Dimension wizard to generate a time dimension and create the appropriate relationships.
- Identify a time dimension table source, import into the model and create relationships to fact query subjects.
Correct answer: D
Explanation:
References:http://www.ibm.com/developerworks/library/ba-pp-modeling-insight-page686/index.html References:
http://www.ibm.com/developerworks/library/ba-pp-modeling-insight-page686/index.html
