WITH 100% ACCURATE SOLUTIONS
True or False: Data Storage is independent from compute? - ✅✅✅CORRECT -True
True or False: All virtual warehouses have access to all data? - ✅✅✅CORRECT -True
True or False: Al interactions with data are initialized through the services layer? - ✅✅✅CORRECT -
True
True or False: Multi-Cluster Warehouses support high concurrency? - ✅✅✅CORRECT -True
True or False: Warehouses can be dynamically expanded to adjust to workloads? - ✅✅✅CORRECT -
True
Which layer provides centralized services for the data warehouse? - ✅✅✅CORRECT -Cloud Services
Which layer contains virtual warehouses for data access? - ✅✅✅CORRECT -Query Processing
Which layer contains the data in compressed, columnar format? - ✅✅✅CORRECT -Database Storage
True or False: Snowflake's security and authentication includes Multi-Factor authentication? -
✅✅✅CORRECT -True
True or False: Snowflake's security and authentication includes Snowflake Failures alerts? -
✅✅✅CORRECT -False
True or False: Snowflake's security and authentication includes data encryption using Snowflake-
managed keys? - ✅✅✅CORRECT -False
,True or False: Snowflake's security and authentication includes object-level access? - ✅✅✅CORRECT
-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 -True
True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that
delivers metadata service? - ✅✅✅CORRECT -True
True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that
delivers security and authentication control? - ✅✅✅CORRECT -True
True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that
delivers query optimization? - ✅✅✅CORRECT -True
True or False: Snowflake supports landing data into internal stage on the cloud storage platform? -
✅✅✅CORRECT -True
True or False: Snowflake supports landing data into external stage on the cloud storage platform? -
✅✅✅CORRECT -True
True or False: Snowflake supports landing data into bring your own device? - ✅✅✅CORRECT -False
True or False: Compute resources used by Snowflake for data loading jobs can by provide by user
managed virtual warehouse? - ✅✅✅CORRECT -True
True or False: Compute resources used by Snowflake for data loading jobs can by provide by Snowflake
managed service? - ✅✅✅CORRECT -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 -False
,True or False: Stages are unique database objects in Snowflake? - ✅✅✅CORRECT -True
True or False: Pipe are unique database objects in Snowflake? - ✅✅✅CORRECT -True
True or False: Table are unique database objects in Snowflake? - ✅✅✅CORRECT -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
C) Consider the practice of splitting input file batch within the recommended range of 10MB and
100MB?
D) All of the above - ✅✅✅CORRECT -D) All of the above
True or False: Snowflake Support Services addresses customer issues covering troubleshooting failed
queries? - ✅✅✅CORRECT -True
True or False: Snowflake Support Services addresses customer issues covering product usage questions?
- ✅✅✅CORRECT -True
True or False: Snowflake Support Services addresses customer issues covering individual query syntax
improvement? - ✅✅✅CORRECT -True
True or False: Snowflake Support Services addresses customer issues covering 3rd party application
configuration support? - ✅✅✅CORRECT -False
Snowflake users with support contracts that have a Severity-1 issue should contact Snowflake in these
ways except:
, A) Snowflake Lodge - set appropriate severity (1-4)
B) Send email
C) 844-SNOWFLAKE - ✅✅✅CORRECT -B) Send email
True or False: The Snowflake Lodge is a community site that has technical information for Support
Customers only? - ✅✅✅CORRECT -False
True or False: The Snowflake Lodge is a community site that is the recommend place to submit support
cases? - ✅✅✅CORRECT -True
True or False: The Snowflake Lodge is a community site that contains the most up to date security alerts
and product release information? - ✅✅✅CORRECT -True
True or False: The Snowflake Lodge is a community site that does not allow members to post questions?
- ✅✅✅CORRECT -False
Snowflake includes administration settings for resource consumption in order to:
A) Help control costs associated with unexpected credit usage of warehouses
B) Manage access to data warehouse for specified users
C) Maintain availability - ✅✅✅CORRECT -A) Help control costs associated with unexpected credit
usage of warehouses
True or False: Create Role can be granted within a Snowflake account by the administrator? -
✅✅✅CORRECT -True
True or False: Drop Role can be granted within a Snowflake account by the administrator? -
✅✅✅CORRECT -True
True or False: Create User permission can be granted within a Snowflake account by the administrator? -
✅✅✅CORRECT -True