Which two options are valid Repository Variable names?

• A.USER
• B.CurrentDay
• C.CurrentMonth
• D.Date

Correct Answer: B,C

CurrentDay and CurrentMonth can be calculated by a sql statement.
Note:
REPOSITORY VARIABLE(DYNAMIC)
Initialized when BI server is started
Assigned value dynamically based on the result of a query
Value is dependent of the sql provided in Initialization Block
Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.

Provide Intialization Block variable Name

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: *

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: *

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: *

The Time Dimension hierarchy is a good example of a__________.

• A.Level-based Time Dimension hierarchy
• B.Ragged Hierarchy
• C.Skip Level Hierarchy
• D.Value-based Hierarchy

Comment: *

Name: *

Email: *

Verification: *