Which of the following can be used when unloading data from Snowflake? (Choose two.)
A.
When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
B.
Use the ENCODING file format option to change the encoding from the default UTF-8.
C.
The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
D.
By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
E.
Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
The Answer Is:
C, D
This question includes an explanation.
Explanation:
The OBJECT_CONSTRUCT function is used in Snowflake to create a JSON object from relational data, which is useful when unloading semi-structured data. The SINGLE = TRUE parameter is used when unloading data to ensure that the data is exported as a single file, which can be up to 5 GB in size. References: [COF-C02] SnowPro Core Certification Exam Study Guide
SnowPro-Core PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"