Oracle Essbase 11 Essentials (1Z0-531) Free Practice Test

Question 1

Changing a dense dimension member from stored to dynamic causes________.

A. a Full restructure

B. an Index restructure

C. No restructure

D. an Outline restructure

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Identify the three true statements about the Administration Services console.

A. You can create custom views in EAS; Custom views help administrators focus on those apps, databases or servers that apply to them

B. Applications and databases can be added to a custom view

C. Calculation scripts can be added to a custom view

D. Users and Groups can be added to a custom view

E. Administration Servers can be added to a custom view

Correct Answer: A,B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Which setting will give information about when a data block is calculated?

A. SET MSG WARNING;

B. SET MSG INFO;

C. SET MSG DETAIL;

D. SET MSG SUMMARY;

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Your current block storage option design includes two dimensions: Markets and Regions.
The Market dimension looks like:

Users need to be able to report by both regions and markets. Subtotals for Northeast and Southwest will display on some reports.

A. Create a UDA with members Northeast and Southwest (associated to states in the Market dimension)

B. Create an attribute dimension with members Northeast and Southwest (associated to states in the Market dimension)

C. Add another level to the market dimension for Northeast with North and East as children and Southwest with West and South as children

D. Create a Text list with the values containing the members Northeast and Southwest.

E. Add an alternate hierarchy to the market dimension with the states as shared members, rolling up to Northeast and Southwest

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Identify the two true statements about block density for a Block Storage (BSO) database.

A. Block density is the percentage of blocks that exist compared to the total number of blocks.

B. You can view the block density on the Application Properties tab in the Administration Services console.

C. Ideally block density will be high.

D. Block density is the percentage of data that exists within a block compared to what can be stored in the total block.

Correct Answer: B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

You need to display a text value based on variance data in an ASO database. If the variance percentage is less than 10, users should see "Low Priority," if the variance percentage is between 11 and 25, users should see "Medium Priority," and if the variance percentage is greater than 25, users should see High Priority." The Essbase feature that supports this capability is:

A. Trigger

B. Not possible in an ASO database

C. Format string

D. Text List

E. Text data type of a measure

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

Given the following, what is the declared block size?

A. 1920 bytes

B. 12450 bytes

C. 3840 bytes

D. 480 bytes

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Essbase 11 Essentials (1Z0-531) Free Practice Test