Q1. Select the correct statement.
A. Cache provides fast and always up-to-date information.
B. Cache can increase traffic to back end database.
C. Cache needs to be purged to refresh data.
D. Cachecan degrade query performance by reading data from the disk instead of the database.
E. Cache is seeded by manually running PL/SQL at the back end database.
Answer: C
Q2. The Time Dimension hierarchy is a good example of a__________.
A. Level-basedTime Dimension hierarchy
B. Ragged Hierarchy
C. Skip Level Hierarchy
D. Value-based Hierarchy
Answer: A
Q3. The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?
A. Changes to the repository can only be carried out in offline mode.
B. Multiple developers can work on one repository at the same time.Results can be merged later on.
C. All aspects of security are being held in the repository file.
D. Opening the rpd.filein online mode results in performance Issues for the application user.
Answer: B
Q4. What are the two leading design solutions recommended by Oracle that you would use for performance?
A. Design requests that use Complex Queries
B. Avoid returning big data sets within the Dashboard
C. Use Cache
D. Avoid using GuidedNavigation unless the data set is large
Answer: BC
Q5. How will you model a Type II Slowly-Changing Dimension?
A. Add an additional column to the dimension table to capture a version of change
B. Overwrite an existing dimension table record with the changed record
C. Add a new row to the dimension table with a new key for the changed record
D. Do Nothing
Answer: C
Q6. How do Dynamic Repository Variables differ from Static Repository Variables?
A. Dynamic Repository Variables are not initialized by the Initialization Block.
B. Dynamic Repository Variables cannot be used in the Expression Builder.
C. Dynamic Repository Variables can be changed by data that is returned from queries.
D. Dynamic Repository Variables cannot be used in a CASE statement.
Answer: C
Q7. One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?
A. Business RequirementsDefinition
B. Technical Requirements Definition
C. Data Quality Assessment
D. DashboardTesting
Answer: B
Q8. Which option does not describe Aggregate tables?
A. Aggregatetables increase query performance by pre-calculating frequently accessed measure aggregations.
B. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better queryresponse.
C. Aggregate tables typically have fewer rows than the non aggregate tables and,therefore,processing should be quicker.
D. Aggregate tables are created and stored on theBIServer.
Answer: C
Q9. What is the process in which there is redundancy of data to improve performance?
A. Redundancy
B. Normalization
C. Denormalization
D. Granularity
E. Cardinality
Answer: C
Q10. Identify the two types of storage for Essbase.
A. Aggregate Storage Option and Block Storage Option
B. Aggregate Storage and Cell Storage
C. OLAP Storage and Cell Storage
D. Aggregate Storage and Hybrid Columnar Compression
Answer: A