SnowPro Core Practice Test

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

Question 66

Which of the following objects is not covered by Time Travel?

  1. Tables
  2. Schemas
  3. Databases
  4. Stages

Question 67

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  1. True
  2. False

Question 68

Which of the following commands are not blocking operations? (Choose two.)

  1. UPDATE
  2. INSERT
  3. MERGE
  4. COPY

Question 69

Which of the following is true of Snowpipe via REST API? (Choose two.)

  1. You can only use it on Internal Stages
  2. All COPY INTO options are available during pipe creation
  3. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands
  4. Snowpipe keeps track of which files it has loaded

Question 70

Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

  1. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
  2. SECURITYADMIN, ACCOUNTADMIN, SYSADMIN
  3. SECURITYADMIN, ACCOUNTADMIN
  4. ACCOUNTADMIN