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: Feb 20, 2025

Add To Cart

Question 1

What does Percentage scanned from cache in the query profile signify?

A : The percentage of data scanned from the local disk cache

B : The percentage of data scanned from the METADATA cache

C : The percentage of data scanned from the QUERY cache

Answer: A

Question 2

A large join query takes around 3 hours to complete in an L warehouse. After increasing the warehouse size to XL one, the query's performance didn't improve. What can be the cause of it?

A : The query was still running before the new size of the warehouse was applied

B : The warehouse doesn't have enough power still

C : The warehouse had auto-suspended before the query finished, and it had to re-start again

D : One of the column's values is significantly more than the rest of the values in the column; that's why it produces a skew in your data.

Answer: D

Question 3

Which of the below commands will use warehouse credits?

A : SHOW TABLES LIKE 'SNOWFL%';

B : SELECT MAX(TEST_ID) FROM SNOWFLAKE;

C : SELECT COUNT(*) FROM SNOWFLAKE;

D : SELECT COUNT(TEST_ID) FROM SNOWFLAKE GROUP BY TEST_ID;

Answer: D

Question 4

Files stored in snowflake stage are automatically encrypted using either AES 128 or 256 strong encryption.

A : TRUE

B : FALSE

Answer: A

Question 5

A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes. Cost is not a concern as long as the solution is the best available. The plan so far consists of the following steps: 1. Deployment of Snowflake accounts on two different cloud providers. 2. Selection of cloud provider regions that are geographically far apart. 3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts. 4. Implementation of Snowflake client redirect. What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

A : Connect the applications using the - URL. Use the Business Critical Snowflake edition.

B : Connect the applications using the - URL. Use the VirtualPrivate Snowflake (VPS) edition.

C : Connect the applications using the - URL. Use the Enterprise Snowflake edition.

D : Connect the applications using the - URL. Use the Business Critical Snowflake edition.

Answer: D

Page: 1 / 89

Total 442 Questions | Updated On: Feb 20, 2025

Add To Cart