SnowPro Core Practice Test

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

Question 156

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

  1. External Tokenization
  2. External Tables
  3. Materialized Views
  4. User-Defined Table Functions (UDTF)

Question 157

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no queries have been executed previously? (Choose three.)

  1. MIN(<< column value >>)
  2. COPY
  3. SUM(<< column value >>)
  4. UPDATE

Question 158

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  1. VIEWS_HISTORY
  2. OBJECT_HISTORY
  3. ACCESS_HISTORY
  4. LOGIN_HISTORY

Question 159

Which feature is only available in the Enterprise or higher editions of Snowflake?

  1. Column-level security
  2. SOC 2 type II certification
  3. Multi-factor Authentication (MFA)
  4. Object-level access control

Question 160

Will data cached in a warehouse be lost when the warehouse is resized?

  1. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
  2. Yes, because the compute resource is replaced in its entirety with a new compute resource.
  3. No, because the size of the cache is independent from the warehouse size.
  4. Yes, because the new compute resource will no longer have access to the cache encryption key.