Ucertify offers free demo for C2090-632 exam. "IBM Cognos 10 BI Metadata Model Developer", also known as C2090-632 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-632 exam, will help you answer those questions. The C2090-632 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-632 exams and revised by experts!


♥♥ 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

Q21. What question should a data modeler answer before accepting this proposed operational data structure? 

A. Should all three tables be consolidated into one? 

B. Should a role playing dimension be created? 

C. Are Branch and Employee dimension tables or fact tables? 

D. Is there a direct relationship between Branch and Employee? 

Answer: D 


Q22. Which of the following is true of an OLAP data structure? 

A. Comprised of normalized dimension and fact structures. 

B. Organizes dimension tables into hierarchies and levels. 

C. Allows "real time" analysis against disparate data sources. 

D. Cardinality must be defined. 

Answer: B 


Q23. Users want to compare Actual Revenue and Sales Target values by Month. Actual Revenue values are stored at the day grain in the Orders Fact table. Sales Target values are stored at the month grain in the Sales Target Fact table. 

In Framework Manager, which technique will best prevent Sales Target values from being double-counted in Query Studio reports? 

A. Define both Month and Day determinant levels in the Time Dimension and Group By Day. 

B. Define both Month and Day determinant levels in the Time Dimension and Group By Month. 

C. Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain. 

D. Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map. 

Answer: B 


Q24. The Cognos 10 report below contains two conformed dimensions, Time Dimension and Product Dimension, and one non-conformed dimension, Order Method. 

Which of the following best describes the results? 

A. Cross join 

B. Multi-fact split 

C. Correlated list 

D. Contiguous result set 

Answer: C 


Q25. When importing metadata into Framework Manager from a relational database, which of the following can be controlled by the modeler performing the import? 

A. Specifying the item names in various languages. 

B. Specifying the usage property for generated query items. 

C. Converting inner joins in the database to outer joins in the model. 

D. Generating relationships based on existing primary and foreign key relationships in the database. 

Answer: D 


Q26. The generated Cognos SQL below contains which one of the following joins? 

A. Inner join on RETURN_REASON_KEY. 

B. Outer join on RETURN_REASON_KEY. 

C. Left inner join on RETURN_REASON_KEY. 

D. Left outer join on RETURN_REASON_KEY. 

Answer: A 


Q27. In Framework Manager, when using star schema groupings in the business view, conformed dimensions can be identified by which one of the following? 

A. Using a different query subject icon for display in the studios. 

B. Viewing the properties of the query subjects in Report Studio. 

C. Viewing the properties of the query subjects in Framework Manager. 

D. Using the same name for the dimension in each star schema grouping. 

Answer: D 


Q28. A user-defined function imported into Framework Manager can be viewed and used in the following locations? 

A. Viewed in the Explorer and used in the expression editor. 

B. Viewed in the Project Viewer and used in the expression editor. 

C. Viewed in the Explorer and used in the SQL of a model query subject. 

D. Viewed in the Diagram and used in the SQL of a data source query subject. 

Answer: A 


Q29. In Framework Manager, which of the following is true about verifying your model? 

A. The entire model must be verified, individual objects cannot be verified. 

B. The model can only be verified through the Publish Packages wizard. 

C. The model can be verified from Cognos Connection or through the Publish Packages wizard. 

D. It is possible to select to automatically repair certain issues that have been detected. 

Answer: D 


Q30. When running an interactive HTML report, which of the following aggregation methods is used by default? 

A. Unspecified 

B. Running 

C. Unknown 

D. Extended 

Answer: B