Online Access Free 1Z0-531 Practice Test

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.Concurrent loads are supported for both ASO and BSO
• C.After an ASO data load, no further calculation is required.
• D.Cells at all levels can be loaded (except Dynamic Calc members) for both ASO and BSO.

Which three statements are true about multiple hierarchies in ASO?

• A.All alternate hierarchies must be dynamic.
• B.First hierarchy must be dynamic.
• C.Alternate hierarchies may be either dynamic or stored.
• D.Multiple hierarchies must be enabled by dimension.
• E.First hierarchy must be stored.

Which six files are involved in database recovery for block storage option after a database crash?

• A.Temp.dat
• B.DBname.otl
• C.Dbname.ind - free fragment file for data and index free fragments
• D.Essn.ind - index
• E.Essn.pag - data
• F.Dbname.tct - transaction control table
• G.Essn.dat
• H.Metadata folder
• I.Dbname.esm - kernel file that contains control information for db recovery

Which statement related to Essbase design is true?

• A.Calc scripts are more efficient at performing calculations vs. member unary operators and member formulas
• B.Attribute dimensions require less performance consideration in ASO databases because they are treated as alternate rollups
• C.Bigger block sizes are better than smaller block sizes
• D.Attribute dimensions require less performance consideration in BSO databases because they are dynamically calculated
• E.One big application is better than three smaller focused applications.

With an average block density greater than 90%.

• A.You should reconsider the dense and sparse settings
• B.You should consider no compression
• C.You should set Commit blocks to
• D.You should reconsider the outline order of dimensions