1Z0-591 Online Practice Questions and Answers

Correct Answer: B

Example (see step 4 and 5 below): Getting Top-N Sales Reps for Year and Year-1

1.

Under the "Business Model and Mapping" Layer, right click the "F1 Revenue" and select "New Object" -> "Logical Column..."

2.

In the "Logical Column" Window give for Name: Year Ago Revenue as seen below:

3.

Goto the "Column Source" Tab and select "Derived from existing columns using an expression" radio button then click on the "Edit Expression" icon.

4.

Enter the following expression in the "Expression Builder" Window by selecting "Functions" in the "Category:" list, "Time Series Functions" in the "Functions:" list then "Ago" "Time Series Functions:" section.

5.

Select the "<>" in the "Ago( )" function, then select "Logical Tables" in the "Category:" list, "F1 Revenue" in the "Logical Tables:" list, then double click the "Revenue" in the "Columns:" list. Etc.

Correct Answer: ACD

Explanation: WLS Embedded LDAP Server

*By default, OBIEE 11g users and groups are now held in the WLS LDAP Server (C)

-More robust directory for storing user details

-Recommended for >1000 users

*

WLS Admin Server Console now used for creating and maintaining users (A)

*

BI Server "outsources" all authentication, authorization to FMW11g (not B)

*

BI Administration tool now used for subject area and row-level security, connection pool passwords only (D) ?WLS LDAP Server can be "swapped out" for alternative directories (MS AD etc)

Correct Answer: BC

Explanation: C: OBIEE Caching and Cache Seeding

Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be

stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration.

For time-consuming Dashboard Pages, we can use the concept of cache seeding in OBIEE, this can be configured as a scheduled job that will ensure that the data is cached and readily available as and when the user runs the dashboard.

Correct Answer: C

Explanation: The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi-dimensional data source, rather than an SQL query against a relational star schema.

Correct Answer: B

Explanation: Denormalized data in the transactional system could be divided into different tables to increase performance.

Correct Answer: A

Correct Answer: B

Explanation: In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files.

Correct Answer: ACD

Explanation: Oracle BI Cluster Server Components

*

Oracle Business Intelligence Cluster Controller: The Cluster Controller determines which BI Server works in the cluster. It monitors the operation of servers in the cluster. The Cluster Controller is deployed in active-passive mode.

*

Clustered BI Servers: The BI Cluster Server feature supports up to 16 BI Servers in a network domain to act as a single server. BI Servers in the cluster share requests from multiple Oracle BI clients.

*

Master BI Server: A clustered Oracle Business Intelligence Server is designated as the Master BI Server. The Oracle Business Intelligence Administration Tool connects to the master BI Server for online repository changes.

*

Cluster Manager: The Cluster Manager is available in the Administration Tool when a repository is opened in online mode. The Cluster Manager enables Oracle BI Server clustered instances.

Correct Answer: A

Explanation: The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it.

Correct Answer: B

Explanation: When you need to model many-to-many relationships between dimension tables and fact tables, you can create a bridge table that resides between the fact and the dimension tables. A bridge table stores multiple records corresponding to that dimension. In the Administration Tool, General tab in the Logical Table dialog box contains a check box that you can select to specify that a table is a bridge table. A bridge table allows you to resolve many-to-many data relationships.

Reference; OBI Server Administration Server Guide, Version 10.1, Identifying Bridge Tables