Free Oracle 1Z0-531 Exam Dumps Questions & Answers

Block size is calculated by the following formula.

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

Which four are the directories used for aggregate storage databases?

• A.Log
• B.Temp
• C.Default
• D.Data
• E.Metadata
• F.Bin

A calculation script is performed on a database for which Create Block on Equation is OFF.
The command SET CREATEBLOCKONEQ ON is issued immediately before an equation in the script.
Which statement accurately describe when blocks will be created?

• A.Blocks will be created when the equation assigns either constant or non-constant values to members of a sparse dimension.
• B.Blocks will be created ONLY when the equation assigns constant values to members of a sparse dimension
• C.Blocks will be created ONLY when the equation assigns non-constant values to members of a sparse dimension
• D.No blocks will be created.

Assuming Sales and Year are sparse and Actual is dense, what two actions will the following calc script perform?
FIX (Actual, @CY, Sales)
DATAEXPORT "BINFILE" "data.txt";
ENDFIX

• A.Export the data for actual, current year into a text file called data.txt
• B.Export the data for actual, current year, sales into a text file called data.txt
• C.Create a text file that can be imported using the DATAIMPORTBIN calc command in another database that has different dimensionality
• D.Export data blocks in a compressed encrypted format

Which two options would provide a better design for the following accounts and metrics?

• A.If block size is large, then keep Accounts and Metrics as one dimension with a dense dimension
• B.If there are a small number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions
• C.If reporting dictates FTE and dollars in the columns and accounts in the rows, split Accounts and Metrics into 2 dimensions
• D.If there are a large number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions