SnowPro Core Practice Test

SnowPro Core Practice Test practice questions, page 34 of 54, with answer review and explanations.

Question 166

How does Snowflake Fail-safe protect data in a permanent table?

  1. Fail-safe makes data available up to 1 day, recoverable by user operations.
  2. Fail-safe makes data available for 7 days, recoverable by user operations.
  3. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
  4. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Question 167

A virtual warehouse is created using the following command: Create warehouse my_WH with - warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true; The image below is a graphical representation of the warehouse utilization across two days. What action should be taken to address this situation?

  1. Increase the warehouse size from Medium to 2XL.
  2. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
  3. Configure the warehouse to a multi-cluster warehouse.
  4. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Question 168

Which minimum Snowflake edition allows for a dedicated metadata store?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake

Question 169

Network policies can be set at which Snowflake levels? (Choose two.)

  1. Role
  2. Schema
  3. User
  4. Database
  5. Account
  6. Tables

Question 170

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  1. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
  2. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
  3. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
  4. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
  5. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
  6. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.