Snowflake Certification Exam Questions
With Correct Answers
True or False: Data Storage is independent from compute? - CORRECT
| | | | | | | | | | |
ANSWER✔✔-True
True or False: All virtual warehouses have access to all data? - CORRECT
| | | | | | | | | | | | |
ANSWER✔✔-True
True or False: Al interactions with data are initialized through the
| | | | | | | | | | |
services layer? - CORRECT ANSWER✔✔-True
| | | |
True or False: Multi-Cluster Warehouses support high concurrency? -
| | | | | | | | |
CORRECT ANSWER✔✔-True
|
True or False: Warehouses can be dynamically expanded to adjust to
| | | | | | | | | | |
workloads? - CORRECT ANSWER✔✔-True
| | |
Which layer provides centralized services for the data warehouse? -
| | | | | | | | | |
CORRECT ANSWER✔✔-Cloud Services
| |
,Which layer contains virtual warehouses for data access? - CORRECT
| | | | | | | | | |
ANSWER✔✔-Query Processing |
Which layer contains the data in compressed, columnar format? -
| | | | | | | | | |
CORRECT ANSWER✔✔-Database Storage
| |
True or False: Snowflake's security and authentication includes Multi-
| | | | | | | |
Factor authentication? - CORRECT ANSWER✔✔-True
| | | |
True or False: Snowflake's security and authentication includes
| | | | | | | |
Snowflake Failures alerts? - CORRECT ANSWER✔✔-False
| | | | |
True or False: Snowflake's security and authentication includes data
| | | | | | | | |
encryption using Snowflake-managed keys? - CORRECT ANSWER✔✔-
| | | | | |
False
True or False: Snowflake's security and authentication includes object-
| | | | | | | |
level access? - CORRECT ANSWER✔✔-True
| | | |
True or False: 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? - CORRECT
| | | | | | | | | | | |
ANSWER✔✔-True
,True or False: Snowflake's architecture includes advance capabilities in
| | | | | | | | |
the cloud services layer that delivers metadata service? - CORRECT
| | | | | | | | | |
ANSWER✔✔-True
True or False: Snowflake's architecture includes advance capabilities in
| | | | | | | | |
the cloud services layer that delivers security and authentication
| | | | | | | | |
control? - CORRECT ANSWER✔✔-True
| | |
True or False: Snowflake's architecture includes advance capabilities in
| | | | | | | | |
the cloud services layer that delivers query optimization? - CORRECT
| | | | | | | | | |
ANSWER✔✔-True
True or False: Snowflake supports landing data into internal stage on the
| | | | | | | | | | |
cloud storage platform? - CORRECT ANSWER✔✔-True
| | | | | |
True or False: Snowflake supports landing data into external stage on
| | | | | | | | | | |
the cloud storage platform? - CORRECT ANSWER✔✔-True
| | | | | |
True or False: Snowflake supports landing data into bring your own
| | | | | | | | | | |
device? - CORRECT ANSWER✔✔-False
| | |
True or False: Compute resources used by Snowflake for data loading
| | | | | | | | | | |
jobs can by provide by user managed virtual warehouse? - CORRECT
| | | | | | | | | | |
ANSWER✔✔-True
, True or False: Compute resources used by Snowflake for data loading
| | | | | | | | | | |
jobs can by provide by Snowflake managed service? - CORRECT
| | | | | | | | | |
ANSWER✔✔-True
True or False: Compute resources used by Snowflake for data loading
| | | | | | | | | | |
jobs can by provide by hardware provisioned by user directly from cloud
| | | | | | | | | | |
|providers? - CORRECT ANSWER✔✔-False| | |
True or False: Stages are unique database objects in Snowflake? -
| | | | | | | | | | |
CORRECT ANSWER✔✔-True |
True or False: Pipe are unique database objects in Snowflake? -
| | | | | | | | | | |
CORRECT ANSWER✔✔-True |
True or False: Table are unique database objects in Snowflake? -
| | | | | | | | | | |
CORRECT ANSWER✔✔-False |
Which approach would result in improved performance through linear
| | | | | | | | |
scaling of data ingestion workload:
| | | |
A) Resize virtual warehouse
| | |
B) Consider the practice of organizing data by granular path
| | | | | | | | |
With Correct Answers
True or False: Data Storage is independent from compute? - CORRECT
| | | | | | | | | | |
ANSWER✔✔-True
True or False: All virtual warehouses have access to all data? - CORRECT
| | | | | | | | | | | | |
ANSWER✔✔-True
True or False: Al interactions with data are initialized through the
| | | | | | | | | | |
services layer? - CORRECT ANSWER✔✔-True
| | | |
True or False: Multi-Cluster Warehouses support high concurrency? -
| | | | | | | | |
CORRECT ANSWER✔✔-True
|
True or False: Warehouses can be dynamically expanded to adjust to
| | | | | | | | | | |
workloads? - CORRECT ANSWER✔✔-True
| | |
Which layer provides centralized services for the data warehouse? -
| | | | | | | | | |
CORRECT ANSWER✔✔-Cloud Services
| |
,Which layer contains virtual warehouses for data access? - CORRECT
| | | | | | | | | |
ANSWER✔✔-Query Processing |
Which layer contains the data in compressed, columnar format? -
| | | | | | | | | |
CORRECT ANSWER✔✔-Database Storage
| |
True or False: Snowflake's security and authentication includes Multi-
| | | | | | | |
Factor authentication? - CORRECT ANSWER✔✔-True
| | | |
True or False: Snowflake's security and authentication includes
| | | | | | | |
Snowflake Failures alerts? - CORRECT ANSWER✔✔-False
| | | | |
True or False: Snowflake's security and authentication includes data
| | | | | | | | |
encryption using Snowflake-managed keys? - CORRECT ANSWER✔✔-
| | | | | |
False
True or False: Snowflake's security and authentication includes object-
| | | | | | | |
level access? - CORRECT ANSWER✔✔-True
| | | |
True or False: 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? - CORRECT
| | | | | | | | | | | |
ANSWER✔✔-True
,True or False: Snowflake's architecture includes advance capabilities in
| | | | | | | | |
the cloud services layer that delivers metadata service? - CORRECT
| | | | | | | | | |
ANSWER✔✔-True
True or False: Snowflake's architecture includes advance capabilities in
| | | | | | | | |
the cloud services layer that delivers security and authentication
| | | | | | | | |
control? - CORRECT ANSWER✔✔-True
| | |
True or False: Snowflake's architecture includes advance capabilities in
| | | | | | | | |
the cloud services layer that delivers query optimization? - CORRECT
| | | | | | | | | |
ANSWER✔✔-True
True or False: Snowflake supports landing data into internal stage on the
| | | | | | | | | | |
cloud storage platform? - CORRECT ANSWER✔✔-True
| | | | | |
True or False: Snowflake supports landing data into external stage on
| | | | | | | | | | |
the cloud storage platform? - CORRECT ANSWER✔✔-True
| | | | | |
True or False: Snowflake supports landing data into bring your own
| | | | | | | | | | |
device? - CORRECT ANSWER✔✔-False
| | |
True or False: Compute resources used by Snowflake for data loading
| | | | | | | | | | |
jobs can by provide by user managed virtual warehouse? - CORRECT
| | | | | | | | | | |
ANSWER✔✔-True
, True or False: Compute resources used by Snowflake for data loading
| | | | | | | | | | |
jobs can by provide by Snowflake managed service? - CORRECT
| | | | | | | | | |
ANSWER✔✔-True
True or False: Compute resources used by Snowflake for data loading
| | | | | | | | | | |
jobs can by provide by hardware provisioned by user directly from cloud
| | | | | | | | | | |
|providers? - CORRECT ANSWER✔✔-False| | |
True or False: Stages are unique database objects in Snowflake? -
| | | | | | | | | | |
CORRECT ANSWER✔✔-True |
True or False: Pipe are unique database objects in Snowflake? -
| | | | | | | | | | |
CORRECT ANSWER✔✔-True |
True or False: Table are unique database objects in Snowflake? -
| | | | | | | | | | |
CORRECT ANSWER✔✔-False |
Which approach would result in improved performance through linear
| | | | | | | | |
scaling of data ingestion workload:
| | | |
A) Resize virtual warehouse
| | |
B) Consider the practice of organizing data by granular path
| | | | | | | | |
