Which of the following statements are true of Snowflake data loading? (Choose three.)
Which of the following statements are true of Snowflake data loading? (Choose three.)
VARIANT 'null' values in Snowflake are not the same as SQL NULL values; they are handled differently in storage and retrieval, which is important to understand when working with semi-structured data. It is recommended to validate the data before loading it into the Snowflake target table to ensure data integrity, consistency, and to avoid potential errors during the load process. Using staging tables to manage MERGE statements is also recommended because it allows for intermediate processing and the handling of data updates effectively, optimizing performance and resource usage.
ACD are correct
Frequent Single rows on any MPP like Snowflake has always been a no no! Function of an OLTP DB
Frequent single row DML? Hell nah. ACD is the way to go.
Variant NULL values: https://docs.snowflake.com/en/user-guide/semistructured-considerations#label-variant-null
ACD, Correct
ACD are correct
ACD are correct
ACD is correct answer.
The result must be deterministic for merge so source can be any reference data source only constraint it should create/modify unique rows
ACD are correct