What is Snowflake - Practice Questions & Exercises

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Snowflake's Core Function

What is the primary function of Snowflake in cloud computing?

A A cloud data platform that stores and analyzes data with separation of storage and compute

B A cloud-based email and collaboration platform

C A tool for creating and managing containerized applications

D A cloud service that manages virtual machines for running applications

💡 Hint

Think about a service that helps with big data storage and analysis in the cloud.

Snowflake is a cloud data platform designed to store and analyze large amounts of data. It separates storage and compute resources to allow flexible scaling.

❓ Architecture

intermediate

Snowflake Architecture Components

Which component is NOT part of Snowflake's architecture?

A Centralized storage layer for data

B Virtual warehouses for compute resources

C Cloud services layer managing metadata and security

D Physical servers managed by the user

💡 Hint

Snowflake manages infrastructure for you in the cloud.

Snowflake runs fully managed on cloud providers, so users do not manage physical servers directly.

❓ security

advanced

Snowflake Security Features

Which Snowflake feature helps protect data by encrypting it automatically?

A Automatic data encryption at rest and in transit

B Manual encryption keys managed by users only

C No encryption, relies on network security

D Encryption only for backups

💡 Hint

Think about how cloud platforms secure data by default.

Snowflake automatically encrypts data both when stored and when moving across the network to keep it safe.

❓ service_behavior

advanced

Snowflake Compute Scaling Behavior

What happens when you increase the size of a Snowflake virtual warehouse?

A Storage capacity increases automatically

B More compute resources are allocated, speeding up queries

C Data is moved to a different cloud region

D User access permissions are reset

💡 Hint

Think about what compute means in cloud data platforms.

Increasing warehouse size adds more compute power, which helps queries run faster without changing storage.

✅ Best Practice

expert

Optimizing Costs with Snowflake Warehouses

Which practice helps reduce costs when using Snowflake virtual warehouses?

A Use the largest warehouse size for all workloads

B Keep warehouses running 24/7 regardless of usage

C Auto-suspend warehouses when idle to avoid unnecessary charges

D Store all data in multiple warehouses simultaneously

💡 Hint

Think about paying only for what you use.

Auto-suspending warehouses when not in use stops compute charges, saving money.