Download SnowPro Core Certification.VCEPlus.COF-C02.2023-01-08.1e.30q.vcex

Download Exam

File Info

Exam SnowPro Core Certification
Number COF-C02
File Name SnowPro Core Certification.VCEPlus.COF-C02.2023-01-08.1e.30q.vcex
Size 21 Kb
Posted January 08, 2023
Downloads 9

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Coupon: EXAM_HUB

Discount: 20%


Demo Questions

Question 1
The fail-safe retention period is how many days?

  • A: 1 day
  • B: 7 days
  • C: 45 days
  • D: 90 days

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

  • A: True
  • B: False

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

  • A: 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
  • B: 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
  • C: 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
  • D: 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

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

  • A: Users
  • B: Tables
  • C: Databases
  • D: Internal Stages

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

  • A: CSV
  • B: JSON
  • C: Parquet
  • D: XML

Question 6
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  • A: True
  • B: False

Question 7
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

  • A: True
  • B: False

Question 8
True or False: A Virtual Warehouse can be resized while suspended.

  • A: True
  • B: False

Question 9
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

  • A: True
  • B: False

Question 10
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

  • A: Via the Snowflake Web Interface (Ul)
  • B: Via the data_share=true parameter
  • C: Via SQL commands
  • D: Via Virtual Warehouses



You can buy ProfExam with a 20% discount..

Get Now!


Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen


Use VCE Exam Simulator to open VCE files