4H0-002 Hyperion Essbase 5 Certification Practice Exam

Sample Questions:

When would disabling data compression be recommended?

when the average block density is very low (<3%)

when the average block density is very high (>95%) and few consecutive repeating values exist

when the database contains many consecutive zero values or other consecutive repeating values.

None

During calculation, what is the calculator cache used for?

for storing blocks

for tracking index page usage

for storing dynamically calculated values for tracking calculation progress through the blocks

None

If Committed Access is being used, which statements are true?

It retains redundant data until a transaction commits

It acquires and releases Write locks as needed during the transaction.

It retains Write locks on all affected blocks until the transaction commits.

It does not restrict Read/Write access on data blocks during the transaction.

Within Database | Statistics, what does block density indicate?

the actual number of blocks existing within the database

the average percentage of data cells within each block that contain data

the maximum possible number of blocks that could exist for this database

the percentage of blocks that exist compared to the total potential number of blocks

What would defragment defrag a fragmented database?

adding a dense member to the outline

adding a sparse member to the outline

changing a member formula in the outline

redefining a Stored dense dimension member as Dynamic Calc and Store

What would cause fragmentation in a database?

deleting a dense member from the outline

deleting a sparse member from the outline

changing a member formula in the outline

redefining a Stored dense dimension member as Dynamic Calc (Non-Store)