Snowflake COF-R02 Practice Test - Questions Answers, Page 4
List of questions
Related questions
Question 31

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
Question 32

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Question 33

The PUT command: (Choose two.)
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html
Question 34

Which interfaces can be used to create and/or manage Virtual Warehouses?
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
Question 35

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history
"When a pipe is recreated, the load history is dropped."
Question 36

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
Question 37

True or False: It is possible to load data into Snowflake without creating a named File Format object.
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-fileformat.html
Question 38

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
Question 39

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
Question 40

Which of the following statements are true of Snowflake releases: (Choose two.)
Explanation:
https://docs.snowflake.com/en/user-guide/intro-releases.html
Question