DEA-C02 · Question #103
DEA-C02 Question #103: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #103. The question stem and answer options stay visible for context.
Question
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.)
Options
- ASELECT SYSTEM$CLUSTERING_DEPTH('shipments');
- BSELECT SYSTEM$CLUSTERING_DEPTH('shipments', '(client_id, warehouse,
- CSELECT SYSTEM$CLUSTERING_DEPTH('shipments', '(client_id,
- DSELECT SYSTEM$CLUSTERING_DEPTH('shipments', '(warehouse, product_id,
- ESELECT SYSTEM$CLUSTERING_INFORMATION('shipments', 3);
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.