Exam Code: C2090-632 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM Cognos 10 BI Metadata Model Developer
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-632 Exam.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-632 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-632 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-632-exam-dumps.html

Q1. 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. 

Answer: C 


Q2. If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use? 

A. Create regular and measure dimensions and set scope. 

B. Create shortcuts to regular dimensions and fact query subjects. 

C. Create star schema groupings for dimension and fact query subjects. 

D. Create relationships between regular dimensions and measure dimensions. 

Answer: A 


Q3. In Framework Manager, if a modeler tests the Month from Time Dimension and SALE_TOTAL from Sales Fact and applies Auto Sum, which of the following is a modeler most likely to see? 

A. An XMIN on Month. 

B. An XSUM on Month. 

C. An XMIN on SALE_TOTAL. 

D. An XSUM on SALE_TOTAL. 

Answer: D 


Q4. In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap? 

A. Unwanted query splits (full outer joins). 

B. One query subject with several relationships. 

C. Multiple ambiguous joins between two query subjects. 

D. Queries that reference two facts with no conformed dimension. 

Answer: C 


Q5. The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects? 

A. Query items. 

B. Data sources. 

C. Relationships. 

D. Parameter maps. 

Answer: A 


Q6. To create a report in Report Studio, a report author accesses which object? 

A. A report specification. 

B. A development model from Framework Manager. 

C. The runtime version of a Framework Manager model. 

D. A file that contains query subjects externalized from Framework Manager. 

Answer: C 


Q7. Which of the following components does a basic Cognos 10 stitch query consist of? 

A. SC() function, full outer join, multiple queries that each query exclusive information. 

B. SC() function, full outer join, multiple queries that query some of the same information. 

C. Coalesce function, full outer join, multiple queries that each query exclusive information. 

D. Coalesce function, full outer join, multiple queries that query some of the same information. 

Answer: D 


Q8. When a modeler imports metadata into Framework Manager, the Usage property for a non-indexed, numeric query item is set to which of the following? 

A. Fact 

B. Attribute 

C. Identifier 

D. Measure Dimension 

Answer: A 


Q9. Which of the following data structures typically contain normalized data? 

A. Cube 

B. Relational 

C. Operational 

D. Data Warehouse 

Answer: C 


Q10. In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change? 

A. Level MUN 

B. Level identifier 

C. Member MUNs 

D. Member aliases 

Answer: C