Janeire Salicio
Quiz by , created more than 1 year ago

First Certificate of Cambridge Tecnología Quiz on 26-51_1z0-591_OBIEE II, created by Janeire Salicio on 24/07/2017.

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

26-51_1z0-591_OBIEE II

Question 1 of 25

1

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

Select one or more of the following:

  • A. Design requests that use Complex Queries

  • B. Avoid returning big data sets within the Dashboard

  • C. Use Cache

  • D. Avoid using Guided Navigation unless the data set is large

Explanation

Question 2 of 25

1

QUESTION NO: 27
The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?

Select one or more of the following:

  • A. Oracle RDBMS

  • B. Microsoft SQL Server

  • C. IBM DB2

  • D. Teradata

Explanation

Question 3 of 25

1

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?

Select one of the following:

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

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

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

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

Explanation

Question 4 of 25

1

QUESTION NO: 29
Which language is used by OBIEE to query Essbase?

Select one of the following:

  • A. SQL

  • B. LINQ

  • C. MDX

  • D. DMX

Explanation

Question 5 of 25

1

QUESTION NO: 30
Which are the three types of tables available to physical tables in the physical layer?

Select one or more of the following:

  • A. Physical Table

  • B. Stored Proc

  • C. Select

  • D. View

  • E. Table

Explanation

Question 6 of 25

1

QUESTION NO: 31
Which option describes how OBIEE natively integrates with HFM?

Select one of the following:

  • A. Through EPM Analytic Data Model (ADM) connectivity

  • B. Direct relational database access

  • C. Through Essbase connectivity

  • D. OBIEE does not support HFM integration

Explanation

Question 7 of 25

1

QUESTION NO: 32
Select the scenario in which block storage must be used instead of aggregate storage.

Select one of the following:

  • A. Incremental data loading

  • B. Top - down planning

  • C. Extremely sparse data sets

  • D. Millions of members in the outline

Explanation

Question 8 of 25

1

QUESTION NO: 33
What would you use to customize the text elements that appear on BI Analysis, Delivers and
Dashboard pages?

Select one of the following:

  • A. Cascading Style Sheets

  • B. DHML Message files

  • C. XML Message Files

  • D. BI Presentation services web template

Explanation

Question 9 of 25

1

QUESTION NO: 34
In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data
warehouse?

Select one of the following:

  • A. Access and Performance Layer

  • B. Master Data Layer

  • C. Staging Data Layer

  • D. Presentation Data Layer

Explanation

Question 10 of 25

1

QUESTION NO: 35
Which two options are valid Repository Variable names?

Select one or more of the following:

  • A. USER

  • B. CurrentDay

  • C. CurrentMonth

  • D. Date

Explanation

Question 11 of 25

1

QUESTION NO: 36

One benefit of adding a second table source that is joined to the first table source in the Physical
Layer by a foreign key relationship is that______.

Select one of the following:

  • A. Multiple SQL queries are performed

  • B. Two SQL queries are performed to get data from both tables

  • C. A single SQL query is performed to get data from both tables

  • D. No SQL queries are performed against the source tables

Explanation

Question 12 of 25

1

QUESTION NO: 37
When creating a Security Realm in the WebLogic Console, which object is created?

Select one of the following:

  • A. Groups

  • B. Row Level Filters

  • C. Server Password

  • D. Single Sign On

Explanation

Question 13 of 25

1

QUESTION NO: 38
Select the correct statement.

Select one of the following:

  • A. Cache provides fast and always up-to-date information.

  • B. Cache can increase traffic to back end database

  • C. Cache needs to be purged to refresh data.

  • D. Cache can degrade query performance by reading data from the disk instead of the database.

  • E. Cache is seeded by manually running PL/SQL at the back end database.

Explanation

Question 14 of 25

1

QUESTION NO: 39
A customer has a requirement for rolling period calculations. What two additional steps will need to
be done to enable this in the repository?

Select one or more of the following:

  • A. Clicking the "Time" option in the Logical Dimension Dialog

  • B. Designating a chronological key for every level of every dimension hierarchy

  • C. Clicking the "Time" option in the Logical Table Source Dialog

  • D. Designating a chronological key for every logical column in the Logical Table Source

  • E. Specifying a sort order in the Logical Table dialog

Explanation

Question 15 of 25

1

QUESTION NO: 40
When creating a query. Subject areas can be combined via point and click as long as____.

Select one of the following:

  • A. the subject areas share objects of the same name

  • B. the subject areas both share the same model in the business model and mapping layer

  • C. the subject areas are both from the same physical source, though they may be in separate
    business layers

  • D. two or more subject areas cannot be joined together without manually mapping the contents

Explanation

Question 16 of 25

1

QUESTION NO: 41
Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful
completion of certain tasks. Which option is not one of them?

Select one of the following:

  • A. Test Environment

  • B. System Testing

  • C. Performance Tuning

  • D. Project initiation and resourcing

  • E. Data Validation / Verification

Explanation

Question 17 of 25

1

QUESTION NO: 42
How will you model a Type II Slowly-Changing Dimension?

Select one of the following:

  • A. Add an additional column to the dimension table to capture a version of change

  • B. Overwrite an existing dimension table record with the changed record

  • C. Add a new row to the dimension table with a new key for the changed record

  • D. Do Nothing

Explanation

Question 18 of 25

1

QUESTION NO: 43
Cache in OBIEE is used to_____. Select the two correct answers.

Select one or more of the following:

  • A. improve performance of Dashboards and Analysis

  • B. decrease query response time

  • C. improve Analysis data quality

  • D. eliminate Write Back Capabilities

  • E. create Aggregate tables

Explanation

Question 19 of 25

1

QUESTION NO: 44
A customer frequently queries multiple dimension tables without a measure. What needs to be
defined in the presentation layer?

Select one of the following:

  • A. Logical Key

  • B. Implicit Fact Column

  • C. Alias

  • D. Logical Column Name

  • E. Custom Display Name

Explanation

Question 20 of 25

1

QUESTION NO: 45
A customer needs to do a cross database join between two tables where, one of the tables has a
small number of values and the other has a large number of values. How can you optimize the
way the BI Server processes the query?

Select one of the following:

  • A. By specifying a one-to-many join between the tables with the small and large numbers of values

  • B. By specifying a driving table

  • C. By specifying a many to one join between the tables with the small and large numbers of values

  • D. By creating your logical join by using the Joins Manager

  • E. By creating your joins by using the Business Model Diagram

Explanation

Question 21 of 25

1

QUESTION NO: 46
Why is it necessary to join multiple source tables to a single dimension?

Select one of the following:

  • A. Because transactional source systems are often denormalized

  • B. Because transactional source systems are often normalized

  • C. Because a single source table often contains all the dimensions needed

  • D. Because the dimensions tables are built in the transactional systems

Explanation

Question 22 of 25

1

QUESTION NO: 47
Query Limits are used to manage Query environment in the repository for users and roles and
can_________.

Select one of the following:

  • A. Control runaway queries

  • B. Limit Queries by maximum run time

  • C. Control aggregation

  • D. Control User Authentication

  • E. Control Write Back Capabilities

Explanation

Question 23 of 25

1

QUESTION NO: 48
A derived measure is never used to_________.

Select one of the following:

  • A. Calculate share measures

  • B. Add two logical columns together

  • C. Calculate a variance between two measures

  • D. Calculate the rank dimension values

  • E. Input data

Explanation

Question 24 of 25

1

QUESTION NO: 49
What are the two types of Session Variables?

Select one or more of the following:

  • A. System

  • B. Non System

  • C. Static

  • D. Dynamic

Explanation

Question 25 of 25

1

QUESTION NO: 50
Content that is saved in personal and shared folders can be browsed by using which view?

Select one of the following:

  • A. Catalog

  • B. Dashboard

  • C. New -> Analysis

  • D. Home

  • E. Favorites

Explanation

Previous
Check answer
Next