Janeire Salicio
Quiz by , created more than 1 year ago

First Certificate of Cambridge Tecnología Quiz on 101-120_1Z0-591_OBIEE V, created by Janeire Salicio on 25/07/2017.

32
1
0
Janeire Salicio
Created by Janeire Salicio almost 7 years ago
Close

101-120_1Z0-591_OBIEE V

Question 1 of 20

1

QUESTION NO: 101
Which two Oracle BI Components contain security information regarding permissions and
privileges?

Select one or more of the following:

  • A. The Web Catalog

  • B. The Repository

  • C. NQSConfig.ini File

  • D. NQServer.ini File

  • E. InstanceConfig.xml File

Explanation

Question 2 of 20

1

QUESTION NO: 102
A customer needs to create a product share calculation. What are the two ways that they would
get the revenue for all products to use in the denominator?

Select one or more of the following:

  • A. Create a derived measure by using the addition function that adds each product value together.

  • B. Create a derived measure based on Revenue that has the Level Total Product selected on the
    Level Tab of the Logical Column Dialog.

  • C. Create a derived measure based on Revenue that has all the levels selected on the Level Tab of
    the Logical Column Dialog except Total Product.

  • D. Create a derived metric by using the Expression Builder.

Explanation

Question 3 of 20

1

QUESTION NO: 103
Which analysis features could be applied to provide interactive controls for end users?

Select one of the following:

  • A. Column Selector

  • B. Action Links

  • C. Conditional Formatting

  • D. Narrative View

  • E. Greenbar Styling

Explanation

Question 4 of 20

1

QUESTION NO: 104
An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars.
How would you accomplish this?

Select one of the following:

  • A. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal
    Calendar and -> Julian Calendar

  • B. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal
    Calendar and Julian Calendar

  • C. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal
    Calendar and + Julian Calendar

  • D. By creating a Presentation Folder called Time<parent> and then two subsequent folders called
    Fiscal Calendar<child> and Julian Calendar<child>

Explanation

Question 5 of 20

1

QUESTION NO: 105
OBIEE default security model stores security Information such as user names and password
combinations for accessing an external system such as Active Directory. It is stored in
the____________.

Select one of the following:

  • A. Policy Store

  • B. Credential Store

  • C. Identity Store

  • D. Person Store

Explanation

Question 6 of 20

1

QUESTION NO: 106
If a customer is planning on building a data warehouse, how would you describe data warehousing
to the customer?

Select one of the following:

  • A. The data in the data warehouse describes events and statuses of business processes, products
    and services, goals and organizational units, and generally mirrors every aspect of the structure
    and behavior of the organization.

  • B. Data warehouses can only be based on multidimensional data modeling.

  • C. Application based data warehouses can be bought off the shelf and used without any tweaking.

  • D. Data warehouse projects are usually implemented within two weeks.

Explanation

Question 7 of 20

1

QUESTION NO: 107
Initialization Blocks are never used to initialize which option?

Select one of the following:

  • A. Dynamic Repository Variables

  • B. System Session Variables

  • C. Non System Session Variables

  • D. rpd file

Explanation

Question 8 of 20

1

QUESTION NO: 108
What must be purchased when integrating Oracle map with Oracle BI?

Select one of the following:

  • A. Oracle Mapviewer

  • B. Oracle Business Intelligence Enterprise Edition

  • C. Spatial Option with Database

  • D. OLAP option

Explanation

Question 9 of 20

1

QUESTION NO: 109
The customer is questioning the necessity to have a data warehouse in place. They want to run
OBIEE against various transactional systems. Identify the two limitations.

Select one or more of the following:

  • A. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.

  • B. The BI server cannot integrate various sources in one metadata model.

  • C. Data quality issues might emerge, due to missing data cleansing.

  • D. Business issues are depending on real-time data.

Explanation

Question 10 of 20

1

QUESTION NO: 110
Permissions for Presentation layer objects and Business layer objects that restrict users is
configured in which software component?

Select one of the following:

  • A. Oracle Enterprise Manager

  • B. Oracle HTTP Server

  • C. WebLogic Server Administration Component

  • D. BI Administration Tool

Explanation

Question 11 of 20

1

QUESTION NO: 111
You run the Consistency Check and receive the warning:
[39003] Missing functional dependency association for column:
DIM_Offer_End_Date.CREATE_DT.
What would you check?

Select one of the following:

  • A. Whether the logical table source for this column has been disabled

  • B. Whether the columns creating CREATE_DT have been deleted

  • C. Whether there is a logical join between the DIM and FACT tables

  • D. Whether there is a physical join between the DIM and FACT tables

  • E. Whether there is a physical column mapped to the logical column

  • F. DIM_Offer_End_Date.CREATE_DT

Explanation

Question 12 of 20

1

QUESTION NO: 112
How do System Session Variables obtain their values?

Select one of the following:

  • A. They are entered by user input on a dashboard

  • B. They are obtained from data fields in the Physical Layer

  • C. They are obtained from the Presentation Layer

  • D. They are obtained from the Initialization Block

Explanation

Question 13 of 20

1

QUESTION NO: 113
Selecting the Manage Map Data link allows one to do which three of the following?

Select one or more of the following:

  • A. Associate map layers to columns defined in the OBIEE metadata

  • B. Create a new map layer

  • C. Set the zoom level of an imported map

  • D. Import images for use on maps

Explanation

Question 14 of 20

1

QUESTION NO: 114
Which option is not an example of a level-based measure?

Select one of the following:

  • A. Regional Revenue

  • B. Sales

  • C. Brand Cost

  • D. Employee Salary

Explanation

Question 15 of 20

1

QUESTION NO: 115
Use of the Enterprise Install option is recommended for which three options?

Select one or more of the following:

  • A. Multiple instances on a single computer

  • B. Scale out for High Availability and Failover

  • C. Support for high security requirements

  • D. Evaluation of end user functionality

  • E. Single users working on a single computer

Explanation

Question 16 of 20

1

QUESTION NO: 116
What are the two ways to use the administration tool?

Select one or more of the following:

  • A. It can be used to manage user password.

  • B. The administration tool uses a set of wizards that support the design of calculations, expressions,
    dimensions, and so on.

  • C. It can be used for versioning of the rpd.

  • D. Administrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.

Explanation

Question 17 of 20

1

QUESTION NO: 117
An integrated BI tools business case can be built around which three options?

Select one or more of the following:

  • A. Scalability

  • B. Fault tolerance

  • C. Cost Savings

  • D. Development efficiency

Explanation

Question 18 of 20

1

QUESTION NO: 118
Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be
implemented by using which method?

Select one of the following:

  • A. Single Sign-On (SSO)

  • B. Database Authentication

  • C. Business Logic Object Security

  • D. External Table Authentication

  • E. LDAP Authentication

Explanation

Question 19 of 20

1

QUESTION NO: 119
Which two steps are needed to set up Failover support for an OBIEE deployment?

Select one or more of the following:

  • A. Use Installer to affect Horizontal scale out of an existing instance

  • B. Employ WebLogic Enterprise Edition, licensed separately

  • C. Use Installer to set up separate single instances, then apply Horizontal scale out clustering

  • D. Apply OBIEE Clustering option

  • E. Leverage spare hardware capacity of single machine by using Vertical scale out option

Explanation

Question 20 of 20

1

QUESTION NO: 120
When creating an initialization Block, which BI Administration function is used?

Select one of the following:

  • A. Variable Manager

  • B. Job Manager

  • C. Identity Manager

  • D. Projects Manager

Explanation

Previous
Check answer
Next