SnowflakeSnowflake
COF-C02 · Question #335
COF-C02 Question #335: Real Exam Question with Answer & Explanation
Sign in or unlock COF-C02 to reveal the answer and full explanation for question #335. The question stem and answer options stay visible for context.
Performance Management
Question
A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data. How can this be achieved?
Options
- AFlatten the data and store it in structured data types in a flattened table. Query the table.
- BStore the data in a table with a variant data type. Query the table.
- CStore the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while
- DStore the data in an external stage and create views on top of it. Query the views.
Unlock COF-C02 to see the answer
You've previewed enough free COF-C02 questions. Unlock COF-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
#JSON Processing#Semi-structured Data#Variant Data Type#Query Optimization