Free Oracle 1Z0-531 Exam Dumps Questions & Answers

Identify the two true statements about materialization in ASO.

• A.  The database is not available during materialization
• B.  Materialization can be tuned via query hints and hard restrictions defined at the database level
• C.  When performing an incremental data load, aggregate views are updated
• D.  Materialization scripts can be saved for future reuse

Identify the two true statements about data loads to ASO and BSO databases.

• A.  Data can only be loaded to level 0 members in ASO database where BSO allows data loads to upper level members.
• B.  After an ASO data load, no further calculation is required.
• C.  Cells at all levels can be loaded (except Dynamic Calc members) for both ASO and BSO.
• D.  Concurrent loads are supported for both ASO and BSO

You should back up the following three for ASO.

• A.  Hyperion_Home \common
• B.  Essbase.sec
• C.  Essbaseinstallfolder \locale
• D.  Essbaseinstallfolder\bin
• E.  ARBORPATH \app\appname
• F.  Essbase.cfg

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.  Text data type of a measure
• B.  Trigger
• C.  Format string
• D.  Text List
• E.  Not possible in an ASO database

Moving a stored entity member in a sparse dimension causes_________.

• A.  an Outline restructure
• B.  No restructure
• C.  a Full restructure
• D.  an Index restructure