SnowPro Core Certification — Question 450

What is the compressed size limit for semi-structured data loaded into a VARIANT data type using the COPY command?

Answer options

• A. 8 MB
• B. 16 MB
• C. 32 MB
• D. 64 MB

Correct answer: B

Explanation

The correct answer is B, as the maximum compressed size limit for semi-structured data loaded into a VARIANT data type using the COPY command is indeed 16 MB. Options A, C, and D do not meet the specified limit, making them incorrect.