Free COF-R02 Exam Braindumps (page: 19)

Page 18 of 83

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

  1. True
  2. False

Answer(s): A

Explanation:

You can experiment the same with snowflake UI.



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

Answer(s): C



The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

  1. Users
  2. Tables
  3. Databases
  4. Internal Stages

Answer(s): A,B,C



What is the default File Format used in the COPY command if one is not specified?

  1. CSV
  2. JSON
  3. Parquet
  4. XML

Answer(s): A


Reference:

https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts