Snowflake Certification V2 Questions and Answers Already Passed

Snowflake Certification V2 Questions and Answers Already Passed True or False: Data Storage is independent from compute? True True or False: All virtual warehouses have access to all data? True True or False: All interactions with data are initialized through the services layer? True True or False: Multi-Cluster Warehouses support high concurrency? True True or False: Warehouses can be dynamically expanded to adjust to workloads? True Which layer provides centralized services for the data warehouse? Cloud Services Which layer contains virtual warehouses for data access? Query Processing Which layer contains the data in compressed, columnar format? Database Storage True or False: Snowflake's security and authentication includes Multi-Factor authentication? True True or False: Snowflake's security and authentication includes Snowflake Failures alerts? False True or False: Snowflake's security and authentication includes data encryption using Snowflake-managed keys? False True or False: Snowflake's security and authentication includes object-level access? 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? True True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that delivers metadata service? True True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that delivers security and authentication control? True True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that delivers query optimization? True True or False: Snowflake supports landing data into an internal stage on the cloud storage platform? True True or False: Snowflake supports landing data into an external stage on the cloud storage platform? True True or False: Snowflake supports landing data into a bring-your-own-device? False True or False: Compute resources used by Snowflake for data loading jobs can be provided by a user-managed virtual warehouse? True True or False: Compute resources used by Snowflake for data loading jobs can be provided by Snowflake-managed service? True True or False: Compute resources used by Snowflake for data loading jobs can be provided by hardware provisioned by a user directly from cloud providers? False True or False: Stages are unique database objects in Snowflake? True True or False: Pipes are unique database objects in Snowflake? True 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