Oracle Business Intelligence Foundation Suite 11g Essentials (1z0-591) Free Practice Test
Question 1
What are the two methodologies that are followed within an OBIEE implementation?
Correct Answer: A,B
Question 2
DSNs are set up for access to which data sources?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 3
Select the correct statement.
Correct Answer: E
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 4
An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 5
Selecting the Manage Map Data link allows one to do which three of the following?
Correct Answer: A,C,D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 6
A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 7
What is an example of a Session Variable?
Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 8
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?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 9
What is the first step when creating an Aggregate table in the OBI repository?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 10
How will you model a Type II Slowly-Changing Dimension?
Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).