Online Access Free 1Z0-531 Practice Test

The data block density for a particular BSO database is between 10% and 90%, and data values within the block do not consecutively repeat. Which type of compression would be most appropriate to use?

• A.RLE
• B.No compression required
• C.Bitmap
• D.ZLIB

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

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

You notice that your reports are running slower than before and realized that nothing in terms of data volume or dimension members has changed. You also checked the log file and found that no one ran any calculation.
Which two would you look for to diagnose the cause of this slower response time?

• A.Check the commit-level setting
• B.Check the data cache setting
• C.Run a MaxL comment to see if the database is fragmented
• D.Check when was the last time the application was stopped

Block size is calculated by the following formula.

• A.Number of stored dense dimension members multiplied together times 8 bytes
• B.Number of total sparse dimension members multiplied together times 8 bytes
• C.Number of stored sparse dimension members multiplied together times 8 bytes
• D.Number of total dense dimension members multiplied together times 8 bytes

Identify the two true statements about incremental loading.

• A.Different materialized views may exist within a slice as compared to the main slice of the database.
• B.Allows for real time data access for end users.
• C.Materialization of slices is required to provide users the correct query results.
• D.Creates *subscribes* along the main slice in the database.