Free Snowflake ARA-C01 Exam Dumps Questions & Answers

When using the COPY INTO
command with the CSV file format, how does the MATCH_BY_COLUMN_NAME parameter behave?

• A.  It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.
• B.  The command will return an error.
• C.  The command will return a warning stating that the file has unmatched columns.
• D.  The parameter will be ignored.

Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

• A.  If a user in the provider account with role authority to create or alter share adds an Enterprise account as a consumer, it can import the share.
• B.  If a user in the provider account with a share owning role sets share_restrictions to False when adding an Enterprise consumer account, it can import the share.
• C.  If a user in the provider account with a share owning role which also has override share restrictions privilege share_restrictions set to False when adding an Enterprise consumer account, it can import the share.
• D.  A Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical.

An Architect is designing partitioned external tables for a Snowflake data lake. The data lake size may grow over time, and partition definitions may need to change in the future.
How can these requirements be met?

• A.  Set METADATA$EXTERNAL_TABLE_PARTITION = MANUAL.
• B.  Use the PARTITION BY (<part_col_name>) clause when creating the external table.
• C.  Use partition_type = USER_SPECIFIED when creating the external table.
• D.  Alter the table using ADD_PARTITION_COLUMN before defining a new partition column.

Which SQL alter command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

• A. 
• B. 
• C. 
• D. 

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?

• A.  Location of files: Google Cloud Storage. File formats: Parquet. File encoding: UTF-8 Compression:
  gzip
• B.  Location of files: Amazon S3. File formats: CSV, JSON. File encoding: Latin-1 (ISO-8859).
  Encryption: 128-bit
• C.  Location of files: Snowflake internal location. File formats: CSV, XML. File encoding: UTF-8.
  Encryption: 128-bit
• D.  Location of files: Azure ADLS. File formats: JSON, XML, Avro, Parquet, ORC. Compression: bzip2.
  Encryption: User-supplied key