Janeire Salicio
Quiz by , created more than 1 year ago

First Certificate of Cambridge Tecnología Quiz on 75-100_1z0-591-OBIEE IV, created by Janeire Salicio on 25/07/2017.

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

75-100_1z0-591-OBIEE IV

Question 1 of 25

1

QUESTION NO: 76
What are the two types of Repository Variables?

Select one or more of the following:

  • A. System

  • B. Non System

  • C. Static

  • D. Dynamic

Explanation

Question 2 of 25

1

QUESTION NO: 77
Under what circumstances would you model within the BI environment to include transactional
data directly?

Select one of the following:

  • A. When the customer needs near real-time data to support decision making in a fast changing
    environment

  • B. When the customer is not prepared to spend budget on data-warehousing

  • C. When the complexity of operational schema does not allow modeling in the BI repository

  • D. When it is not possible to query against a transactional system

Explanation

Question 3 of 25

1

QUESTION NO: 78
What are the two capabilities that users can apply to an Analysis when working within Plug-In for
MS Office?

Select one or more of the following:

  • A. Edit Analysis

  • B. Refresh All

  • C. Edit Prompts and Levels

  • D. Publish

Explanation

Question 4 of 25

1

QUESTION NO: 79
Which three components are part of a cluster server?

Select one or more of the following:

  • A. Master Server

  • B. Repository Publishing Directory

  • C. Primary Cluster Controller

  • D. Web Server

  • E. Server request Controller

Explanation

Question 5 of 25

1

QUESTION NO: 80
If Security attributes conflict, what happens?

Select one of the following:

  • A. The user or application role is granted the minimum security attribute

  • B. The user or application role is granted the maximum security attribute

  • C. The user or application role is granted No security attribute

  • D. The user or application role is granted the Fully Restrictive security attribute

Explanation

Question 6 of 25

1

QUESTION NO: 81
How do Dynamic Repository Variables differ from Static Repository Variables?

Select one of the following:

  • A. Dynamic Repository Variables are not initialized by the Initialization Block.

  • B. Dynamic Repository Variables cannot be used in the Expression Builder.

  • C. Dynamic Repository Variables can be changed by data that is returned from queries.

  • D. Dynamic Repository Variables cannot be used in a CASE statement

Explanation

Question 7 of 25

1

QUESTION NO: 82
The three metadata layers are an important concept of the BI Server. Which statement is
incorrect?

Select one of the following:

  • A. The physical layer defines the objects and relationships that the Oracle BI Server needs to write
    native queries against each physical data source.

  • B. Separating the logical of the application from the physical model provides the ability to federate
    multiple physical sources to the same logical object.

  • C. The model and mapping layer define the business or logical model of the data. This layer
    determines the analytic behavior seen by users.

  • D. The presentation layer defines the relationship that is needed to create the DML.

Explanation

Question 8 of 25

1

QUESTION NO: 83
Which two options are included in Oracle BI Server cache management techniques?

Select one or more of the following:

  • A. Using NQSConfig.ini to manually edit the parameters

  • B. Scheduling Server password

  • C. Maximum Number of Rows to Download to Excel

  • D. Inspecting the cache reports

  • E. Manage access to Subject Areas

Explanation

Question 9 of 25

1

QUESTION NO: 84
To add multiple sources to on existing logical table dimension in the Business Model and Mapping
layer, the source of the data must first exist in which option?

Select one of the following:

  • A. Presentation Layer

  • B. Business Aggregate Layer

  • C. Physical Layer

  • D. Web Catalog

Explanation

Question 10 of 25

1

QUESTION NO: 85
A customer wants to analyze the efficiency of his/her order fulfillment process. If the customer has
a dimensional model, which option is the fact table?

Select one of the following:

  • A. Stores

  • B. Orders

  • C. Products

  • D. Time

Explanation

Question 11 of 25

1

QUESTION NO: 86
What is the first step when creating an Aggregate table in the OBI repository?

Select one of the following:

  • A. Test the Aggregate table by using Analysis

  • B. Specify the Fact table that you want to aggregate

  • C. Use Job Manager to run the Aggregate script

  • D. Create a dedicated Connection Pool

Explanation

Question 12 of 25

1

QUESTION NO: 87
Where is Oracle Mapviewer installed?

Select one of the following:

  • A. In the same domain as OBIEE on the web application server

  • B. Never on the same domain as OBIEE on the web application server

  • C. On the Database server

  • D. On its own application server

Explanation

Question 13 of 25

1

QUESTION NO: 88
When adding a new dimension to an existing logical table, what is the significance of the Logical
Level setting in the Logical Table Source properties?

