Creating a Snowflake account and workspace - Practice Exercises

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Snowflake Account Creation

Which of the following is required to create a Snowflake account?

A A valid email address and organization details

B An AWS or Azure subscription

C A pre-configured virtual private cloud (VPC)

D A local database server

💡 Hint

Think about what basic information Snowflake needs to identify your account.

Snowflake requires a valid email and organization details to create an account. Cloud subscriptions or local servers are not prerequisites.

❓ Configuration

intermediate

Choosing the Correct Snowflake Edition

You want to create a Snowflake workspace with features like data sharing and multi-cluster warehouses. Which Snowflake edition should you select?

A Enterprise Edition

B Free Trial Edition

C Virtual Private Snowflake (VPS)

D Standard Edition

💡 Hint

Consider which edition supports advanced features like multi-cluster warehouses.

Enterprise Edition supports advanced features such as data sharing and multi-cluster warehouses, unlike Standard or Free Trial editions.

❓ Architecture

advanced

Snowflake Account Region Selection Impact

What is the main impact of selecting a specific cloud region when creating a Snowflake account?

A It limits the types of data formats you can use

B It determines the physical location of your data and affects latency

C It restricts the number of users who can access the account

D It controls the maximum size of your virtual warehouses

💡 Hint

Think about how cloud regions affect data storage and access speed.

Choosing a cloud region sets where your data physically resides, impacting latency and compliance requirements.

❓ security

advanced

Securing Access to Snowflake Workspace

Which method is most effective to secure user access when creating a Snowflake workspace?

A Use only username and password authentication

B Share the account credentials among team members

C Allow access from any IP address without restrictions

D Enable Multi-Factor Authentication (MFA) for all users

💡 Hint

Consider what adds an extra layer of security beyond passwords.

Enabling MFA adds a second verification step, greatly improving security over just passwords.

❓ service_behavior

expert

Behavior of Snowflake Workspace After Account Creation

After successfully creating a Snowflake account and workspace, what is the default behavior regarding virtual warehouses?

A Virtual warehouses are created but remain suspended until manually started

B A default virtual warehouse is automatically created and started

C No virtual warehouses are created; you must create them manually before running queries

D Multiple virtual warehouses are created for different workloads automatically

💡 Hint

Think about what you need to do before running your first query.

Snowflake does not create any virtual warehouses by default; users must create and start them to run queries.