Snowflake COF-R02 Practice Test - Questions Answers, Page 5
List of questions
Related questions
Question 41

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Question 42

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html
Question 43

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html
Question 44

The Query History in the Snowflake Web Interface (UI) is kept for approximately:
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html
Question 45

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
Question 46

Which of the following terms best describes Snowflake’s database architecture?
Explanation:
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.
Question 47

Which of the following objects is not covered by Time Travel?
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html
Question 48

When can a Virtual Warehouse start running queries?
Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Question 49

True or False: Pipes can be suspended and resumed.
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:
Question 50

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html
Question