Snowflake
ADA-C01 · Question #36
ADA-C01 Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Question
An Administrator loads data into a staging table every day. Once loaded, users from several different 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 will not incur Time Travel costs.
- 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 ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 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.