Janeire Salicio
Quiz by , created more than 1 year ago

Preguntas de la 1-25

94
1
0
Janeire Salicio
Created by Janeire Salicio over 7 years ago
Close

1-25_1z0-591-OBIEE I

Question 1 of 25

1

QUESTION NO: 1
When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if
the data is loaded nightly?

Select one of the following:

  • A. The lowest level of aggregation

  • B. The highest level of aggregation

  • C. Multiple levels of aggregation

  • D. Independently from aggregation level

Explanation

Question 2 of 25

1

QUESTION NO: 2
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________.

Select one of the following:

  • A. $10,000

  • B. 0

  • C. 1

  • D. Year

Explanation

Question 3 of 25

1

QUESTION NO: 3
Which two components are required for all OBIEE installations?

Select one or more of the following:

  • A. Admin Server

  • B. RCU Schema

  • C. Managed Server

  • D. Node Manager

  • E. Oracle 11g

Explanation

Question 4 of 25

1

QUESTION NO: 4
The administration tool is the developer's interface to the repository file. It allows the development
of and changes to the metadata repository file. Which statement is true?

Select one of the following:

  • A. Changes to the repository can only be carried out in offline mode.

  • B. Multiple developers can work on one repository at the same time. Results can be merged later on.

  • C. All aspects of security are being held in the repository file.

  • D. Opening the rpd.file in online mode results in performance Issues for the application user.

Explanation

Question 5 of 25

1

QUESTION NO: 5
Which installation option is used to install into an existing Fusion Middleware Home?

Select one of the following:

  • A. Software Only Install

  • B. Simple Install

  • C. Enterprise Install

  • D. Cannot install into an existing Fusion Middleware Home

Explanation

Question 6 of 25

1

QUESTION NO: 6
What are the two methodologies that are followed within an OBIEE implementation?

Select one or more of the following:

  • A. Do not use prototypes

  • B. Use an iterative approach

  • C. Start with a small model and then enhance the repository

  • D. Start with a big repository and trim it down with the requirements

Explanation

Question 7 of 25

1

QUESTION NO: 7
Which option describes how OBIEE Integrates with Planning?

Select one or more of the following:

  • A. OBIEE primarily accesses Planning using standard Essbase integration techniques.

  • B. OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM)
    layer.

  • C. Planning is not a supported OBIEE source.

  • D. OBIEE integrates with Planning directly through relational database access.

Explanation

Question 8 of 25

1

QUESTION NO: 8
What is an example of a Session Variable?

Select one of the following:

  • A. ETL Load Date

  • B. User Organization

  • C. OLAP DSN

  • D. Top Customers by Revenue

Explanation

Question 9 of 25

1

QUESTION NO: 9
Which option is used to enter the rank function when creating a new rank measure?

Select one of the following:

  • A. Initialization Block

  • B. Expression Builder

  • C. Connection Pool

  • D. Web Catalog

Explanation

Question 10 of 25

1

QUESTION NO: 10
Query limits tab can be accessed through________.

Select one of the following:

  • A. Security Manager, Query tab, Application role dialog box, Permissions

  • B. Security Manager, Application Roles tab, Query dialog box, Permissions

  • C. Security Manager, Application Roles tab, Application role dialog box, Permissions

  • D. Security Manager, Application Roles tab, Application role dialog box, Query Properties

Explanation

Question 11 of 25

1

QUESTION NO: 11
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?

Select one of the following:

  • A. Year

  • B. Month

  • C. Quarter

  • D. CurrentMonth

Explanation

Question 12 of 25

1

QUESTION NO: 12
WLS Embedded LDAP Server is managed by the Admin Server Console and supports which
three options?

Select one or more of the following:

  • A. Creating and Maintaining Users

  • B. Authentication and Authorization

  • C. Basic Directory for storing user details

  • D. Subject area and row-level security, connection pool passwords

  • E. Application of Session Variables as Data Filters

