Snowflake Quiz

which are 3 layers in snowflake architecture

• Security Layer

• Query processing

• Database Storage

• Product Catalog

• Cloud Services

Snowflake can be hosted on which cloud platforms ?

• AWS

• Oracle Cloud

• Google Cloud

• Azure

• IBM cloud

Compute cost will not increase if we increase the size of warehouse. (True/False)

• False

• True

We can change the size of warehouse even when it is executing the queries. (True/False)

• True

• False

Which feature in snowflake allow user to un-drop table which is already dropped?

• Fail Safe

• Time Travel

• Data replication

• Zero copy Clone

Which snowflake object will check the credit consumption and alert the user ?

• Credit checker

• Warehouse Monitor

• Resource Monitor

• Credit threshold

• Credit Monitor

Which of the following are not snowflake editions.

• Enterprise Edition

• Virtual Private Snowflake

• Basic Edition

• Business Critical Edition

• Premium Edition

Query Optimization occurs in which layer of snowflake architecture ?

• Query Processing layer

• Database Storage layer

• Optimization layer

• Cloud Services

Data changes made in Clone object is not reflected on to its source object.

(True/False)

• True

• False

Consider a table of size 1 GB. This table is cloned and the cloned object's size is also 1 GB. (True/False)

• False

• True