Snowflake Fundamentals Quiz

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​

• Creates new
• replace existing
• modify
• delete

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

Answer explanation

Correct Answers: A, B, C, and D

• Option 1 is correct. Snowflake offers different pricing for computing and storage depending upon the region you choose. For example, a Snowflake instance running in the Mumbai region costs $3.30/credit, whereas the same instance running in the Frankfurt region costs $4.00/credit. So if you are looking to save costs, you would choose a low-cost region.

• Option 2 is correct. The closer you are to your end-users, data transfer latency would be lower so you can transfer and access data faster. Hence, it is always a good practice to set up your Snowflake account in the region closer to your end-users.

• Option 3 and 4 are correct. As is often the case in most countries, there are data sovereignty and regulatory restrictions on where the data of users is stored. For example, in the EU, certain sensitive user data is now allowed to cross the EU boundary. India also has similar restrictions enforced by the law. Hence, if you build software that will store such sensitive user data, you will need to check the regulatory requirements and choose the Snowflake region accordingly.

Informatica, Matillion, Azure data factory are examples of ………………….. partners of the Snowflake partner ecosystem.

• Data Management

• Business Intelligence

• Data Integration

• Data Science

Answer explanation

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