ARA-C01 Question #104: Real Exam Question with Answer & Explanation

The correct answer is C: Location of files: Google Cloud Storage. For the configuration of data unloading in Snowflake, the valid option among the provided choices is "C." This is because Snowflake supports unloading data into Google Cloud Storage using the COPY INTO <location> command with specific configurations. The configurations listed in

Data Integration and Pipelines

Question

An Architect needs to design a data unloading strategy for Snowflake, that will be used with the COPY INTO <location> command. Which configuration is valid?

Options

ALocation of files: Snowflake internal location
BLocation of files: Amazon S3
CLocation of files: Google Cloud Storage
DLocation of files: Azure ADLS

Explanation

For the configuration of data unloading in Snowflake, the valid option among the provided choices is "C." This is because Snowflake supports unloading data into Google Cloud Storage using the COPY INTO <location> command with specific configurations. The configurations listed in option C, such as Parquet file format with UTF-8 encoding and gzip compression, are all supported by Snowflake. Notably, Parquet is a columnar storage file format, which is optimal for high- performance data processing tasks in Snowflake. The UTF-8 file encoding and gzip compression are both standard and widely used settings that are compatible with Snowflake's capabilities for data unloading to cloud storage platforms.

Topics

#Data Unloading#COPY INTO command#External Stages#Cloud Storage Integration

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice Browse All ARA-C01 Questions