Online Access Free ARA-C01 Exam Questions

What are characteristics of the use of transactions in Snowflake? (Select TWO).

• A.A transaction can be started explicitly by executing a BEGIN TRANSACTION statement and ended explicitly by executing an END TRANSACTION statement.
• B.Explicit transactions can contain DDL, DML, and query statements.
• C.Explicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.
• D.A transaction can be started explicitly by executing a BEGIN WORK statement and ended explicitly by executing a COMMIT WORK statement.
• E.The autocommit setting can be changed inside a stored procedure.

A table for IOT devices that measures water usage is created. The table quickly becomes large and contains more than 2 billion rows.

The general query patterns for the table are:
1. DeviceId, lOT_timestamp and Customerld are frequently used in the filter predicate for the select statement
2. The columns City and DeviceManuf acturer are often retrieved
3. There is often a count on Uniqueld
Which field(s) should be used for the clustering key?

• A.Uniqueld
• B.City and DeviceManuf acturer
• C.lOT_timestamp
• D.Deviceld and Customerld

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

• A.A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.
• B.A task will move to a suspended state during the daylight savings time change.
• C.Task schedules can be designed to follow specified or local time zones to accommodate the time changes.
• D.A task scheduled in a UTC-based schedule will have no issues with the time changes.
• E.A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

What actions are permitted when using the Snowflake SQL REST API? (Select TWO).

• A.The use of a PUT command
• B.The use of a CALL command to a stored procedure which returns a table
• C.Submitting multiple SQL statements in a single call
• D.The use of a GET command
• E.The use of a ROLLBACK command

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?

• A.The query is processing a very large dataset.
• B.The query has overly complex logic.
• C.The query Is reading from remote storage
• D.The query Is queued for execution.