Snowflake quiz

In what year snowflake was develop?

• 2011

• 2012

• 2013

• 2014

Answer explanation

Developed in 2012, Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data. 

Snowflakes is a fully manage Saas. What is Saas stand for?

• Solution as a service

• Source as a service

• Snowflake as a service

• Software as a service

Answer explanation

Saas stands for Software as a service

What layer is made up of virtual warehouses that executes data processing task required for queries?

• Compute layer

• Data base layer

• Security layer

• Administration layer

Answer explanation

Compute layer

It holds all data loaded into snowflakes, this is called what?

• Compute layer

• Security layer

• Data base storage layer

• Storage layer

Answer explanation

The data base storage layer holds all data loaded into snowflake including structure and semi structure data.

Structured data is generally tabular data that is represented by rows and columns in a database. True or False?

• True

• False

Answer explanation

TRUE - Structured data is generally tabular data that is represented by rows and columns in a database.

In snowflakes you can query data by using _____?

• DDL

• DCL

• SQL

• DMAL

In snowflakes micro partition how many MB does uncompressed data block storage have?

• 50MB and 500MB

• 20MB and 50MB

• 100MB and 1000MB

• All of the above

Answer explanation

In micro partition we have small 50mb and 500mb uncompress data block storage

What is called a bundle of compute and resource memory?

• On premise warehouse

• data warehouse

• Memory warehouse

• Virtual warehouse

Answer explanation

Virtual warehouse is a bundle of compute and resource memory. you need vw to perform any ddl or mdl activity on the data within snowflake.

When snowflake receives the same query again it can rapidly return the result set to user without needing to go to find the data. This is called what?

• Data in memory

• Caching

• Data query

• Stored data

Answer explanation

Caching is when snowflake receives the same query again it can rapidly return the result set to user without needing to go to find the data.

It holds the authentication, infrastructure, metadata, optimizer and security. this is also called the the brain of the operation?

• Authentication services

• Security services

• Access services

• Cloud services

Answer explanation

Cloud services holds the authentication, infrastructure, metadata, optimizer and security. this is also called the the brain of the operation.