1Z0-591 - Oracle Business Intelligence Foundation Suite 11g Essentials Exam
Go back to Oracle
How many questions are there on the 1Z0-591 exam?
There are 75 questions on the 1Z0-591 exam to be completed in 120 minutes.
How long is the 1Z0-591 exam?
The 1Z0-591 exam is 120 minutes to complete 75 questions.
How much does the 1Z0-591 exam cost?
The 1Z0-591 exam is $245. The exam provider is Pearson Vue and you can register for the exam on their website.
What is the best way to study for the 1Z0-591 exam?
The best way to study for the 1Z0-591 exam is to practice at Exam.com.
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?
Every Monday late night
To add multiple sources to on existing logical table dimension in the Business Model and Mapping layer, the source of the data must first exist in which option?
You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?
Create a physical time table in your database.
Create a Logical Table that is sourced from a time field in one of your dimension tables.
Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?
DSNs are set up for access to which data sources?
ODBC Data Sources
Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
OLAP cubes can be queried by using SQL.
The Time Dimension hierarchy is a good example of a__________.
Level-based Time Dimension hierarchy
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?
By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs
Which two Oracle BI Components contain security information regarding permissions and privileges?
Under what circumstances would you model within the BI environment to include transactional data directly?
When the customer needs near real-time data to support decision making in a fast changing environment
Which component is responsible for determining the device that receives the alerts for a given user account?
The Consistency Checker checks______.
Mappings to the physical objects
Which two options are included in Oracle BI Server cache management techniques?
Using NQSConfig.ini to manually edit the parameters
Inspecting the cache reports
Cache in OBIEE is used to_____. Select the two correct answers.
improve performance of Dashboards and Analysis
decrease query response time
Which of the following characteristics pertain to a "ragged" hierarchy?
A branch of the hierarchy may have a different number of levels than other branches.
Content that is saved in personal and shared folders can be browsed by using which view?
Select the correct statement.
Cache needs to be purged to refresh data.
What are the two disadvantages of implementing Query Caching?
Cache results being old
Storage space for cache
What is an example of a Session Variable?
A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?
Using the Calculation Wizard
WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?
Creating and Maintaining Users
Basic Directory for storing user details
Subject area and row-level security, connection pool passwords
In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse?
Presentation Data Layer
Which two steps are needed to set up Failover support for an OBIEE deployment?
Use Installer to affect Horizontal scale out of an existing instance
Apply OBIEE Clustering option
Which two components are required for all OBIEE installations?
Which language is used by OBIEE to query Essbase?
A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?
Clicking the "Time" option in the Logical Dimension Dialog
Designating a chronological key for every level of every dimension hierarchy
When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?
OBIEE 11g authentication of users is performed by which two components listed below?
Repository file (rpd)
Embedded WebLogic LDAP server
Identify the two types of storage for Essbase.
Aggregate Storage Option and Block Storage Option
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?
Technical Requirements Definition
Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.
When Exporting an Analysis from a Dashboard, which of the following is NOT an option?
A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?
Set the Priority Group to 0.
Derived metrics are_____.
Derived from other logical columns
Which OBIEE capability enables developers to build Aggregate tables?
Aggregate Persistence Wizard
When creating a Security Realm in the WebLogic Console, which object is created?
How do System Session Variables obtain their values?
They are obtained from the Initialization Block
Which three components are part of a cluster server?
Primary Cluster Controller
Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?
Project initiation and resourcing
The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?
What are the two types of Session Variables?
The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?
Multiple developers can work on one repository at the same time. Results can be merged later on.
A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?
The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?
Start and Stop BI Services
If a customer is planning on building a data warehouse, how would you describe data warehousing to the customer?
The data in the data warehouse describes events and statuses of business processes, products and services, goals and organizational units, and generally mirrors every aspect of the structure and behavior of the organization.
Which variable does not use initialization blocks to initialize its values?
Static Repository Variable
What must be purchased when integrating Oracle map with Oracle BI?
When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?
The lowest level of aggregation
What is the process in which there is redundancy of data to improve performance?
Which analysis features could be applied to provide interactive controls for end users?