Snowflake Training New

Snowflake Training New

Poll

Virtual Warehouse optimizes the query before execution.

• True

• False

Poll

Billing against snowflake account depends on the snowflake edition.

• False

• True

Open Ended

Which is the largest sized virtual warehouse that we can create in snowflake ?

Poll

Cloud service layer uses user provided warehouse to perform the tasks

• True

• False

Open Ended

Which service duplicates database in another account in different region ?

Multiple Choice

User can be associated with only one Role

• True

• False

Open Ended

Which load strategy is an example of server less model in snowflake ?

Poll

Snowflake cannot handle loading semi structured data.

• False

• True

Multiple Select

Which among below is true.

• Warehouse can be resumed & suspended automatically

• Warehouse cannot be suspended once started

• Running warehouse consume credits

• Warehouse can be created only through WEB UI

• Warehouse does heavy lifting by executing the query in snowflake architecture

Multiple Select

What is the size of each Micro-Partitions ?

• 50MB - 500MB

• 5MB - 50MB

• 50GB - 500GB

• 5GB - 50GB

Multiple Choice

Which cache is cleared/deleted once the warehouse is suspended ?

• Result Cache

• Local Cache

• Remote Disk

• metadata cache

Multiple Choice

Data Consumer can alter the data in table which is shared by data provider

• True

• False