MCQs on Setting Up and Exploring Snowflake | Snowflake
Snowflake is a powerful cloud-based data warehousing solution designed to handle big data workloads seamlessly. In this chapter, “Setting Up and Exploring Snowflake,” you’ll learn to create a Snowflake account, navigate its web interface, manage roles and users, and perform your first hands-on database creation. Here’s a set of multiple-choice questions (MCQs) to reinforce your understanding.
Creating a Snowflake Account
- What is required to sign up for a Snowflake account?
a) Email address and phone number
b) Email address and company name
c) Social media login credentials
d) Company registration documents - Snowflake offers free trials with:
a) Unlimited storage and compute
b) Limited-time access to features
c) 30 days of credits
d) Permanent free access to one database - The process of activating a Snowflake account begins with:
a) Downloading Snowflake software
b) Clicking on the activation link in the email
c) Setting up a virtual machine
d) Installing a desktop application - During the account setup, you can choose your Snowflake region. This is important because:
a) It affects data storage costs
b) It determines the color of the UI
c) It limits the number of users
d) It restricts data query options - Which cloud platforms are supported by Snowflake?
a) AWS, Azure, and Google Cloud
b) AWS and Google Cloud only
c) Azure only
d) AWS, Azure, and IBM Cloud
Navigating the Snowflake Web Interface
- The Snowflake web interface allows you to:
a) Create and manage virtual machines
b) Access, load, and query data
c) Manage physical data centers
d) Install server-side software - Which section of the Snowflake interface is used to write SQL queries?
a) Worksheets
b) Database Explorer
c) Admin Console
d) Account Settings - The “Account” section in the Snowflake web interface is used for:
a) Writing queries
b) Adjusting billing and account preferences
c) Creating databases
d) Query optimization - What is the purpose of the “Help” menu in the Snowflake interface?
a) To execute pre-written queries
b) To provide documentation and tutorials
c) To create new users
d) To manage data security - Where can you view the compute resources (warehouses) in Snowflake?
a) Databases tab
b) Admin Console
c) Warehouses tab
d) SQL Scripts tab
Understanding Roles and Users
- Roles in Snowflake are used to:
a) Query data across regions
b) Assign permissions to users
c) Create new data warehouses
d) Optimize SQL queries - Which role is assigned by default to a new user in Snowflake?
a) ACCOUNTADMIN
b) SYSADMIN
c) PUBLIC
d) SECURITYADMIN - What is the primary purpose of the SECURITYADMIN role?
a) Managing billing
b) Administering security settings and user roles
c) Writing complex SQL queries
d) Creating databases - The PUBLIC role in Snowflake is:
a) A role for anonymous users
b) A default role assigned to every user
c) A role with no permissions
d) A role used for billing - To assign a role to a user, which command is used?
a) GRANT ROLE TO USER
b) ASSIGN ROLE TO USER
c) CREATE ROLE USER
d) ROLE GRANT TO USER
Hands-on: Creating Your First Database
- To create a database in Snowflake, which SQL command is used?
a) CREATE DATABASE
b) NEW DATABASE
c) INIT DATABASE
d) SETUP DATABASE - A database in Snowflake consists of:
a) Tables and queries only
b) Schemas, tables, and other objects
c) Only metadata
d) User profiles - The “SHOW DATABASES” command is used to:
a) List all available databases
b) Delete a database
c) Create a new database
d) Backup a database - Which role must a user have to create a database in Snowflake?
a) SECURITYADMIN
b) ACCOUNTADMIN
c) SYSADMIN
d) WAREHOUSEADMIN - Snowflake databases store data using:
a) Traditional file systems
b) Columnar storage format
c) XML-based storage
d) Blockchain technology
Additional Questions for Review
- Snowflake’s architecture is based on:
a) Shared-disk model
b) Shared-nothing model
c) Hybrid-cloud model
d) Serverless model - What feature of Snowflake enables scaling of compute resources?
a) Auto-scale
b) Multi-cluster warehouses
c) Compute boost
d) Elastic computing - Users can load data into Snowflake using:
a) Excel spreadsheets only
b) SQL scripts, external stages, and APIs
c) Only REST APIs
d) Command-line tools exclusively - A “schema” in Snowflake is:
a) A backup of the database
b) A logical grouping of database objects
c) A physical file structure
d) A replication tool - Snowflake provides built-in support for:
a) ETL tools and visualization platforms
b) Only third-party ETL tools
c) Hadoop storage systems
d) On-premise data warehouses - The “USE DATABASE” command is used to:
a) Switch to a specified database
b) Delete a database
c) Create a new database
d) Backup a database - Data security in Snowflake is ensured by:
a) Encrypted storage and user roles
b) Dedicated firewalls
c) Local file backups
d) Physical security measures - The “TIME TRAVEL” feature in Snowflake is used for:
a) Query optimization
b) Restoring historical data
c) Scheduling queries
d) Migrating databases - In Snowflake, “Virtual Warehouses” are:
a) Physical servers
b) Compute resources for executing queries
c) Data storage locations
d) Query optimization tools - Snowflake supports data sharing through:
a) Secure Data Sharing feature
b) External file transfers
c) Direct database links
d) Encrypted email attachments
Answers
| Qno | Answer |
|---|---|
| 1 | b) Email address and company name |
| 2 | c) 30 days of credits |
| 3 | b) Clicking on the activation link in the email |
| 4 | a) It affects data storage costs |
| 5 | a) AWS, Azure, and Google Cloud |
| 6 | b) Access, load, and query data |
| 7 | a) Worksheets |
| 8 | b) Adjusting billing and account preferences |
| 9 | b) To provide documentation and tutorials |
| 10 | c) Warehouses tab |
| 11 | b) Assign permissions to users |
| 12 | c) PUBLIC |
| 13 | b) Administering security settings and user roles |
| 14 | b) A default role assigned to every user |
| 15 | a) GRANT ROLE TO USER |
| 16 | a) CREATE DATABASE |
| 17 | b) Schemas, tables, and other objects |
| 18 | a) List all available databases |
| 19 | c) SYSADMIN |
| 20 | b) Columnar storage format |
| 21 | b) Shared-nothing model |
| 22 | b) Multi-cluster warehouses |
| 23 | b) SQL scripts, external stages, and APIs |
| 24 | b) A logical grouping of database objects |
| 25 | a) ETL tools and visualization platforms |
| 26 | a) Switch to a specified database |
| 27 | a) Encrypted storage and user roles |
| 28 | b) Restoring historical data |
| 29 | b) Compute resources for executing queries |
| 30 | a) Secure Data Sharing feature |