Free Snowflake ARA-R01 Exam Questions

Become Snowflake Certified with updated ARA-R01 exam questions and correct answers

Page: 1 / 34

Total 166 Questions | Updated On: Jan 15, 2024

Add To Cart

Question 1

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

A : The MERGE command

B : The UPSERT command

C : The CHANGES clause

D : A STREAM object

E : The CHANGE_DATA_CAPTURE command

Answer: C,D

Question 2

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?

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

Question 3

How can the Snowpipe REST API be used to keep a log of data load history?

A : Call insertReport every 20 minutes, fetching the last 10,000 entries.

B : Call loadHistoryScan every minute for the maximum time range.

C : Call insertReport every 8 minutes for a 10-minute time range.

D : Call loadHistoryScan every 10 minutes for a 15-minutes range.

Answer: D

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?

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 can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

A : Create multiple clustering keys for a table.

B : Create multiple materialized views with different cluster keys.

C : Create super projections that will automatically create clustering.

D : Create a clustering key that contains all columns used in the access paths.

Answer: B

Page: 1 / 34

Total 166 Questions | Updated On: Jan 15, 2024

Add To Cart