11g 1z0-591 Dumps Full Questions with Free PDF Questions to Pass
100% Updated Oracle 1z0-591 Enterprise PDF Dumps
Passing the Oracle 1z0-591 exam provides candidates with a valuable certification that signifies their expertise in Oracle Business Intelligence Foundation Suite 11g. Oracle Business Intelligence Foundation Suite 11g Essentials certification can help IT professionals to demonstrate their competence and expertise in Business Intelligence, making them highly valued by employers. Additionally, certified professionals can showcase their knowledge and skills by building complex BI projects with Oracle's BI software, which can help enhance their career opportunities and earning potential.
NEW QUESTION # 26
Which option is used to enter the rank function when creating a new rank measure?
- A. Expression Builder
- B. Connection Pool
- C. Web Catalog
- D. Initialization Block
Answer: A
Explanation:
Explanation/Reference:
Example (see step 4 and 5 below): Getting Top-N Sales Reps for Year and Year-1
1. Under the "Business Model and Mapping" Layer, right click the "F1 Revenue" and select "New Object" ->
"Logical Column..."
2. In the "Logical Column" Window give for Name: Year Ago Revenue as seen below:
3. Goto the "Column Source" Tab and select "Derived from existing columns using an expression" radio button then click on the "Edit Expression" icon.
4. Enter the following expression in the "Expression Builder" Window by selecting "Functions" in the "Category:" list, "Time Series Functions" in the "Functions:" list then "Ago" "Time Series Functions:" section.
5. Select the "<<Measure>>" in the "Ago( )" function, then select "Logical Tables" in the "Category:" list, "F1 Revenue" in the "Logical Tables:" list, then double click the "Revenue" in the "Columns:" list.
Etc.
NEW QUESTION # 27
Which installation option is used to install into an existing Fusion Middleware Home?
- A. EnterpriseInstall
- B. Simple Install
- C. Cannot installinto an existing Fusion Middleware Home
- D. Software Only Install
Answer: D
Explanation:
The Software Only Install type installs the Oracle Business Intelligence software binary files in an Oracle home for later configuration as part of a Fusion Middleware deployment.
NEW QUESTION # 28
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?
- A. Mixed
- B. Fact-based
- C. Time-based
- D. Complex
Answer: A
Explanation:
You have three sort of fragmentation:
Fact-based / Dimension-based fragmentation
Content-based / Value-based fragmentation
Level-based fragmentation / aggregate navigation
You can combine the techniques above to construct powerful design that are known as Complex
partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex
fragmentation.
NEW QUESTION # 29
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?
- A. System Testing
- B. Test Environment
- C. Projectinitiation and resourcing
- D. Performance Tuning
- E. Data Validation / Verification
Answer: C
NEW QUESTION # 30
Permissions for Presentation layer objects and Business layer objects that restrict users is configured in which software component?
- A. Oracle Enterprise Manager
- B. Oracle HTTP Server
- C. BI Administration Tool
- D. WebLogic Server Administration Component
Answer: C
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 # 31
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?
- A. Every day after Data Warehouse refresh
- B. Every Monday early morning
- C. Every day before Data Warehouse refresh
- D. Every Monday late night
Answer: D
Explanation:
Explanation/Reference:
Purge and reseed once a week after the reports have run to improve report response time.
NEW QUESTION # 32
Point-and-click generation of case statement logic can be accessed via which option?
- A. Column Properties -> Conditional Format tab
- B. Column Formula -> Bins tab
- C. Subject Area metrics
- D. Compound Layout
- E. Advanced Tab
Answer: B
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 # 33
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?
- A. Create a derived measure by using the addition function that adds each product value together.
- B. Create a derived measure based on Revenue that has the Level Total Product selected on the Level Tab of the Logical Column Dialog.
- C. Create a derived metric by using the Expression Builder.
- D. 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.
Answer: A,D
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.
NEW QUESTION # 34
What is an example of a Session Variable?
- A. OLAP DSN
- B. Top Customers by Revenue
- C. User Organization
- D. ETL Load Date
Answer: C
Explanation:
Note 1: There are four types of variables that you can use:
Session
Repository
Presentation
Request
Note 2: 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.
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.
NEW QUESTION # 35
Which option is used to enter the rank function when creating a new rank measure?
- A. Expression Builder
- B. Connection Pool
- C. Web Catalog
- D. Initialization Block
Answer: A
Explanation:
Example (see step 4 and 5 below): Getting Top-N Sales Reps for Year and Year-1
1. Under the "Business Model and Mapping" Layer, right click the "F1 Revenue" and select "New Object" ->
"Logical Column..."
2. In the "Logical Column" Window give for Name: Year Ago Revenue as seen below:
3. Goto the "Column Source" Tab and select "Derived from existing columns using an expression" radio button then click on the "Edit Expression" icon.
4. Enter the following expression in the "Expression Builder" Window by selecting "Functions" in the
"Category:" list, "Time Series Functions" in the "Functions:" list then "Ago" "Time Series Functions:" section.
5. Select the "<<Measure>>" in the "Ago( )" function, then select "Logical Tables" in the "Category:" list,
"F1 Revenue" in the "Logical Tables:" list, then double click the "Revenue" in the "Columns:" list.
Etc.
NEW QUESTION # 36
What is the first step when creating an Aggregate table in the OBI repository?
- A. Specify the Fact table that you want to aggregate
- B. Create a dedicated Connection Pool
- C. Use Job Manager to run the Aggregate script
- D. Test the Aggregate table by using Analysis
Answer: A
Explanation:
Steps for Creating Aggregate Tables in OBIEE
1.Create all Dimension Tables, Fact Tables & Hierarchies, which are required to be aggregated.
2.Go to ToolsaUtilities (from Administration tool menu bar), a dialog box will pop up with all available utilities.
3.Select Aggregate Persistence Wizard, and then click Execute Button.
4.Now Select appropriate path where you need to generate Aggregate Table SQL.
Note : Click Generate DDL file for first time generation of Aggregate Table
Click Next, to move to next page (Select Business Model & Measure Page)
In Select Business Model & Measure Page, Select Appropriate Business Model & then select
associated Fact / Measure.
Etc.
NEW QUESTION # 37
Which three techniques are applied to support Failover?
- A. OBIEE Clustering
- B. Vertical Scaleout
- C. Universal Installer > Scale Out BI System option
- D. WebLogic Clustering
Answer: A,C,D
Explanation:
Explanation
A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.
B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you'd choose to instead scale out the existing BI domain.
Node2-2
C: OBIEE Clustering - Approach of Oracle BI Server Load balancing/Failover
NEW QUESTION # 38
Identify the two types of storage for Essbase.
- A. Aggregate Storage and Hybrid Columnar Compression
- B. OLAP Storage and Cell Storage
- C. Aggregate Storage Option and Block Storage Option
- D. Aggregate Storage and Cell Storage
Answer: C
Explanation:
Oracle Essbase developers creating planning and budgeting applications have been keenly aware of the advantages and disadvantages of the two different storage types available to them:
*Block storage option (BSO) databases support a wide range of calculations, including forecasts, allocations, and aggregations through procedural calculation scripts. The results of these calculations can be written back to the database, but applications that use BSO storage are limited to about 10 dimensions and member counts in the low hundreds of thousands.
*Aggregate storage option (ASO) databases can support about 20 dimensions and member counts in the millions. ASO databases use multidimensional functions rather than procedural scripts to perform calculations, but the results of queries cannot be stored back in the database, making ASO unsuitable for most financial management applications.
NEW QUESTION # 39
Which two Oracle BI Components contain security information regarding permissions and privileges?
- A. NQSConfig.ini File
- B. The Repository
- C. NQServer.ini File
- D. The Web Catalog
- E. InstanceConfig.xml File
Answer: A,B
Explanation:
Explanation
B: Oracle Business Intelligence uses a role-based access control model. Security is defined in terms of Application Roles that are mapped to directory server groups and users.
To define a complete security model, you have then to define:
1. A security structure by creating this elements:
* The directory Server User and Group managed by the authentication provider.
* The application roles managed by the policy store provider
2. a security policy (permissions) split across the following components:
*Presentation Catalog
* Repository
* Policy Store to define the Application Policies managed by the policy store provider D: NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.
The file is located in this directory :
11g: ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn All changes made to this file require that you restart the Oracle BI Server Service.
Type of Parameters in NQSConfig.ini:
* Security Section Parameters
The security parameters specify default values for the Oracle BI Server security features.
Includes among others:
/ DEFAULT_PRIVILEGES
* Repository Section Parameters
* Query Result Cache Section Parameters
* General Section Parameters
The General section contains general server default parameters, including localization and internationalization, temporary space and memory allocation, and other default parameters used to determine how data is returned from the Oracle BI Server to a client.
NEW QUESTION # 40
The Time Dimension hierarchy is a good example of a__________.
- A. Skip Level Hierarchy
- B. Value-based Hierarchy
- C. Level-based Time Dimension hierarchy
- D. Ragged Hierarchy
Answer: C
Explanation:
Explanation/Reference:
Level-based Hierarchy
Level-based hierarchy is the first type of hierarchy in OBIEE.
Consists of an ordered set of two or more levels. For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships.
Dimension hierarchy levels allow :
* to perform aggregate navigation,
* to configure level-based measure calculations,
* users from Dashboard and Answers to drill down from one parent to a child level.
Special type of level-based dimension are supported:
* Unbalanced (or ragged) and Skip-level hierarchy
* time dimension to provides special functionality for modeling time series data.
NEW QUESTION # 41
......
Use Valid Exam 1z0-591 by ActualTestsQuiz Books For Free Website: https://vceplus.actualtestsquiz.com/1z0-591-test-torrent.html
