Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 21:

  When Exporting an Analysis from a Dashboard, which of the following is NOT an option?

  A. MS Excel
  B. MS Word
  C. PDF
  D. CSV
  B. MS Word

• Question 22:

  Where is Cache in OBIEE located?

  A. In relational database
  B. It is local disk-based.
  C. In dynamic aggregate
  D. In memory cache
  B. It is local disk-based.

  ---

  In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files.

• Question 23:

  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. Year
  B. Month
  C. Quarter
  D. CurrentMonth
  D. CurrentMonth

  ---

  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;

• Question 24:

  Identity the three advantages of the BI Server metadata repository.

  A. Mapping of federated data sources to one logical object
  B. Ability to change physical sources without losing reports
  C. Little changes in the physical layer to shift from development to production environment
  D. Three layers support the highest level of security
  A. Mapping of federated data sources to one logical object
  C. Little changes in the physical layer to shift from development to production environment
  D. Three layers support the highest level of security

  ---

  A: OBIEE Federated Repository

  Instead of moving data in to a single database, OBIEE ?BI Administration can access multiple databases and create a single federated repository.OBIEE BI Answer uses this federated repository and build the ad-hoc reports and dashboards.

  D: Repository Metadata Consists of 3 Layers

  *

  The Physical Layer (Schema)

  *

  The Business Model and Mapping Layer

  *

  The Presentation Layer

  Note:

  

• Question 25:

  Which OBIEE capability enables developers to build Aggregate tables?

  A. Aggregate Persistence Wizard
  B. Expression Builder
  C. Table Builder
  D. Query Analyzer
  A. Aggregate Persistence Wizard

  ---

  Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they're used when appropriate.

• Question 26:

  An integrated BI tools business case can be built around which three options?

  A. Scalability
  B. Fault tolerance
  C. Cost Savings
  D. Development efficiency
  A. Scalability
  C. Cost Savings
  D. Development efficiency

• Question 27:

  Which component is responsible for determining the device that receives the alerts for a given user account?

  A. Dashboard
  B. iBot
  C. Alerts
  D. Delivery Profiles
  B. iBot

  ---

  Intelligent Bursting and Output Tool (iBot).

  iBot is an utility available in OBIEE which is used for reports scheduling as well as Alerts sent to the required recipients on different web accessible / communication devices.

• Question 28:

  Which resource identifies the OBIEE Web Catalog (webcat)?

  A. instanceconfig.xml
  B. RCU Schema
  C. Identity Store
  D. nqsconfig.ini
  E. Admin Server
  C. Identity Store
  E. Admin Server

  ---

  C: Oracle Business Intelligence authenticates users and get groups using an Oracle WebLogic Server authentication provider against user information held in an identity store.

• Question 29:

  Which are the three types of tables available to physical tables in the physical layer?

  A. Physical Table
  B. Stored Proc
  C. Select
  D. View
  E. Table
  A. Physical Table
  B. Stored Proc
  C. Select

  ---

  Pull the table and column definition into the physical layer Use the OBIEE "import metadata" wizard to pull the table and column definition into the physical layer. The wizard is used so that all of the column definitions do not need to be manually added into the physical layer.

  Figure:

  

  Note: The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information about the physical data sources.

• Question 30:

  Which option does not describe Aggregate tables?

  A. Aggregate tables increase query performance by pre-calculating frequently accessed measure aggregations.
  B. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.
  C. Aggregate tables typically have fewer rows than the non aggregate tables and, therefore, processing should be quicker.
  D. Aggregate tables are created and stored on the BI Server.
  D. Aggregate tables are created and stored on the BI Server.