EMT Practice Test

1. Question Content...

---

Question1: Which of the following statements is correct regarding the implementation of object security in Framework Manager?

Question2: In order to create complex joins in Framework Manager, a modeler can use which of the following techniques?

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

Question4: After metadata is imported into Framework Manager or a new query subject is created, is it recommended to first verify which one of the following property settings?

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

Question6: 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?

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

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

Question9: What must a modeler consider when modeling for drill-through between multiple data sources?

Question10: What is true of a Framework Manager model of an operational database lacking a time dimension?

Question11: In Cognos 10, what are the two distinct types authors can publish from Framework Manager?

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

Question13: In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?

Question14: Which of the following are proven practices for organizing the objects in a project?

Question15: Which column is most likely a non-conformed or non-shared dimension from the SQL below?

Question16: 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?

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

Question18: In Framework Manager, which of the following is a correct technique for model segmentation?

Question19: Which of the following is true for 0 .. n cardinality?

Question20: Which of the following is true regarding the operational data structure illustrated below?

Question21: In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?

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

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

Question24: A recursive relationship exists between SALES_STAFF_CODE and MANAGER_CODE in the SALES_STUFF data source query subject. This query subject is provided in a model to report authors.
Using this query subject alone, report authors cannot create a report that includes management staff and the sales staff that report to them. How can the existing recursive relationship in the model be modified to provide this ability to report authors?

Question25: In Framework Manager, which of the following is correct technique for maintaining packages?

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

Question27: Which of the following is true applying object security in Framework Manager?

Question28: In Framework Manager, which of the following is the true about verifying your model?

Question29: Which of the following is true of the generated native SQL below?

Question30: The database table below would typically be found in what data structure?

Question31: To create a report in Report Studio, a report author accesses which object?

Question32: The illustration below represents which of the following data traps?

Question33: What question should a data modeler answer before accepting this proposed operational data structure?

Question34: In a transitive relationship scenario, what problems exist when reporting from the tables below?

Question35: With respect to Cognos 10 security, which of the following is true of the Cognos namespace?

Question36: Which of the following data structures typically contain normalized data?

Question37: What does a star schema database structure typically consist of?

Question38: Which of the following is true of an OLAP data structure?

Question39: Which of the following is correct regarding the Cognos 10 security environment?

Question40: In Framework Manager, it is recommended to model operational metadata as a virtual star schema for which one of the following reasons?

Question41: 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?

Question42: Which of the following join types does the generated SQL below illustrate?
select
Manager.Manager as Manager,

Product.Product as Product

from
datasource_name.database_name.schema.Manager Manager

datasource_name.database_name.schema.Product Product

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

Question44: An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total.
What will the author see in the generated Cognos SQL for the Revenue footer column?

Question45: Which of the following objects in the Framework environment acts as a container and provides a unique name of objects?

Question46: 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?

Question47: The generated Cognos SQL below contains which one of the following joins?

Question48: Which technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?

Question49: In Framework Manager, which of the following statements is correct when working with a multi-lingual project?

Question50: Which of the following components does a basic Cognos 10 stitch query consist of?

Question51: Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?

Question52: 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?