Janeire Salicio
Quiz von , erstellt am 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
Erstellt von Janeire Salicio vor mehr als 7 Jahre
Schließen

51-75_1z0-591_OBIEE III

51-75_1z0-591_OBIEE III

Frage 1 von 25

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 2 von 25

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 3 von 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?

Wähle eine der folgenden:

  • A. Business Requirements Definition

  • B. Technical Requirements Definition

  • C. Data Quality Assessment

  • D. Dashboard Testing

Erklärung

Frage 4 von 25

1

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 5 von 25

1

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

Wähle eine der folgenden:

  • A. ODBC Data Sources

  • B. Oracle Data Sources

  • C. IBM Data Sources

  • D. Teradata Data Sources

Erklärung

Frage 6 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 7 von 25

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 8 von 25

1

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

Wähle eine der folgenden:

  • A. Start and Stop BI Services

  • B. Build Aggregate Queries

  • C. Create Summary Tables

  • D. Manage user logins

Erklärung

Frage 9 von 25

1

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

Wähle eine der folgenden:

  • A. Level-based Time Dimension hierarchy

  • B. Ragged Hierarchy

  • C. Skip Level Hierarchy

  • D. Value-based Hierarchy

Erklärung

Frage 10 von 25

1

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

Wähle eine der folgenden:

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

Erklärung

Frage 11 von 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?

Wähle eine der folgenden:

  • 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

Erklärung

Frage 12 von 25

1

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

Wähle eine der folgenden:

  • A. Member Alias

  • B. Alternate Hierarchies

  • C. Dynamic Time Series

  • D. Parent/Child-based Hierarchies

Erklärung

Frage 13 von 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?

Wähle eine der folgenden:

  • 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

Erklärung

Frage 14 von 25

1

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 15 von 25

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 16 von 25

1

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

Wähle eine der folgenden:

  • 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

Erklärung

Frage 17 von 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?

Wähle eine der folgenden:

  • 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

Erklärung

Frage 18 von 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?

Wähle eine der folgenden:

  • A. Navteq

  • B. TeleAtlas

  • C. Google

  • D. ESRI

Erklärung

Frage 19 von 25

1

QUESTION NO: 69
The Consistency Checker checks______.

Wähle eine der folgenden:

  • 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

Erklärung

Frage 20 von 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?

Wähle eine der folgenden:

  • A. Fact-based

  • B. Time-based

  • C. Mixed

  • D. Complex

Erklärung

Frage 21 von 25

1

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

Wähle eine der folgenden:

  • 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

Erklärung

Frage 22 von 25

1

QUESTION NO: 72
Where is Cache in OBIEE located?

Wähle eine der folgenden:

  • A. In relational database

  • B. It is local disk-based.

  • C. In dynamic aggregate

  • D. In memory cache

Erklärung

Frage 23 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 24 von 25

1

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

Wähle eine der folgenden:

  • A. Aggregate Persistence Wizard

  • B. Expression Builder

  • C. Table Builder

  • D. Query Analyzer

Erklärung

Frage 25 von 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?

Wähle eine oder mehr der folgenden:

  • A. Logical Key

  • B. Parent Level

  • C. Child Level

  • D. Dynamic Key

Erklärung

Vorherige
Antwort prüfen
Nächste