B - Snowflake Level Up Step 1-2 Questions and complete solutions
Which of the following terms are associated with the Cloud Services Layer?
Query
... [Show More] Processing
Query Planning
Query Optimization
Query Design
Query Compilation
Which of the following terms are associated with the Compute/Warehouse Layer?
Query Processing
Query Planning
Query Optimization
Query Design
Query Compilation
Which of the following are performed by the Cloud Services layer?
Metadata Management
User Authentication
Metadata Storage
Data Security
Availability Zone Management
Three of these terms refer to the same layer. Select the correct 3.
Compute Layer
Virtual Warehouse Layer
Catalog Layer
Metadata Layer
Query Processing Layer
Two of these terms refer to the same layer. Select the correct 2.
Cloud Services Layer
Virtual Warehouse Layer
Services Layer
Storage Layer
Catalog Layer
Two of these terms refer to the same layer. Select the correct 2.
Metadata Layer
Virtual Storage Layer
Catalog Layer
Data Layer
Storage Layer
Which of the following statements about Snowflake are true?
1. Storage can increase or decrease without any effect on virtual warehouse sizes.
2. Virtual Warehouses have no effect on compute costs.
3. Compute can be scaled up, down, out, or in and there is no effect on storage used.
4. Cloud services can be increased to multiple regions without any user intervention.
5. Two Virtual Warehouses can access the same data at the same time without causing contention issues.
Q
What attributes make Snowflake a true SaaS solution?
1. No hardware to purchase or configure.
2. No creation of user accounts or roles is required.
3. No maintenance upgrades or patches to install.
4. No data storage costs.
5. No query processing costs.
6. Transparent releases don't require user intervention.
Which installment option versions of Snowflake are available?
1. Microsoft Cloud Native Accounts
2. Snowflake-Hosted Accounts (on Amazon cloud infrastructure)
3. Hybrid On-Premise + Cloud Installation
4. Enterprise In-House VPC Installation
5. On-Premise Custom Installation
6. Snowflake-Hosted Accounts (on Azure cloud infrastructure)
Which of the following terms describes Snowflake's Architecture?
Shared Disk
Shared Nothing
Shared Data
Shared Memory Which of the following terms or phrases can also be used to describe Snowflake?
1. Native SQL
2. Hybrid Columnar
3. Built from the ground up for the cloud
4. Hadoop-Compliant
5. Multi-cluster
6. Oracle derived
Which statements are true about storage relationships?
1. Snowflake Tables are stored within Schemas.
2. Snowflake Databases are stored within Warehouses
3. Snowflake Warehouses are stored within Data Marts
4. Snowflake Schemas are stored within Warehouses
5. Snowflake Warehouses are stored within Databases
6. Snowflake Schemas are stored within Databases
When a warehouse is resized, which queries make use of the new size?
1. Both current and subsequent queries
2. Only currently running queries
3. Only subsequent queries
Snowflake data storage costs are calculated based on:
1. Uncompressed Size
2. Compressed Size
3. Amount Stored on Last Day of Month
4. Amount Stored on First Day of Month
5. Amount Stored - Daily Average
Snowflake data storage costs include which types of data?
1. Metadata
2. Persistent data stored in permanent tables
3. Data retained to enable data recovery (time travel and fail-safe)
4. Cached results
5. Semi-structured data - additional fees
Snowflake compute costs depend on which of the following?
1. The number of rows returned in queries.
2. The amount of time warehouses have run.
3. The total number of warehouses in the account.
4. The sizes of running warehouses.
How often does Snowflake release new features? What common tasks for traditional on-premise database and IT staff, are not required with Snowflake?
1. Maintaining metadata
2. Maintaining statistics
3. Maintaining the physical security of a server room (key cards, door locks, etc)
4. Maintaining database objects [Show Less]