1Z0-531 · Question #40
Identify the two true statements about materialization in ASO.
The correct answer is A. When performing an incremental data load, aggregate views are updated D. Materialization scripts can be saved for future reuse. The following process is recommended for defining and materializing aggregations: After the outline is created or changed, load data values. Perform the default aggregation. Do not select specify a storage stopping point option. Materialize the suggested aggregate views and…
Question
Identify the two true statements about materialization in ASO.
Options
- AWhen performing an incremental data load, aggregate views are updated
- BThe database is not available during materialization
- CMaterialization can be tuned via query hints and hard restrictions defined at the database level
- DMaterialization scripts can be saved for future reuse
How the community answered
(36 responses)- A78% (28)
- B8% (3)
- C14% (5)
Explanation
The following process is recommended for defining and materializing aggregations: * After the outline is created or changed, load data values. * Perform the default aggregation. Do not select specify a storage stopping point option. * Materialize the suggested aggregate views and save the default selection in an aggregation * Run the types of queries the aggregation is being designed for. * If query time or aggregation time is too long, consider fine-tuning the aggregation as stated * Save the aggregation selection as an aggregation script (D)
Topics
Community Discussion
No community discussion yet for this question.