Janeire Salicio
Quiz by , created more than 1 year ago

First Certificate of Cambridge Tecnología Test sobre 51-75_1z0-591_OBIEE III, creado por Janeire Salicio el 25/07/2017.

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

51-75_1z0-591_OBIEE III

51-75_1z0-591_OBIEE III

Question 1 of 25

1

QUESTION NO: 51
Identify the two Object level security functions that are done on the repository by using the BI Admin tool.

Select one or more of the following:

  • A. Assign users to a web catalog group

  • B. Create a new repository group

  • C. Create a new user in the repository

  • D. Create a web catalog group

  • E. Define permissions for Dashboard

Explanation

Question 2 of 25

1

QUESTION NO: 52
OBIEE 11g authentication of users is performed by which two components listed below?

Select one or more of the following:

  • A. Repository file (rpd)

  • B. Embedded WebLogic LDAP server

  • C. External directories such as Active Directory using WebLogic and Fusion Middleware's Oracle
    Platform Security Services framework

  • D. BI Presentation Services

Explanation

Question 3 of 25

1

QUESTION NO: 53
One of the initial phases in OBIEE implementation is the Discovery phase where the project team
focuses on a few activities. Which option is not one of them?

Select one of the following:

  • A. Business Requirements Definition

  • B. Technical Requirements Definition

  • C. Data Quality Assessment

  • D. Dashboard Testing

Explanation

Question 4 of 25

1

QUESTION NO: 54
Identify the two true statements about alias tables.

Select one or more of the following:

  • A. Alias tables are set up to avoid triangular or circular joins.

  • B. Alias tables are set up to include best practice naming conventions for physical table names.

  • C. Alias tables are set up to create another physical copy of the data.

  • D. Alias tables are set up to create a copy of the data with a filter applied to it.

Explanation

Question 5 of 25

1

QUESTION NO: 55
DSNs are set up for access to which data sources?

Select one of the following:

  • A. ODBC Data Sources

  • B. Oracle Data Sources

  • C. IBM Data Sources

  • D. Teradata Data Sources

Explanation

Question 6 of 25

1

QUESTION NO: 56
You do not have a physical time table in your database but would like to use the time series
functions that OBIEE offers. What two options do you have?

Select one or more of the following:

  • A. Create a physical time table in your database.

  • B. Create a Logical Table that is sourced from the time key in the fact table.

  • C. Create an "Opaque View" in the physical layer that contains the time columns from the fact and
    map it into your physical model.

  • D. Create a Logical Table that is sourced from a time field in one of your dimension tables.

  • E. Create a time table that is joined through a intervening Table so there is no foreign key
    relationship.

Explanation

Question 7 of 25

1

QUESTION NO: 57
Identity the three advantages of the BI Server metadata repository.

Select one or more of the following:

  • A. Mapping of federated data sources to one logical object

  • B. Ability to change physical sources without losing reports

  • C. Little changes in the physical layer to shift from development to production environment

  • D. Three layers support the highest level of security

Explanation

Question 8 of 25

1

QUESTION NO: 58
The WebLogic Console will allow you to perform which of the following functions in the BI
Managed Server?

Select one of the following:

  • A. Start and Stop BI Services

  • B. Build Aggregate Queries

  • C. Create Summary Tables

  • D. Manage user logins

Explanation

Question 9 of 25

1

QUESTION NO: 59
The Time Dimension hierarchy is a good example of a__________.

Select one of the following:

  • A. Level-based Time Dimension hierarchy

  • B. Ragged Hierarchy

  • C. Skip Level Hierarchy

  • D. Value-based Hierarchy

Explanation

Question 10 of 25

1

QUESTION NO: 60
When designing a Star Schema, which option does not apply?

Select one of the following:

  • A. The facts are quantifiable

  • B. The fact has several foreign keys that are primary keys in the dimensional table

  • C. Fact table is joined to the related dimensional tables.

  • D. Dimensional tables are normalized.

  • E. Dimensional tables have one attribute primary key as Product_ID for products.

Explanation

Question 11 of 25

1

QUESTION NO: 61
If you have a database with four aggregate tables, how should the repository be configured to take
advantage of the aggregates?

Select one of the following:

  • A. By creating four new logical tables sources

  • B. By creating four new logical table sources and choosing each dimension's level of aggregation in
    the Content tab

  • C. By creating four new logical table sources and using the Fragmentation content to specify the
    aggregation levels

  • D. By creating four new logical table sources and using the "where" section of the Content tab to
    specify the aggregation levels

