Copy and Edit

75-100_1z0-591-OBIEE IV

Description

First Certificate of Cambridge Tecnología Quiz on 75-100_1z0-591-OBIEE IV, created by Janeire Salicio on 25/07/2017.
Janeire Salicio
Quiz by Janeire Salicio, updated more than 1 year ago
Janeire Salicio
Created by Janeire Salicio over 7 years ago
48
1
0

Resource summary

Question 1

Question
QUESTION NO: 76 What are the two types of Repository Variables?
Answer
  • A. System
  • B. Non System
  • C. Static
  • D. Dynamic

Question 2

Question
QUESTION NO: 77 Under what circumstances would you model within the BI environment to include transactional data directly?
Answer
  • 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

Question 3

Question
QUESTION NO: 78 What are the two capabilities that users can apply to an Analysis when working within Plug-In for MS Office?
Answer
  • A. Edit Analysis
  • B. Refresh All
  • C. Edit Prompts and Levels
  • D. Publish

Question 4

Question
QUESTION NO: 79 Which three components are part of a cluster server?
Answer
  • A. Master Server
  • B. Repository Publishing Directory
  • C. Primary Cluster Controller
  • D. Web Server
  • E. Server request Controller

Question 5

Question
QUESTION NO: 80 If Security attributes conflict, what happens?
Answer
  • 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

Question 6

Question
QUESTION NO: 81 How do Dynamic Repository Variables differ from Static Repository Variables?
Answer
  • 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

Question 7

Question
QUESTION NO: 82 The three metadata layers are an important concept of the BI Server. Which statement is incorrect?
Answer
  • 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.

Question 8

Question
QUESTION NO: 83 Which two options are included in Oracle BI Server cache management techniques?
Answer
  • 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

Question 9

Question
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?
Answer
  • A. Presentation Layer
  • B. Business Aggregate Layer
  • C. Physical Layer
  • D. Web Catalog

Question 10

Question
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?
Answer
  • A. Stores
  • B. Orders
  • C. Products
  • D. Time

Question 11

Question
QUESTION NO: 86 What is the first step when creating an Aggregate table in the OBI repository?
Answer
  • 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

Question 12

Question
QUESTION NO: 87 Where is Oracle Mapviewer installed?
Answer
  • 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

Question 13

Question
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?
Answer
  • 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.

Question 14

Question
QUESTION NO: 89 Which component is responsible for determining the device that receives the alerts for a given user account?
Answer
  • A. Dashboard
  • B. iBot
  • C. Alerts
  • D. Delivery Profiles

Question 15

Question
QUESTION NO: 90 What are the two disadvantages of implementing Query Caching?
Answer
  • 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

Question 16

Question
QUESTION NO: 91 Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.
Answer
  • A. Online
  • B. Offline
  • C. Managed
  • D. UnManaged

Question 17

Question
QUESTION NO: 92 Derived metrics are_____.
Answer
  • 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

Question 18

Question
QUESTION NO: 93 Which variable does not use initialization blocks to initialize its values?
Answer
  • A. Static Repository Variable
  • B. Dynamic Repository Variable
  • C. System Variable
  • D. Non System Variable

Question 19

Question
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?
Answer
  • 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

Question 20

Question
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?
Answer
  • A. Every day before Data Warehouse refresh
  • B. Every day after Data Warehouse refresh
  • C. Every Monday early morning
  • D. Every Monday late night

Question 21

Question
QUESTION NO: 96 Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?
Answer
  • A. NQSConfig.ini
  • B. Cache table in OBIEE repository
  • C. Web Catalogue
  • D. Instanceconfig.xml

Question 22

Question
QUESTION NO: 97 What must be done before you can run the Oracle Business Intelligence 11g Installer?
Answer
  • 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

Question 23

Question
QUESTION NO: 98 Which option does not describe Aggregate tables?
Answer
  • 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.

Question 24

Question
QUESTION NO: 99 Security Manager is used for______.
Answer
  • 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

Question 25

Question
QUESTION NO: 100 Which configuration can be changed through Enterprise Manager?
Answer
  • 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
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Test Diagnóstico de Informática Básica
victorlobato2009
TECNOLOGÍA TAREA
Denisse Alcalá P
Materiales de construccion
Diana Woolfolk
INSTRUMENTOS DE MEDIDAS Y SIMBOLOGÍA ELECTRICA - VOLTAJE.
Teresa Villa
Leyes de Kirchhoff (Voltaje y corriente)
dianamardp
DISPOSITIVOS DE ALMACENAMIENTO
Esteban Bravo3B
tema 6 : ELECTRÓNICA
alejandrauscola
20 preguntas sobre sistemas operativos
esmeraldameza100
codigos QR
Cristina Padilla
Curso Basico De Android
manrongel
Historia de la Ingeniería
Camila González
Browse Library