Free Preparation Discussions
MENU
Snowflake Exam ARA-C01 Topic 2 Question 43 Discussion
Topic #: 2
The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization
What Snowflake data modeling approaches will meet these requirements? (Choose two.)
Effective pruning in Snowflake relies on the organization of data within micro-partitions. By using an ORDER BY clause with clustering keys when loading data into the reporting tables, Snowflake can better organize the data within micro-partitions. This organization allows Snowflake to skip over irrelevant micro-partitions during a query, thus improving query performance and reducing the amount of data scanned12.
Reference =
* Snowflake Documentation on micro-partitions and data clustering2
* Community article on recognizing unsatisfactory pruning and improving it1
Socorro
3 months agoFlorinda
3 months agoCherelle
3 months agoLawanda
2 months agoAn
2 months agoBlair
2 months agoNada
2 months agoGaston
3 months agoWillodean
3 months agoRosann
3 months agoBrigette
2 months agoJulian
2 months agoSusy
3 months agoLouis
4 months agoFatima
4 months agoCasie
4 months agoGearldine
4 months ago