Snowflake Certification
Study online at https://quizlet.com/_c5v0jm
1. Data Storage is _______ from compute (1) independent
2. COMPUTE clusters are predefined by _______ and AWS and Azure
________ cloud services
3. True or False: True
The SYSADMIN role is managed by the ACCOUNTAD-
MIN role.
4. True or False: True
All virtual warehouses have access to all data?
5. True or False: All interactions with data are initialized True
through the services layer?
6. True or False: True
Multi-Cluster Warehouses support high concurrency?
7. True or False: Warehouses can be dynamically ex- True
panded to adjust to workloads?
8. Which layer provides centralized services for the data Cloud Services
warehouse?
9. Which layer contains virtual warehouses for data ac- Query Processing
cess?
10. Which layer contains the data in compressed, colum- Database Storage
nar format?
11. True or False: Snowflake's security and authentication True
includes Multi-Factor authentication?
, Snowflake Certification
Study online at https://quizlet.com/_c5v0jm
12. True or False: Snowflake's security and authentication False
includes Snowflake Failures alerts?
13. True or False: Snowflake's security and authentication False
includes data encryption using Snowflake-managed
keys?
14. True or False: Snowflake's security and authentication True
includes object-level access?
15. Snowflake delivers transaction management for con- Same
sistent operations on the______data at the____ time
16. True or False: True
Snowflake's cloud services layer delivers metadata
service
17. True or False: True
Snowflake's cloud services delivers security and au-
thentication control.
18. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers query optimization?
19. True or False: Snowflake supports landing data into True
internal stage on the cloud storage platform?
20. True or False: Snowflake supports landing data into True
external stage on the cloud storage platform?
21. False
, Snowflake Certification
Study online at https://quizlet.com/_c5v0jm
True or False: Snowflake supports landing data into
bring your own device?
22. True or False: Compute resources used by Snowflake True
for data loading jobs can by provide by user managed
virtual warehouse?
23. Compute resources used by Snowflake for data load- managed service
ing jobs can be provided by Snowflake _________
__________ (2)
24. True or False: Compute resources used by Snowflake False
for data loading jobs can by provide by hardware pro-
visioned by user directly from cloud providers?
25. True or False: Stages are unique database objects in True
Snowflake?
26. __________ are unique database objects in Snowflake Pipe
(1)
27. True or False: False
Table are unique database objects in Snowflake
28. Which approach would result in improved perfor- D) All of the above
mance through linear scaling of data ingestion work-
load:
A) Resize virtual warehouse
B) Consider the practice of organizing data by granu-
lar path
C) Consider the practice of splitting input file batch
, Snowflake Certification
Study online at https://quizlet.com/_c5v0jm
within the recommended range of 10MB and 100MB
D) All of the above
29. True or False: Snowflake Support Services address- True
es customer issues covering troubleshooting failed
queries?
30. True or False: Snowflake Support Services addresses True
customer issues covering product usage questions?
31. True or False: Snowflake Support Services addresses True
customer issues covering individual query syntax im-
provement?
32. True or False: False
Snowflake Support Services issues covering 3rd party
application configuration support
33. Users w/ support contracts that have a Severity-1 is- B) Send email
sue should contact Snowflake in these ways except:
A) Snowflake Lodge - set appropriate severity (1-4)
B) Send email
C) 844-SNOWFLAKE
34. True or False: The Snowflake Lodge is a community False
site that has technical information for Support Cus-
tomers only
35. True or False: The Snowflake Lodge is a community True
site that is the recommend place to submit support
cases?
Study online at https://quizlet.com/_c5v0jm
1. Data Storage is _______ from compute (1) independent
2. COMPUTE clusters are predefined by _______ and AWS and Azure
________ cloud services
3. True or False: True
The SYSADMIN role is managed by the ACCOUNTAD-
MIN role.
4. True or False: True
All virtual warehouses have access to all data?
5. True or False: All interactions with data are initialized True
through the services layer?
6. True or False: True
Multi-Cluster Warehouses support high concurrency?
7. True or False: Warehouses can be dynamically ex- True
panded to adjust to workloads?
8. Which layer provides centralized services for the data Cloud Services
warehouse?
9. Which layer contains virtual warehouses for data ac- Query Processing
cess?
10. Which layer contains the data in compressed, colum- Database Storage
nar format?
11. True or False: Snowflake's security and authentication True
includes Multi-Factor authentication?
, Snowflake Certification
Study online at https://quizlet.com/_c5v0jm
12. True or False: Snowflake's security and authentication False
includes Snowflake Failures alerts?
13. True or False: Snowflake's security and authentication False
includes data encryption using Snowflake-managed
keys?
14. True or False: Snowflake's security and authentication True
includes object-level access?
15. Snowflake delivers transaction management for con- Same
sistent operations on the______data at the____ time
16. True or False: True
Snowflake's cloud services layer delivers metadata
service
17. True or False: True
Snowflake's cloud services delivers security and au-
thentication control.
18. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers query optimization?
19. True or False: Snowflake supports landing data into True
internal stage on the cloud storage platform?
20. True or False: Snowflake supports landing data into True
external stage on the cloud storage platform?
21. False
, Snowflake Certification
Study online at https://quizlet.com/_c5v0jm
True or False: Snowflake supports landing data into
bring your own device?
22. True or False: Compute resources used by Snowflake True
for data loading jobs can by provide by user managed
virtual warehouse?
23. Compute resources used by Snowflake for data load- managed service
ing jobs can be provided by Snowflake _________
__________ (2)
24. True or False: Compute resources used by Snowflake False
for data loading jobs can by provide by hardware pro-
visioned by user directly from cloud providers?
25. True or False: Stages are unique database objects in True
Snowflake?
26. __________ are unique database objects in Snowflake Pipe
(1)
27. True or False: False
Table are unique database objects in Snowflake
28. Which approach would result in improved perfor- D) All of the above
mance through linear scaling of data ingestion work-
load:
A) Resize virtual warehouse
B) Consider the practice of organizing data by granu-
lar path
C) Consider the practice of splitting input file batch
, Snowflake Certification
Study online at https://quizlet.com/_c5v0jm
within the recommended range of 10MB and 100MB
D) All of the above
29. True or False: Snowflake Support Services address- True
es customer issues covering troubleshooting failed
queries?
30. True or False: Snowflake Support Services addresses True
customer issues covering product usage questions?
31. True or False: Snowflake Support Services addresses True
customer issues covering individual query syntax im-
provement?
32. True or False: False
Snowflake Support Services issues covering 3rd party
application configuration support
33. Users w/ support contracts that have a Severity-1 is- B) Send email
sue should contact Snowflake in these ways except:
A) Snowflake Lodge - set appropriate severity (1-4)
B) Send email
C) 844-SNOWFLAKE
34. True or False: The Snowflake Lodge is a community False
site that has technical information for Support Cus-
tomers only
35. True or False: The Snowflake Lodge is a community True
site that is the recommend place to submit support
cases?
