Free Access to Snowflake.ARA-C01.v2026-04-11.q236 with Valid Practice Test (Page 39)

Question 186

What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).

A.SYSTEMSCLUSTERING
B.SYSTEMSTABLE_CLUSTERING
C.SYSTEMSCLUSTERING_DEPTH
D.SYSTEMSCLUSTERING_RATIO
E.SYSTEMSCLUSTERING_INFORMATION

Question 187

A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below:

Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses.
Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries.
The Architect must design a clustering key for this table to improve the query performance.
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?

A.C5, C4, C2
B.C3, C4, C5
C.C1, C3, C2
D.C2, C1, C3

Question 188

An Architect with the ORGADMIN role wants to change a Snowflake account from an Enterprise edition to a Business Critical edition.
How should this be accomplished?

A.Run an ALTER ACCOUNT command and create a tag of EDITION and set the tag to Business Critical.
B.Failover to a new account in the same region and specify the new account's edition upon creation.
C.Use the account's ACCOUNTADMIN role to change the edition.
D.Contact Snowflake Support and request that the account's edition be changed.

Question 189

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? (Select TWO).

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

Correct Answer: A,C

This question centers aroundcross-cloud ingestionusingSnowpipe, where the Snowflake account is onGoogle Cloud, but the source data resides inAmazon S3. Sinceautomatic Snowpipe event-based integration (using AWS SNS)is only supported when Snowflake is deployed onAWS, this limits the options.
In a multi-cloud scenario (e.g., S3 to GCP-hosted Snowflake), onlymanual triggering of Snowpipeis available, typically through theSnowpipe REST API.
Option A - Correct
You can configure your client application to call theSnowpipe REST APIwhen files are available. This is suitable and supported forcross-cloud ingestion, such as from AWS S3 into a Snowflake account hosted on GCP.
Official Extract:
"For cloud platforms other than AWS, or when using Snowpipe in a cross-cloud or external storage configuration, the REST API must be used to trigger ingestion." Source:Snowflake Docs - Using Snowpipe REST API Option C - Correct AWS Lambda can be used toinvoke the Snowpipe REST APIwhen files arrive in S3. This is a common pattern in cross-cloud integrations, acting as a middle layer.
Official Extract:
"You can use an AWS Lambda function to call the Snowpipe REST API when new files are added to your S3 bucket. This pattern works for Snowflake accounts hosted outside of AWS." Source:Snowflake Docs - Automating Snowpipe REST API Calls Option B - Incorrect S3 Glacier is an archival storage service and isnot supportedfor direct loading into Snowflake, since data is not immediately accessible.
Option D - Incorrect
UsingAWS SNS for auto-notificationis only supported whenSnowflake is deployed on AWS. Since this question specifies Snowflake onGCP, SNS-based integration isnot supported.
Official Extract:
"Snowpipe supports Amazon S3 event notifications (SNS/SQS) only for Snowflake accounts hosted on AWS." Source:Snowflake Docs - Supported Cloud Platforms Option E - Incorrect Similar to Option B, S3 Glacier isnot a valid sourcefor data loading because it does not provide real-time file access.
References:
Snowflake Documentation - Snowpipe Overview
Snowpipe REST API
Automating Snowpipe with Lambda
Automatic Ingestion Support - Cloud Limitations

Question 190

An Architect is defining transaction rules to adhere to ACID properties to ensure that executed statements are either committed or rolled back. Based on this scenario, what characteristics of transactions should be considered? (Select TWO).

A.The autocommit setting can be changed inside a stored procedure.
B.Explicit transactions should 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.An explicit transaction can be started by executing a BEGIN WORK statement and can be ended by executing a COMMIT WORK statement.
E.An explicit transaction can be started by executing a BEGIN TRANSACTION statement and can be ended by executing an END TRANSACTION statement.

Question 186

Question 187

Question 188

Question 189

Question 190

Download PDF File