Identify the reason why Oracle OLAP provides a favorable aggregation strategy.

• A.OLAP cubes eliminate the need for a large number of aggregate tables.
• B.OLAP cubes are stored outside of the database in highly optimized file structures.
• C.OLAP cubes can be easily transported from database to database.
• D.OLAP cubes can be queried by using SQL.

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

You run the Consistency Check and receive the warning:
[39003] Missing functional dependency association for column: DIM_Offer_End_Date.CREATE_DT.
What would you check?

• A.Whether the logical table source for this column has been disabled
• B.Whether the columns creating CREATE_DT have been deleted
• C.Whether there is a logical join between the DIM and FACT tables
• D.Whether there is a physical join between the DIM and FACT tables
• E.Whether there is a physical column mapped to the logical column
• F.DIM_Offer_End_Date.CREATE_DT

Comment: *

Name: *

Email: *

Verification: *

If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?

• A.By creating four new logical tables sources
• B.By creating four new logical table sources and choosing each dimension's level of aggregation in the Content tab
• C.By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels
• D.By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels

Correct Answer: B

Content Tab
Aggregation Content
You can define the aggregation (ie the group by) of:
by hierarchy level
by logical column
It helps you to define an aggregate navigation

Note: logical table source
Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this element.
The definition of the logical table source is used:
* to specify transformations/calculations (in the column mapping tab),
* to enable aggregate navigation and fragmentation (in the content tab) The Content tab of the Logical Table Source is used to define :
* any aggregate table content definitions (specify the grain of the physical tables),
* fragmented table definitions for the source,
* and WHERE clauses (if you want to limit the number of rows returned).

Comment: *

Name: *

Email: *

Verification: *