Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-591

Oracle 1z0-591 Exam Practice Questions (P. 5)

  • Full Access (120 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
  1. A
    OLAP cubes eliminate the need for a large number of aggregate tables.
  2. B
    OLAP cubes are stored outside of the database in highly optimized file structures.
  3. C
    OLAP cubes can be easily transported from database to database.
  4. D
    OLAP cubes can be queried by using SQL.

Correct Answer:
D
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's Guide, What's New in Oracle OLAP?

Question #22
When Exporting an Analysis from a Dashboard, which of the following is NOT an option?
  1. A
    MS Excel
  2. B
    MS Word
  3. C
    PDF
  4. D
    CSV

Correct Answer:
B
Incorrect answers:
C: Use the PDF and Print Properties to export analysis to PDF format.

Question #23
Which of the following characteristics pertain to a "ragged" hierarchy?
  1. A
    It can only be stored in an XML structure.
  2. B
    A branch of the hierarchy may have a different number of levels than other branches.
  3. C
    All values can have a maximum of six levels.
  4. D
    It creates multiple levels of hierarchy in the database table.

Correct Answer:
B
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 #24
What is the process in which there is redundancy of data to improve performance?
  1. A
    Redundancy
  2. B
    Normalization
  3. C
    Denormalization
  4. D
    Granularity
  5. E
    Cardinality

Correct Answer:
C
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 #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. A
    By creating two Logical Fact Tables for each database
  2. B
    By creating joins in the physical model so it looks like a single table
  3. C
    By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
  4. D
    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. E
    By creating one logical table sources and checking the "This Source should be combined with other sources at this level" box

Correct Answer:
C
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 > Creating and Administering the Business Model and Mapping Layer in a Repository >
Creating and Administering Logical Table Sources (Mappings) > Defining Content of Logical Table Sources

Previous Questions Next Questions

All Pages