Explanation

Question 13 of 25

1

QUESTION NO: 13
Point-and-click generation of case statement logic can be accessed via which option?

Select one of the following:

  • A. Column Formula -> Bins tab

  • B. Compound Layout

  • C. Column Properties -> Conditional Format tab

  • D. Advanced Tab

  • E. Subject Area metrics

Explanation

Question 14 of 25

1

QUESTION NO: 14
Which task can be performed after the Administrator link has been reached through logging into
OBIEE?

Select one of the following:

  • A. Associate map layers to columns

  • B. Manage access to Subject Areas

  • C. SSO enablement

  • D. Start or Stop BI Managed Servers

Explanation

Question 15 of 25

1

QUESTION NO: 15
Which three techniques are applied to support Failover?

Select one or more of the following:

  • A. WebLogic Clustering

  • B. Universal Installer > Scale Out BI System option

  • C. OBIEE Clustering

  • D. Vertical Scaleout

Explanation

Question 16 of 25

1

QUESTION NO: 16
The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS
applications?

Select one or more of the following:

  • A. MS Visio

  • B. MS Excel

  • C. MS Project

  • D. MS Word

Explanation

Question 17 of 25

1

QUESTION NO: 17
A user's BI Home page provides one-click access to which three options?

Select one or more of the following:

  • A. Create new content

  • B. Oracle BI online documentation

  • C. Catalog search functionality

  • D. Dashboard layout editor

  • E. Business model metadata

Explanation

Question 18 of 25

1

QUESTION NO: 18
A customer needs to have a calculation done prior to aggregating the data. How would you
accomplish this?

Select one of the following:

  • A. By creating a derived measure by using the Logical Columns available

  • B. By creating a derived measure in the Column Mapping dialog box by using the physical table
    columns.

  • C. By creating a derived measure by using Logic Columns available and changing the aggregation
    type

  • D. By creating a derived metric by using the Expression Builder

  • E. By creating a derived metric by using the Calculation Wizard

Explanation

Question 19 of 25

1

QUESTION NO: 19
Which resource identifies the OBIEE Web Catalog (webcat)?

Select one or more of the following:

  • A. instanceconfig.xml

  • B. RCU Schema

  • C. Identity Store

  • D. nqsconfig.ini

  • E. Admin Server

Explanation

Question 20 of 25

1

QUESTION NO: 20
The ODBC DNS is never used for _______.

Select one of the following:

  • A. Initial import of the physical layer metadata on a Windows server

  • B. Query execution and data access on a Windows server

  • C. Initial import of the physical layer metadata, query execution, and data access on a Windows
    Server

  • D. Changing passwords

  • E. Comparing RPDs

Explanation

Question 21 of 25

1

QUESTION NO: 21
Identify the reason why Oracle OLAP provides a favorable aggregation strategy.

Select one of the following:

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

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

  • C. OLAP cubes can be easily transported from database to database.

  • D. OLAP cubes can be queried by using SQL.

Explanation

Question 22 of 25

1

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

Select one of the following:

  • A. MS Excel

  • B. MS Word

  • C. PDF

  • D. CSV

Explanation

Question 23 of 25

1

QUESTION NO: 23
Which of the following characteristics pertain to a "ragged" hierarchy?

Select one of the following:

  • A. It can only be stored in an XML structure.

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

  • C. All values can have a maximum of six levels.

  • D. It creates multiple levels of hierarchy in the database table.

Explanation

Question 24 of 25

1

QUESTION NO: 24
What is the process in which there is redundancy of data to improve performance?

Select one of the following:

  • A. Redundancy

  • B. Normalization

  • C. Denormalization

  • D. Granularity

  • E. Cardinality

Explanation

Question 25 of 25

1

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?

Select one of the following:

  • A. By creating two Logical Fact Tables for each database

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

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

  • 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.

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

Explanation

Previous
Check answer
Next