Explanation

Question 12 of 25

1

QUESTION NO: 62
Which of the following native features of Essbase are not supported in OBIEE 11g?

Select one of the following:

  • A. Member Alias

  • B. Alternate Hierarchies

  • C. Dynamic Time Series

  • D. Parent/Child-based Hierarchies

Explanation

Question 13 of 25

1

QUESTION NO: 63
A customer would like to create a change and a % Change for Revenue at the same time. How
would they accomplish this?

Select one of the following:

  • A. Using the Expression Builder

  • B. Using the Calculation Wizard

  • C. Defining them in the physical data model

  • D. Defining them in the Presentation Layer

Explanation

Question 14 of 25

1

QUESTION NO: 64
When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard,
which two statements are true?

Select one or more of the following:

  • A. The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate
    table.

  • B. The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate
    tables and their corresponding objects in the repository.

  • C. Job Manager can be used to run the Aggregate Persistence script.

  • D. The Extraction Transformation and Loading process creates the aggregate tables.

Explanation

Question 15 of 25

1

QUESTION NO: 65
Which three options apply to FMW Application Roles?

Select one or more of the following:

  • A. Provide an indirection between LDAP groups and BI roles

  • B. Can be exported / moved between FMW11g environments

  • C. Are created and managed by using the WLS Admin Console and FMW Control

  • D. Can be created by using BI Administrator Client and "pushed" to WLS Admin Console

  • E. Secures RPD permissions but NOT Web Catalog (webcat) permissions

Explanation

Question 16 of 25

1

QUESTION NO: 66
How do you get the BI plug-in for MS Office?

Select one of the following:

  • A. By contacting the administrator

  • B. By downloading it from the BI Server

  • C. By downloading it from the Database Server

  • D. By downloading it from Microsoft Server

Explanation

Question 17 of 25

1

QUESTION NO: 67
There are two aggregate tables that are available for query. How would they be mapped into the
logical data model so queries can use them?

Select one of the following:

  • A. By creating two new logical tables sources

  • B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the
    Content tab

  • C. Both A and B

  • D. By creating one new Logical Table Source

Explanation

Question 18 of 25

1

QUESTION NO: 68
Which Oracle Partner is the supplier of map-based content to provide background maps, boundary
information, and points of interest?

Select one of the following:

  • A. Navteq

  • B. TeleAtlas

  • C. Google

  • D. ESRI

Explanation

Question 19 of 25

1

QUESTION NO: 69
The Consistency Checker checks______.

Select one of the following:

  • A. The validity of objects outside the metadata using the connection

  • B. Mappings to the physical objects

  • C. For objects deleted from the database

  • D. Syntax errors in derived logical columns

Explanation

Question 20 of 25

1

QUESTION NO: 70
A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?

Select one of the following:

  • A. Fact-based

  • B. Time-based

  • C. Mixed

  • D. Complex

Explanation

Question 21 of 25

1

QUESTION NO: 71
Identify the two types of storage for Essbase.

Select one of the following:

  • A. Aggregate Storage Option and Block Storage Option

  • B. Aggregate Storage and Cell Storage

  • C. OLAP Storage and Cell Storage

  • D. Aggregate Storage and Hybrid Columnar Compression

Explanation

Question 22 of 25

1

QUESTION NO: 72
Where is Cache in OBIEE located?

Select one of the following:

  • A. In relational database

  • B. It is local disk-based.

  • C. In dynamic aggregate

  • D. In memory cache

Explanation

Question 23 of 25

1

QUESTION NO: 73
A customer always wants Aggregate Table l to be looked at first to see if it can answer the query.
What should be done to make sure this happens?

Select one of the following:

  • A. Make Aggregate Table 1 the first table in the list of Logical Table Sources.

  • B. Do not map the logical level in the Content tab.

  • C. Set the Priority Group to 0.

  • D. Set the Priority Croup to 5.

Explanation

Question 24 of 25

1

QUESTION NO: 74
Which OBIEE capability enables developers to build Aggregate tables?

Select one of the following:

  • A. Aggregate Persistence Wizard

  • B. Expression Builder

  • C. Table Builder

  • D. Query Analyzer

Explanation

Question 25 of 25

1

QUESTION NO: 75
When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension,
then select "New Object" What must be selected next?

Select one or more of the following:

  • A. Logical Key

  • B. Parent Level

  • C. Child Level

  • D. Dynamic Key

Explanation

Previous
Check answer
Next