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 / 90

Total 449 Questions | Updated On: Jun 05, 2025

Add To Cart

Question 1

What does a response error code of 429 from the insertFiles, insertReport, or loadHistoryScan API of Snowpipe mean?

A : Failure. Request rate limit exceeded

B : Failure. Invalid request due to an invalid format or limit exceeded

C : Failure. PipeName not recognized

Answer: A

Question 2

create or replace table result_scan_table_1 like result_scan_table;

Will the above query cost compute credits?

A : No, since it is a metadata operation only

B : Yes, it will need compute as the table structure is also getting created

C : It is hard to say without looking at query profile

Answer: A

Question 3

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

A : The MERGE command

B : The UPSERT command

C : The CHANGES clause

D : A STREAM object

E : Thee CHANGE_DATA_CAPTURE command

Answer: C,D

Question 4

To which entity do we grant privileges?

A : Users

B : Groups

C : Roles

D : Account

Answer: C

Question 5

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

Page: 1 / 90

Total 449 Questions | Updated On: Jun 05, 2025

Add To Cart