Online Access Free ARA-R01 Practice Test

A user has activated primary and secondary roles for a session.
What operation is the user prohibited from using as part of SQL actions in Snowflake using the secondary role?

• A.Create
• B.Delete
• C.Insert
• D.Truncate

Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.

This command results in the following error:
SQL compilation error: invalid parameter 'validation_mode'
Assuming the syntax is correct, what is the cause of this error?

• A.The VALIDATION_MODE parameter does not support COPY statements with CSV file formats.
• B.The VALIDATION_MODE parameter does not support COPY statements that transform data during a load.
• C.The value return_all_errors of the option VALIDATION_MODE is causing a compilation error.
• D.The VALIDATION_MODE parameter supports COPY statements that load data from external stages only.

A company has several sites in different regions from which the company wants to ingest data.
Which of the following will enable this type of data ingestion?

• A.The company should provision a reader account to each site and ingest the data through the reader accounts.
• B.The company must replicate data between Snowflake accounts.
• C.The company should use a storage integration for the external stage.
• D.The company must have a Snowflake account in each cloud region to be able to ingest data to that account.

A company is trying to Ingest 10 TB of CSV data into a Snowflake table using Snowpipe as part of Its migration from a legacy database platform. The records need to be ingested in the MOST performant and cost-effective way.
How can these requirements be met?

• A.Use on error = SKIP_FILE in the copy into command.
• B.Use purge = TRUE in the copy into command.
• C.Use FURGE = FALSE in the copy into command.
• D.Use ON_ERROR = continue in the copy into command.

When using the copy into <table> command with the CSV file format, how does the match_by_column_name parameter behave?

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