What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?

• A.Cascading Style Sheets
• B.DHML Message files
• C.XML Message Files
• D.BI Presentation services web template

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

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

Correct Answer: B

Explanation/Reference:
Steps for Creating Aggregate Tables in OBIEE
1. Create all Dimension Tables, Fact Tables & Hierarchies, which are required to be aggregated.
2. Go to ToolsàUtilities (from Administration tool menu bar), a dialog box will pop up with all available utilities.
3. Select Aggregate Persistence Wizard, and then click Execute Button.
4. Now Select appropriate path where you need to generate Aggregate Table SQL.
Note : Click Generate DDL file for first time generation of Aggregate Table Click Next, to move to next page (Select Business Model & Measure Page) In Select Business Model & Measure Page, Select Appropriate Business Model & then select associated Fact / Measure.

Etc.

Comment: *

Name: *

Email: *

Verification: *

An organization has its employees' names in an Employees table, and information about their jobs in a Jobs table.
However, an organization's employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to-many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?

• A.By modeling the many to many relationship in the business model
• B.By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs
• C.By creating the many to many join in the physical model
• D.By creating a logical table source (LTS) that joins the Employees and Jobs tables

Comment: *

Name: *

Email: *

Verification: *

The ODBC DSN is never used for _______.

• A.Initial import of the physical layer metadata on a Windows server
• B.Query execution and data access on a Windows server
• C.Initial import of the physical layer metadata, query execution, and data access on a Windows Server
• D.Changing passwords
• E.Comparing RPDs

Comment: *

Name: *

Email: *

Verification: *