Q1. The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.
A. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.
B. TheBIserver cannot integrate various sourcesin one metadata model.
C. Dataquality issues might emerge, due to missing data cleansing.
D. Business issues are depending on real-time data.
Answer: AC
Q2. Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished?
A. Everyday before Data Warehouse refresh
B. Every day after Data Warehouse refresh
C. Every Monday early morning
D. Every Monday late night
Answer: D
Q3. Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
A. Assign users to a webcatalog group
B. Create a new repository group
C. Createanew user in the repository
D. Createaweb catalog group
E. Define permissions for Dashboard
Answer: BC
Q4. An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010 and 2011 on a single report. How can you model this in the RPD?
A. By creating two Logical Fact Tables for each database
B. By creating joins in the physical model so it looks like a single table
C. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
D. By creatingtwo logical table sourcesand checkingthe“This Source should be combined with other sources at this level”box leaving the Fragmentation content area blank.
E. By creatingonelogical table sources and checkingthe“This Source should be combined with other sources at this level” box
Answer: E
Q5. Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?
A. Navteq
B. TeleAtlas
C. Google
D. ESRI
Answer: C
Q6. When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
A. The analyst mustfirstwrite DML (Data Manipulation Language) scriptstocreate the aggregate table.
B. TheAggregate Persistence Wizard enables youto automate the creation of physical aggregate tables and theircorresponding objects in the repository.
C. Job Managercanbe used to run the Aggregate Persistence script.
D. TheExtractionTransformation and Loading process creates the aggregate tables.
Answer: BC
Q7. You run the Consistency Check and receive the warning:
[39003] Missing functional dependency association for column: DIM_Offer_End_Date.CREATE_DT.
What would you check?
A. Whether the logical table source for this column has been disabled
B. Whether the columns creating CREATE_DT have been deleted
C. Whether there is a logical join between the DIM and FACT tables
D. Whether there is a physical join between the DIM and FACT tables
E. Whether there is a physical column mapped to the logical column
F. DIM_Offer_End_Date.CREATE_DT
Answer: A
Q8. Which language is used by OBIEE to query Essbase?
A. SQL
B. LINQ
C. MDX
D. DMX
Answer: C
Q9. Which of the following characteristics pertain to a "ragged" hierarchy?
A. It can only be stored in an XML structure.
B. A branch of the hierarchy may have a different number of levels than other branches.
C. All values can have a maximum of six levels.
D. It creates multiple levels of hierarchy in the databasetable.
Answer: B
Q10. Which OBIEE capability enables developers to build Aggregate tables?
A. Aggregate Persistence Wizard
B. Expression Builder
C. Table Builder
D. Query Analyzer
Answer: A