Free COF-C03 – SnowPro Core Certification Practice Test Question

Select an option, then click Submit answer.

• ○

  1 day

• ○

  7 days

• ○

  45 days

• ○

  90 days
  

Select an option, then click Submit answer.

• ○

  True

• ○

  False
  

Select an option, then click Submit answer.

• ○

  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

• ○

  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

• ○

  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

• ○

  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
  

Select all that apply, then click Submit answer.

• ○

  Users

• ○

  Tables

• ○

  Databases

• ○

  Internal Stages
  

Select an option, then click Submit answer.

• ○

  CSV

• ○

  JSON

• ○

  Parquet

• ○

  XML
  

Select an option, then click Submit answer.

• ○

  True

• ○

  False
  

Select an option, then click Submit answer.

• ○

  True

• ○

  False
  

Select an option, then click Submit answer.

• ○

  True

• ○

  False
  

Select an option, then click Submit answer.

• ○

  True

• ○

  False
  

Select all that apply, then click Submit answer.

• ○

  Via the Snowflake Web Interface (Ul)

• ○

  Via the data_share=true parameter

• ○

  Via SQL commands

• ○

  Via Virtual Warehouses