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

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

Select count(*) from EMPLOYEE ;

Which cache will be used for this query ?

• Result Cache

• Metadata Cache

• Local Cache

• Remote Disk

• None of the above