Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 81:

  Which two options are valid Repository Variable names?

  A. USER
  B. CurrentDay
  C. CurrentMonth
  D. Date
  B. CurrentDay
  C. CurrentMonth

  ---

  CurrentDay and 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

• Question 82:

  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. Presentation Layer
  B. Business Aggregate Layer
  C. Physical Layer
  D. Web Catalog
  C. Physical Layer

  ---

  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.

• Question 83:

  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 before Data Warehouse refresh
  B. Every day after Data Warehouse refresh
  C. Every Monday early morning
  D. Every Monday late night
  D. Every Monday late night

  ---

  Purge and reseed once a week after the reports have run to improve report response time.

• Question 84:

  The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.

  A. $10,000
  C. 1
  D. Year
  C. 1

  ---

  The rank measure is numbered from 1. The highest sales amount will be ranked 1.

• Question 85:

  What are the two types of Session Variables?

  A. System
  B. Non System
  C. Static
  D. Dynamic
  A. System
  B. Non System

  ---

  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.

• Question 86:

  Why is it necessary to join multiple source tables to a single dimension?

  A. Because transactional source systems are often denormalized
  B. Because transactional source systems are often normalized
  C. Because a single source table often contains all the dimensions needed
  D. Because the dimensions tables are built in the transactional systems
  B. Because transactional source systems are often normalized

  ---

  Denormalized data in the transactional system could be divided into different tables to increase performance.

• Question 87:

  Which configuration can be changed through Enterprise Manager?

  A. Minimum Number of Rows to Download to Excel
  B. The default BI Server Repository
  C. Start and Stop BI Services
  D. Manages user login
  B. The default BI Server Repository

  ---

  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.

  

  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.

  Note 2: 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.

  

• Question 88:

  Content that is saved in personal and shared folders can be browsed by using which view?

  A. Catalog
  B. Dashboard
  C. New -> Analysis
  D. Home
  E. Favorites
  A. Catalog

  ---

  The Catalog Manager workspace enables you to view and work with catalog objects. It displays the following folders for an open catalog:

  The shared folder-- Contains content that is shared among catalog users. This includes the preconfigured dashboards and analyses that are distributed with prebuilt applications, and other objects such as shared filters.

  The system folder -- Contains administrative elements of Presentation Services. Some of these elements are distributed with the product, and others are configured by you as the administrator, such as privileges. Avoid modifying any files in

  this folder. Presentation Services uses these files internally and modifying them might cause unexpected results.

  The users folder -- Contains content that catalog users with the appropriate permissions have saved to their personal folders, such as individual analyses.

  Reference: Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition, What Does the Catalog Manager Workspace Look Like?

• Question 89:

  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 Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar
  B. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar
  C. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar
  D. By creating a Presentation Folder called Time and then two subsequent folders called Fiscal Calendar and Julian Calendar
  A. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar

  ---

  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

  

• Question 90:

  The three metadata layers are an important concept of the BI Server. Which statement is incorrect?

  A. The physical layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source.
  B. Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.
  C. The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.
  D. The presentation layer defines the relationship that is needed to create the DML.
  D. The presentation layer defines the relationship that is needed to create the DML.

  ---

  The relationship is defined at the model and mapping layer.

  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.