SnowPro Advanced: Data Engineer — Question 12

A Data Engineer needs to load JSON output from some software into Snowflake using Snowpipe.
Which recommendations apply to this scenario? (Choose three.)

Answer options

• A. Load large files (1 GB or larger).
• B. Ensure that data files are 100-250 MB (or larger) in size, compressed.
• C. Load a single huge array containing multiple records into a single table row.
• D. Verify each value of each unique element stores a single native data type (string or number).
• E. Extract semi-structured data elements containing null values into relational columns before loading.
• F. Create data files that are less than 100 MB and stage them in cloud storage at a sequence greater than once each minute.

Correct answer: B, D, E

Explanation

Option B is correct because Snowpipe performs best with files that are 100-250 MB in size, especially when they are compressed. Option D is valid as it ensures that data consistency is maintained by storing each value in a single native data type. Option E is also correct as it allows for better handling of semi-structured data by converting null-containing elements into relational columns before loading. Options A, C, and F are not ideal practices for loading data into Snowflake using Snowpipe.