SnowPro Core Practice Test

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

Question 11

True or False: The COPY command must specify a File Format in order to execute.

  1. True
  2. False

Question 12

Which of the following commands sets the Virtual Warehouse for a session?

  1. COPY WAREHOUSE FROM <<config file>>;
  2. SET WAREHOUSE = <<warehouse name>>;
  3. USE WAREHOUSE <<warehouse name>>;
  4. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Question 13

Which of the following objects can be cloned? (Choose four.)

  1. Tables
  2. Named File Formats
  3. Schemas
  4. Shares
  5. Databases
  6. Users

Question 14

Which object allows you to limit the number of credits consumed within a Snowflake account?

  1. Account Usage Tracking
  2. Resource Monitor
  3. Warehouse Limit Parameter
  4. Credit Consumption Tracker

Question 15

Snowflake is designed for which type of workloads? (Choose two.)

  1. OLAP (Analytics) workloads
  2. OLTP (Transactional) workloads
  3. Concurrent workloads
  4. On-premise workloads