Download IBM Cognos 10 BI Metadata Model Developer.C2090-632.PassCertification.2019-02-28.53q.vcex

Vendor: IBM
Exam Code: C2090-632
Exam Name: IBM Cognos 10 BI Metadata Model Developer
Date: Feb 28, 2019
File Size: 591 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

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?
  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.
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?
  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”.
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?
  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.
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. 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.
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
  1. Inner join
  2. Disjointed join
  3. Outer join
  4. Cross join
Correct answer: D
Question 6
In Framework Manager, which of the following statements is correct when working with a multi-lingual project?
  1. The design languages can be changed at any point.
  2. A project language cannot be deleted once defined in Framework Manager.
  3. A language must be added to the project before it can be published with a package.
  4. 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? 
  
  1. It illustrates a parallel relationship.
  2. It should be consolidated into one table.
  3. It should be examined for a connection trap.
  4. 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?
  1. When importing metadata from more than once data source, include all imported objects in the root namespace.
  2. When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.
  3. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
  4. 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?
  1. The entire model must be verified, individual objects cannot be verified.
  2. The model can only be verified through the Publish Package wizard.
  3. The model can be verified from Cognos Connection or through the Publish Packages wizard.
  4. 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?
  1. Create relationships from date fields in one dimension to date fields in another dimension.
  2. Use parameter maps to map date values in one query subject to date values in another query subject.
  3. Use the Time Dimension wizard to generate a time dimension and create the appropriate relationships.
  4. 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
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!