
Explanation:
The question requires selecting three true statements about Snowflake data loading. Option A is correct because VARIANT 'null' values in semi-structured data (like JSON) are distinct from SQL NULL values - JSON null is a valid value while SQL NULL represents absence of data. Option C is correct as data validation before loading ensures data quality and prevents errors in the target table. Option D is correct because staging tables help manage MERGE operations efficiently by preparing and validating data first. Option B is incorrect because Snowflake is optimized for bulk operations, not frequent single-row DMLs, which go against its columnar architecture and can cause inefficiencies and higher costs. The community discussion shows strong consensus (94%) for ACD, with multiple comments providing detailed reasoning about VARIANT null semantics, the inefficiency of single-row DMLs, and the benefits of validation and staging tables.
Ultimate access to all questions.
Which of the following statements are true regarding data loading in Snowflake? (Select three.)
A
VARIANT ג€nullג€ values are not the same as SQL NULL values
B
It is recommended to do frequent, single row DMLs
C
It is recommended to validate the data before loading into the Snowflake target table
D
It is recommended to use staging tables to manage MERGE statements
No comments yet.