Pass Your Oracle Exam with 1Z1-591 Exam Dumps (Updated 122 Questions)
1Z1-591 Exam Dumps - Oracle Practice Test Questions
Oracle 1Z1-591 exam consists of 70 multiple-choice questions that need to be completed within 120 minutes. 1Z1-591 exam covers topics like Oracle BI Foundation Suite architecture, administration, data modeling, and data sources. 1Z1-591 exam also includes questions related to Oracle BI Answers, Oracle BI Interactive Dashboards, Oracle BI Publisher, and Oracle BI Delivers.
NEW QUESTION # 69
Permissions for Presentation layer objects and Business layer objects that restrict users is configured in which software component?
- A. WebLogic Server Administration Component
- B. Oracle HTTP Server
- C. Oracle Enterprise Manager
- D. BI Administration Tool
Answer: D
Explanation:
Explanation
Oracle Business Intelligence Enterprise Edition (OBIEE) Security is managed through:
a) BI Server Security Manager accessed through the BI 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) BI Presentation administration accessed through Presentation Web Services.
* Manage Web groups and users
* Set Permissions for Web Catalog items
* Manage privileges and rights given to groups and users
* Control access to dashboards
c) Catalog Manager.
* Set permission for Web Catalog items (Dashboards and Dashboards pages)
NEW QUESTION # 70
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?
- A. Do not map the logical level in the Content tab.
- B. Set the Priority Croup to 5.
- C. Set the Priority Group to 0.
- D. Make Aggregate Table 1 the first table in the list of Logical Table Sources.
Answer: C
Explanation:
Explanation
Priority group
You can set priority group numbers to determine which logical table source should be used for queries for which there is more than one logical table source that can satisfy the requested set of columns.
For example, you might have user queries that can be fulfilled by both a data warehouse and an OLTP source.
Often, access to an operational system is "expensive," while access to a data warehouse is "cheap." In this situation, you can assign a higher priority to the data warehouse to ensure that all queries are fulfilled by the data warehouse if possible.
Note that the priority group of a given logical table source does not always ensure that a particular query will be fulfilled by that source.
Priority Group Designation
0 the highest-priority source (the default)
1 a lowest-priority source
NEW QUESTION # 71
A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
- A. By creatinga derived metricby using the Calculation Wizard
- B. By creating a derived metricby using the Expression Builder
- C. By creating a derived measure by using the Logical Columns available
- D. By creating a derived measure in the Column Mapping dialog box byusing the physical tablecolumns.
- E. By creating a derived measure by using LogicColumnsavailable andchanging theaggregationtype
Answer: E
Explanation:
Note1: 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.
http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/obiee_measure_column.jpg
NEW QUESTION # 72
If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?
- A. By creating four new logical tables sources
- B. By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels
- C. By creating four new logical table sources and choosing each dimension's level of aggregation in the Content tab
- D. By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels
Answer: C
Explanation:
Content Tab
Aggregation Content
You can define the aggregation (ie the group by) of:
by hierarchy level by logical column It helps you to define an aggregate navigation
Note: logical table source
Logical table sources define the mappings from a single logical table to one or more physical
tables. A logicaltable contains one or more logical table source. The mapping between physical
columns and logical columns are done in this element.
The definition of the logical table source is used:
The Content tab of the Logical Table Source is used to define :
NEW QUESTION # 73
WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?
- A. Subject area and row-level security, connection pool passwords
- B. Basic Directory for storing user details
- C. Application of Session Variables as Data Filters
- D. Authentication and Authorization
- E. Creating and Maintaining Users
Answer: A,B,E
Explanation:
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)
NEW QUESTION # 74
The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.
- A. TheBIserver cannot integrate various sourcesin one metadata model.
- B. Dataquality issues might emerge, due to missing data cleansing.
- C. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.
- D. Business issues are depending on real-time data.
Answer: B,C
NEW QUESTION # 75
What are the two types of Session Variables?
- A. Dynamic
- B. Static
- C. System
- D. Non System
Answer: C,D
Explanation:
There are two types of session variables:
System - A session variable that the Oracle BI Server and Oracle BI Presentation Services use
for specific purposes.
System session variables have reserved names that cannot be used for other kinds of variables
(such as static or dynamic repository variables and non-system session variables).
Non-system - A system variable that the administrator creates and names. For example, the
administrator might create a SalesRegion non-system variable that initializes the name of a user's
sales region.
The administrator creates non-system session variables using the Oracle BI Administration Tool.
Note: Session Variables
A session variable is a variable that is initialized at login time for each user. When a user begins a
session, the Oracle BI Server creates a new instance of a session variable and initializes it.
There are as many instances of a session variable as there are active sessions on the Oracle BI
Server. Each instance of a session variable could be initialized to a different value.
NEW QUESTION # 76
Which two steps are needed to set up Failover support for an OBIEE deployment?
- A. Use Installer to set up separate single instances, then apply Horizontal scale out clustering
- B. Employ WebLogic Enterprise Edition, licensed separately
- C. Apply OBIEE Clustering option
- D. Use Installer to affect Horizontal scale out of an existing instance
- E. Leverage spare hardware capacity of single machine by using Verticalscale out option
Answer: C,D
Explanation:
Horizonal Scaleout of System Components
*Used for adding additional managed servers (Java components) and system components to an existing cluster
*Used for scalability and failover
*Set up via the Universal Installer > Scale Out BI System option
NEW QUESTION # 77
Selecting the Manage Map Data link allows one to do which three of the following?
- A. Import images for use on maps
- B. Set the zoom level of an imported map
- C. Create a new map layer
- D. Associate map layers to columns defined in the OBIEE metadata
Answer: A,B,D
Explanation:
The Oracle BI Presentation Services Administration page provides the Manage Map Data link. This link displays the Manage Map Data page, where you can manage the logical and display versions of the data from various physical data sources. This defines the layers that content designers use when creating map views.
The data that is available for managing maps and data is stored in Oracle Database as part of MapViewer.
Using this page, you provide:
* (A) Logical names to prevent any existing BI column mappings and map analyses from breaking because of changes to the physical data or to the data source.
* Display names so that the geographic data is meaningful to end users.
Note: Administering Maps Using Administration Pages
For (C) -layers, see 3-7 below.
For (D) -import images, see 11-12 below.
To administer maps using Administration pages:
* Sign in to Oracle Business Intelligence.
* In the global header, click Administration.
* Click the Manage Map Data link to display the Manage Map Data page.
* Click the Layers tab.
* Click the Import Layers button to display the Import Layers dialog.
* In the dialog, select the connection and the layers that are needed for zooming and drilling. (This tab is not prepopulated by other selections on the Administration pages. You can use any layers or images with any map.) Click OK when you have finished selecting layers that are appropriate for the subject area with which you are working.
* Back on the Layers tab, select a layer, then click the Edit Layer button to display the Edit Layer dialog in which you associate layers with attribute columns so that you can display BI data in the map view.
Click OK when you have finished editing the layer.
You use this tab to associate layers with BI data. If you use the City column in multiple subject areas, then you must associate it with a layer for each subject area.
* Click the Background Maps tab, then click the Import Background Maps button to display the Import Background Maps dialog.
* In the dialog, select the connection and the main maps to use.
The connection that you select for the main map can be different from the connection for the layers or images.
Click OK when you have finished selecting main maps.
* Back on the Background Maps tab, select a map, then click the Edit Background Map button to display the Edit Background Map dialog in which you name the map and specify the order of layers and their zoom levels.
Click OK when you have finished editing the map.
* Optionally, click the Images tab, then click the Import Images button to display the Import Images dialog. You can import images if you plan to use them as a format on maps.
* In the dialog, select the connection and the images to use.
Click OK when you have finished selecting images.
* Click Back when you have finished working with the Administration page. Your changes are saved automatically.
NEW QUESTION # 78
A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?
- A. Defining them in the Presentation Layer
- B. Defining them in the physical data model
- C. Using the Expression Builder
- D. Using the Calculation Wizard
Answer: D
Explanation:
Explanation/Reference:
After creating your base metrics, try using the Calculation Wizard to automate the process of creating time- series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.
NEW QUESTION # 79
Why is it necessary to join multiple source tables to a single dimension?
- A. Because transactional source systems are often denormalized
- B. Because the dimensions tables are built in the transactional systems
- C. Because transactional source systems are often normalized
- D. Because a single source table often contains all the dimensions needed
Answer: C
Explanation:
Denormalized data in the transactional system could be divided into different tables to increase performance.
NEW QUESTION # 80
Which language is used by OBIEE to query Essbase?
- A. SQL
- B. MDX
- C. DMX
- D. LINQ
Answer: B
Explanation:
Explanation/Reference:
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.
NEW QUESTION # 81
What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?
- A. BI Presentation services web template
- B. XMLMessage Files
- C. DHMLMessage files
- D. Cascading Style Sheets
Answer: D
Explanation:
You can control the way that the interface for Oracle BI EE is displayed to users by creating skins and styles.
While skins and styles are typically used to customize the look and feel of analyses and dashboards by providing logos, color schemes, fonts, table borders, and other elements, they can also be used to control the position and justification of various elements by including specialized style tags in the relevant style sheet (.css) file.
You can check the directory skin location with a right click on a OBIEE dashboard page, select show source code and search "custom.css".
NEW QUESTION # 82
Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
- A. Define permissions for Dashboard
- B. Create a web catalog group
- C. Create a new repository group
- D. Create a new user in the repository
- E. Assign users to a web catalog group
Answer: C,D
Explanation:
The Oracle Business Intelligence (BI) Administration Tool can be used to build, modify, enhance, and manage an Oracle BI repository.
C: To add a new user to a repository
1 Open a repository in the Administration Tool.
2 Display the security manager by selecting Manage > Security.
3 Select Action > New > User to open the User dialog box.
4 Type a name and password for the user.
5 If you want to log queries for this user in the query log, change the query logging level to 1 or 2.
6 Click OK.
This creates a new user with default rights granted to it.
Note: What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool?
Oracle Business Intelligence Administration Tool is Used to manage OBIEE server Available only for Windows operating systems.
A Windows application that allows the BI Server administrator to create & edit repositories.
Can edit repositories in either online or offline mode.
Having a session manager and a cache manager in online mode.
NEW QUESTION # 83
What are the two disadvantages of implementing Query Caching?
- A. Increased network traffic
- B. Reduction in BI server processing time
- C. Storage space for cache
- D. Cache results being old
- E. Needs a lot of administrators' time
Answer: C,D
Explanation:
B: The problem with caching of any kind is how to deal with stale data. How you decide to deal with this depends on how time critical your business intelligence queries happen to be. OBIEE provides a wide variety of mechanisms for dealing with stale data. The cache can be purged automatically at intervals. Caching can be enabled selectively for individual physical tables, so that data in a frequently updated table is never cached. OBIEE provides a set of ODBC procedures that can be called when ETL processes complete to programmatically purge designated tables. But, by far the best way to selectively purge the cache is to use an event polling table. This table is populated by the client database whenever changes are made to any table (by an ETL process for a data warehouse or by a table-based trigger for an OLTP database). At specified intervals the BI Server polls this event polling table and deletes from its cache any query results that are dependent on the changed data.
NEW QUESTION # 84
Which configuration can be changed through Enterprise Manager?
- A. The default BI Server Repository
- B. Manages user login
- C. Start and Stop BI Services
- D. Minimum Number of Rows to Download to Excel
Answer: A
Explanation:
The Repository can be configured within the Enterprise Manager. See Note 1 below.
Note 1:Once you've locked the Oracle BI Domain, you would then use the same screen back in
Enterprise Manager to browse and select the RPD file, and then enter the password, twice.
NewImage Once you've entered these details you would then press the Apply button, to save the changes. At this point, the RPD gets a sequence number after it, and it's displayed as the current default online repository for the Oracle BI Domain.
Note2: An OBIEE 11g system (or "Oracle BI Domain") is generally managed through a combination of Oracle Enterprise Manager Fusion Middleware Control, part of the Enterprise Manager "family", or through WebLogic Server Scripting Tool (WLST) scripts. Each Fusion Middleware Control instance as shipped with OBIEE 11g controls a single Oracle BI Domain (DEV, or PROD for example), and is installed along with WebLogic Server Admin Console in the WebLogic Admin Server, one of the two JVMs (the other being the managed server) that gets installed by default with OBIEE 11g. The screenshot below shows Fusion Middleware Control showing the status of the BI Server, Presentation Server and other system components within the installation.
Sshot 2
NEW QUESTION # 85
A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
- A. By creating a derived measure by using the Logical Columns available
- B. By creating a derived measure in the Column Mapping dialog box by using the physical table columns.
- C. By creating a derived metric by using the Expression Builder
- D. By creating a derived measure by using Logic Columns available and changing the aggregation type
- E. By creating a derived metric by using the Calculation Wizard
Answer: B
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.
NEW QUESTION # 86
If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?
- A. By creating four new logical tables sources
- B. By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels
- C. By creating four new logical table sources and choosing each dimension's level of aggregation in the Content tab
- D. By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels
Answer: C
Explanation:
Explanation
Content Tab
Aggregation Content
You can define the aggregation (ie the group by) of:
by hierarchy level
by logical column
It helps you to define an aggregate navigation
http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/fact_table/obiee_fragmentation_content_one_colu
Note: logical table source Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this element.
The definition of the logical table source is used:
* to specify transformations/calculations (in the column mapping tab),
* to enable aggregate navigation and fragmentation (in the content tab) The Content tab of the Logical Table Source is used to define :
* any aggregate table content definitions (specify the grain of the physical tables),
* fragmented table definitions for the source,
* and WHERE clauses (if you want to limit the number of rows returned).
NEW QUESTION # 87
Where is Cache in OBIEE located?
- A. In dynamic aggregate
- B. It is local disk-based.
- C. In relational database
- D. In memory cache
Answer: B
Explanation:
Explanation
Explanation/Reference:
In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files.
NEW QUESTION # 88
......
Oracle Business Intelligence Foundation Suite 11g Essentials exam is a multiple-choice exam that consists of 70 questions, which must be completed within a time limit of 120 minutes. 1Z1-591 exam covers a wide range of topics, including Oracle Business Intelligence architecture, the Oracle BI user interface, Oracle BI Publisher, Oracle BI Answers, Oracle BI Interactive Dashboards, and much more.
To become certified in the Oracle Business Intelligence Foundation Suite 11g Essentials, candidates must pass the 1z0-591 exam. 1Z1-591 exam covers a range of topics, including data modeling, report design, analytics, performance management, and security. Candidates must also demonstrate their ability to use the Oracle Business Intelligence Foundation Suite 11g to solve real-world business problems.
New Real 1Z1-591 Exam Dumps Questions: https://drive.google.com/open?id=1Svoooy4U5hr1rZXonAT_idO0eZsxKhLx
Pass Your 1Z1-591 Exam Easily with Accurate PDF Questions: https://www.prep4sures.top/1z1-591-exam-dumps-torrent.html