If a customer is planning on building a data warehouse, how would you describe data warehousing to the customer?

• A.The data in the data warehouse describes events and statuses of business processes, products and services, goals and organizational units, and generally mirrors every aspect of the structure and behavior of the organization.
• B.Data warehouses can only be based on multidimensional data modeling.
• C.Application based data warehouses can be bought off the shelf and used without any tweaking.
• D.Data warehouse projects are usually implemented within two weeks.

Comment: *

Name: *

Email: *

Verification: *

When designing a Star Schema, which option does not apply?

• A.The facts are quantifiable.
• B.The fact has several foreign keys that are primary keys in the dimensional table
• C.Fact table is joined to the related dimensional tables.
• D.Dimensional tables are normalized.
• E.Dimensional tables have one attribute primary key as Product_ID for products.

Correct Answer: D

Explanation/Reference:
In a Star Schema the dimensional tables does not need to be normalized.
A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.
Incorrect answers:
B: A star schema is a dimensional schema with a single fact table that has foreign key relationships with several dimension tables.
C, E: A star join is a primary key to foreign key join :
* of the dimension tables
* to a fact_table.
See picture below:

Comment: *

Name: *

Email: *

Verification: *

Which are the three types of tables available to physical tables in the physical layer?

• A.Physical Table
• B.Stored Proc
• C.Select
• D.View
• E.Table

Correct Answer: A,B,C

Explanation/Reference:
Pull the table and column definition into the physical layer
Use the OBIEE "import metadata" wizard to pull the table and column definition into the physical layer. The wizard is used so that all of the column definitions do not need to be manually added into the physical layer.
Figure:

Note: The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information about the physical data sources.

Comment: *

Name: *

Email: *

Verification: *

When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?

• A.Logical Key
• B.Parent Level
• C.Child Level
• D.Dynamic Key

Comment: *

Name: *

Email: *

Verification: *

What are the two methodologies that are followed within an OBIEE implementation?

• A.Do not use prototypes
• B.Use an iterative approach
• C.Start with a small model and then enhance the repository
• D.Start with a big repository and trim it down with the requirements

Correct Answer: B,C

Explanation

Comment: *

Name: *

Email: *

Verification: *