Oracle
1Z0-531 · Question #39
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…
The correct answer is A. Partial clears are supported for ASO B. Perform a logical clear, using MDX to specify the region to be cleared. Within ASO partial clear are supported. Logical clear is faster than physical clear.
Loading Data
Question
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?
Options
- APartial clears are supported for ASO
- BPerform a logical clear, using MDX to specify the region to be cleared
- CPerform a physical clear, using MDX to specify the region to be cleared
- DRun a calc script containing the CLEARDATA command and a set of FIX statements that isolate
- ERun a calc script containing the CLEARBLOCK command and a set of FIX statements that isolate
How the community answered
(38 responses)- A71% (27)
- C8% (3)
- D18% (7)
- E3% (1)
Explanation
Within ASO partial clear are supported. Logical clear is faster than physical clear.
Topics
#ASO data clear#partial clear#logical clear#incremental load
Community Discussion
No community discussion yet for this question.