Janeire Salicio
Quiz por , criado more than 1 year ago

First Certificate of Cambridge Tecnología Quiz sobre 75-100_1z0-591-OBIEE IV, criado por Janeire Salicio em 25-07-2017.

48
1
0
Janeire Salicio
Criado por Janeire Salicio mais de 7 anos atrás
Fechar

75-100_1z0-591-OBIEE IV

75-100_1z0-591-OBIEE IV

Questão 1 de 25

1

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

Selecione uma ou mais das seguintes:

  • A. System

  • B. Non System

  • C. Static

  • D. Dynamic

Explicação

Questão 2 de 25

1

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

Selecione uma das seguintes:

  • 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

Explicação

Questão 3 de 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?

Selecione uma ou mais das seguintes:

  • A. Edit Analysis

  • B. Refresh All

  • C. Edit Prompts and Levels

  • D. Publish

Explicação

Questão 4 de 25

1

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

Selecione uma ou mais das seguintes:

  • A. Master Server

  • B. Repository Publishing Directory

  • C. Primary Cluster Controller

  • D. Web Server

  • E. Server request Controller

Explicação

Questão 5 de 25

1

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

Selecione uma das seguintes:

  • 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

Explicação

Questão 6 de 25

1

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

Selecione uma das seguintes:

  • 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

Explicação

Questão 7 de 25

1

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

Selecione uma das seguintes:

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

Explicação

Questão 8 de 25

1

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

Selecione uma ou mais das seguintes:

  • 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

Explicação

Questão 9 de 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?

Selecione uma das seguintes:

  • A. Presentation Layer

  • B. Business Aggregate Layer

  • C. Physical Layer

  • D. Web Catalog

Explicação

Questão 10 de 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?

Selecione uma das seguintes:

  • A. Stores

  • B. Orders

  • C. Products

  • D. Time

Explicação

Questão 11 de 25

1

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

Selecione uma das seguintes:

  • 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

Explicação

Questão 12 de 25

1

QUESTION NO: 87
Where is Oracle Mapviewer installed?

Selecione uma das seguintes:

  • 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

Explicação

Questão 13 de 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?

Selecione uma das seguintes:

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

Explicação

Questão 14 de 25

1

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

Selecione uma das seguintes:

  • A. Dashboard

  • B. iBot

  • C. Alerts

  • D. Delivery Profiles

Explicação

Questão 15 de 25

1

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

Selecione uma ou mais das seguintes:

  • 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

Explicação

Questão 16 de 25

1

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

Selecione uma das seguintes:

  • A. Online

  • B. Offline

  • C. Managed

  • D. UnManaged

Explicação

Questão 17 de 25

1

QUESTION NO: 92
Derived metrics are_____.

Selecione uma das seguintes:

  • 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

Explicação

Questão 18 de 25

1

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

Selecione uma das seguintes:

  • A. Static Repository Variable

  • B. Dynamic Repository Variable

  • C. System Variable

  • D. Non System Variable

Explicação

Questão 19 de 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?

Selecione uma das seguintes:

  • 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

Explicação

Questão 20 de 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?

Selecione uma das seguintes:

  • A. Every day before Data Warehouse refresh

  • B. Every day after Data Warehouse refresh

  • C. Every Monday early morning

  • D. Every Monday late night

Explicação

Questão 21 de 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?

Selecione uma das seguintes:

  • A. NQSConfig.ini

  • B. Cache table in OBIEE repository

  • C. Web Catalogue

  • D. Instanceconfig.xml

Explicação

Questão 22 de 25

1

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

Selecione uma das seguintes:

  • 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

Explicação

Questão 23 de 25

1

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

Selecione uma das seguintes:

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

Explicação

Questão 24 de 25

1

QUESTION NO: 99
Security Manager is used for______.

Selecione uma das seguintes:

  • 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

Explicação

Questão 25 de 25

1

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

Selecione uma das seguintes:

  • 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

Explicação

Anterior
Verificar resposta
Próximo