SnowflakeSnowflake
DEA-C02 · Question #92
DEA-C02 Question #92: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.
Performance Optimization
Question
Data is loaded into a staging table every day. From there, several departments perform transformations on the data and load it into different production tables. How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?
Options
- ACreate it as an external table, which is not covered by Time Travel.
- BCreate it as a transient table with a retention time of 0 days.
- CCreate it as a temporary table with a retention time of 0 days.
- DCreate it as a permanent table with a retention time of 0 days.
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.
Topics
#Transient Tables#Data Retention#Time Travel#Storage Costs