Free Snowflake ARA-C01 Exam Questions

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

Page: 1 / 89

Total 442 Questions | Updated On: Mar 28, 2025

Add To Cart

Question 1

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

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: B,D

Question 2

A company needs to have the following features available in its Snowflake account: 1. Support for Multi-Factor Authentication (MFA) 2. A minimum of 2 months of Time Travel availability 3. Database replication in between different regions 4. Native support for JDBC and ODBC 5. Customer-managed encryption keys using Tri-Secret Secure 6. Support for Payment Card Industry Data Security Standards (PCI DSS) In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

A : Standard

B : Enterprise

C : Business Critical

D : Virtual Private Snowflake (VPS)

Answer: C

Question 3

Which semi structured data function interprets an input string as a JSON document, producing a VARIANT value.

A : PARSE_JSON

B : PARSE_XML

C : STRIP_JSON

D : Try a hands-on exercise to understand this

Answer: A

Question 4

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 5

What types of objects does Snowflake return when we execute the function GET_OBJECT_REFERENCES? (Choose two)

A : UDFs

B : Materialized views

C : Views (including secure views)

D : Tables

E : Streams

Answer: C,D

Page: 1 / 89

Total 442 Questions | Updated On: Mar 28, 2025

Add To Cart