COGNOS Cognos 8 BI Metadata Model Developer Sample Questions:
1. 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.
2. What does a star schema database structure typically consist of?
A) Normalized dimension tables and detailed fact tables.
B) Normalized dimension tables and summarized fact tables.
C) De-normalized hierarchy of dimension tables and fact tables.
D) De-normalized dimension tables and fact tables.
3. In Cognos 8, what are the two distinct model types authors can work with?
A) OLAP and DMR
B) Dimensional and DMR
C) Relational and Dimensional
D) Relational and SAP BW
4. 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 Month.
B) Define both Month and Day determinant levels in the Time Dimension and Group By Day.
C) Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.
D) Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain.
5. Which of the following is true when applying object security in Framework Manager?
A) Allow overrides Deny if specified in the properties of the object.
B) If beginning to apply security by specifying object security on an object with no children, all other objects remain accessible to all users.
C) Child objects only inherit security from their parent if the Inherit property is set to Yes.
D) If beginning to apply security by specifying object security on an object with no children, all other objects will not be accessible to all users.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: D | Question # 3 Answer: C | Question # 4 Answer: A | Question # 5 Answer: D |
1035 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.
