SNOWFLAKE CERTIFICATION EXAM
QUESTIONS AND ANSWERS 100%
SOLVED
,True or False: Data Storage is independent from compute? - ANSWERSTrue
True or False: All virtual warehouses have access to all data? - ANSWERSTrue
True or False: Al interactions with data are initialized through the services layer? -
ANSWERSTrue
True or False: Multi-Cluster Warehouses support high concurrency? - ANSWERSTrue
True or False: Warehouses can be dynamically expanded to adjust to workloads? -
ANSWERSTrue
Which layer provides centralized services for the data warehouse? - ANSWERSCloud
Services
Which layer contains virtual warehouses for data access? - ANSWERSQuery
Processing
Which layer contains the data in compressed, columnar format? - ANSWERSDatabase
Storage
True or False: Snowflake's security and authentication includes Multi-Factor
authentication? - ANSWERSTrue
True or False: Snowflake's security and authentication includes Snowflake Failures
alerts? - ANSWERSFalse
True or False: Snowflake's security and authentication includes data encryption using
Snowflake-managed keys? - ANSWERSFalse
True or False: Snowflake's security and authentication includes object-level access? -
ANSWERSTrue
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? - ANSWERSTrue
True or False: Snowflake's architecture includes advance capabilities in the cloud
services layer that delivers metadata service? - ANSWERSTrue
True or False: Snowflake's architecture includes advance capabilities in the cloud
services layer that delivers security and authentication control? - ANSWERSTrue
, True or False: Snowflake's architecture includes advance capabilities in the cloud
services layer that delivers query optimization? - ANSWERSTrue
True or False: Snowflake supports landing data into internal stage on the cloud storage
platform? - ANSWERSTrue
True or False: Snowflake supports landing data into external stage on the cloud storage
platform? - ANSWERSTrue
True or False: Snowflake supports landing data into bring your own device? -
ANSWERSFalse
True or False: Compute resources used by Snowflake for data loading jobs can by
provide by user managed virtual warehouse? - ANSWERSTrue
True or False: Compute resources used by Snowflake for data loading jobs can by
provide by Snowflake managed service? - ANSWERSTrue
True or False: Compute resources used by Snowflake for data loading jobs can by
provide by hardware provisioned by user directly from cloud providers? -
ANSWERSFalse
True or False: Stages are unique database objects in Snowflake? - ANSWERSTrue
True or False: Pipe are unique database objects in Snowflake? - ANSWERSTrue
True or False: Table are unique database objects in Snowflake? - ANSWERSFalse
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
C) Consider the practice of splitting input file batch within the recommended range of
10MB and 100MB?
D) All of the above - ANSWERSD) All of the above
True or False: Snowflake Support Services addresses customer issues covering
troubleshooting failed queries? - ANSWERSTrue
True or False: Snowflake Support Services addresses customer issues covering
product usage questions? - ANSWERSTrue
True or False: Snowflake Support Services addresses customer issues covering
individual query syntax improvement? - ANSWERSTrue
QUESTIONS AND ANSWERS 100%
SOLVED
,True or False: Data Storage is independent from compute? - ANSWERSTrue
True or False: All virtual warehouses have access to all data? - ANSWERSTrue
True or False: Al interactions with data are initialized through the services layer? -
ANSWERSTrue
True or False: Multi-Cluster Warehouses support high concurrency? - ANSWERSTrue
True or False: Warehouses can be dynamically expanded to adjust to workloads? -
ANSWERSTrue
Which layer provides centralized services for the data warehouse? - ANSWERSCloud
Services
Which layer contains virtual warehouses for data access? - ANSWERSQuery
Processing
Which layer contains the data in compressed, columnar format? - ANSWERSDatabase
Storage
True or False: Snowflake's security and authentication includes Multi-Factor
authentication? - ANSWERSTrue
True or False: Snowflake's security and authentication includes Snowflake Failures
alerts? - ANSWERSFalse
True or False: Snowflake's security and authentication includes data encryption using
Snowflake-managed keys? - ANSWERSFalse
True or False: Snowflake's security and authentication includes object-level access? -
ANSWERSTrue
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? - ANSWERSTrue
True or False: Snowflake's architecture includes advance capabilities in the cloud
services layer that delivers metadata service? - ANSWERSTrue
True or False: Snowflake's architecture includes advance capabilities in the cloud
services layer that delivers security and authentication control? - ANSWERSTrue
, True or False: Snowflake's architecture includes advance capabilities in the cloud
services layer that delivers query optimization? - ANSWERSTrue
True or False: Snowflake supports landing data into internal stage on the cloud storage
platform? - ANSWERSTrue
True or False: Snowflake supports landing data into external stage on the cloud storage
platform? - ANSWERSTrue
True or False: Snowflake supports landing data into bring your own device? -
ANSWERSFalse
True or False: Compute resources used by Snowflake for data loading jobs can by
provide by user managed virtual warehouse? - ANSWERSTrue
True or False: Compute resources used by Snowflake for data loading jobs can by
provide by Snowflake managed service? - ANSWERSTrue
True or False: Compute resources used by Snowflake for data loading jobs can by
provide by hardware provisioned by user directly from cloud providers? -
ANSWERSFalse
True or False: Stages are unique database objects in Snowflake? - ANSWERSTrue
True or False: Pipe are unique database objects in Snowflake? - ANSWERSTrue
True or False: Table are unique database objects in Snowflake? - ANSWERSFalse
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
C) Consider the practice of splitting input file batch within the recommended range of
10MB and 100MB?
D) All of the above - ANSWERSD) All of the above
True or False: Snowflake Support Services addresses customer issues covering
troubleshooting failed queries? - ANSWERSTrue
True or False: Snowflake Support Services addresses customer issues covering
product usage questions? - ANSWERSTrue
True or False: Snowflake Support Services addresses customer issues covering
individual query syntax improvement? - ANSWERSTrue
