Question 1

An Architect would like to save quarter-end financial results for the previous six years.

Which Snowflake feature can the Architect use to accomplish this?

Options :

A : Search optimization service

B : Materialized view

C : Time Travel

D : Zero-copy cloning

E : Secure views

Answer: D

Question 2

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The

Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME.

What is the reason for this?

Options :

A : The query is processing a very large dataset.

B : The query has overly complex logic.

C : The query is queued for execution.

D : The query is reading from remote storage.

Answer: B

Question 3

An Architect is troubleshooting a query with poor performance using the QUERY function. The Architect observes that the COMPILATION_TIME Is greater than the EXECUTION_TIME. What is the reason for this?

Options :

A : The query is processing a very large dataset.

B : The query has overly complex logic.

C : The query Is queued for execution.

D : The query Is reading from remote storage

Answer: B

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

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

Options :

A : The warehouse MY_WH will be made active every five minutes to check the stream.

B : The warehouse MY_WH will only be active when there are results in the stream.

C : The warehouse MY_WH will never suspend.

D : The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Answer: B

Higher Test Marks with Free Online ARA-R01 Exam Practice

Buying Options: