1Z1-591 by Oracle Actual Free Exam Questions And Answers

Question 1

A customer wants to analyze the efficiency of his/her order fulfillment process. If the customer has a dimensional model, which option is the fact table?

A. Time

B. Orders

C. Products

D. Stores

Discussion 0

Correct Answer: B Vote an answer

Question 2

One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.

A. Multiple SQL queries are performed

B. No SQL queries are performed against the source tables

C. A single SQL query is performed to get data from both tables

D. Two SQL queries are performed to get data from both tables

Discussion 0

Correct Answer: C Vote an answer

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

Question 3

Where is Cache in OBIEE located?

A. In relational database

B. In dynamic aggregate

C. In memory cache

D. It is local disk-based.

Discussion 0

Correct Answer: D Vote an answer

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

Question 4

Why is it necessary to join multiple source tables to a single dimension?

A. Because transactional source systems are often denormalized

B. Because transactional source systems are often normalized

C. Because the dimensions tables are built in the transactional systems

D. Because a single source table often contains all the dimensions needed

Discussion 0

Correct Answer: B Vote an answer

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

Question 5

What is an example of a Session Variable?

A. User Organization

B. ETL Load Date

C. Top Customers by Revenue

D. OLAP DSN

Discussion 0

Correct Answer: A Vote an answer

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

Question 6

Content that is saved in personal and shared folders can be browsed by using which view?

A. New -> Analysis

B. Favorites

C. Home

D. Dashboard

E. Catalog

Discussion 0

Correct Answer: E Vote an answer

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

Question 7

Query limits tab can be accessed through________.

A. Security Manager, Application Roles tab, Query dialog box, Permissions

B. Security Manager, Query tab, Application role dialog box, Permissions

C. Security Manager, Application Roles tab, Application role dialog box, Query Properties

D. Security Manager, Application Roles tab, Application role dialog box, Permissions

Discussion 0

Correct Answer: D Vote an answer

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

Question 8

The Consistency Checker checks______.

A. For objects deleted from the database

B. The validity of objects outside the metadata using the connection

C. Mappings to the physical objects

D. Syntax errors in derived logical columns

Discussion 0

Correct Answer: C Vote an answer

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

Question 9

OBIEE default security model stores security Information such as user names and password combinations for accessing an external system such as Active Directory. It is stored in the____________.

A. Policy Store

B. Identity Store

C. Person Store

D. Credential Store

Discussion 0

Correct Answer: B Vote an answer

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

Question 10

Which two steps are needed to set up Failover support for an OBIEE deployment?

A. Use Installer to affect Horizontal scale out of an existing instance

B. Apply OBIEE Clustering option

C. Use Installer to set up separate single instances, then apply Horizontal scale out clustering

D. Employ WebLogic Enterprise Edition, licensed separately

E. Leverage spare hardware capacity of single machine by using Vertical scale out option

Discussion 0

Correct Answer: A,B Vote an answer

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

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

Contact Us

Useful Links

Latest Updated