Identify the two true statements about alias tables.

Alias tables are set up to avoid triangular or circular joins.

Alias tables are set up to include best practice naming conventions for physical table names.

Alias tables are set up to create another physical copy of the data.

Alias tables are set up to create a copy of the data with a filter applied to it.

OBIEE 11g authentication of users is performed by which two components listed below?

External directories such as Active Directory using WebLogic and Fusion Middleware's Oracle Platform Security Services framework

An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?

By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar

By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar

By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar

By creating a Presentation Folder called Time and then two subsequent folders called Fiscal Calendar and Julian Calendar

Which task can be performed after the Administrator link has been reached through logging into OBIEE?

start or Stop Bl Managed Server

Associate map layers to columns

Which option does not describe Aggregate tables?

Aggregate tables are created and stored on the Bl Server.

Aggregate tables increase query performance by pre-calculating frequently accessed measure aggregations.

Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.

Aggregate tables typically have fewer rows than the non aggregate tables and, therefore, processing should be quicker.

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

Prepare for 1z0-591 with more than an answer.

120 questions in the full set12 sample questionsUpdated Sep 16, 2021

Study as flashcards

Exam fee: $245 USD
Level: OCS
Valid for: Lifetime (no expiration)

Domains covered on the exam 7

Oracle BI and EPM System Overview15%
Oracle BI Installation12%
OBIEE User Interface Overview18%
Repository Development and Administration25%
Oracle Business Intelligence Enterprise Edition Security20%
Management and Performance Tuning15%
MS Office Integration and Spatial Intelligence10%

1
The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?
Show answer details
Correct answer: A, B, C
A, B, C -- Explanation:
BIEE 11g Install High level Steps : Software Required 1. Database (Oracle, IBM DB2 or MS-SQL) 2. Repository Creation Utility (RCU) 3. OBIEE 11 g (11.1.1.3 is latest OBIEE as of 30 April 2011) 4. WebLogic 10.3.3 (Optional - Only required for 64 bit machine or IBM AIX) 5. JDK 1.6 64 bit (Optional - Only required for 64 bit machine)

A, B, C -- Explanation:
BIEE 11g Install High level Steps : Software Required 1. Database (Oracle, IBM DB2 or MS-SQL) 2. Repository Creation Utility (RCU) 3. OBIEE 11 g (11.1.1.3 is latest OBIEE as of 30 April 2011) 4. WebLogic 10.3.3 (Optional - Only required for 64 bit machine or IBM AIX) 5. JDK 1.6 64 bit (Optional - Only required for 64 bit machine)

A, B, C -- Explanation:
BIEE 11g Install High level Steps : Software Required 1. Database (Oracle, IBM DB2 or MS-SQL) 2. Repository Creation Utility (RCU) 3. OBIEE 11 g (11.1.1.3 is latest OBIEE as of 30 April 2011) 4. WebLogic 10.3.3 (Optional - Only required for 64 bit machine or IBM AIX) 5. JDK 1.6 64 bit (Optional - Only required for 64 bit machine)
2
Identify the two true statements about alias tables.
Show answer details
Correct answer: A, B
A, B -- Explanation:
It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below: (A) * An alias is used to avoid circular joins and to configure self joins. * You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria. * Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases. (B) * You can rename aliases to make physical and business model easier to understand.

A, B -- Explanation:
It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below: (A) * An alias is used to avoid circular joins and to configure self joins. * You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria. * Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases. (B) * You can rename aliases to make physical and business model easier to understand.
3
OBIEE 11g authentication of users is performed by which two components listed below?
Show answer details
Correct answer: A, B
A, B -- Explanation:
A: Authentication at the Oracle Business Intelligence Enterprise Edition Layer The Oracle Product Lifecycle Analytics (Oracle PLA) application utilizes the Oracle Business Intelligence Enterprise Edition Layer (OBIEE) layer’s platform authentication features.
You change the password for the PLMA.RPD repository file using the OBIEE Admin Tool.
B: LDAP Authentication LDAP authentication is used as an alternative to storing user IDs and passwords in an Oracle Bl repository.
You can set up the Oracle Bl Server to take the user ID and password, and have it then pass the user ID and password to an LDAP server for authentication.
Reference: Oracle Product Lifecycle Analytics, Security Guide , Configuring and Using Authentication

A, B -- Explanation:
A: Authentication at the Oracle Business Intelligence Enterprise Edition Layer The Oracle Product Lifecycle Analytics (Oracle PLA) application utilizes the Oracle Business Intelligence Enterprise Edition Layer (OBIEE) layer’s platform authentication features.
You change the password for the PLMA.RPD repository file using the OBIEE Admin Tool.
B: LDAP Authentication LDAP authentication is used as an alternative to storing user IDs and passwords in an Oracle Bl repository.
You can set up the Oracle Bl Server to take the user ID and password, and have it then pass the user ID and password to an LDAP server for authentication.
Reference: Oracle Product Lifecycle Analytics, Security Guide , Configuring and Using Authentication
4
An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?
Show answer details
Correct answer: A
Explanation:
You can nest presentation folders in two ways. 1) You can enter a hyphen and a greater than sign in the description field of the table to achieve the result. 2) Or, prefix the name of the presentation folder to be nested with a hyphen and a space and place it after the folder in which it nests to achieve the same result as shown below.
5
Which task can be performed after the Administrator link has been reached through logging into OBIEE?
Show answer details
Correct answer: B, C, D
B, C, D -- Explanation:
B: Bl Server Security Manager accessed through the Bl Server Administration Tool. * Set permission to business model, tables, columns and subject areas * Specify filters to limit data accessible by users * Set authentication options

B, C, D -- Explanation:
B: Bl Server Security Manager accessed through the Bl Server Administration Tool. * Set permission to business model, tables, columns and subject areas * Specify filters to limit data accessible by users * Set authentication options

B, C, D -- Explanation:
B: Bl Server Security Manager accessed through the Bl Server Administration Tool. * Set permission to business model, tables, columns and subject areas * Specify filters to limit data accessible by users * Set authentication options
6
Which option does not describe Aggregate tables?
Show answer details
Correct answer: D
D

Create an account to continue.

Create account Sign in

Create an account to continue.

Related exams