Test
26-51_1z0-591_OBIEE II
Preguntas del test (25)
1QUESTION NO: 26
What are the two leading design solutions recommended by Oracle that you would use for
performance?- AA. Design requests that use Complex Queries
- BB. Avoid returning big data sets within the Dashboard
- CC. Use Cache
- DD. Avoid using Guided Navigation unless the data set is large
2QUESTION NO: 27
The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?- AA. Oracle RDBMS
- BB. Microsoft SQL Server
- CC. IBM DB2
- DD. Teradata
3QUESTION NO: 28
There is a logical fact table that contains Item number, store, time, and revenue. How would you
add Number of items sold?- AA. By creating a derived measure on the logical column Item number and using the count Function
- BB. By creating a derived measure on the logical column item number and using the count distinct
function - CC. By creating a derived measure based on the physical column item number and changing the
aggregation method to count - DD. By creating a derived metric by using the Expression Builder
4QUESTION NO: 29
Which language is used by OBIEE to query Essbase?- AA. SQL
- BB. LINQ
- CC. MDX
- DD. DMX
5QUESTION NO: 30
Which are the three types of tables available to physical tables in the physical layer?- AA. Physical Table
- BB. Stored Proc
- CC. Select
- DD. View
- EE. Table
6QUESTION NO: 31
Which option describes how OBIEE natively integrates with HFM?- AA. Through EPM Analytic Data Model (ADM) connectivity
- BB. Direct relational database access
- CC. Through Essbase connectivity
- DD. OBIEE does not support HFM integration
7QUESTION NO: 32
Select the scenario in which block storage must be used instead of aggregate storage.- AA. Incremental data loading
- BB. Top - down planning
- CC. Extremely sparse data sets
- DD. Millions of members in the outline
8QUESTION NO: 33
What would you use to customize the text elements that appear on BI Analysis, Delivers and
Dashboard pages?- AA. Cascading Style Sheets
- BB. DHML Message files
- CC. XML Message Files
- DD. BI Presentation services web template
9QUESTION NO: 34
In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data
warehouse?- AA. Access and Performance Layer
- BB. Master Data Layer
- CC. Staging Data Layer
- DD. Presentation Data Layer
10QUESTION NO: 35
Which two options are valid Repository Variable names?- AA. USER
- BB. CurrentDay
- CC. CurrentMonth
- DD. Date
11QUESTION 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______.- AA. Multiple SQL queries are performed
- BB. Two SQL queries are performed to get data from both tables
- CC. A single SQL query is performed to get data from both tables
- DD. No SQL queries are performed against the source tables
12QUESTION NO: 37
When creating a Security Realm in the WebLogic Console, which object is created?- AA. Groups
- BB. Row Level Filters
- CC. Server Password
- DD. Single Sign On
13QUESTION NO: 38
Select the correct statement.- AA. Cache provides fast and always up-to-date information.
- BB. Cache can increase traffic to back end database
- CC. Cache needs to be purged to refresh data.
- DD. Cache can degrade query performance by reading data from the disk instead of the database.
- EE. Cache is seeded by manually running PL/SQL at the back end database.
14QUESTION 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?- AA. Clicking the "Time" option in the Logical Dimension Dialog
- BB. Designating a chronological key for every level of every dimension hierarchy
- CC. Clicking the "Time" option in the Logical Table Source Dialog
- DD. Designating a chronological key for every logical column in the Logical Table Source
- EE. Specifying a sort order in the Logical Table dialog
15QUESTION NO: 40
When creating a query. Subject areas can be combined via point and click as long as____.- AA. the subject areas share objects of the same name
- BB. the subject areas both share the same model in the business model and mapping layer
- CC. the subject areas are both from the same physical source, though they may be in separate
business layers - DD. two or more subject areas cannot be joined together without manually mapping the contents
16QUESTION 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?- AA. Test Environment
- BB. System Testing
- CC. Performance Tuning
- DD. Project initiation and resourcing
- EE. Data Validation / Verification
17QUESTION NO: 42
How will you model a Type II Slowly-Changing Dimension?- AA. Add an additional column to the dimension table to capture a version of change
- BB. Overwrite an existing dimension table record with the changed record
- CC. Add a new row to the dimension table with a new key for the changed record
- DD. Do Nothing
18QUESTION NO: 43
Cache in OBIEE is used to_____. Select the two correct answers.- AA. improve performance of Dashboards and Analysis
- BB. decrease query response time
- CC. improve Analysis data quality
- DD. eliminate Write Back Capabilities
- EE. create Aggregate tables
19QUESTION NO: 44
A customer frequently queries multiple dimension tables without a measure. What needs to be
defined in the presentation layer?- AA. Logical Key
- BB. Implicit Fact Column
- CC. Alias
- DD. Logical Column Name
- EE. Custom Display Name
20QUESTION 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?- AA. By specifying a one-to-many join between the tables with the small and large numbers of values
- BB. By specifying a driving table
- CC. By specifying a many to one join between the tables with the small and large numbers of values
- DD. By creating your logical join by using the Joins Manager
- EE. By creating your joins by using the Business Model Diagram
21QUESTION NO: 46
Why is it necessary to join multiple source tables to a single dimension?- AA. Because transactional source systems are often denormalized
- BB. Because transactional source systems are often normalized
- CC. Because a single source table often contains all the dimensions needed
- DD. Because the dimensions tables are built in the transactional systems
22QUESTION NO: 47
Query Limits are used to manage Query environment in the repository for users and roles and
can_________.- AA. Control runaway queries
- BB. Limit Queries by maximum run time
- CC. Control aggregation
- DD. Control User Authentication
- EE. Control Write Back Capabilities
23QUESTION NO: 48
A derived measure is never used to_________.- AA. Calculate share measures
- BB. Add two logical columns together
- CC. Calculate a variance between two measures
- DD. Calculate the rank dimension values
- EE. Input data
24QUESTION NO: 49
What are the two types of Session Variables?- AA. System
- BB. Non System
- CC. Static
- DD. Dynamic
25QUESTION NO: 50
Content that is saved in personal and shared folders can be browsed by using which view?- AA. Catalog
- BB. Dashboard
- CC. New -> Analysis
- DD. Home
- EE. Favorites
Información
- Descripción
- First Certificate of Cambridge Tecnología Test sobre 26-51_1z0-591_OBIEE II, creado por Janeire Salicio el 24/07/2017.
- Autor
- Janeire Salicio
- Idioma
- Español
- Visitas
- 58
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test