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

Comment: *

Name: *

Email: *

Verification: *

What is an example of a Session Variable?

• A.ETL Load Date
• B.User Organization
• C.OLAP DSN
• D.Top Customers by Revenue

Comment: *

Name: *

Email: *

Verification: *

A user's BI Home page provides one-click access to which three options?

• A.Create new content
• B.Oracle BI online documentation
• C.Catalog search functionality
• D.Dashboard layout editor
• E.Business model metadata

Correct Answer: A,B,C

See BI Home Page screenshot below:

Note:The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content. From the BI home page users can browse and view the entire BI content. The BI catalog folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users.
Following content will be available under the BI catalog structure: BI Publisher Reports (regardless of data source) OTBI reports & dashboards OBIA dashboards & scorecards Financial Reporting
Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard.
New reports created can be saved in BI catalog and added as embedded content within Fusion applications screens or links added to reporting pane. This enables users to extend the prebuilt embedded analytics within Fusion Applications.

Comment: *

Name: *

Email: *

Verification: *

A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?

• A.Logical Key
• B.Implicit Fact Column
• C.Alias
• D.Logical Column Name
• E.Custom Display Name

Comment: *

Name: *

Email: *

Verification: *

OBIEE 11g authentication of users is performed by which two components listed below?

• A.Repository file (rpd)
• B.Embedded WebLogicLDAP server
• C.External directories such as Active Directory using WebLogic andFusion Middleware's Oracle Platform Security Services framework
• D.BI Presentation Services

Comment: *

Name: *

Email: *

Verification: *