Free Practice Snowflake SnowPro-Advanced-Architect Exam Questions 2025

Stay ahead with 100% Free SnowPro Advanced, Architect SnowPro-Advanced-Architect Dumps Practice Questions

Page: 1 / 89

Total 442 Questions | Updated On: Apr 21, 2025

Add To Cart

Question 1

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 2

Which SQL alter command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

A :

B :

C :

D :

Answer: A

Question 3

Which ALTER commands will impact a column's availability in Time Travel?

A : ALTER TABLE … DROP COLUMN …

B : ALTER TABLE … SET NOT NULL …

C : ALTER TABLE … SET DATA TYPE …

D : ALTER TABLE … RENAME COLUMN …

Answer: C

Question 4

What are the limitations about external functions? (Choose two.)

A : We can only write functions, not stored procedures.

B : The maximum response size per batch is 16MB.

C : External functions must be scalar, so it returns a single value for each input row.

D : Future grants of privileges on external functions are supported.

Answer: A,C

Question 5

What is the function of Resource Monitors regarding data pipelines?

A : Make data not being replicated twice in the same pipeline

B : It performs backups for your pipelines every 5 minutes

C : It helps you monitor and control the costs of your pipelines

Answer: C

Page: 1 / 89

Total 442 Questions | Updated On: Apr 21, 2025

Add To Cart