Free Access Snowflake.ARA-C01.v2024-05-05.q106 Practice Test (Page 2)

Question 1

The following table exists in the production database:
A regulatory requirement states that the company must mask the username for events that are older than six months based on the current date when the data is queried.
How can the requirement be met without duplicating the event data and making sure it is applied when creating views using the table or cloning the table?

A.Use a secure view on the user_events table using a case statement on the username column.

B.Use a masking policy on the username column using a entitlement table with valid dates.

C.Use a masking policy on the username column with event_timestamp as a conditional column.

D.Use a row level policy on the user_events table using a entitlement table with valid dates.

Question 2

With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?

A.Only if the system estimates there's enough query load to keep the cluster busy for at least 4 minutes.

B.Immediately when either a query is queued or the system detects that there's one more query than the currently-running clusters can execute

C.Only if the system estimates there's enough query load to keep the cluster busy for at least 6 minutes.

Question 3

A user can change object parameters using which of the following roles?

A.SYSADMIN, SECURITYADMIN

B.ACCOUNTADMIN, USER with PRIVILEGE

C.ACCOUNTADMIN, SECURITYADMIN

D.SECURITYADMIN, USER with PRIVILEGE

Question 4

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?

A.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.

B.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.

C.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.

D.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.

Question 5

A Snowflake Architect is designing a multiple-account design strategy.
This strategy will be MOST cost-effective with which scenarios? (Select TWO).

A.The company needs to support different role-based access control features for the development, test, and production environments.

B.The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.

C.The company wants to clone a production database that resides on AWS to a development database that resides on Azure.

D.The company must use a specific network policy for certain users to allow and block given IP addresses.

E.The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.

Other Version: 1863Snowflake.ARA-C01.v2025-09-27.q148; 3938Snowflake.ARA-C01.v2025-02-14.q177

Latest Upload: 201PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 296Nokia.4A0-113.v2026-05-01.q69; 253EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 209Salesforce.MC-202.v2026-04-30.q57; 205BICSI.INSTC_V8.v2026-04-29.q53; 333NMLS.MLO.v2026-04-28.q82; 242NCARB.Project-Management.v2026-04-28.q27; 459EMC.D-AV-DY-23.v2026-04-27.q184; 1113ServiceNow.CSA.v2026-04-27.q483

Question 1

Question 2

Question 3

Question 4

Question 5

Download PDF File