WorksheetsSnowflake Cloud Platform
Total questions: 10
Worksheet time: 6mins
What are two kinds of virtual warehouses?
Basic
Standard
Concurrent
Snowpark optimized
Auto
Which of the following terms BEST describes Snowflake's Architecture?
Shared nothing
Shared everything
Shared Data
Shared Memory
In which layer does Snowflake perform query execution?
Snowgrid
Query Compilation layer
Compute layer
Cloud Services Layer
Which statements are true about storage relationships?
Schema are created in Databases
Snowflake Databases are stored within Warehouses
Tables are part of schema
Snowflake Warehouses are stored within Databases
Which services are managed by Snowflake's Cloud Services Layer?
Security
Query optimization
Query Execution
Metadata Management
Patches update
Scale up is more suitable for which scenario
Concurrency issue
More query complexity
More number of users accessing the same report
Virtual Warehouse Types: Standard cannot "scale out"
True
False
Neither true nor false
It can scale out only if Standard edition is selected
Which is the minimum edition where Materialized views can be used?
Standard
Enterprise
Business Critical
None of the above
Map Reduce
Pruning
B-Tree
Indexing
Hashmap
Partitioning is automatically completed on the natural ingestion order of the data
The natural ingestion order maintains correlations between columns which could be useful for pruning
Micro-partitions are logical groupings
Micropartitions can't be changed once created
