SnowPro Core Practice Test

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

Question 146

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

  1. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
  2. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
  3. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
  4. A user cannot specify a default warehouse when using the ODBC driver.
  5. The default virtual warehouse size can be changed at any time.

Question 147

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

  1. INSERT
  2. PUT
  3. GET
  4. COPY

Question 148

The Snowflake Cloud Data Platform is described as having which of the following architectures?

  1. Shared-disk
  2. Shared-nothing
  3. Multi-cluster shared data
  4. Serverless query engine

Question 149

Which of the following is a data tokenization integration partner?

  1. Protegrity
  2. Tableau
  3. DBeaver
  4. SAP

Question 150

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

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