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. In Framework Manager, which of the following is a correct technique for model segmentation? 

A. Segment a project at the level of an individual query subject. 

B. Define the repository type and path to the repository in Cognos Connection. 

C. Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location. 

D. Copy all segmented model files into one common folder before using Framework Manger's model merge feature. 

Answer: C 


Q2. In Framework Manager, which of the following is a correct technique for maintaining packages? 

A. Edit the contents of a package by including or excluding model objects such as namespaces, folders, and query subjects. 

B. Publish packages to the network as well as to the content store in order to maintain model versioning and prevent report errors. 

C. Perform an impact analysis on a package to identify the impact of changing the cardinality of a relationship between two query subjects included in the package. 

D. When publishing packages, use file system version control so that reports created based on one version of a model will always run against that same version of the model regardless of how many times the package is published. 

Answer: A 


Q3. To ensure a query subject is recognized as a fact by the Cognos 10 query engine in all query scenarios, the query subject requires which cardinality rule? 

A. One instance of attached cardinality must be 1..1. 

B. One instance of attached cardinality must be 1..n. 

C. All instances of attached cardinality must be either 1..n or 0..n. 

D. All instances of attached cardinality must be either 1..1 or 0..n. 

Answer: C 


Q4. Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects? 

A. model 

B. folder 

C. namespace 

D. query subject folder 

Answer: C 


Q5. In Cognos 10, what are the two distinct model types authors can publish from Framework Manager? 

A. OLAP and DMR 

B. Dimensional and DMR 

C. Relational and SAP BW 

D. Relational and Dimensional 

Answer: D 


Q6. Which of the following are proven practices for organizing the objects in a project? 

A. When importing metadata from more than one data source, include all imported objects in the root namespace. 

B. When importing metadata from more than one data source, create a separate folder for the imported objects from each data source. 

C. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source. 

D. When importing metadata from more than one data source, do not override the relationships defined between the data sources at the time of import. 

Answer: C 


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


Q8. In Framework Manager, which of the following will have a negative impact on query performance? 

A. Enable the Allow Enhanced Model Portability governor. 

B. Set the Cross-product joins and Outer Joins governors to Deny. 

C. Add filters and calculations to model query subjects rather than data source query subjects. 

D. Ensure that, where required, queries are executed against materialized views which contain only aggregated data rather than base tables that contain all the data. 

Answer: A 


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


Q10. 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? 

A. To generate the most efficient SQL at run time and simplify model maintenance. 

B. To prevent the exclusion of columns from a table that may be required in future reports. 

C. To prevent improperly constructed SQL and reduce issues with model documentation and readability. 

D. To provide authors with access to all columns in a database table which reduces requests to the modeler? 

Answer: A