Question 1

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

Question 2

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 3

Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported. What could be causing this?

Options :

A : There were JSON nulls in the recent data imports.

B : The order of the keys in the JSON was changed.

C : The recent data imports contained fewer fields than usual.

D : There were variations in string lengths for the JSON values in the recent dataimports.

Answer: B,D

Question 4

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)

Options :

A : There needs to be fewer objects per tenant.

B : Security and Role-Based Access Control (RBAC) policies must be simple to configure.

C : Compute costs must be optimized.

D : Tenant data shape may be unique per tenant.

E : Storage costs must be optimized.

Answer: D,E

Question 5

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner. Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

Options :

A : Utilize a higher Buffer.flush.time in the connector configuration.

B : Utilize a higher Buffer.size.bytes in the connector configuration.

C : Utilize a lower Buffer.size.bytes in the connector configuration.

D : Utilize a lower Buffer.count.records in the connector configuration.

Answer: A

Smartly Prepare Exam with Free Online ARA-R01 Practice Test

Buying Options: