MCQs on Snowflake Fundamentals | Snowflake
Snowflake is a cutting-edge cloud data platform that simplifies data management, querying, and analysis. Chapter 3 dives into the foundational concepts of Snowflake, including its object hierarchy (databases, schemas, tables), efficient management of virtual warehouses, and the basics of data storage. Learn how to query with SQL in Snowflake for optimal performance and usability.
MCQs
Topic 1: Snowflake’s Object Hierarchy (Databases, Schemas, Tables)
- In Snowflake, a schema is a:
a) Collection of databases
b) Logical grouping of tables and other objects
c) Physical storage location for data
d) Type of virtual warehouse - What is the smallest unit of data organization in Snowflake?
a) Database
b) Table
c) Schema
d) Warehouse - A database in Snowflake can contain:
a) Only schemas
b) Only tables
c) Schemas, tables, and other objects
d) Only virtual warehouses - Which command is used to create a schema in Snowflake?
a) CREATE TABLE
b) CREATE SCHEMA
c) CREATE DATABASE
d) CREATE WAREHOUSE - The default role in Snowflake that allows the creation of databases is:
a) SYSADMIN
b) PUBLIC
c) SECURITYADMIN
d) ACCOUNTADMIN - What is the purpose of a table in Snowflake?
a) Storing configuration details
b) Hosting data records
c) Managing user roles
d) Organizing warehouses - A schema resides inside which component of Snowflake’s hierarchy?
a) Table
b) Virtual warehouse
c) Database
d) Query
Topic 2: Working with Warehouses
- Virtual warehouses in Snowflake are primarily used for:
a) Storing data
b) Executing queries
c) Managing schemas
d) Configuring networks - How can you suspend a warehouse in Snowflake?
a) By deleting the warehouse
b) By using the SUSPEND command
c) Automatically after a specified idle time
d) By creating a new database - Which size of virtual warehouse in Snowflake offers the highest compute capacity?
a) SMALL
b) MEDIUM
c) LARGE
d) 4XLARGE - Warehouses in Snowflake scale:
a) Vertically only
b) Horizontally only
c) Both horizontally and vertically
d) Automatically without user input - When a virtual warehouse is running, Snowflake charges for:
a) Data storage
b) Compute resources
c) Network bandwidth
d) All of the above - What happens when a query is executed in Snowflake, but no warehouse is running?
a) The query fails
b) Snowflake automatically starts the warehouse
c) The query is queued until a warehouse starts
d) The query uses Snowflake’s default warehouse - Which command is used to resize a virtual warehouse in Snowflake?
a) ALTER WAREHOUSE
b) MODIFY WAREHOUSE
c) RESIZE WAREHOUSE
d) UPDATE WAREHOUSE
Topic 3: Data Storage and Virtual Warehouses
- Snowflake stores data in:
a) Proprietary data centers
b) A cloud storage layer
c) On-premise servers
d) SQL databases - Snowflake data storage is optimized for:
a) Network speed
b) High availability and compression
c) On-premise compatibility
d) Low-cost compute - Data in Snowflake is stored as:
a) Plain text files
b) Encrypted and compressed micro-partitions
c) JSON objects
d) SQL files - How does Snowflake ensure scalability in data storage?
a) By storing data in fixed-size blocks
b) By using cloud providers’ storage infrastructure
c) By limiting the number of tables per schema
d) By compressing all data to the same level - Snowflake separates compute from:
a) Data access
b) Data storage
c) Networking
d) User authentication - Which term describes Snowflake’s ability to automatically manage the availability of data?
a) High availability
b) Data mirroring
c) Elastic scaling
d) Data replication
Topic 4: Introduction to Querying with SQL
- Snowflake uses which SQL dialect?
a) PostgreSQL
b) ANSI SQL
c) MySQL
d) Oracle SQL - Which clause in a SQL SELECT statement is used to filter rows?
a) ORDER BY
b) GROUP BY
c) WHERE
d) FROM - To limit the number of rows returned by a query, you use:
a) LIMIT
b) OFFSET
c) RESTRICT
d) COUNT - In Snowflake, how do you write a query to select all columns from a table named “customers”?
a) SELECT customers.* FROM *
b) SELECT * FROM customers
c) SELECT ALL FROM customers
d) SELECT FROM customers - The COUNT function in SQL is used to:
a) Sum numeric values
b) Count the number of rows
c) Retrieve unique records
d) Filter duplicate rows - Which keyword is used to sort query results in ascending order?
a) SORT
b) ORDER BY ASC
c) GROUP BY
d) FILTER ASC - In Snowflake, which function is used to combine the results of two queries?
a) JOIN
b) UNION
c) MERGE
d) CONCAT - Which of the following is not a valid aggregate function in SQL?
a) AVG
b) MAX
c) SUM
d) COUNT DISTINCT - The default sort order for results in Snowflake is:
a) Ascending
b) Descending
c) Random
d) None - A query in Snowflake returns data in:
a) CSV format
b) JSON format
c) Tabular format
d) Any specified format
Answer Key
| QNo | Answer |
|---|---|
| 1 | b) Logical grouping of tables and other objects |
| 2 | b) Table |
| 3 | c) Schemas, tables, and other objects |
| 4 | b) CREATE SCHEMA |
| 5 | a) SYSADMIN |
| 6 | b) Hosting data records |
| 7 | c) Database |
| 8 | b) Executing queries |
| 9 | c) Automatically after a specified idle time |
| 10 | d) 4XLARGE |
| 11 | c) Both horizontally and vertically |
| 12 | b) Compute resources |
| 13 | b) Snowflake automatically starts the warehouse |
| 14 | a) ALTER WAREHOUSE |
| 15 | b) A cloud storage layer |
| 16 | b) High availability and compression |
| 17 | b) Encrypted and compressed micro-partitions |
| 18 | b) By using cloud providers’ storage infrastructure |
| 19 | b) Data storage |
| 20 | a) High availability |
| 21 | b) ANSI SQL |
| 22 | c) WHERE |
| 23 | a) LIMIT |
| 24 | b) SELECT * FROM customers |
| 25 | b) Count the number of rows |
| 26 | b) ORDER BY ASC |
| 27 | b) UNION |
| 28 | d) COUNT DISTINCT |
| 29 | d) None |
| 30 | c) Tabular format |