SnowFlake Dec_11

Which of the following terms are associated with the Compute/Warehouse Layer?

• Query Processing

• Query Planning

• Query Optimization

• Query Design

• Query Compilation

Which of the following are performed by the Cloud Services layer? (Select 4)

• Metadata Management

• User Authentication

• Metadata Storage

• Data Security

• Availability Zone Management

Three of these terms refer to the same layer. Select the correct 3

• Compute Layer

• Virtual Warehouse Layer

• Catalog Layer

• Metadata Layer

• Query Processing Layer

Two of these terms refer to the same layer. Select the correct 2

• Cloud Services Layer

• Virtual Warehouse Layer

• Services Layer

• Storage Layer

• Catalog Layer

Which of the following statements about Snowflake are true? (Select 3)

• Storage can increase or decrease without any effect on virtual warehouse sizes

• Virtual Warehouses have no effect on compute costs

• Compute can be scaled up, down, out, or in and there is no effect on storage used.

• Cloud services can be increased to multiple regions without any user intervention.

• Two Virtual Warehouses can access the same data at the same time without causing contention issues.

What attributes make Snowflake a true SaaS solution? (Select 3)

• No hardware to purchase or configure

• No creation of user accounts or roles is required

• No maintenance upgrades or patches to install

• No data storage costs

• Transparent releases don't require user intervention

Which of the following terms describes Snowflake's Architecture?

• Shared Disk

• Shared Nothing

• Shared Data

• Shared Memory

Snowflake Ecosystem Tech Partners are classified into which of the following functional categories?

• Data Integration

• Business Intelligence

• SQL Editors

• Security & Governance

• Advanced Analytics and Programmatic Interfaces

Which of the following Snowflake Editions automatically store data in an encrypted state?

• Standard

• Enterprise

• Business Critical

• None of the options

The following questions have to do cloud platforms. Mark all the statements that are true.

• A company can use more than one cloud infrastructure provider by setting up several Snowflake accounts

• A company can have its data stored in more than one geographical region by setting up several Snowflake accounts

• A company can use a combination of data sharing and replication to distribute data to various regions and cloud platforms

• A company can use availability zones to distribute data to various regions and cloud platforms