Snow Test Question 60 6.0

According to snowflake architecture, data storage is independent of compute

• TRUE

• FALSE

All virtual warehouses in snowflake has access to all data

• TRUE

• FALSE

Which layer in the snowflake architecture contains virtual warehouse

• Cloud services

• Query processing

• Database Storage

• None

Which layer in snowflake contains data in compressed, columnar format

• Cloud services

• Query processing

• Database storage

• None

Which of the below approach would result in a better performance through linear scaling of data ingestion workload

• Resize virtual warehouse

• Consider the practice of organizing data by granular path

• Consider the practice of splitting input file batch within the recommended range of 10 MB and 100 MB

• All of the above

Snowflake provides specific administration features and capabilities to support the following activities except?

• Manage databases and warehouses within snowflake account

• Manage roles and users within a snowflake account

• Monitor usage and manage resources to control costs in a snowflake account

• Manage 3rd party applications providing data to a snowflake account

Select all characteristics of snowflake's multi-cluster environment

• Multiple virtual warehouses in a deployment

• Individual warehouses scale out/in based on query activity

• Multi-cluster warehouses support the same properties and actions as single-cluster warehouse

• User must specify which cluster each query will use

What are the two modes in which a multi-cluster warehouse can run?

• Static

• Dynamic

• Maximized

• Auto-scale

• None of the above

What does snowflake offer to help control the credits consumed by a multi-cluster warehouse running in Auto-scale mode?

• Auto scale

• Scaling policy

• Maximum_number_of_server_clusters

• Minimum_number_of_server_clusters

• None of the above

What scaling policies are supported by snowflake?

• Standard

• Economy

• Premium