Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
Oracle Other Certification
1z0-591
Oracle Business Intelligence Foundation Suite 11g Essentials Questions and Answers

Pass the Oracle Other Certification 1z0-591 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-591 Premium Access

View all detail and faqs for the 1z0-591 exam

Go to Exam

833 Students Passed

92% Average Score

96% Same Questions

Viewing page 2 out of 4 pages

Viewing questions 11-20 out of questions

Questions # 11:

An integrated BI tools business case can be built around which three options?

Options:

Scalability

Fault tolerance

Cost Savings

Development efficiency

Answer

A, C, D

Questions # 12:

When creating a Security Realm in the WebLogic Console, which object is created?

Options:

Groups

Row Level Filters

Server Password

Single Sign On

Answer

Explanation

Security Realms are an Oracle Platform Security Services concept and bring together sets of users, groups, providers and so on for a WebLogic domain.

Questions # 13:

An organization has its employees' names in an Employees table, and information about their jobs in a Jobs table.

However, an organization's employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to-many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?

Options:

By modeling the many to many relationship in the business model

By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs

By creating the many to many join in the physical model

By creating a logical table source (LTS) that joins the Employees and Jobs tables

Answer

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

Questions # 14:

Select the scenario in which block storage must be used instead of aggregate storage.

Options:

Incremental data loading

Top - down planning

Extremely sparse data sets

Millions of members in the outline

Answer

Explanation

BSO is preferred to ASO in the following scenarios:

* Top-down planning and allocation (Sales Forecasting)

* Cost Allocations across products and customers (Profitability Analysis)

* Currency conversion, inter-company eliminations(Financial consolidations)

Questions # 15:

Derived metrics are_____.

Options:

Derived from other logical columns

Derived from other physical columns

Used to apply pre-aggregation calculations to measures

Used to rename measures to user-friendly names

Answer

Questions # 16:

Query Limits are used to manage Query environment in the repository for users and roles and can_________.

Options:

Control runaway queries

Limit Queries by maximum run time

Control aggregation

Control User Authentication

Control Write Back Capabilities

Answer

Explanation

Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.

See figure below.

Questions # 17:

Which two options are valid Repository Variable names?

Options:

USER

CurrentDay

CurrentMonth

Date

Answer

B, C

Explanation

CurrentDay and CurrentMonth can be calculated by a sql statement.

Note:

REPOSITORY VARIABLE(DYNAMIC)

· Initialized when BI server is started

· Assigned value dynamically based on the result of a query

· Value is dependent of the sql provided in Initialization Block

Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.

Provide Intialization Block variable Name

Questions # 18:

Which three techniques are applied to support Failover?

Options:

WebLogic Clustering

Universal Installer > Scale Out BI System option

OBIEE Clustering

Vertical Scaleout

Answer

A, B, C

Explanation

A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.

B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you’d choose to instead scale out the existing BI domain.