[Free] 2018(Mar) EnsurePass Pass4sure Oracle 1z0-591 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Mar Oracle Official New Released 1z0-591
100% Free Download! 100% Pass Guaranteed!

Oracle Business Intelligence Foundation Suite 11g Essentials

Question No: 21

Identify the reason why Oracle OLAP provides a favorable aggregation strategy.

  1. OLAP cubes eliminate the need for a large number of aggregate tables.

  2. OLAP cubes are stored outside of the database in highly optimized file structures.

  3. OLAP cubes can be easily transported from database to database.

  4. OLAP cubes can be queried by using SQL.

Answer: D

Explanation: All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL.

Reference: Oracle OLAP User#39;s Guide, What#39;s New in Oracle OLAP?

Question No: 22

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

  1. MS Excel

  2. MS Word

  3. PDF

  4. CSV

Answer: B

Question No: 23

Which of the following characteristics pertain to a quot;raggedquot; hierarchy?

  1. It can only be stored in an XML structure.

  2. A branch of the hierarchy may have a different number of levels than other branches.

  3. All values can have a maximum of six levels.

  4. It creates multiple levels of hierarchy in the database table.

Answer: B

Explanation: Ragged Hierarchies are hierarchies where some routes down the hierarchy are longer than others; for example, you may have an organizational hierarchy for salespeople where the overall boss has two assistant managers, one of them works on their own and another has three sales managers under them; some of those sales manager may have sales staff under them, and some sales staff may have trainees under them.

Question No: 24

What is the process in which there is redundancy of data to improve performance?

  1. Redundancy

  2. Normalization

  3. Denormalization

  4. Granularity

  5. Cardinality

Answer: C

Explanation: Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique.

Denormalization should not be the first choice for improving performance and should only be used for fine tuning of a database for a particular application.

Question No: 25

An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010 and 2011 on a single report. How can you model this in the RPD?

  1. By creating two Logical Fact Tables for each database

  2. By creating joins in the physical model so it looks like a single table

  3. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source

  4. By creating two logical table sources and checking the “This Source should be combined with other sources at this level” box leaving the Fragmentation content area blank.

  5. By creating one logical table sources and checking the “This Source should be combined with other sources at this level” box

Answer: C Explanation:

Note: This source should be combined with other sources at this level (check box) Description: Check this box when data sources at the same level of aggregation do not contain overlapping information. In this situation, all sources must be combined to get a complete picture of information at this level of aggregation.

Note 2: To use a source correctly, the Analytics Server has to know what each source contains in terms of the business model. Therefore, you need to define aggregation content for each logical table source of a fact table. The aggregation content rule defines at what level of granularity the data is stored in this fact table.

Use the Content tab of the Logical Table Source dialog box to define any aggregate table content definitions, fragmented table definitions for the source, and Where clauses (if you want to limit the number of rows returned).

Reference: Siebel Business Analytics Server Administration Guide gt; Creating and Administering the Business Model and Mapping Layer in a Repository gt; Creating and Administering Logical Table Sources (Mappings) gt; Defining Content of Logical Table Sources

Question No: 26

What are the two leading design solutions recommended by Oracle that you would use for performance?

  1. Design requests that use Complex Queries

  2. Avoid returning big data sets within the Dashboard

  3. Use Cache

  4. Avoid using Guided Navigation unless the data set is large

Answer: B,C

Explanation: C: 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.

Question No: 27

The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?

  1. Oracle RDBMS

  2. Microsoft SQL Server

  3. IBM DB2

  4. Teradata

    Answer: A,B,C

    Explanation: BIEE 11g Install High level Steps :

    Software Required

    1. Database (Oracle, IBM DB2 or MS-SQL)

    2. Repository Creation Utility (RCU)

    3. OBIEE 11g ( is latest OBIEE as of 30 April 2011)

    4. WebLogic 10.3.3 (Optional – Only required for 64 bit machine or IBM AIX)

    5. JDK 1.6 64 bit (Optional – Only required for 64 bit machine)

      Question No: 28

      There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?

      1. By creating a derived measure on the logical column Item number and using the count Function

      2. By creating a derived measure on the logical column item number and using the count distinct function

      3. By creating a derived measure based on the physical column item number and changing the aggregation method to count

      4. By creating a derived metric by using the Expression Builder

Answer: B

Explanation: You should use a logical column (not physical). In fact,in the Explanation of the exam, it displays a logical column.

Question No: 29

Which language is used by OBIEE to query Essbase?

  1. SQL

  2. LINQ

  3. MDX

  4. DMX

Answer: C

Explanation: The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi-dimensional data source, rather than an SQL query against a relational star schema.

Question No: 30

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

  1. Physical Table

  2. Stored Proc

  3. Select

  4. View

  5. Table

Answer: A,B,C

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


Ensurepass 2018 PDF and VCE

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.

100% Ensurepass Free Download!
Download Free Demo:1z0-591 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-591 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.