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

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

528 Students Passed

84% Average Score

92% Same Questions

Viewing page 1 out of 4 pages

Viewing questions 1-10 out of questions

Questions # 1:

The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.

Options:

$10,000

Year

Answer

Explanation

The rank measure is numbered from 1. The highest sales amount will be ranked 1.

Questions # 2:

There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?

Options:

By creating a derived measure on the logical column Item number and using the count Function

By creating a derived measure on the logical column item number and using the count distinct function

By creating a derived measure based on the physical column item number and changing the aggregation method to count

By creating a derived metric by using the Expression Builder

Answer

Explanation

You should use a logical column (not physical). In fact,in the Explanation of the exam, it displays a logical column.

Questions # 3:

Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished?

Options:

Every day before Data Warehouse refresh

Every day after Data Warehouse refresh

Every Monday early morning

Every Monday late night

Answer

Explanation

Purge and reseed once a week after the reports have run to improve report response time.

Questions # 4:

A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?

Options:

By creating a derived measure by using the Logical Columns available

By creating a derived measure in the Column Mapping dialog box by using the physical table columns.

By creating a derived measure by using Logic Columns available and changing the aggregation type

By creating a derived metric by using the Expression Builder

By creating a derived metric by using the Calculation Wizard

Answer

Explanation

Note 1: OBIEE offers two calculation types for measure in the repository:

logical

physical

You can define calculations in either of the following ways:

* Before the aggregation, in the logical table source.

* After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)

Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.

Measure columns always calculate the aggregation with which they are defined.

Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.

Questions # 5:

A customer needs to create a product share calculation. What are the two ways that they would get the revenue for all products to use in the denominator?

Options:

Create a derived measure by using the addition function that adds each product value together.

Create a derived measure based on Revenue that has the Level Total Product selected on the Level Tab of the Logical Column Dialog.

Create a derived measure based on Revenue that has all the levels selected on the Level Tab of the Logical Column Dialog except Total Product.

Create a derived metric by using the Expression Builder.

Answer

A, C

Explanation

Note: A level-based measure is a column whose values are always calculated to a specific level of aggregation.

The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column.

Level-based measures allow :

* to return data at multiple levels of aggregation (the query grain and the level-based column grain) with one single query

* to create share measures (percentage), that are calculated by taking some measure and dividing it by a level-based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional revenue each salesperson generates.

Questions # 6:

How do System Session Variables obtain their values?

Options:

They are entered by user input on a dashboard

They are obtained from data fields in the Physical Layer

They are obtained from the Presentation Layer

They are obtained from the Initialization Block

Answer

Explanation

Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables.

Questions # 7:

When Exporting an Analysis from a Dashboard, which of the following is NOT an option?

Options:

MS Excel

MS Word

PDF

CSV

Answer

Questions # 8:

One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?

Options:

Business Requirements Definition

Technical Requirements Definition

Data Quality Assessment

Dashboard Testing

Answer

Questions # 9:

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

Options:

Creating and Maintaining Users

Authentication and Authorization

Basic Directory for storing user details

Subject area and row-level security, connection pool passwords

Application of Session Variables as Data Filters

Answer

A, B, C

Questions # 10:

The ODBC DSN is never used for _______.

Options:

Initial import of the physical layer metadata on a Windows server

Query execution and data access on a Windows server

Initial import of the physical layer metadata, query execution, and data access on a Windows Server

Changing passwords

Comparing RPDs

Answer

Explanation

You do not use ODBC DSN to compare repositories.

Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect.

Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source.

The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it.

The DSN contains information about the data source such as:

the name,

the directory,

and the driver.

On Windows, the DSN also specifies the ODBC driver to be used to access the database.

Viewing page 1 out of 4 pages

Viewing questions 1-10 out of questions