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.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator
 
 


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
Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html



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
Correct Answer: A
You can experiment the same with snowflake UI.



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
Correct Answer: C



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
Correct Answer: ABC



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
Correct Answer: A
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html



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
Correct Answer: A



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

  • A: True
  • B: False
Correct Answer: B
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216
(16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.



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

  • A: True
  • B: False
Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-asuspended-warehouse



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
Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html



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
Correct Answer: AC
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html






CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset