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

• A.Presentation DataLayer
• B.Staging Data Layer
• C.Master Data Layer
• D.Access and Performance Layer

Comment: *

Name: *

Email: *

Verification: *

Which of the following characteristics pertain to a "ragged" hierarchy?

• A.It can only be stored in an XML structure.
• B.A branch of the hierarchy may have a different number of levels than other branches.
• C.All values can have a maximum of six levels.
• D.It creates multiple levels of hierarchy in the database table.

Comment: *

Name: *

Email: *

Verification: *

When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?

• A.It defines the granularity of the dimension.
• B.It determines the actual value of the dimension.
• C.It creates a new session variable.
• D.It creates a foreign key relationship.

Correct Answer: A

Explanation
OBIEE - Grain (Level of summarization)
Grain definition in the context of OBIEE.
The following list describes the different grains in navigating a query:
* Aggregation grain. The grain of the aggregate source of from a level based metrics
* Query grain. The grain of the request.
* Time Series grain. The grain at which the time series function aggregation is requested.
* Storage grain. The query in the example can be computed from daily sales or from monthly sales, or from quarterly sales.
Note:
The aggregation grain is defined in the content tab of the logical table source.
When the query grain match the aggregation grain of a logical table source, this one is used to create the physical query.
http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/fact_table/obiee_fragmentation_content_one_colu

Comment: *

Name: *

Email: *

Verification: *

Select the scenario in which block storage must be used instead of aggregate storage.

• A.Incremental data loading
• B.Top - down planning
• C.Extremely sparse data sets
• D.Millions of members in the outline

Comment: *

Name: *

Email: *

Verification: *

When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?

• A.The analyst mustfirstwrite DML (Data Manipulation Language) scriptstocreate the aggregate table.
• B.TheAggregate Persistence Wizard enables youto automate the creation of physical aggregate tables and theircorresponding objects in the repository.
• C.Job Managercanbe used to run the Aggregate Persistence script.
• D.TheExtractionTransformation and Loading process creates the aggregate tables.

Comment: *

Name: *

Email: *

Verification: *