Q1. There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
A. By creating two new logical tables sources
B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
C. Both Aand B
D. By creating one new LogicalTableSource
Answer: B
Q2. A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?
A. Clicking the "Time" option in theLogical Dimension Dialog
B. Designatingachronological key for every level of every dimension hierarchy
C. Clicking the "Time" option in the LogicalTable Source Dialog
D. Designating a chronological keyfor every logical column in the Logical Table Source
E. Specifying a sort order in theLogicalTable dialog
Answer: AB
Q3. Select the scenario in which block storage must be used instead of aggregate storage.
A. Incremental data loading
B. Top - down planning
C. Extremely sparse data sets
D. Millions of members in the outline
Answer: B
Q4. The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?
A. Start and Stop BI Services
B. Build Aggregate Queries
C. Create SummaryTables
D. Manage user logins
Answer: A
Q5. Which option is used to enter the rank function when creating a new rank measure?
A. Initialization Block
B. Expression Builder
C. Connection Pool
D. Web Catalog
Answer: B
Q6. Which option describes how OBIEE Integrates with Planning?
A. OBIEE primarily accesses Planning using standard Essbase integration techniques.
B. OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer.
C. Planning is not a supported OBIEE source.
D. OBIEEintegrates with Planning directly through relational database access.
Answer: AB
Q7. A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
A. By creating a derived measure by using the Logical Columns available
B. By creating a derived measure in the Column Mapping dialog box byusing the physical tablecolumns.
C. By creating a derived measure by using LogicColumnsavailable andchanging theaggregationtype
D. By creating a derived metricby using the Expression Builder
E. By creatinga derived metricby using the Calculation Wizard
Answer: C
Q8. Which component is responsible for determining the device that receives the alerts for a given user account?
A. Dashboard
B. iBot
C. Alerts
D. Delivery Profiles
Answer: B
Q9. Initialization Blocks are never used to initialize which option?
A. Dynamic Repository Variables
B. System Session Variables
C. Non System Session Variables
D. rpd file
Answer: D
Q10. What are the two types of Session Variables?
A. System
B. Non System
C. Static
D. Dynamic
Answer: AB