Snowflake Certification
Study online at https://quizlet.com/_6ajnzq
1. True or False: Data Storage is independent from com- True
pute?
2. True or False: All virtual warehouses have access to all True
data?
3. True or False: Al interactions with data are initialized True
through the services layer?
4. True or False: Multi-Cluster Warehouses support high True
concurrency?
5. True or False: Warehouses can be dynamically ex- True
panded to adjust to workloads?
6. Which layer provides centralized services for the data Cloud Services
warehouse?
7. Which layer contains virtual warehouses for data ac- Query Processing
cess?
8. Which layer contains the data in compressed, colum- Database Storage
nar format?
9. True or False: Snowflake's security and authentication True
includes Multi-Factor authentication?
10. True or False: Snowflake's security and authentication False
includes Snowflake Failures alerts?
11. True or False: Snowflake's security and authentication False
includes data encryption using Snowflake-managed
keys?
, Snowflake Certification
Study online at https://quizlet.com/_6ajnzq
12. True or False: Snowflake's security and authentication True
includes object-level access?
13. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers transaction management for consistent opera-
tions on the same data at the same time?
14. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers metadata service?
15. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers security and authentication control?
16. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers query optimization?
17. True or False: Snowflake supports landing data into True
internal stage on the cloud storage platform?
18. True or False: Snowflake supports landing data into True
external stage on the cloud storage platform?
19. True or False: Snowflake supports landing data into False
bring your own device?
20. True or False: Compute resources used by Snowflake True
for data loading jobs can by provide by user managed
virtual warehouse?
21. True
, Snowflake Certification
Study online at https://quizlet.com/_6ajnzq
True or False: Compute resources used by Snowflake
for data loading jobs can by provide by Snowflake
managed service?
22. 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?
23. True or False: Stages are unique database objects in True
Snowflake?
24. True or False: Pipe are unique database objects in True
Snowflake?
25. True or False: Table are unique database objects in False
Snowflake?
26. 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
within the recommended range of 10MB and 100MB?
D) All of the above
27. True or False: Snowflake Support Services address- True
es customer issues covering troubleshooting failed
queries?
28. True or False: Snowflake Support Services addresses True
customer issues covering product usage questions?
, Snowflake Certification
Study online at https://quizlet.com/_6ajnzq
29. True or False: Snowflake Support Services addresses True
customer issues covering individual query syntax im-
provement?
30. True or False: Snowflake Support Services addresses False
customer issues covering 3rd party application config-
uration support?
31. Snowflake users with support contracts that have a B) Send email
Severity-1 issue should contact Snowflake in these
ways except:
A) Snowflake Lodge - set appropriate severity (1-4)
B) Send email
C) 844-SNOWFLAKE
32. True or False: The Snowflake Lodge is a community False
site that has technical information for Support Cus-
tomers only?
33. True or False: The Snowflake Lodge is a community True
site that is the recommend place to submit support
cases?
34. True or False: The Snowflake Lodge is a community True
site that contains the most up to date security alerts
and product release information?
35. True or False: The Snowflake Lodge is a community False
site that does not allow members to post questions?
36. Snowflake includes administration settings for re- A) Help control costs as-
source consumption in order to: sociated with unexpected
Study online at https://quizlet.com/_6ajnzq
1. True or False: Data Storage is independent from com- True
pute?
2. True or False: All virtual warehouses have access to all True
data?
3. True or False: Al interactions with data are initialized True
through the services layer?
4. True or False: Multi-Cluster Warehouses support high True
concurrency?
5. True or False: Warehouses can be dynamically ex- True
panded to adjust to workloads?
6. Which layer provides centralized services for the data Cloud Services
warehouse?
7. Which layer contains virtual warehouses for data ac- Query Processing
cess?
8. Which layer contains the data in compressed, colum- Database Storage
nar format?
9. True or False: Snowflake's security and authentication True
includes Multi-Factor authentication?
10. True or False: Snowflake's security and authentication False
includes Snowflake Failures alerts?
11. True or False: Snowflake's security and authentication False
includes data encryption using Snowflake-managed
keys?
, Snowflake Certification
Study online at https://quizlet.com/_6ajnzq
12. True or False: Snowflake's security and authentication True
includes object-level access?
13. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers transaction management for consistent opera-
tions on the same data at the same time?
14. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers metadata service?
15. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers security and authentication control?
16. True or False: Snowflake's architecture includes ad- True
vance capabilities in the cloud services layer that de-
livers query optimization?
17. True or False: Snowflake supports landing data into True
internal stage on the cloud storage platform?
18. True or False: Snowflake supports landing data into True
external stage on the cloud storage platform?
19. True or False: Snowflake supports landing data into False
bring your own device?
20. True or False: Compute resources used by Snowflake True
for data loading jobs can by provide by user managed
virtual warehouse?
21. True
, Snowflake Certification
Study online at https://quizlet.com/_6ajnzq
True or False: Compute resources used by Snowflake
for data loading jobs can by provide by Snowflake
managed service?
22. 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?
23. True or False: Stages are unique database objects in True
Snowflake?
24. True or False: Pipe are unique database objects in True
Snowflake?
25. True or False: Table are unique database objects in False
Snowflake?
26. 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
within the recommended range of 10MB and 100MB?
D) All of the above
27. True or False: Snowflake Support Services address- True
es customer issues covering troubleshooting failed
queries?
28. True or False: Snowflake Support Services addresses True
customer issues covering product usage questions?
, Snowflake Certification
Study online at https://quizlet.com/_6ajnzq
29. True or False: Snowflake Support Services addresses True
customer issues covering individual query syntax im-
provement?
30. True or False: Snowflake Support Services addresses False
customer issues covering 3rd party application config-
uration support?
31. Snowflake users with support contracts that have a B) Send email
Severity-1 issue should contact Snowflake in these
ways except:
A) Snowflake Lodge - set appropriate severity (1-4)
B) Send email
C) 844-SNOWFLAKE
32. True or False: The Snowflake Lodge is a community False
site that has technical information for Support Cus-
tomers only?
33. True or False: The Snowflake Lodge is a community True
site that is the recommend place to submit support
cases?
34. True or False: The Snowflake Lodge is a community True
site that contains the most up to date security alerts
and product release information?
35. True or False: The Snowflake Lodge is a community False
site that does not allow members to post questions?
36. Snowflake includes administration settings for re- A) Help control costs as-
source consumption in order to: sociated with unexpected
