Quiz
75-100_1z0-591-OBIEE IV
Questions in this quiz (25)
1QUESTION NO: 76
What are the two types of Repository Variables?- AA. System
- BB. Non System
- CC. Static
- DD. Dynamic
2QUESTION NO: 77
Under what circumstances would you model within the BI environment to include transactional
data directly?- AA. When the customer needs near real-time data to support decision making in a fast changing
environment - BB. When the customer is not prepared to spend budget on data-warehousing
- CC. When the complexity of operational schema does not allow modeling in the BI repository
- DD. When it is not possible to query against a transactional system
- AA. When the customer needs near real-time data to support decision making in a fast changing
3QUESTION NO: 78
What are the two capabilities that users can apply to an Analysis when working within Plug-In for
MS Office?- AA. Edit Analysis
- BB. Refresh All
- CC. Edit Prompts and Levels
- DD. Publish
4QUESTION NO: 79
Which three components are part of a cluster server?- AA. Master Server
- BB. Repository Publishing Directory
- CC. Primary Cluster Controller
- DD. Web Server
- EE. Server request Controller
5QUESTION NO: 80
If Security attributes conflict, what happens?- AA. The user or application role is granted the minimum security attribute
- BB. The user or application role is granted the maximum security attribute
- CC. The user or application role is granted No security attribute
- DD. The user or application role is granted the Fully Restrictive security attribute
6QUESTION NO: 81
How do Dynamic Repository Variables differ from Static Repository Variables?- AA. Dynamic Repository Variables are not initialized by the Initialization Block.
- BB. Dynamic Repository Variables cannot be used in the Expression Builder.
- CC. Dynamic Repository Variables can be changed by data that is returned from queries.
- DD. Dynamic Repository Variables cannot be used in a CASE statement
7QUESTION NO: 82
The three metadata layers are an important concept of the BI Server. Which statement is
incorrect?- AA. The physical layer defines the objects and relationships that the Oracle BI Server needs to write
native queries against each physical data source. - BB. Separating the logical of the application from the physical model provides the ability to federate
multiple physical sources to the same logical object. - CC. The model and mapping layer define the business or logical model of the data. This layer
determines the analytic behavior seen by users. - DD. The presentation layer defines the relationship that is needed to create the DML.
- AA. The physical layer defines the objects and relationships that the Oracle BI Server needs to write
8QUESTION NO: 83
Which two options are included in Oracle BI Server cache management techniques?- AA. Using NQSConfig.ini to manually edit the parameters
- BB. Scheduling Server password
- CC. Maximum Number of Rows to Download to Excel
- DD. Inspecting the cache reports
- EE. Manage access to Subject Areas
9QUESTION 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?- AA. Presentation Layer
- BB. Business Aggregate Layer
- CC. Physical Layer
- DD. Web Catalog
10QUESTION 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?- AA. Stores
- BB. Orders
- CC. Products
- DD. Time
11QUESTION NO: 86
What is the first step when creating an Aggregate table in the OBI repository?- AA. Test the Aggregate table by using Analysis
- BB. Specify the Fact table that you want to aggregate
- CC. Use Job Manager to run the Aggregate script
- DD. Create a dedicated Connection Pool
12QUESTION NO: 87
Where is Oracle Mapviewer installed?- AA. In the same domain as OBIEE on the web application server
- BB. Never on the same domain as OBIEE on the web application server
- CC. On the Database server
- DD. On its own application server
13QUESTION 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?- AA. It defines the granularity of the dimension.
- BB. It determines the actual value of the dimension.
- CC. It creates a new session variable.
- DD. It creates a foreign key relationship.
14QUESTION NO: 89
Which component is responsible for determining the device that receives the alerts for a given
user account?- AA. Dashboard
- BB. iBot
- CC. Alerts
- DD. Delivery Profiles
15QUESTION NO: 90
What are the two disadvantages of implementing Query Caching?- AA. Reduction in BI server processing time
- BB. Cache results being old
- CC. Storage space for cache
- DD. Increased network traffic
- EE. Needs a lot of administrators' time
16QUESTION NO: 91
Identify the correct mode to use when opening the web catalog while performing security settings
modifications and migrations.- AA. Online
- BB. Offline
- CC. Managed
- DD. UnManaged
17QUESTION NO: 92
Derived metrics are_____.- AA. Derived from other logical columns
- BB. Derived from other physical columns
- CC. Used to apply pre-aggregation calculations to measures
- DD. Used to rename measures to user-friendly names
18QUESTION NO: 93
Which variable does not use initialization blocks to initialize its values?- AA. Static Repository Variable
- BB. Dynamic Repository Variable
- CC. System Variable
- DD. Non System Variable
19QUESTION 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?- AA. By modeling the many to many relationship in the business model
- BB. By creating a bridge table that represents one employee doing one job, with several rows for an
employee who has several jobs - CC. By creating the many to many join in the physical model
- DD. By creating a logical table source (LTS) that joins the Employees and Jobs tables
20QUESTION 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?- AA. Every day before Data Warehouse refresh
- BB. Every day after Data Warehouse refresh
- CC. Every Monday early morning
- DD. Every Monday late night
21QUESTION NO: 96
Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion
Middleware control. Which component stores the configuration Information?- AA. NQSConfig.ini
- BB. Cache table in OBIEE repository
- CC. Web Catalogue
- DD. Instanceconfig.xml
22QUESTION NO: 97
What must be done before you can run the Oracle Business Intelligence 11g Installer?- AA. Obtain BI installation media
- BB. Create required Oracle Business Intelligence schemas in a database
- CC. Ensure system meets installation requirements for Fusing Middleware, Oracle Business
Intelligence, AND Repository Creation Utility - DD. Install the WLS Admin Server
- EE. Select installation components – OBIEE, BIP, RTD
23QUESTION NO: 98
Which option does not describe Aggregate tables?- AA. Aggregate tables increase query performance by pre-calculating frequently accessed measure
aggregations. - BB. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query
response. - CC. Aggregate tables typically have fewer rows than the non aggregate tables and, therefore,
processing should be quicker. - DD. Aggregate tables are created and stored on the BI Server.
- AA. Aggregate tables increase query performance by pre-calculating frequently accessed measure
24QUESTION NO: 99
Security Manager is used for______.- AA. Setting permissions for particular users or application roles
- BB. Setting permissions for individual objects in the Presentation Layer
- CC. Setting up new Roles and Groups
- DD. Setting up new Application Roles
25QUESTION NO: 100
Which configuration can be changed through Enterprise Manager?- AA. Minimum Number of Rows to Download to Excel
- BB. The default BI Server Repository
- CC. Start and Stop BI Services
- DD. Manages user login
Information
- Description
- First Certificate of Cambridge Tecnología Quiz on 75-100_1z0-591-OBIEE IV, created by Janeire Salicio on 25/07/2017.
- Author
- Janeire Salicio
- Language
- Español
- Views
- 51
- Tags
- Rating
- No ratings yet Rate this quiz