Q1. There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold? 

A. By creating a derived measure on the logical columnItem number and using the count Function 

B. By creating a derived measure on the logical column item number and usingthe count distinct function 

C. By creating a derived measure based on the physical column item number and changing theaggregation method to count 

D. By creatinga derived metric by using the Expression Builder 

View Answer

Q2. How do you get the BI plug-in for MS Office? 

A. By contacting the administrator 

B. By downloading it from the BI Server 

C. By downloading it from the Database Server 

D. By downloading it from Microsoft Server 

View Answer

Q3. A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this? 

A. By creating a derived measure by using the Logical Columns available 

B. By creating a derived measure in the Column Mapping dialog box byusing the physical tablecolumns. 

C. By creating a derived measure by using LogicColumnsavailable andchanging theaggregationtype 

D. By creating a derived metricby using the Expression Builder 

E. By creatinga derived metricby using the Calculation Wizard 

View Answer

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

View Answer

Q5. When creating an initialization Block, which BI Administration function is used? 

A. Variable Manager 

B. Job Manager 

C. Identity Manager 

D. Projects Manager 

View Answer

Q6. In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse? 

A. Access and Performance Layer 

B. Master Data Layer 

C. Staging Data Layer 

D. Presentation DataLayer 

View Answer

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

View Answer

Q8. 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. TheBIserver cannot integrate various sourcesin one metadata model. 

C. Dataquality issues might emerge, due to missing data cleansing. 

D. Business issues are depending on real-time data. 

View Answer

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

View Answer

Q10. 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 Verticalscale out option 

View Answer