Pre-Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

COF-C02 SnowPro Core Certification Exam is now Stable and With Pass Result | Test Your Knowledge for Free

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-C02
  5. SnowPro Core Certification Exam
Exams4sure Dumps

COF-C02 Practice Questions

SnowPro Core Certification Exam

Last Update 2 days ago
Total Questions : 948

Dive into our fully updated and stable COF-C02 practice test platform, featuring all the latest SnowPro Core Certification exam questions added this week. Our preparation tool is more than just a Snowflake study aid; it's a strategic advantage.

Our free SnowPro Core Certification practice questions crafted to reflect the domains and difficulty of the actual exam. The detailed rationales explain the 'why' behind each answer, reinforcing key concepts about COF-C02. Use this test to pinpoint which areas you need to focus your study on.

COF-C02 PDF

COF-C02 PDF (Printable)
$43.75
$124.99
 Add to Cart

COF-C02 Testing Engine

COF-C02 PDF (Printable)
$50.75
$144.99
 Add to Cart

COF-C02 PDF + Testing Engine

COF-C02 PDF (Printable)
$63.7
$181.99
 Add to Cart
Question # 61

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Options:

A.  

External Tokenization

B.  

External Tables

C.  

Materialized Views

D.  

User-Defined Table Functions (UDTF)

Discussion 0
Question # 62

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

Options:

A.  

1 second

B.  

60 seconds

C.  

5 minutes

D.  

60 minutes

Discussion 0
Question # 63

Which statement is true about running tasks in Snowflake?

Options:

A.  

A task can be called using a CALL statement to run a set of predefined SQL commands.

B.  

A task allows a user to execute a single SQL statement/command using a predefined schedule.

C.  

A task allows a user to execute a set of SQL commands on a predefined schedule.

D.  

A task can be executed using a SELECT statement to run a predefined SQL command.

Discussion 0
Question # 64

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

Question # 64

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Options:

A.  

select src:dealership from car_sales;

B.  

select src.dealership from car_sales;

C.  

select src:Dealership from car_sales;

D.  

select dealership from car_sales;

Discussion 0
Question # 65

What COPY INTO SQL command should be used to unload data into multiple files?

Options:

A.  

SINGLE=TRUE

B.  

MULTIPLE=TRUE

C.  

MULTIPLE=FALSE

D.  

SINGLE=FALSE

Discussion 0
Question # 66

What type of query benefits the MOST from search optimization?

Options:

A.  

A query that uses only disjunction (i.e., OR) predicates

B.  

A query that includes analytical expressions

C.  

A query that uses equality predicates or predicates that use IN

D.  

A query that filters on semi-structured data types

Discussion 0
Question # 67

What are supported file formats for unloading data from Snowflake? (Choose three.)

Options:

A.  

XML

B.  

JSON

C.  

Parquet

D.  

ORC

E.  

AVRO

F.  

CSV

Discussion 0
Question # 68

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Options:

A.  

INSERT

B.  

PUT

C.  

GET

D.  

COPY

Discussion 0
Question # 69

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Options:

A.  

10-50 MB

B.  

100-250 MB

C.  

300-500 MB

D.  

1000-1500 MB

Discussion 0
Question # 70

Users are responsible for data storage costs until what occurs?

Options:

A.  

Data expires from Time Travel

B.  

Data expires from Fail-safe

C.  

Data is deleted from a table

D.  

Data is truncated from a table

Discussion 0
Question # 71

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

Options:

A.  

30 days

B.  

7 days

C.  

48 hours

D.  

24 hours

Discussion 0
Question # 72

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

Options:

A.  

Amazon Web Services

B.  

Docker

C.  

IBM Cloud

D.  

Microsoft Azure Cloud

E.  

Google Cloud Platform

F.  

Oracle Cloud

Discussion 0
Question # 73

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Options:

A.  

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.  

An error will occur, as views with qualified references cannot be cloned.

C.  

An error will occur, as stored objects cannot be cloned.

D.  

The stored procedures and views will refer to tables in the source database.

Discussion 0
Question # 74

When loading data into Snowflake, how should the data be organized?

Options:

A.  

Into single files with 100-250 MB of compressed data per file

B.  

Into single files with 1-100 MB of compressed data per file

C.  

Into files of maximum size of 1 GB of compressed data per file

D.  

Into files of maximum size of 4 GB of compressed data per file

Discussion 0
Question # 75

Which of the following significantly improves the performance of selective point lookup queries on a table?

Options:

A.  

Clustering

B.  

Materialized Views

C.  

Zero-copy Cloning

D.  

Search Optimization Service

Discussion 0
Question # 76

How can a row access policy be applied to a table or a view? (Choose two.)

Options:

A.  

Within the policy DDL

B.  

Within the create table or create view DDL

C.  

By future APPLY for all objects in a schema

D.  

Within a control table

E.  

Using the command ALTER ADD ROW ACCESS POLICY ;

Discussion 0