Free Snowflake SnowPro-Advanced-Architect Exam Questions

Become Snowflake Certified with updated SnowPro-Advanced-Architect exam questions and correct answers

Page: 1 / 90

Total 449 Questions | Updated On: Feb 19, 2026

Add To Cart

Question 1

Which of the two are limitations of the insertReport API of SnowPipe?

A : The 10,000 most recent events are retained

B : Events are retained for a maximum of 10 minutes

C : Events are retained for a maximum of 24 hours

Answer: A,B

Question 2

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

A : GRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER USER_01;

B : GRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;

C : GRANT ROLE NEW_ROLE TO USER USER_01; GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

D : GRANT ROLE NEW_ROLE TO USER_01; GRANT CREATE MATERIALIZED VIEW ON EDW.STG_SCHEMA TO NEW_ROLE;

Answer: A

Question 3

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 command to Snowflake when new files have arrived in Amazon S3 Glacier storage.

Answer: A,C

Question 4

For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.

A : FALSE

B : TRUE

Answer: B

Question 5

A company needs to have the following features available in its Snowflake account: 1. Support for Multi-Factor Authentication (MFA) 2. A minimum of 2 months of Time Travel availability 3. Database replication in between different regions 4. Native support for JDBC and ODBC 5. Customer-managed encryption keys using Tri-Secret Secure 6. Support for Payment Card Industry Data Security Standards (PCI DSS) In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

A : Standard

B : Enterprise

C : Business Critical

D : Virtual Private Snowflake (VPS)

Answer: C

Page: 1 / 90

Total 449 Questions | Updated On: Feb 19, 2026

Add To Cart