Question 1

What is a key consideration when setting up search optimization service for a table?

Options :

A : Search optimization service works best with a column that has a minimum of 100 K distinct values.

B : Search optimization service can significantly improve query performance on partitioned external tables.

C : Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.

D : The table must be clustered with a key having multiple columns for effective search optimization.

Answer: A

Question 2

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)

Options :

A : Clone a table from a share.

B : Grant modify permissions on the share.

C : Create a table from the shared database.

D : Create additional views inside the shared database.

E : Create a table stream on the shared table.

Answer: A,D

Question 3

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

Options :

A : CONTINUE

B : SKIP_FILE

C : ABORT_STATEMENT

D : FAIL

Answer: A,B,C

Question 4

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

Options :

A : At the root level (HSM)

B : At the account level (AMK)

C : At the table level (TMK)

D : At the micro-partition level

Answer: B

Question 5

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

Options :

A : A task scheduled in a UTC-based schedule will have no issues with the time changes.

B : Task schedules can be designed to follow specified or local time zones to accommodate the time changes

C : A task will move to a suspended state during the daylight savings time change.

D : A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

E : A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

Answer: A,B

Free ARA-R01 Mock Exam – Practice Online Confidently

Buying Options: