Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. ARA-C01

Snowflake ARA-C01 Exam
SnowPro Advanced Architect (Page 2 )

Updated On: 30-Jan-2026
Page 2 of 23
PDF with 228 Questions

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

  1. The MERGE command
  2. The UPSERT command
  3. The CHANGES clause
  4. A STREAM object
  5. Thee CHANGE_DATA_CAPTURE command

Answer(s): C,D



What are characteristics of the use of transactions in Snowflake? (Choose two.)

  1. Explicit transactions can contain DDL, DML, and query statements.
  2. The AUTOCOMMIT setting can be changed inside a stored procedure.
  3. A transaction can be started explicitly by executing a BEGIN WORK statement and end explicitly by executing a COMMIT WORK statement.
  4. A transaction can be started explicitly by executing a BEGIN TRANSACTION statement and end explicitly by executing an END TRANSACTION statement.
  5. Explicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.

Answer(s): C,E



When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

  1. At the root level (HSM)
  2. At the account level (AMK)
  3. At the table level (TMK)
  4. At the micro-partition level

Answer(s): B



An Architect needs to meet a company requirement to ingest files from the company's AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account.

How can the ingestion of these files into the company's Snowflake account be initiated? (Choose two.)

  1. Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
  2. Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.
  3. Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
  4. Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.
  5. Configure the client application to issue a COPY INTO <TABLE> command to Snowflake when new files have arrived in Amazon S3 Glacier storage.

Answer(s): A,C



The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps:

Step 1: Data files are loaded in a stage.

Step 2: An Amazon S3 event notification, published by SNS, informs Snowpipe -- by way of Amazon Simple Queue Service (SQS) - that files are ready to load. Snowpipe copies the files into a queue.

Step 3: A Snowflake-provided virtual warehouse loads data from the queued files into the target table based on parameters defined in the specified pipe.

If an AWS Administrator accidentally deletes the SQS subscription to the SNS topic in Step 2, what will happen to the pipe that references the topic to receive event messages from Amazon
S3?

  1. The pipe will continue to receive the messages as Snowflake will automatically restore the subscription to the same SNS topic and will recreate the pipe by specifying the same SNS topic name in the pipe definition.
  2. The pipe will no longer be able to receive the messages and the user must wait for 24 hours from the time when the SNS topic subscription was deleted. Pipe recreation is not required as the pipe will reuse the same subscription to the existing SNS topic after 24 hours.
  3. The pipe will continue to receive the messages as Snowflake will automatically restore the subscription by creating a new SNS topic. Snowflake will then recreate the pipe by specifying the new SNS topic name in the pipe definition.
  4. The pipe will no longer be able to receive the messages. To restore the system immediately, the user needs to manually create a new SNS topic with a different name and then recreate the pipe by specifying the new SNS topic name in the pipe definition.

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3



Viewing page 2 of 23
Viewing questions 6 - 10 out of 228 questions



Post your Comments and Discuss Snowflake ARA-C01 exam prep with other Community members:

Join the ARA-C01 Discussion