SnowPro Advanced: Architect — Question 171
An Architect is appraising the compute and storage costs of a storage strategy to augment performance techniques.
What performance optimization techniques in Snowflake have storage costs associated with them? (Choose three.)
Answer options
- A. Rekeying
- B. Materialized view
- C. Clustering a table
- D. Query acceleration service
- E. Search optimization service
- F. Multi-cluster virtual warehouse
Correct answer: B, C, E
Explanation
The correct answers, B, C, and E, are associated with storage costs due to their nature of creating additional data structures or optimizing data storage. Materialized views store precomputed results, clustering organizes data for faster retrieval, and search optimization maintains data in a way that can enhance query performance. In contrast, rekeying, query acceleration service, and multi-cluster virtual warehouse do not directly impact storage costs.