Question 1
Question
QUESTION NO: 101
Which two Oracle BI Components contain security information regarding permissions and
privileges?
Question 2
Question
QUESTION NO: 102
A customer needs to create a product share calculation. What are the two ways that they would
get the revenue for all products to use in the denominator?
Answer
-
A. Create a derived measure by using the addition function that adds each product value together.
-
B. Create a derived measure based on Revenue that has the Level Total Product selected on the
Level Tab of the Logical Column Dialog.
-
C. Create a derived measure based on Revenue that has all the levels selected on the Level Tab of
the Logical Column Dialog except Total Product.
-
D. Create a derived metric by using the Expression Builder.
Question 3
Question
QUESTION NO: 103
Which analysis features could be applied to provide interactive controls for end users?
Question 4
Question
QUESTION NO: 104
An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars.
How would you accomplish this?
Answer
-
A. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal
Calendar and -> Julian Calendar
-
B. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal
Calendar and Julian Calendar
-
C. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal
Calendar and + Julian Calendar
-
D. By creating a Presentation Folder called Time<parent> and then two subsequent folders called
Fiscal Calendar<child> and Julian Calendar<child>
Question 5
Question
QUESTION NO: 105
OBIEE default security model stores security Information such as user names and password
combinations for accessing an external system such as Active Directory. It is stored in
the____________.
Answer
-
A. Policy Store
-
B. Credential Store
-
C. Identity Store
-
D. Person Store
Question 6
Question
QUESTION NO: 106
If a customer is planning on building a data warehouse, how would you describe data warehousing
to the customer?
Answer
-
A. The data in the data warehouse describes events and statuses of business processes, products
and services, goals and organizational units, and generally mirrors every aspect of the structure
and behavior of the organization.
-
B. Data warehouses can only be based on multidimensional data modeling.
-
C. Application based data warehouses can be bought off the shelf and used without any tweaking.
-
D. Data warehouse projects are usually implemented within two weeks.
Question 7
Question
QUESTION NO: 107
Initialization Blocks are never used to initialize which option?
Answer
-
A. Dynamic Repository Variables
-
B. System Session Variables
-
C. Non System Session Variables
-
D. rpd file
Question 8
Question
QUESTION NO: 108
What must be purchased when integrating Oracle map with Oracle BI?
Question 9
Question
QUESTION NO: 109
The customer is questioning the necessity to have a data warehouse in place. They want to run
OBIEE against various transactional systems. Identify the two limitations.
Answer
-
A. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.
-
B. The BI server cannot integrate various sources in one metadata model.
-
C. Data quality issues might emerge, due to missing data cleansing.
-
D. Business issues are depending on real-time data.
Question 10
Question
QUESTION NO: 110
Permissions for Presentation layer objects and Business layer objects that restrict users is
configured in which software component?
Answer
-
A. Oracle Enterprise Manager
-
B. Oracle HTTP Server
-
C. WebLogic Server Administration Component
-
D. BI Administration Tool
Question 11
Question
QUESTION NO: 111
You run the Consistency Check and receive the warning:
[39003] Missing functional dependency association for column:
DIM_Offer_End_Date.CREATE_DT.
What would you check?
Answer
-
A. Whether the logical table source for this column has been disabled
-
B. Whether the columns creating CREATE_DT have been deleted
-
C. Whether there is a logical join between the DIM and FACT tables
-
D. Whether there is a physical join between the DIM and FACT tables
-
E. Whether there is a physical column mapped to the logical column
-
F. DIM_Offer_End_Date.CREATE_DT
Question 12
Question
QUESTION NO: 112
How do System Session Variables obtain their values?
Answer
-
A. They are entered by user input on a dashboard
-
B. They are obtained from data fields in the Physical Layer
-
C. They are obtained from the Presentation Layer
-
D. They are obtained from the Initialization Block
Question 13
Question
QUESTION NO: 113
Selecting the Manage Map Data link allows one to do which three of the following?
Answer
-
A. Associate map layers to columns defined in the OBIEE metadata
-
B. Create a new map layer
-
C. Set the zoom level of an imported map
-
D. Import images for use on maps
Question 14
Question
QUESTION NO: 114
Which option is not an example of a level-based measure?
Answer
-
A. Regional Revenue
-
B. Sales
-
C. Brand Cost
-
D. Employee Salary
Question 15
Question
QUESTION NO: 115
Use of the Enterprise Install option is recommended for which three options?
Answer
-
A. Multiple instances on a single computer
-
B. Scale out for High Availability and Failover
-
C. Support for high security requirements
-
D. Evaluation of end user functionality
-
E. Single users working on a single computer
Question 16
Question
QUESTION NO: 116
What are the two ways to use the administration tool?
Answer
-
A. It can be used to manage user password.
-
B. The administration tool uses a set of wizards that support the design of calculations, expressions,
dimensions, and so on.
-
C. It can be used for versioning of the rpd.
-
D. Administrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.
Question 17
Question
QUESTION NO: 117
An integrated BI tools business case can be built around which three options?
Question 18
Question
QUESTION NO: 118
Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be
implemented by using which method?
Answer
-
A. Single Sign-On (SSO)
-
B. Database Authentication
-
C. Business Logic Object Security
-
D. External Table Authentication
-
E. LDAP Authentication
Question 19
Question
QUESTION NO: 119
Which two steps are needed to set up Failover support for an OBIEE deployment?
Answer
-
A. Use Installer to affect Horizontal scale out of an existing instance
-
B. Employ WebLogic Enterprise Edition, licensed separately
-
C. Use Installer to set up separate single instances, then apply Horizontal scale out clustering
-
D. Apply OBIEE Clustering option
-
E. Leverage spare hardware capacity of single machine by using Vertical scale out option
Question 20
Question
QUESTION NO: 120
When creating an initialization Block, which BI Administration function is used?
Answer
-
A. Variable Manager
-
B. Job Manager
-
C. Identity Manager
-
D. Projects Manager