CertsTopics Logo

Summer Certification Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Pass Using COF-C03 Exam Dumps

Page: 15 / 84
Total 1160 questions
Get COF-C03 Full Access Download COF-C03 PDF

SnowPro Core Certification 2026 Exam Questions and Answers

Question 57

What are type predicates used for?

Options:

A.

Extracting data from a variant column

B.

Casting a value in a variant column to a particular data type

C.

Determining if a value in a variant column is a particular data type

D.

Manipulating objects and arrays in a VARIANT column

Question 58

A user notices that query performance has decreased. The virtual warehouses appear to be properly sized and are functioning correctly. The user suspects the issue lies within the services responsible for query planning and access validation. Which components of Snowflake architecture would be involved in diagnosing or optimizing this issue? Select TWO.

Options:

A.

The services handling authentication and access control.

B.

The services managing data loading and ETL operations.

C.

The services controlling warehouse scaling and suspension.

D.

The services managing data micro-partitioning and file storage.

E.

The services responsible for query parsing and optimization.

Question 59

What privileges are required to allow role RL_CUST_WH to start warehouse CUST_WH?

Options:

A.

GRANT OPERATE ON CUST_WH TO ROLE RL_CUST_WH;

B.

GRANT CREATE WAREHOUSES ON ACCOUNT TO ROLE RL_CUST_WH;

C.

GRANT MANAGE WAREHOUSES ON ACCOUNT TO ROLE RL_CUST_WH;

D.

GRANT USAGE ON CUST_WH TO ROLE RL_CUST_WH;

Question 60

How can a Data Exchange Administrator provide a user with account access to a Data Exchange?

Options:

A.

Grant the user the USERADMIN role.

B.

Add the user to the Data Exchange.

C.

Enable the IMPORT SHARE privilege and grant this privilege to the user.

D.

Create a new database for the Data Exchange and provide access to the user.

Page: 15 / 84
Total 1160 questions
Get COF-C03 Full Access Download COF-C03 PDF