Multi-account and organization management in Snowflake - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Snowflake Organizations

What is the primary purpose of a Snowflake Organization in multi-account management?

A To create multiple databases within a single Snowflake account.

B To group multiple Snowflake accounts for centralized billing and governance.

C To manage user roles within a single Snowflake account.

D To replicate data across different cloud providers automatically.

💡 Hint

Think about how companies manage multiple accounts under one umbrella.

A Snowflake Organization allows grouping multiple accounts to simplify billing and governance across them.

❓ Architecture

intermediate

Account Hierarchy in Snowflake Organizations

Which statement correctly describes the relationship between a Snowflake Organization and its member accounts?

A An Organization contains multiple accounts, each with independent compute and storage resources.

B An Organization shares a single compute cluster across all accounts.

C All accounts in an Organization share the same user roles and permissions.

D Accounts in an Organization must be in the same cloud region.

💡 Hint

Consider how resources are isolated or shared in multi-account setups.

Each account in a Snowflake Organization has its own compute and storage, ensuring resource isolation.

❓ security

advanced

Managing Access Across Multiple Snowflake Accounts

Which approach best secures user access across multiple accounts in a Snowflake Organization?

A Leverage Snowflake's Organization Admin role to centrally manage users and roles across accounts.

B Disable multi-factor authentication to reduce login complexity.

C Share the same password for users across all accounts to simplify login.

D Use separate user accounts and roles in each Snowflake account without central management.

💡 Hint

Think about centralized control for security in multi-account environments.

The Organization Admin role allows centralized user and role management across accounts, improving security and consistency.

❓ service_behavior

advanced

Billing Behavior in Snowflake Organizations

How does billing work for multiple accounts under a single Snowflake Organization?

A Each account receives a separate bill directly from Snowflake.

B Billing is only applied to the master account; other accounts are free.

C The Organization receives a consolidated bill that includes usage from all member accounts.

D Billing is based on the number of users, not usage, across all accounts.

💡 Hint

Consider how organizations simplify payment for multiple accounts.

Snowflake Organizations consolidate billing for all member accounts into a single invoice.

✅ Best Practice

expert

Best Practice for Cross-Account Data Sharing in Snowflake Organizations

What is the recommended best practice to securely share data between accounts within a Snowflake Organization?

A Create identical tables in each account and synchronize data with scheduled scripts.

B Export data to external files and import them into the other account manually.

C Grant direct access to the underlying storage buckets across accounts.

D Use Snowflake Secure Data Sharing features to share data without copying it between accounts.

💡 Hint

Think about efficient and secure ways to share data without duplication.

Snowflake Secure Data Sharing allows sharing live data securely without copying or moving it between accounts.