Which two options are valid Repository Variable names?

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

Correct Answer: B,C

Explanation/Reference:
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: *

Which OBIEE capability enables developers to build Aggregate tables?

• A.Aggregate Persistence Wizard
• B.Expression Builder
• C.Table Builder
• D.Query Analyzer

Comment: *

Name: *

Email: *

Verification: *

What are the two types of Session Variables?

• A.System
• B.Non System
• C.Static
• D.Dynamic

Comment: *

Name: *

Email: *

Verification: *

The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.

• A.Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.
• B.The BI server cannot integrate various sources in one metadata model.
• C.Business issues are depending on real-time data.
• D.Data quality issues might emerge, due to missing data cleansing.

Comment: *

Name: *

Email: *

Verification: *

Identify the two types of storage for Essbase.

• A.Aggregate Storage Option and Block Storage Option
• B.Aggregate Storage and Cell Storage
• C.OLAP Storage and Cell Storage
• D.Aggregate Storage and Hybrid Columnar Compression

Comment: *

Name: *

Email: *

Verification: *