Sample Questions:

What are two basic differences between the calculation commands CALC DIM and A (Choose two.)AGG executes member formulas

CALC DIM executes member formulas.

AGG is faster than CALC DIM in a Sparse dimension.

CALC DIM is faster than AGG in a Sparse dimension

What are three disadvantages of a transparent partition? (Choose three.)

old level 0 data

redundant storage

increased network load

higher degree of outline synchronization

slower query and calculation performance

What are two ways to improve data load speed in block storage? (Choose two.)

load the file from the client

load the file from the server

sort data files in order by Dense dimensions

sort data files in order by Sparse dimensions

Which two statements are true about aggregate storage databases? (Choose two.)

Upper level members are all dynamically calculated.

Hyperion Planning can create aggregate storage databases.

Only one database can be created in an aggregate storage application.

The conversion wizard converts calculation scripts to aggregation scripts.

Which three actions cause the database to defragment and be fully restructured? (Choose three.)

adding a Dense member to the outline

changing a member formula in the outline

changing a Sparse dimension to a Dense dimension

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