SnowPro Core Practice Test

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

Question 116

True or False: Once created, a micro-partition will never be changed.

  1. True
  2. False

Question 117

What services does Snowflake automatically provide for customers that they may have been responsible for with their on-premise system? (Choose all that apply.)

  1. Installing and configuring hardware
  2. Patching software
  3. Physical security
  4. Maintaining metadata and statistics

Question 118

Which of the following statements would be used to export/unload data from Snowflake?

  1. COPY INTO @stage
  2. EXPORT TO @stage
  3. INSERT INTO @stage
  4. EXPORT_TO_STAGE(stage => @stage, select => 'select * from t1');

Question 119

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

  1. True
  2. False

Question 120

How would you determine the size of the virtual warehouse used for a task?

  1. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
  2. Querying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
  3. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
  4. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule