26-51_1z0-591_OBIEE II

Question

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

Answer 1

A. Design requests that use Complex Queries

Answer 2

B. Avoid returning big data sets within the Dashboard

Answer 3

C. Use Cache

Answer 4

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

Answer 5

A. Oracle RDBMS

Answer 6

B. Microsoft SQL Server

Answer 7

C. IBM DB2

Answer 8

D. Teradata

Answer 9

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

Answer 10

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

Answer 11

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

Answer 12

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

Answer 13

A. Physical Table

Answer 14

B. Stored Proc

Answer 15

A. Through EPM Analytic Data Model (ADM) connectivity

Answer 16

B. Direct relational database access

Answer 17

C. Through Essbase connectivity

Answer 18

D. OBIEE does not support HFM integration

Answer 19

A. Incremental data loading

Answer 20

B. Top - down planning

Answer 21

C. Extremely sparse data sets

Answer 22

D. Millions of members in the outline

Answer 23

A. Cascading Style Sheets

Answer 24

B. DHML Message files

Answer 25

C. XML Message Files

Answer 26

D. BI Presentation services web template

Answer 27

A. Access and Performance Layer

Answer 28

B. Master Data Layer

Answer 29

C. Staging Data Layer

Answer 30

D. Presentation Data Layer

Answer 31

B. CurrentDay

Answer 32

C. CurrentMonth

Answer 33

A. Multiple SQL queries are performed

Answer 34

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

Answer 35

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

Answer 36

D. No SQL queries are performed against the source tables

Answer 37

B. Row Level Filters

Answer 38

C. Server Password

Answer 39

D. Single Sign On

Answer 40

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

Answer 41

B. Cache can increase traffic to back end database

Answer 42

C. Cache needs to be purged to refresh data.

Answer 43

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

Answer 44

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

Answer 45

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

Answer 46

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

Answer 47

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

Answer 48

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

Answer 49

E. Specifying a sort order in the Logical Table dialog

Answer 50

A. the subject areas share objects of the same name

Answer 51

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

Answer 52

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

Answer 53

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

Answer 54

A. Test Environment

Answer 55

B. System Testing

Answer 56

C. Performance Tuning

Answer 57

D. Project initiation and resourcing

Answer 58

E. Data Validation / Verification

Answer 59

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

Answer 60

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

Answer 61

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

Answer 62

D. Do Nothing

Answer 63

A. improve performance of Dashboards and Analysis

Answer 64

B. decrease query response time

Answer 65

C. improve Analysis data quality

Answer 66

D. eliminate Write Back Capabilities

Answer 67

E. create Aggregate tables

Answer 68

A. Logical Key

Answer 69

B. Implicit Fact Column

Answer 70

D. Logical Column Name

Answer 71

E. Custom Display Name

Answer 72

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

Answer 73

B. By specifying a driving table

Answer 74

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

Answer 75

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

Answer 76

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

Answer 77

A. Because transactional source systems are often denormalized

Answer 78

B. Because transactional source systems are often normalized

Answer 79

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

Answer 80

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

Answer 81

A. Control runaway queries

Answer 82

B. Limit Queries by maximum run time

Answer 83

C. Control aggregation

Answer 84

D. Control User Authentication

Answer 85

E. Control Write Back Capabilities

Answer 86

A. Calculate share measures

Answer 87

B. Add two logical columns together

Answer 88

C. Calculate a variance between two measures

Answer 89

D. Calculate the rank dimension values

Answer 90

E. Input data

Answer 91

B. Non System

Answer 92

D. Dynamic

Answer 93

A. Catalog

Answer 94

B. Dashboard

Answer 95

C. New -> Analysis

Answer 96

E. Favorites

Next up

26-51_1z0-591_OBIEE II

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Similar

	Created by Janeire Salicio over 7 years ago