QUESTION: 1
When a customer wants to get sales numbers by day, how is data stored in the Star
Schema, if the data is loaded nightly?
A. The lowest level of aggregation
B. The highest level of aggregation
C. Multiple levels of aggregation
D. Independently from aggregation level
Answer(s): A
QUESTION: 2
The highest sales amount for this year is $10, 000. If you create a rank measure for sales
this year and display it on a report, the value wil be________.
A. $10, 000
B. 0
C. 1
D. Year
Answer(s): C
Explanation: The rank measure is numbered from 1. The highest sales amount will be ranked 1.
QUESTION: 3
Which two components are required for all OBIEE installations?
A. Admin Server
B. RCU Schema
C. Managed Server
D. Node Manager
E. Oracle 11g
Answer(s): B, E
Explanation: B: Before you can run Oracle Business Intelligence 11g Installer, you must first create
required Oracle Business Intelligence schemas in an unhardened database. You use a tool
called the Repository Creation Utility (RCU) to create these schemas with the appropriate
permissions and data.
E: The database 11gR2 is required if you want to run the Oracle Business Intelligence
Enterprise Edition plus Samples
One Oracle Database Preinstalled and not hardened to host the schemas.
QUESTION: 4