An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010
and 2011 on a single report.
How can you model this in the RPD?
A. By creating two Logical Fact Tables for each database
B. By creating joins in the physical model so it looks like a single table
C. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
D. By creating two logical table sources and checking the "This Source should be combined with other sources at this level" box leaving the Fragmentation content area blank.
E. By creating one logical table sources and checking the "This Source should be combined with other sources at this level" box
Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?
A. Test Environment
B. System Testing
C. Performance Tuning
D. Project initiation and resourcing
E. Data Validation / Verification
A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?
A. By specifying a one-to-many join between the tables with the small and large numbers of values
B. By specifying a driving table
C. By specifying a many to one join between the tables with the small and large numbers of values
D. By creating your logical join by using the Joins Manager
E. By creating your joins by using the Business Model Diagram
DSNs are set up for access to which data sources?
A. ODBC Data Sources
B. Oracle Data Sources
C. IBM Data Sources
D. Teradata Data Sources
A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?
A. Using the Expression Builder
B. Using the Calculation Wizard
C. Defining them in the physical data model
D. Defining them in the Presentation Layer
The Consistency Checker checks______.
A. The validity of objects outside the metadata using the connection
B. Mappings to the physical objects
C. For objects deleted from the database
D. Syntax errors in derived logical columns
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
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
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
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
