Câu 14: DEA-C02: SnowPro Advanced Data Engineer DEA-C02

A Data Engineer is working to optimize the performance of end-users' queries about automobile shipment data for a portal web application that generates dashboards for different clients. An internal team queries the information using order_date as a WHERE condition; the ingestion and natural clustering are performed in this column. However, the application recovers data using the client_id, warehouse, product_id, and destination_city. The Engineer needs to create materialized views with different cluster keys, and must choose two columns combined with client_id to optimize the first cluster key. Which statements will provide all the information needed to select the MOST effective combination of columns to cluster? (Choose two.)

1. A. SELECT SYSTEM$CLUSTERING_DEPTH('shipments');
2. B. SELECT SYSTEM$CLUSTERING_DEPTH('shipments', '(client_id, warehouse, product_id)'); — đáp án hiện tại
3. C. SELECT SYSTEM$CLUSTERING_DEPTH('shipments', ' (client_id, destination_city, product_id)') — đáp án hiện tại
4. D. SELECT SYSTEM$CLUSTERING_DEPTH('shipments', '(warehouse, product_id, destination_city)')
5. E. SELECT SYSTEM$CLUSTERING_INFORMATION('shipments', 3);