COGNOS Cognos 8 BI Metadata Model Developer Sample Questions:
1. The Cognos 8 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) Correlated list
C) Multi-fact split
D) Contiguous result set
2. In Framework Manager, when using star schema groupings in the business view, conformed dimensions can be identified by which one of the following?
A) Viewing the properties of the query subjects in Report Studio.
B) Viewing the properties of the query subjects in Framework Manager.
C) Using the same name for the dimension in each star schema grouping.
D) Using a different query subject icon for display in the studios.
3. 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 SQL of a model query subject.
B) Viewed in the Project Viewer and used in the expression editor.
C) Viewed in the Diagram and used in the SQL of a data source query subject.
D) Viewed in the Explorer and used in the expression editor.
4. 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 relationships between regular dimensions and measure dimensions.
C) Create star schema groupings for dimension and fact query subjects.
D) Create shortcuts to regular dimensions and fact query subjects.
5. In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?
A) Import the stored procedure, use it to create a calculation in the expression editor and then publish the calculation as part of a package.
B) Import the stored procedure, add it as a model calculation, and then publish it as part of a package.
C) Import the stored procedure, set the type to Data Modification, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package.
D) Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: D | Question # 4 Answer: A | Question # 5 Answer: D |














1098 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
