1z0-591 Exam Training Practice Tests (Oracle Business Intelligence Foundation Suite 11g Essentials)]

Question 1

Which language is used by OBIEE to query Essbase?

A. SQL B. DMX C. LINQ D. MDX

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

DSNs are set up for access to which data sources?

A. ODBC Data Sources B. Oracle Data Sources C. IBM Data Sources D. Teradata Data Sources

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

The Time Dimension hierarchy is a good example of a__________.

A. Level-based Time Dimension hierarchy B. Value-based Hierarchy C. Ragged Hierarchy D. Skip Level Hierarchy

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

A. Year B. Month C. Quarter D. CurrentMonth

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

Which component is responsible for determining the device that receives the alerts for a given user account?

A. Dashboard B. Alerts C. iBot D. Delivery Profiles

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

How do Dynamic Repository Variables differ from Static Repository Variables?

A. Dynamic Repository Variables cannot be used in the Expression Builder. B. Dynamic Repository Variables cannot be used in a CASE statement. C. Dynamic Repository Variables are not initialized by the Initialization Block. D. Dynamic Repository Variables can be changed by data that is returned from queries.

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?

A. Basic Directory for storing user details B. Application of Session Variables as Data Filters C. Subject area and row-level security, connection pool passwords D. Authentication and Authorization E. Creating and Maintaining Users

Correct Answer: A,D,E

Question 8

Point-and-click generation of case statement logic can be accessed via which option?

A. Subject Area metrics B. Compound Layout C. Advanced Tab D. Column Properties -> Conditional Format tab E. Column Formula -> Bins tab

Correct Answer: E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 9

What must be purchased when integrating Oracle map with Oracle BI?

A. Spatial Option with Database B. Oracle Business Intelligence Enterprise Edition C. OLAP option D. Oracle Mapviewer

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Oracle Business Intelligence Foundation Suite 11g Essentials - 1z0-591 Exam Practice Test