Oracle Oracle Certifications 1Z0-591 Questions & Answers

• Question 41:

  How do Dynamic Repository Variables differ from Static Repository Variables?

  A. Dynamic Repository Variables are not initialized by the Initialization Block.

  B. Dynamic Repository Variables cannot be used in the Expression Builder.

  C. Dynamic Repository Variables can be changed by data that is returned from queries.

  D. Dynamic Repository Variables cannot be used in a CASE statement.

  Correct Answer: C

  Explanation: Dynamic Repository Variables:

  You initialize dynamic repository variables in the same way as static variables, but the values are refreshed by data returned from queries. When defining a dynamic repository variable, you will create an initialization block or use a pre-existing

  one that contains a SQL query. You will also set up a schedule that the Oracle BI Server will follow to execute the query and periodically refresh the value of the variable.

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

• Question 42:

  Which three components are part of a cluster server?

  A. Master Server

  B. Repository Publishing Directory

  C. Primary Cluster Controller

  D. Web Server

  E. Server request Controller

  Correct Answer: ACD

  Explanation: Oracle BI Cluster Server Components

  *

  Oracle Business Intelligence Cluster Controller: The Cluster Controller determines which BI Server works in the cluster. It monitors the operation of servers in the cluster. The Cluster Controller is deployed in active-passive mode.

  *

  Clustered BI Servers: The BI Cluster Server feature supports up to 16 BI Servers in a network domain to act as a single server. BI Servers in the cluster share requests from multiple Oracle BI clients.

  *

  Master BI Server: A clustered Oracle Business Intelligence Server is designated as the Master BI Server. The Oracle Business Intelligence Administration Tool connects to the master BI Server for online repository changes.

  *

  Cluster Manager: The Cluster Manager is available in the Administration Tool when a repository is opened in online mode. The Cluster Manager enables Oracle BI Server clustered instances.

• Question 43:

  Under what circumstances would you model within the BI environment to include transactional data directly?

  A. When the customer needs near real-time data to support decision making in a fast changing environment

  B. When the customer is not prepared to spend budget on data-warehousing

  C. When the complexity of operational schema does not allow modeling in the BI repository

  D. When it is not possible to query against a transactional system

  Correct Answer: A

• Question 44:

  What are the two capabilities that users can apply to an Analysis when working within Plug- In for MS Office?

  A. Edit Analysis

  B. Refresh All

  C. Edit Prompts and Levels

  D. Publish

  Correct Answer: BC

  C: Right-click Table and select Insert as List from the shortcut menu. The Edit Prompts and Levels dialog box appears. Accept the default options and click Insert.

  

  Explanation: B: Click Refresh All from the Oracle BI menu in PowerPoint to refresh all the refreshable objects in the presentation.

  Reference: Using Oracle Business Intelligence Office Add-Ins with Oracle Business Intelligence Enterprise Edition (10.1.3.4) on Windows

• Question 45:

  When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?

  A. Logical Key

  B. Parent Level

  C. Child Level

  D. Dynamic Key

  Correct Answer: B

  Explanation: Steps to Create a Dimension Hierarchy - >Create a dimension object.Add a parent-level object.Add child-level objects.Determine number of elements.Specify level columns.Create level keys.Create a level-based measure.Create additional level-based measures.Create share measures.Create rank measures.Add measures to Presentation layer.Test share and rank measures.

• Question 46:

  What are the two types of Repository Variables?

  A. System

  B. Non System

  C. Static

  D. Dynamic

  Correct Answer: CD

  Explanation: There are static and dynamic repository variables.

  Note:

  Variables in the Oracle BI Server can be either repository or session variables, and are defined using the Variable Manager within the Oracle BI Administrator (Manage > Variables).

  

  This brings up the Variable Manager, that divides variables out into repository and session variables, with a further subdivision into static and dynamic repository ones and system and non-system session ones. You can also define variables at the Presentation Server level, these are scoped to individual dashboards and are used amongst other things for setting dashboard prompt values and integrating the dashboard with BI Publisher parameters. Here's a screenshot of a typical Variable Manager screen.

  

• Question 47:

  Which OBIEE capability enables developers to build Aggregate tables?

  A. Aggregate Persistence Wizard

  B. Expression Builder

  C. Table Builder

  D. Query Analyzer

  Correct Answer: A

  Explanation: 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 48:

  Where is Cache in OBIEE located?

  A. In relational database

  B. It is local disk-based.

  C. In dynamic aggregate

  D. In memory cache

  Correct Answer: B

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

• Question 49:

  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. Make Aggregate Table 1 the first table in the list of Logical Table Sources.

  B. Do not map the logical level in the Content tab.

  C. Set the Priority Group to 0.

  D. Set the Priority Croup to 5.

  Correct Answer: C

  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

• Question 50:

  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. Fact-based

  B. Time-based

  C. Mixed

  D. Complex

  Correct Answer: D

  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.