Snowflake COF-R02 Practice Test - Questions Answers, Page 2
List of questions
Related questions
Question 11

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.
Explanation:
Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/
Question 12

Which of the following are options when creating a Virtual Warehouse?
Question 13

Which of the following DML commands isn’t supported by Snowflake?
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html
Question 14

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/connecting.html
Question 15

Which of the following are true of multi-cluster Warehouses? Select all that apply below.
Question 16

What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers
Question 17

True or False: Snowflake charges a premium for storing semi-structured data.
Explanation:
Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/doessnowflakechargespremium-for-storing-semi-structured-data
Question 18

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
Explanation:
Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance
Question 19

True or False: A single database can exist in more than one Snowflake account.
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html
Question 20

Which of the following roles is recommended to be used to create and manage users and roles?
Explanation:
https://docs.snowflake.com/en/user-guide/security-access-control-overview.html"Security admin: Role that can manage any object grant globally, as well as create, monitor, andmanage users and roles"
Question