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

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

$43.75
~~$124.99~~

Add to Cart

COF-C02 Testing Engine

$50.75
~~$144.99~~

Add to Cart

COF-C02 PDF + Testing Engine

$63.7
~~$181.99~~

Add to Cart

Question # 21

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

Options:

The ability to scale up warehouses

The use of warehouse auto scaling

The ability to resize warehouses

Use of multi-clustered warehouses

The use of warehouse indexing

Discussion 0

Question # 22

What happens when a cloned table is replicated to a secondary database? (Select TWO)

Options:

A read-only copy of the cloned tables is stored.

The replication will not be successful.

The physical data is replicated

Additional costs for storage are charged to a secondary account

Metadata pointers to cloned tables are replicated

Discussion 0

Question # 23

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

Options:

True

False

Discussion 0

Question # 24

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through SQL commands

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

Discussion 0

Question # 25

Which Snowflake partner specializes in data catalog solutions?

Options:

Alation

DataRobot

dbt

Tableau

Discussion 0

Question # 26

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Options:

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

Discussion 0

Question # 27

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Options:

Compute Credits = 50 Credits Cloud Services = 10

Compute Credits = 80 Credits Cloud Services = 5

Compute Credits = 10 Credits Cloud Services = 9

Compute Credits = 120 Credits Cloud Services = 10

Compute Credits = 200 Credits Cloud Services = 26

Discussion 0

Question # 28

What is the minimum Snowflake edition required to create a materialized view?

Options:

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

Discussion 0

Question # 29

Which of the following objects can be shared through secure data sharing?

Options:

Masking policy

Stored procedure

Task

External table

Discussion 0

Question # 30

User-level network policies can be created by which of the following roles? (Select TWO).

Options:

ROLEADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

USERADMIN

Discussion 0

Question # 31

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Options:

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Columns can be reordered

Columns can be omitted

Row level access can be defined

Discussion 0

Question # 32

Which feature is only available in the Enterprise or higher editions of Snowflake?

Options:

Column-level security

SOC 2 type II certification

Multi-factor Authentication (MFA)

Object-level access control

Discussion 0

Question # 33

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

Options:

True

False

Discussion 0

Question # 34

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

Options:

The primary cluster in the virtual warehouse

The entire virtual warehouse

The database in which the virtual warehouse resides

The Queries currently being run on the virtual warehouse

Discussion 0

Question # 35

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Options:

Compute layer

Storage layer

Cloud infrastructure layer

Cloud services layer

Discussion 0

Question # 36

True or False: Fail-safe can be disabled within a Snowflake account.

Options:

True

False

Discussion 0

Question # 37

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

Options:

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Discussion 0

Question # 38

Which of the following commands cannot be used within a reader account?

Options:

CREATE SHARE

ALTER WAREHOUSE

DROP ROLE

SHOW SCHEMAS

DESCRBE TABLE

Discussion 0

Question # 39

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

Options:

Use data encryption.

Use dynamic data masking.

Use secure materialized views.

Revoke all roles for functional managers and end users.

Discussion 0

Question # 40

What is the minimum Snowflake edition required for row level security?

Options:

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Discussion 0

Get COF-C02 dumps and pass your exam in 24 hours!

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

COF-C02 Practice Questions

COF-C02 PDF

COF-C02 Testing Engine

COF-C02 PDF + Testing Engine

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Options:

Answer:

Explanation:

Options:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Options:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Free Exams Sample Questions

We Accept

Secure Site

Customer Review

Money Back Guarantee