Practice Test 1 Flashcards
Which term is used to describe Snowflake’s architecture?
Multi-cluster, shared data warehouse
What appears on the top bar of the Snowflake UI?
Databases
Warehouses
Tables
Worksheets
Shares
Account (for admins)
History
Partner connect, help, notifications (top right side)
Drop down menu for user (top right side)
Databases
Warehouses
Worksheets
Shares
Account (for admins)
History
Partner connect, help, notifications (top right side)
Drop down menu for user (top right side)
What are the Snowflake editions?
Standard, Premier, Enterprise, Enterprise for Sensitive Data (ESD), and Virtual Private Snowflake (VPS)
What’s the factor when you increase the t-shirt size of warehouse? 2, 4, 6, or 8?
2
Snowflake is designed for which type of workloads? (select all that apply)
OLAP (analytics) workloads
OLTP (transactional) workloads
Concurrent workloads
On-premises workloads
OLAP
Concurrent
Which of the following are Cloud-native solutions? Select all that apply.
Google Big Query
Snowflake
Both
both
What are the three things customers want most from their enterprise data warehouse solution?
Concurrency
Query Performance
Simplicity
A Snowflake deployment runs in which environment?
Region
Does AWS Private Link allow customers to connect their on prem VPC ?
YES
Which of the following can you clone?
User
Table
Schema
Databases
Views
Shares
Table
Schema
Database
True or false: The Query Profiler view is only available for completed queries.
False
What are some of the items the services layer in Snowflake manages? Select all that apply
User authentication
Metadata
Query Compilation and Optimization
Data Security
All
What types of data does Snowflake support natively? Select all that apply.
Structured, relational data
Semi-structured data such as JSON and AVRO
All
Where is metadata stored?
Global services layer
Virtual warehouse layer
Data storage layer
Customer’s local place
Global services layer
True or False: A micropartition will be updated as updates are made to the rows of the data it contains
False
True/False: When a clone of a table is created, the original table’s data is physically copied?
False
True/False: Fail safe is configurable.
False
Do all tables have fail safe?
No
Which features are direct results of Snowflake’s storage management approach? Select all that apply.
Time Travel
Zero-copy cloning
Fail safe
Time Travel
Zero Copy Cloning
In order to view the storage usage of all tables in a db, you can use: (Select all that apply)
SHOW TABLES;
SHOW STORAGE BY TABLE;
INFORMATION_SCHEMA.TABLE_STORAGE_METRICS
INFORMATION_SCHEMA.TABLE_HISTORY
show tables;
NFORMATION_SCHEMA.TABLE_STORAGE_METRICS
True/False: A single schema can exist in more than one database in SF
False
What’s the maximum row size?
8 MB
16 MB
50 MB
4000 GB
16MB
True or False: The database storage in Snowflake is split across the nodes like other Shared nothing databases.
True
True/False: Zero-copy cloning is an additional feature of Snowflake available for Enterprise edition and up
False
What kind of data format is JSON?
Semi-structured
Unstructured
Structured
semi structured
What methods can be used to create and/or manage Virtual Warehouses?
Snowflake Web Interface
SQL commands
When does a warehouse come out of suspended state (2 ways)
When it is auto-resumed
When a query is run
What is the default time for auto-suspend?
10 min
Warehouses size up between t-shirt sizes by a factor of what?
2
Which of the following does SF not support?
insert
upsert
merge
upsert
How many threads does a single Virtual Machine within a Compute Cluster contain?
8
True/False: The user has to specify which cluster a query will run on in a multi-cluster warehouse.
False
When scaling up virtual warehouses by increasing virtual warehouse t-shirt size, you are primary scaling for improved:
Performance
Concurrency
Simplicity
On-Prem accessibility
performance
True/False: The minimum time that a warehouse is charged is 5 mins.
False
True or false: You can resize a Virtual Warehouse while queries are running.
True
True or false: It is a best practice in Snowflake to break large tables into partitions to improve query performance.
False
Why would you scale a Virtual Warehouse UP?
Complex queries
Large datasets
More workloads
Complex Queries
Large Datasets
Why would you scale a Virtual Warehouse OUT?
Handle concurrency
Handle complex query
Concurrency