SnowPro Advanced: Architect Free Practice Questions

Question 1

Which capability best supports separating compute and storage to independently scale query workloads in Snowflake?

Accepted Answer

Virtual Warehouses

Question 2

What is the primary purpose of clustering keys in large tables?

Accepted Answer

To physically sort data to improve query performance on common filter columns

Question 3

Which feature should you use to share live data across different Snowflake accounts without duplicating data?

Accepted Answer

Secure Data Sharing

Question 4

When is it appropriate to use a transient table instead of a permanent table?

Accepted Answer

For short-lived intermediate results where data retention policies are not required

Question 5

Which practice helps maintain consistent performance when loading large volumes of data?

Accepted Answer

Staging data in external stages and using COPY INTO in batches

Question 6

What is a benefit of using Streams and Tasks for change data capture?

Accepted Answer

They capture row-level changes for incremental processing and automation

Question 7

Which scenario is best suited for using Snowflake's external stages with cloud storage?

Accepted Answer

Loading data files already stored in AWS S3, Azure Blob, or Google Cloud Storage

Question 8

What advantage does zero-copy cloning provide for development and testing?

Accepted Answer

It creates instant copies of databases or schemas without duplicating storage

Question 9

When should you consider using a materialized view?

Accepted Answer

To precompute and cache aggregation results for frequent queries

Question 10

Which statement accurately describes Snowflake's automatic clustering?

Accepted Answer

It prevents any manual clustering from being defined

Question 11

What is a practical use case for Snowflake's secure data sharing with consumers?

Accepted Answer

Providing real-time read access to shared data without data movement

Question 12

Which factor most influences warehouse sizing for query performance?

Accepted Answer

The number of concurrent queries and complexity of joins

Question 13

What is a recommended approach for managing long-running queries in Snowflake?

Accepted Answer

Use statement queues and resource monitors to control concurrency and resource usage

Question 14

Which benefit does Snowflake's architecture provide for handling variable workloads?

Accepted Answer

Independent scaling of compute and storage without downtime

Question 15

Which strategy best supports cost governance when multiple teams share a Snowflake account?

Accepted Answer

Implementing resource monitors and assigning warehouses by team

A lot more is already mapped out