Quiz: Snowflake's Cloud Data Warehouse Questions!

242 Questions | By Kgbspy | Last updated: Jan 22, 2021 | Total Attempts: 1522

Questions

Settings

Questions and Answers

1.

True or False: Data Storage is independent from compute?
- A.
  
  True
- B.
  
  False
2.

True or False: All virtual warehouses have access to all data?
- A.
  
  True
- B.
  
  False
3.

True or False: All interactions with data are initialized through the services layer?
- A.
  
  True
- B.
  
  False
4.

True or False: Multi-Cluster Warehouses support high concurrency?
- A.
  
  True
- B.
  
  False
5.

True or False: Warehouses can be dynamically expanded to adjust to workloads?
- A.
  
  True
- B.
  
  False
6.

Which layer provides centralized services for the data warehouse?
- A.
  
  Cloud Services
- B.
  
  Query Processing
- C.
  
  Database Storage
7.

Which layer contains virtual warehouses for data access?
- A.
  
  Cloud Services
- B.
  
  Query Processing
- C.
  
  Database Storage
8.

Which layer contains the data in compressed, columnar format?
- A.
  
  Database Storage
- B.
  
  Cloud Services
- C.
  
  Query Processing
9.

Snowflake's security and authentication includes Multi-Factor authentication?
- A.
  
  True
- B.
  
  False
10.

Snowflake's security and authentication includes Snowflake Failures alerts?
- A.
  
  True
- B.
  
  False
11.

Snowflake's security and authentication includes data encryption using Snowflake-managed keys?
- A.
  
  True
- B.
  
  False
12.

Snowflake's security and authentication includes object-level access?
- A.
  
  True
- B.
  
  False
13.

Snowflake's architecture includes advance capabilities in the cloud services layer that delivers transaction management for consistent operations on the same data at the same time?
- A.
  
  True
- B.
  
  False
14.

Snowflake's architecture includes advance capabilities in the cloud services layer that delivers metadata service?
- A.
  
  True
- B.
  
  False
15.

Snowflake's architecture includes advance capabilities in the cloud services layer that delivers security and authentication control?
- A.
  
  True
- B.
  
  False
16.

Snowflake's architecture includes advance capabilities in the cloud services layer that delivers query optimization?
- A.
  
  True
- B.
  
  False
17.

Snowflake supports landing data into internal stage on the cloud storage platform?
- A.
  
  True
- B.
  
  False
18.

Snowflake supports landing data into external stage on the cloud storage platform?
- A.
  
  True
- B.
  
  False
19.

Snowflake supports landing data into bring your own device?
- A.
  
  True
- B.
  
  False
20.

Compute resources used by Snowflake for data loading jobs can by provide by user managed virtual warehouse?
- A.
  
  True
- B.
  
  False
21.

Compute resources used by Snowflake for data loading jobs can by provide by Snowflake managed service?
- A.
  
  True
- B.
  
  False
22.

Compute resources used by Snowflake for data loading jobs can by provide by hardware provisioned by user directly from cloud providers?
- A.
  
  True
- B.
  
  False
23.

Stages are unique database objects in Snowflake?
- A.
  
  True
- B.
  
  False
24.

Pipe are unique database objects in Snowflake?
- A.
  
  True
- B.
  
  False
25.

Table are unique database objects in Snowflake?
- A.
  
  True
- B.
  
  False