Snowflake Architecture & Core Concepts

1. What is the primary benefit of Snowflake's micro-partitions for query performance?

Reduced network latency

Efficient data pruning and parallel processing

Automatic query result caching

Built-in indexing on all columns

2. What does a virtual warehouse control in Snowflake?

Data storage location and encryption

Compute resources and query execution

User authentication and permissions

Network connectivity and firewalls

3. Which Snowflake service tier provides multi-cluster warehouse functionality and materialized views?

Standard Edition

Business Critical Edition

Enterprise Edition

Premium Edition

4. What is Snowflake's Fail-safe feature designed to protect against?

Network interruptions

Accidental data deletion or corruption

Query timeout errors

Warehouse scaling failures

5. True or False: Snowflake requires manual index creation for optimal query performance.

True

False

6. Which Snowflake feature allows you to create a read-only copy of a database or schema instantly?

Time Travel

Clone

Fail-safe

Snapshot

7. True or False: Snowflake stores all data in a proprietary columnar format for optimal compression.

True

False

8. What is the maximum number of days Snowflake retains historical data for Time Travel by default?

7 days

14 days

30 days

90 days

9. What is the primary advantage of Snowflake's separation of compute and storage?

Independent scaling and cost optimization

Elimination of data redundancy

Automatic query optimization

Built-in machine learning capabilities

Submit

11. Which authentication methods does Snowflake support? (Select all that apply)

Username/password and SSO

Multi-factor authentication (MFA)

OAuth and SAML

Kerberos and LDAP

Submit

13. Which component of Snowflake's architecture is responsible for parsing and optimizing SQL queries?

Storage layer

Query processing layer

Cloud services layer

Execution engine

14. What does Snowflake's Result Cache store?

Query compilation results

Intermediate query execution steps

Complete query results from identical queries

User session information

Submit

17. What is the default file format Snowflake uses for internal staged files?

Parquet

ORC

Compressed binary

JSON Lines

18. Which file formats does Snowflake natively support for data loading? (Select all that apply)

CSV and JSON

Parquet and ORC

AVRO and XML

Binary and proprietary formats

Submit

19. Which Snowflake object type is used to create a logical grouping of databases and schemas?

Organization

Account

Warehouse

Stage

Submit

SnowPro Core Snowflake Architecture Quiz

1. What is the primary benefit of Snowflake's micro-partitions for query performance?

2.

What first name or nickname would you like us to use?

2. What does a virtual warehouse control in Snowflake?

3. Which Snowflake service tier provides multi-cluster warehouse functionality and materialized views?

4. What is Snowflake's Fail-safe feature designed to protect against?

5. True or False: Snowflake requires manual index creation for optimal query performance.

6. Which Snowflake feature allows you to create a read-only copy of a database or schema instantly?

7. True or False: Snowflake stores all data in a proprietary columnar format for optimal compression.

8. What is the maximum number of days Snowflake retains historical data for Time Travel by default?

9. What is the primary advantage of Snowflake's separation of compute and storage?

10. Snowflake's ______ feature allows you to access previous versions of data within the retention period.

11. Which authentication methods does Snowflake support? (Select all that apply)

12. Snowflake's ______ enables secure data sharing with external Snowflake accounts without data movement.

13. Which component of Snowflake's architecture is responsible for parsing and optimizing SQL queries?

14. What does Snowflake's Result Cache store?

15. Snowflake's role-based access control (RBAC) uses ______ to grant permissions on securable objects.

16. Snowflake automatically manages ______ for all stored data, enabling zero-copy cloning.

17. What is the default file format Snowflake uses for internal staged files?

18. Which file formats does Snowflake natively support for data loading? (Select all that apply)

19. Which Snowflake object type is used to create a logical grouping of databases and schemas?

20. Snowflake's Data Cloud architecture enables ______ across organizations without copying data.