Free Oracle 1Z0-531 Exam Dumps Questions & Answers

You are performing incremental loads to an ASO database during the day, providing near real time data to the SaleDtl ASO database. Before the incremental load, you need to clear a specific set of data in the fastest amount of time possible.
What is the best solution?

• A.  Partial clears are supported for ASO
• B.  Perform a physical clear, using MDX to specify the region to be cleared
• C.  Run a calc script containing the CLEARDATA command and a set of FIX statements that isolate the desired data set
• D.  Run a calc script containing the CLEARBLOCK command and a set of FIX statements that isolate the desired data set
• E.  Perform a logical clear, using MDX to specify the region to be cleared

Which two statements are true (assuming data is loaded to a BSO database and to the members noted below)?

• A.  If you delete a sparse stored member, the block density shrinks.
• B.  If you delete a dense stored member, the number of blocks shrinks
• C.  If you delete a sparse stored member, the index file shrinks.
• D.  If you delete a dense shared member, the block size shrinks.
• E.  If you delete a sparse shared member, the outline file shrinks.
• F.  If you delete a sparse shared member, the page file shrinks.

Within which two directories can you set the location and file size in ASO?

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

Identify the four true statements about attribute dimensions

• A.  Attributes allow cross tab reports with other dims
• B.  Attributes are stored
• C.  Even though ASO databases allow many dimensions, attribute dimensions are still available and used in aggregate storage option databases
• D.  Attributes are assigned to dense dimensions
• E.  Security can be assigned by attribute dimension
• F.  Attributes are dynamically calculated

You have a reporting requirement to track and report the employee status for employees in your workforce ASO Essbase database. Employee status can change over time. One report requires employees down the rows and employee status across the columns.
What is the best solution to meet the all of the requirements?

• A.  Attribute dimension
• B.  Smart List
• C.  Separate Employee status dimension
• D.  Alternate hierarchy
• E.  User defined attribute
• F.  Varying attribute dimension
• G.  Text List