SNOWFLAKE CERTIFICATION EXAM QUESTIONS AND ANSWERS 100% SOLVED

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