Font size
WorksheetsSnowflake Fundamentals Quiz
Total questions: 11
Worksheet time: 6mins
Which of the following are not snowflake editions ?
Enterprise Edition
Basic Edition
Business Critical Edition
Standard Edition
Query Optimization occurs in which layer of snowflake architecture ?
Query Processing layer
Database Storage layer
Optimization layer
Cloud Services
When a warehouse of large size is used for an hour then how many credits are used ?
4
8
16
32
Select the statements which are correct/True
Scale up means increasing warehouse size
Scale up means adding more clusters to warehouse
Scale out means increasing warehouse size
Scale out means adding more clusters to warehouse
Every new data Insert into a table, (a) micro partitions
Micro-partition size in uncompressed format ?
10 MB - 20 MB
40 MB - 60 MB
50 MB to 250 MB
50 MB to 500 MB
Micro-partitions are
Immutable
Changeable
elastic
mutables
What are the key considerations for choosing a specific region for your Snowflake account?
(Select all that apply)
Cost
Proximity to the end-users
Data sovereignty
Regulatory requirements
Informatica, Matillion, Azure data factory are examples of ………………….. partners of the Snowflake partner ecosystem.
Data Management
Business Intelligence
Data Integration
Data Science
The following object in Snowflake is also known as the ‘data dictionary’ of a database.
PUBLIC schema
Data Catalog
INFORMATION_SCHEMA schema
None of the above
A resource monitor can be created by…
ACCOUNTADMIN role
SYSADMIN role
USERADMIN role
Owner of the virtual warehouse
Any of the above
