Question 1

A company security requirement states that encryption keys used for encrypting files in Snowflake need to be re-encrypted using new keys every 12 months. The company is using an Enterprise edition of Snowflake.How can this requirement be met?

Options :

A : Set the periodic_data_rekeying parameter to true.

B : Contact Snowflake Support to enable periodic rekeying.

C : Create a task to run the rekeying function on a 12-month schedule.

D : Upgrade to a Business Critical edition of Snowfiake.

Answer: A

Question 2

A copy command is executed to load a file.After the file has loaded and the metadata has expired, what options can be used to reload the file? (Select TWO).

Options :

A : Set the FORCE option to TRUE.

B : Set the DISABLE_SNOWFLAKE_DATA option to TRUE.

C : Set the ALLOW_DUPLICATE option to TRUE.

D : Set the LOAD_UNCERTAIN_FILES option to TRUE.

E : Set the PRESERVE_SPACE option to TRUE.

Answer: A,D

Question 3

You want to automatically delete the files from stage after a successful load using the COPY INTO command. What will be recommended approach for deletion?

Options :

A : Set PURGE=TRUE in the COPY INTO command

B : Set REMOVE=TRUE in the COPY INTO Command

C : No need to do anything, snowflake does it automatically

Answer: A

Question 4

External functions must be scalar functions

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization’s system. What is the BEST way to find recent and ongoing login attempts to Snowflake?

Options :

A : Call the LOGIN_HISTORY Information Schema table function.

B : Query the LOGIN_HISTORY view in the ACCOUNT_USAGE schema in the SNOWFLAKE database.

C : View the History tab in the Snowflake UI and set up a filter for SQL text that contains the text "LOGIN".

D : View the Users section in the Account tab in the Snowflake UI and review the last login column.

Answer: B

Free ARA-C01 Mock Exam – Practice Online Confidently

Buying Options: