QUESTION NO: 101 Which two Oracle BI Components contain security information regarding permissions and privileges?
A. The Web Catalog
B. The Repository
C. NQSConfig.ini File
D. NQServer.ini File
E. InstanceConfig.xml File
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?
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 NO: 103 Which analysis features could be applied to provide interactive controls for end users?
A. Column Selector
B. Action Links
C. Conditional Formatting
D. Narrative View
E. Greenbar Styling
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?
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 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____________.
A. Policy Store
B. Credential Store
C. Identity Store
D. Person Store
QUESTION NO: 106 If a customer is planning on building a data warehouse, how would you describe data warehousing to the customer?
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 NO: 107 Initialization Blocks are never used to initialize which option?
A. Dynamic Repository Variables
B. System Session Variables
C. Non System Session Variables
D. rpd file
QUESTION NO: 108 What must be purchased when integrating Oracle map with Oracle BI?
A. Oracle Mapviewer
B. Oracle Business Intelligence Enterprise Edition
C. Spatial Option with Database
D. OLAP option
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.
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 NO: 110 Permissions for Presentation layer objects and Business layer objects that restrict users is configured in which software component?
A. Oracle Enterprise Manager
B. Oracle HTTP Server
C. WebLogic Server Administration Component
D. BI Administration Tool
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?
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 NO: 112 How do System Session Variables obtain their values?
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 NO: 113 Selecting the Manage Map Data link allows one to do which three of the following?
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 NO: 114 Which option is not an example of a level-based measure?
A. Regional Revenue
B. Sales
C. Brand Cost
D. Employee Salary
QUESTION NO: 115 Use of the Enterprise Install option is recommended for which three options?
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 NO: 116 What are the two ways to use the administration tool?
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 NO: 117 An integrated BI tools business case can be built around which three options?
A. Scalability
B. Fault tolerance
C. Cost Savings
D. Development efficiency
QUESTION NO: 118 Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?
A. Single Sign-On (SSO)
B. Database Authentication
C. Business Logic Object Security
D. External Table Authentication
E. LDAP Authentication
QUESTION NO: 119 Which two steps are needed to set up Failover support for an OBIEE deployment?
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 NO: 120 When creating an initialization Block, which BI Administration function is used?
A. Variable Manager
B. Job Manager
C. Identity Manager
D. Projects Manager
