Question 1

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

Question 2

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 3

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 4

Based on the Snowflake object hierarchy, what securable objects belong directly to a Snowflake account? (Select THREE).

Options :

A : Database

B : Schema

C : Table

D : Stage

E : Role

F : Warehouse

Answer: A,E,F

Question 5

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?

Options :

A : All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

B : Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

C : Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

D : All rows loaded using a specific COPY statement will have the same timestamp value.

Answer: D

Free ARA-R01 Mock Exam – Practice Online Confidently

Buying Options: