Q1. When creating a Security Realm in the WebLogic Console, which object is created? 

A. Groups 

B. Row Level Filters 

C. Server Password 

D. Single Sign On 

View Answer

Q2. 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 

View Answer

Q3. When designing a Star Schema, which option does not apply? 

A. The facts are quantifiable. 

B. The fact has several foreign keys that are primary keys in the dimensional table 

C. Fact table is joined to the related dimensional tables. 

D. Dimensional tables are normalized. 

E. Dimensional tables have one attribute primary key as Product_ID for products. 

View Answer

Q4. Content that is saved in personal and shared folders can be browsed by using which view? 

A. Catalog 

B. Dashboard 

C. New -> Analysis 

D. Home 

E. Favorites 

View Answer

Q5. What are the two leading design solutions recommended by Oracle that you would use for performance? 

A. Design requests that use Complex Queries 

B. Avoid returning big data sets within the Dashboard 

C. Use Cache 

D. Avoid using GuidedNavigation unless the data set is large 

View Answer

Q6. 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 

View Answer

Q7. 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 

View Answer

Q8. 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. 

View Answer

Q9. Which are the three types of tables available to physical tables in the physical layer? 

A. Physical Table 

B. Stored Proc 

C. Select 

D. View 

E. Table 

View Answer

Q10. An integrated BI tools business case can be built around which three options? 

A. Scalability 

B. Fault tolerance 

C. Cost Savings 

D. Development efficiency 

View Answer