DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ1

VerifiedOfficial exam objectives/topics

A Data Engineer is optimizing end-user query performance for automobile-shipment data in a portal web application that produces dashboards for different clients.

An internal team queries the data with order_date as a WHERE condition, and ingestion and natural clustering occur on that column. However, the application retrieves data by using client_id, warehouse, product_id, and destination_city. The Engineer must create materialized views with different cluster keys and needs to choose two columns, together with client_id, to optimize the first cluster key.

Which statements provide all the information required to select the MOST effective combination of columns for clustering?

Choose two
Explanation

Snowflake's SYSTEM$CLUSTERING_DEPTH can calculate average clustering depth for any specified parenthesized set of table columns, and a lower depth indicates better clustering for that set. Evaluating (client_id, warehouse, product_id) and (client_id, destination_city, product_id) provides the needed comparison of valid candidate keys that each include client_id plus two application access columns. SYSTEM$CLUSTERING_INFORMATION('shipments', 3) returns clustering errors, not clustering information for a proposed column combination.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!