Free 1z0-591 Braindumps Download Updated on Jun 29, 2025 with 122 Questions
Oracle 1z0-591 Exam Practice Test Questions
NEW QUESTION # 21
Which two Oracle BI Components contain security information regarding permissions and privileges?
- A. The Repository
- B. NQSConfig.ini File
- C. InstanceConfig.xml File
- D. The Web Catalog
- E. NQServer.ini File
Answer: A,D
Explanation:
Web Catalog does contain object permissions: folder, reports, etc. The repository has objects permissions to Subject Areas, etc.
NEW QUESTION # 22
A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?
- A. By creating your logical join by using the Joins Manager
- B. By specifying a one-to-many join between the tables with the small and large numbers of values
- C. By creating your joins by using the Business Model Diagram
- D. By specifying a driving table
- E. By specifying a many to one join between the tables with the small and large numbers of values
Answer: D
Explanation:
Explanation
You can specify a Driving table parameter in a complex join.
Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross-database joins when one table is very small and the other table is very large.
The BI Server will query the driving table (the small one) and will get a list of values. The BI Server will then generate a second SQL using a parameterized IN list with the values from the first query.
Specifying driving tables leads to query optimization only when the number of rows being selected from the driving table is much smaller than the number of rows in the table to which it is being joined.
NEW QUESTION # 23
Selecting the Manage Map Data link allows one to do which three of the following?
- A. Associate map layers to columns defined in the OBIEE metadata
- B. Set the zoom level of an imported map
- C. Import images for use on maps
- D. Create a new map layer
Answer: A,B,C
Explanation:
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 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 # 24
The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?
- A. MS Project
- B. MS Visio
- C. MS Word
- D. MS Excel
Answer: C,D
Explanation:
Oracle Business Intelligence Office Plug-In is a Windows application that is an optional feature under the Oracle Business Intelligence Presentation Services. The Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that report into Microsoft Word or Excel.
Reference: Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Installing Individual Oracle BI Components >Installing Oracle BI Office Plug-In
NEW QUESTION # 25
Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?
- A. NQSConfig.ini
- B. Instanceconfig.xml
- C. Web Catalogue
- D. Cache table in OBIEE repository
Answer: A
Explanation:
Explanation
Explanation/Reference:
NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.
The parameters in the Query Result Cache Section provide configuration information for Oracle BI Server caching. The query cache is enabled by default. After deciding on a strategy for flushing outdated entries, you should configure the cache storage parameters in Fusion Middleware Control and in the NQSConfig.INI file.
Incorrect answers:
D: On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services.
NEW QUESTION # 26
Where is Cache in OBIEE located?
- A. In dynamic aggregate
- B. In memory cache
- C. It is local disk-based.
- D. In relational database
Answer: C
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 # 27
What are the two types of Session Variables?
- A. Static
- B. System
- C. Non System
- D. Dynamic
Answer: B,C
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 # 28
Identify the two true statements about alias tables.
- A. Alias tables are set up to avoid triangular or circular joins.
- B. Alias tables are set up to create another physical copy of the data.
- C. Alias tables are set up to create a copy of the data with a filter applied to it.
- D. Alias tables are set up to include best practice naming conventions for physical table names.
Answer: D
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.
NEW QUESTION # 29
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 LogicColumnsavailable andchanging theaggregationtype
- B. By creating a derived metricby using the Expression Builder
- C. By creatinga derived metricby using the Calculation Wizard
- D. By creating a derived measure by using the Logical Columns available
- E. By creating a derived measure in the Column Mapping dialog box byusing the physical tablecolumns.
Answer: A
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 # 30
The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?
- A. MS Project
- B. MS Visio
- C. MS Word
- D. MS Excel
Answer: C,D
Explanation:
Oracle Business Intelligence Office Plug-In is a Windows application that is an optional feature under the Oracle Business Intelligence Presentation Services. The Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that report into Microsoft Word or Excel.
NEW QUESTION # 31
Select the correct statement.
- A. Cache can increase traffic to back end database.
- B. Cache needs to be purged to refresh data.
- C. Cache provides fast and always up-to-date information.
- D. Cache can degrade query performance by reading data from the disk instead of the database.
- E. Cache is seeded by manually running PL/SQL at the back end database.
Answer: B
Explanation:
Explanation/Reference:
In a standard OBIEE implementation, we generally want to purge and re-build the cache after every ETL (extract, transform, and load) run.
Incorrect answers:
A: A cache item might be out of date.
B: Cache reduces traffic to the back end database. At worst it does not change the amount traffic.
D: The cache disk should be at faster than the disk of the database.
E: OBIEE Caching and Cache Seeding
Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration.
For time-consuming Dashboard Pages, we can use the concept of cache seeding in OBIEE, this can be configured as a scheduled job that will ensure that the data is cached and readily available as and when the user runs the dashboard.
NEW QUESTION # 32
One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?
- A. CurrentMonth
- B. Month
- C. Quarter
- D. Year
Answer: A
Explanation:
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.
http://www.adivaconsulting.com/images/blog/OBIEE_Variable_files/image003.jpg Provide Intialization Block variable Name
http://www.adivaconsulting.com/images/blog/OBIEE_Variable_files/image004.jpg
Click on "Edit Data Source" button and provide the sql to be used for the variable, e.g.
select lower(sys_context('USERENV','SESSION_USER'))|| '@'|| lower(sys_context('USERENV','DB_NAME'))
from dual;
NEW QUESTION # 33
Query limits tab can be accessed through________.
- A. Security Manager, Application Roles tab, Application role dialog box, Permissions
- B. Security Manager, Application Roles tab, Query dialog box, Permissions
- C. Security Manager, Query tab, Application role dialog box, Permissions
- D. Security Manager, Application Roles tab, Application role dialog box, Query Properties
Answer: A
Explanation:
Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users.
Steps:
1. Login to Repository using OBIEE Admin Tool
2. Navigate to Manage > Identity
3. Go to Application Role tab, choose the role and double click on it to open.
4. Click on Permissions tab
5. Set the 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.
NEW QUESTION # 34
Point-and-click generation of case statement logic can be accessed via which option?
- A. Advanced Tab
- B. Compound Layout
- C. Column Formula -> Bins tab
- D. Subject Area metrics
- E. Column Properties -> Conditional Format tab
Answer: C
Explanation:
The "Edit Column Formula" dialog box has a second, very tiny tab called, "Bins." You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under "Expressions" if you want). A CASE statement is a lot like an IF-THEN-ELSE statement, except that it's a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define.
Note: Figure:
NEW QUESTION # 35
An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?
- A. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar
- B. By creating a Presentation Folder called Time<parent> and then two subsequent folders called Fiscal Calendar<child> and Julian Calendar<child>
- C. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar
- D. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar
Answer: C
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.
Result
NEW QUESTION # 36
Which variable does not use initialization blocks to initialize its values?
- A. System Variable
- B. Non System Variable
- C. Dynamic Repository Variable
- D. Static Repository Variable
Answer: D
Explanation:
The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it.
NEW QUESTION # 37
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?
- A. WebCatalog
- B. PhysicalLayer
- C. Business Aggregate Layer
- D. Presentation Layer
Answer: B
Explanation:
Note:
At the highest level, an OBIEE Metadata Repository includes three layers of information:
1.First, a Physical layer is defined. The metadata layer identifies the source data.
2.Second, a Business Model and Mapping layer is defined. This metadata layer organizes the physical layer into logical categories and records the appropriate metadata for access to the source data. 3.Finally, the Presentation layer is defined. This metadata layer exposes the business model entities for end-user access.
NEW QUESTION # 38
One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting.
Which variable below is a valid example of a Dynamic Repository Variable?
- A. CurrentMonth
- B. Month
- C. Quarter
- D. Year
Answer: A
Explanation:
Explanation/Reference:
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
Click on "Edit Data Source" button and provide the sql to be used for the variable, e.g.
select lower(sys_context('USERENV','SESSION_USER'))||
'@'||
lower(sys_context('USERENV','DB_NAME'))
from dual;
NEW QUESTION # 39
Which task can be performed after the Administrator link has been reached through logging into OBIEE?
- A. SSO enablement
- B. Start or Stop BI Managed Servers
- C. Associate map layers to columns
- D. Manage access to Subject Areas
Answer: C
Explanation:
It is asking for Which task (NOT Which Tasks).
Using Administration (not Administrator) link in OBIEE you can go to 'Manage Map Data' and manage map components.
NEW QUESTION # 40
Which task can be performed after the Administrator link has been reached through logging into OBIEE?
- A. SSO enablement
- B. Start or Stop BI Managed Servers
- C. Associate map layers to columns
- D. Manage access to Subject Areas
Answer: C
Explanation:
It is asking for Which task (NOT Which Tasks).
Using Administration (not Administrator) link in OBIEE you can go to 'Manage Map Data' and
manage map components.
NEW QUESTION # 41
Select the scenario in which block storage must be used instead of aggregate storage.
- A. Incremental data loading
- B. Millions of members in the outline
- C. Extremely sparse data sets
- D. Top - down planning
Answer: D
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)
NEW QUESTION # 42
An integrated BI tools business case can be built around which three options?
- A. Cost Savings
- B. Fault tolerance
- C. Development efficiency
- D. Scalability
Answer: A,C,D
NEW QUESTION # 43
......
Updated Verified 1z0-591 dumps Q&As - Pass Guarantee or Full Refund: https://realpdf.free4torrent.com/1z0-591-valid-dumps-torrent.html