Free Snowflake SnowPro-Advanced-Architect Exam Questions

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

Page: 1 / 89

Total 442 Questions | Updated On: May 02, 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

Schema owner can grant object privileges in a regular schema

A : TRUE

B : FALSE

Answer: B

Question 3

The 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 : C2, C1, C3

B : C5, C4, C2

C : C3, C4, C5

D : C1, C3, C2

Answer: A

Question 4

Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.

A : After the ETL run, execute the identical queries so that they remain in the result cache

B : After the ETL run, resize the warehouse to a larger warehouse

C : After the ETL run, copy the tables to another schema for the business users to query

Answer: A

Question 5

An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts. The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data in the QA account need to be an exact copy of the database objects, including privileges and data in the Production account on at least a nightly basis. Which is the LEAST complex approach to use to populate the QA account with the Production account’s data and database objects on a nightly basis?

A : 1) Create a share in the Production account for each database2) Share access to the QA account as a Consumer3) The QA account creates a database directly from each share4) Create clones of those databases on a nightly basis5) Run tests directly on those cloned databases

B : 1) Create a stage in the Production account2) Create a stage in the QA account that points to the same external object-storage location3) Create a task that runs nightly to unload each table in the Production account into the stage4) Use Snowpipe to populate the QA account

C : 1) Enable replication for each database in the Production account2) Create replica databases in the QA account3) Create clones of the replica databases on a nightly basis4) Run tests directly on those cloned databases

D : 1) In the Production account, create an external function that connects into the QA account and returnsall the data for one specific table2) Run the external function as part of a stored procedure that loops through each table in the Productionaccount and populates each table in the QA account

Answer: A

Page: 1 / 89

Total 442 Questions | Updated On: May 02, 2025

Add To Cart