Exam DAA-C01 Topic 1 Question 123 Discussion

Option B is the best strategy. Creating a materialized view that pre-aggregates the data by and 'transaction_date' addresses both aspects:Partition pruning is naturally leveraged because the materialized view will store aggregated data, allowing queries filtering on 'transaction_date' to use partition pruning during refresh and query. Clustering helps because the data within each partition (date) is clustered by 'customer_id' , making aggregations by customer efficient. Option A might not provide sufficient performance improvement if the aggregation by customer is still slow. Option C will improve query performance marginally but is not a good option with partition pruning, because the data is already partition on date. Option D reclustering too frequently can be costly and may not always result in significant performance gains. Option E can be a costly operation and also data migration may be hectic. Thus the best is to have materialized view.