Select one of the following:

  • A. It defines the granularity of the dimension.

  • B. It determines the actual value of the dimension.

  • C. It creates a new session variable.

  • D. It creates a foreign key relationship.

Explanation

Question 14 of 25

1

QUESTION NO: 89
Which component is responsible for determining the device that receives the alerts for a given
user account?

Select one of the following:

  • A. Dashboard

  • B. iBot

  • C. Alerts

  • D. Delivery Profiles

Explanation

Question 15 of 25

1

QUESTION NO: 90
What are the two disadvantages of implementing Query Caching?

Select one or more of the following:

  • A. Reduction in BI server processing time

  • B. Cache results being old

  • C. Storage space for cache

  • D. Increased network traffic

  • E. Needs a lot of administrators' time

Explanation

Question 16 of 25

1

QUESTION NO: 91
Identify the correct mode to use when opening the web catalog while performing security settings
modifications and migrations.

Select one of the following:

  • A. Online

  • B. Offline

  • C. Managed

  • D. UnManaged

Explanation

Question 17 of 25

1

QUESTION NO: 92
Derived metrics are_____.

Select one of the following:

  • A. Derived from other logical columns

  • B. Derived from other physical columns

  • C. Used to apply pre-aggregation calculations to measures

  • D. Used to rename measures to user-friendly names

Explanation

Question 18 of 25

1

QUESTION NO: 93
Which variable does not use initialization blocks to initialize its values?

Select one of the following:

  • A. Static Repository Variable

  • B. Dynamic Repository Variable

  • C. System Variable

  • D. Non System Variable

Explanation

Question 19 of 25

1

QUESTION NO: 94
An organization has its employees' names in an Employees table, and information about their jobs
in a Jobs table.
However, an organization's employees can have multiple jobs, and the same job can be
performed by multiple employees. This situation would result in a many to-many relationship
between the Employees and Jobs tables. How can the many to-many relationship issue be
resolved?

Select one of the following:

  • A. By modeling the many to many relationship in the business model

  • B. By creating a bridge table that represents one employee doing one job, with several rows for an
    employee who has several jobs

  • C. By creating the many to many join in the physical model

  • D. By creating a logical table source (LTS) that joins the Employees and Jobs tables

Explanation

Question 20 of 25

1

QUESTION NO: 95
Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis,
the majority of users at the company log in to Oracle BI every Monday to generate the previous
week's sales report. The BI Administrator schedules cache purge and cache seeding to improve
report response times. How is this accomplished?

Select one of the following:

  • A. Every day before Data Warehouse refresh

  • B. Every day after Data Warehouse refresh

  • C. Every Monday early morning

  • D. Every Monday late night

Explanation

Question 21 of 25

1

QUESTION NO: 96
Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion
Middleware control. Which component stores the configuration Information?

Select one of the following:

  • A. NQSConfig.ini

  • B. Cache table in OBIEE repository

  • C. Web Catalogue

  • D. Instanceconfig.xml

Explanation

Question 22 of 25

1

QUESTION NO: 97
What must be done before you can run the Oracle Business Intelligence 11g Installer?

Select one of the following:

  • A. Obtain BI installation media

  • B. Create required Oracle Business Intelligence schemas in a database

  • C. Ensure system meets installation requirements for Fusing Middleware, Oracle Business
    Intelligence, AND Repository Creation Utility

  • D. Install the WLS Admin Server

  • E. Select installation components – OBIEE, BIP, RTD

Explanation

Question 23 of 25

1

QUESTION NO: 98
Which option does not describe Aggregate tables?

Select one of the following:

  • A. Aggregate tables increase query performance by pre-calculating frequently accessed measure
    aggregations.

  • B. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query
    response.

  • C. Aggregate tables typically have fewer rows than the non aggregate tables and, therefore,
    processing should be quicker.

  • D. Aggregate tables are created and stored on the BI Server.

Explanation

Question 24 of 25

1

QUESTION NO: 99
Security Manager is used for______.

Select one of the following:

  • A. Setting permissions for particular users or application roles

  • B. Setting permissions for individual objects in the Presentation Layer

  • C. Setting up new Roles and Groups

  • D. Setting up new Application Roles

Explanation

Question 25 of 25

1

QUESTION NO: 100
Which configuration can be changed through Enterprise Manager?

Select one of the following:

  • A. Minimum Number of Rows to Download to Excel

  • B. The default BI Server Repository

  • C. Start and Stop BI Services

  • D. Manages user login

Explanation

Previous
Check answer
Next