QUESTION NO: 76 What are the two types of Repository Variables?
A. System
B. Non System
C. Static
D. Dynamic
QUESTION NO: 77 Under what circumstances would you model within the BI environment to include transactional data directly?
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 NO: 78 What are the two capabilities that users can apply to an Analysis when working within Plug-In for MS Office?
A. Edit Analysis
B. Refresh All
C. Edit Prompts and Levels
D. Publish
QUESTION NO: 79 Which three components are part of a cluster server?
A. Master Server
B. Repository Publishing Directory
C. Primary Cluster Controller
D. Web Server
E. Server request Controller
QUESTION NO: 80 If Security attributes conflict, what happens?
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 NO: 81 How do Dynamic Repository Variables differ from Static Repository Variables?
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 NO: 82 The three metadata layers are an important concept of the BI Server. Which statement is incorrect?
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 NO: 83 Which two options are included in Oracle BI Server cache management techniques?
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 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?
A. Presentation Layer
B. Business Aggregate Layer
C. Physical Layer
D. Web Catalog
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?
A. Stores
B. Orders
C. Products
D. Time
QUESTION NO: 86 What is the first step when creating an Aggregate table in the OBI repository?
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 NO: 87 Where is Oracle Mapviewer installed?
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 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?
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 NO: 89 Which component is responsible for determining the device that receives the alerts for a given user account?
A. Dashboard
B. iBot
C. Alerts
D. Delivery Profiles
QUESTION NO: 90 What are the two disadvantages of implementing Query Caching?
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 NO: 91 Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.
A. Online
B. Offline
C. Managed
D. UnManaged
QUESTION NO: 92 Derived metrics are_____.
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 NO: 93 Which variable does not use initialization blocks to initialize its values?
A. Static Repository Variable
B. Dynamic Repository Variable
C. System Variable
D. Non System Variable
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?
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 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?
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 NO: 96 Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?
A. NQSConfig.ini
B. Cache table in OBIEE repository
C. Web Catalogue
D. Instanceconfig.xml
QUESTION NO: 97 What must be done before you can run the Oracle Business Intelligence 11g Installer?
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 NO: 98 Which option does not describe Aggregate tables?
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 NO: 99 Security Manager is used for______.
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 NO: 100 Which configuration can be changed through Enterprise Manager?
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
