A. The Extraction Transformation and Loading process creates the aggregate tables.
B. Job Manager can be used to run the Aggregate Persistence script.
C. The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.
D. The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
A. By creating a derived measure on the logical column Item number and using the count Function
B. By creating a derived measure based on the physical column item number and changing the aggregation method to count
C. By creating a derived metric by using the Expression Builder
D. By creating a derived measure on the logical column item number and using the count distinct function
A. The presentation layer defines the relationship that is needed to create the DML.
B. Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.
C. The physical layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source.
D. The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.
A. Cache is seeded by manually running PL/SQL at the back end database.
B. Cache can increase traffic to back end database.
C. Cache can degrade query performance by reading data from the disk instead of the database.
D. Cache needs to be purged to refresh data.
E. Cache provides fast and always up-to-date information.
A. Provide an indirection between LDAP groups and BI roles
B. Are created and managed by using the WLS Admin Console and FMW Control
C. Can be created by using BI Administrator Client and "pushed" to WLS Admin Console
D. Can be exported / moved between FMW11g environments
E. Secures RPD permissions but NOT Web Catalog (webcat) permissions
A. Create a derived metric by using the Expression Builder.
B. Create a derived measure based on Revenue that has all the levels selected on the Level Tab of the Logical Column Dialog except Total Product.
C. Create a derived measure based on Revenue that has the Level Total Product selected on the Level Tab of the Logical Column Dialog.
D. Create a derived measure by using the addition function that adds each product value together.
A. Setting permissions for particular users or application roles
B. Setting up new Roles and Groups
C. Setting up new Application Roles
D. Setting permissions for individual objects in the Presentation Layer
A. Aggregate Persistence Wizard
B. Query Analyzer
C. Expression Builder
D. Table Builder
A. Access and Performance Layer
B. Presentation Data Layer
C. Master Data Layer
D. Staging Data Layer
A. By creating a Presentation Folder called Time<parent> and then two subsequent folders called Fiscal Calendar<child> and Julian Calendar<child>
B. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar
C. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar
D. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar
