Exam for engine

QUESTION 17
Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis,
the majority of users at the company log in to Oracle BI every Monday to generate the previous week’s sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished?

QUESTION 18
What are the two types of Repository Variables?

QUESTION 19
One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

QUESTION 20
Which OBIEE capability enables developers to build Aggregate tables?

QUESTION 21
What are the two types of Session Variables?

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

QUESTION 23
Which two options are valid Repository Variable names?

QUESTION 24
One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

QUESTION 25
Which two Oracle BI Components contain security information regarding permissions and privileges?

QUESTION 26
Which two options are included in Oracle BI Server cache management techniques?

QUESTION 27
Which installation option is used to install into an existing Fusion Middleware Home?

QUESTION 28
Cache in OBIEE is used to_____. Select the two correct answers.

QUESTION 29
What are the two leading design solutions recommended by Oracle that you would use for performance?

QUESTION 30
A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?

QUESTION 31
Which three options apply to FMW Application Roles?

QUESTION 32
What are the two disadvantages of implementing Query Caching?

QUESTION 33
Which three techniques are applied to support Failover?

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

QUESTION 35
Which task can be performed after the Administrator link has been reached through logging into OBIEE?

QUESTION 36
A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?

QUESTION 37
Which two Oracle BI Components contain security information regarding permissions and privileges?

QUESTION 38
The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.

QUESTION 39
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?

QUESTION 40
What is the process in which there is redundancy of data to improve performance?

QUESTION 41
DSNs are set up for access to which data sources?