Snowflake Architecture & Core Concepts

1. 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

2. 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

Submit

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

Standard Edition

Business Critical Edition

Enterprise Edition

Premium Edition

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

Network interruptions

Accidental data deletion or corruption

Query timeout errors

Warehouse scaling failures

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

True

False

Submit

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

Storage layer

Query processing layer

Cloud services layer

Execution engine

9. What does Snowflake's Result Cache store?

Query compilation results

Intermediate query execution steps

Complete query results from identical queries

User session information

Submit

11. 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

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

7 days

14 days

30 days

90 days

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

True

False

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

Time Travel

Clone

Fail-safe

Snapshot

Submit

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

Parquet

ORC

Compressed binary

JSON Lines

17. 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. 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

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

Organization

Account

Warehouse

Stage

SnowPro Core Snowflake Architecture Quiz

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

2.

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

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

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

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

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

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

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

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

9. What does Snowflake's Result Cache store?

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

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

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

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

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

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

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

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

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

19. What does a virtual warehouse control in Snowflake?

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