Snowflake Cloud Platform

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

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

• Map Reduce

• Pruning

• B-Tree

• Indexing

• Hashmap

Which of the following is not a characteristic of "automatic micro-partitions" in Snowflake?

• 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