Question 1

A company needs to have the following features available in its Snowflake account: 1. Support for Multi-Factor Authentication (MFA) 2. A minimum of 2 months of Time Travel availability 3. Database replication in between different regions 4. Native support for JDBC and ODBC 5. Customer-managed encryption keys using Tri-Secret Secure 6. Support for Payment Card Industry Data Security Standards (PCI DSS) In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

Options :

A : Standard

B : Enterprise

C : Business Critical

D : Virtual Private Snowflake (VPS)

Answer: C

Question 2

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?

Options :

A : The healthcare company will need to change the institute’s Snowflake edition in the accounts panel.

B : By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.

C : Contact Snowflake and they will execute the share request for the healthcare company.

D : Set the share_restriction parameter on the shared object to false.

Answer: D

Question 3

An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously. Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)

Options :

A : COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;

B : COPY INTO tablea FROM @%tablea;

C : COPY INTO tablea FROM @%tablea FILES = ('file5.csv');

D : COPY INTO tablea FROM @%tablea FORCE = TRUE;

E : COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;

F : COPY INTO tablea FROM @%tablea MERGE = TRUE;

Answer: B,C

Question 4

VALIDATION_MODE does not support COPY statements that transform data during a load

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?

Options :

A : Snowpipe loads duplicate data into the source table

B : Data loading will fail when the snowpipe is triggered

C : All the files will be loaded into stage again

Answer: A

Higher Test Marks with Free Online ARA-C01 Exam Practice

Buying Options: