Snowflake COF-C03 Practice Questions

You have shared a table with another Snowflake account. A user in the consumer account has executed a query on the shared table. Who will be charged for the query cost?

Consumer

Producer (the account which shared the data)

check_circle

Correct AnswerA

When data is shared with another Snowflake account, the consumer account executing the query is charged for the compute cost.

https://docs.snowflake.net/manuals/user-guide/data-sharing-intro.html#how-does-secure-data-sharing-work

Question 12

What is the minimum Snowflake edition in which Federated Authentication & MFA are available?

Enterprise

Standard

Business Critical

check_circle

Correct AnswerB

Federated Authentication & MFA are available in all editions, therefore the minimum edition is Standard where these functionalities are available.

Please see also https://www.snowflake.com/pricing/

Question 13

On the WebUI which button on the top bar should you select to run queries?

History

Databases

Virtual Warehouses

Worksheets

Account

check_circle

Correct AnswerE

Worksheets button will take you to the interface where you can create 1 or more worksheets in which you can edit & execute SQL queries.

Question 14

A virtual warehouse must be running in order to process SQL queries. For which type of queries results may be produced without requiring a running virtual warehouse?

Select all that apply

Select All that Apply

for queries for which results can be fulfilled from the metadata cache

for queries that have previously run and their results are stored in the result cache

for queries that make use of clustering keys

for queries that process less then 10 MB of data

check_circle

Correct AnswersB, C

Queries, for which results can be fulfilled from cache do not require a virtual warehouse. The cache could be result cache, metadata cache

Question 15

Which of the following simple transformations can be used while loading data through the COPY command?

Select all that apply

Pivot

Truncate

Re-order Columns

Cast

Omit Columns

Transpose

check_circle

Correct AnswersB, C, D, E

You can perform basic transformations such as column re-ordering, column omission, cast data types & truncating text data while load it through the COPY command

Question 16

A Small virtual warehouse (comprising of 2 servers) executing for 2 hours will consume same number of credits as a Medium virtual warehouse (comprising of 4 servers) executing for 1 hour.

TRUE

FALSE

check_circle

Correct AnswerA

Correct. With a larger size the credit consumption is more. In the given example it is exactly double.

Question 17

The COPY command can load data from which of the following?

Select all that apply

Detachable hard disks

Internal stage

Tape drives

External Stage i.e. Cloud Storage

check_circle

Correct AnswersB, D

The COPY command can load data from external stages i.e. Snowflake Stage defined on data already present in Cloud Storage. It can also load data from a Snowflake Internal stage

Question 18

The provider of data can add multiple databases in a Share definition.

FALSE

TRUE

check_circle

Correct AnswerA

Incorrect. Only one database can be added to a share. However multiple schemas, tables and views can be added to a share.

Question 19

Snowflake UDFs can be written in which of the following languages?

Select all that apply

JAVA

PYTHON

JAVASCRIPT

SQL

check_circle

Correct AnswersC, D

Snowflake UDFs can be written in JavaScript or SQL

https://docs.snowflake.net/manuals/sql-reference/user-defined-functions.html

Question 20

A virtual warehouse can be resized any time, regardless if it is in suspended state or active and executing queries.

FALSE

TRUE

check_circle

Correct AnswerB

Correct, a virtual warehouse can be resized any time

chevron_left 1 2 3...16 chevron_right

AcingExam

Precision in Certification. Momentum in Career.

Product

Home
View All Exams

Company

About Us
Privacy Policy
Terms of Service

Connect

public alternate_email share

System Status: Optimal

AcingExam

homeHome local_fire_departmentPopular Exams library_booksView All Exams mailContact

AcingExam

Precision in Certification. Momentum in Career.

Product

Home
View All Exams

Company

About Us
Privacy Policy
Terms of Service

Connect

public alternate_email share

System Status: Optimal

Snowflake COF-C03 Practice Questions - AcingExam

mail[email protected]

Trusted by 1.5M+ IT Professionals

AcingExam

homeHome local_fire_departmentPopular Exams library_booksView All Exams mailContact

Homechevron_rightSnowflakechevron_rightCOF-C03chevron_rightPractice Questions

The latest changes and updates from the administration for this exam.

verified

Latest Update: May 11 2026

All questions are working fine.

All Questions (305)bookmarkBookmarked (0)

All305Show all accessible questions in this exam.Missed305Questions you haven't attempted yet.Incorrect0Questions you answered incorrectly on your last attempt.

Question 11

You have shared a table with another Snowflake account. A user in the consumer account has executed a query on the shared table. Who will be charged for the query cost?

Consumer

Producer (the account which shared the data)

check_circle

Correct AnswerA

When data is shared with another Snowflake account, the consumer account executing the query is charged for the compute cost.

https://docs.snowflake.net/manuals/user-guide/data-sharing-intro.html#how-does-secure-data-sharing-work

Question 12

What is the minimum Snowflake edition in which Federated Authentication & MFA are available?

Enterprise

Standard

Business Critical

check_circle

Correct AnswerB

Federated Authentication & MFA are available in all editions, therefore the minimum edition is Standard where these functionalities are available.

Please see also https://www.snowflake.com/pricing/

Question 13

On the WebUI which button on the top bar should you select to run queries?

History

Databases

Virtual Warehouses

Worksheets

Account

check_circle

Correct AnswerE

Worksheets button will take you to the interface where you can create 1 or more worksheets in which you can edit & execute SQL queries.

Question 14

A virtual warehouse must be running in order to process SQL queries. For which type of queries results may be produced without requiring a running virtual warehouse?

Select all that apply

Select All that Apply

for queries for which results can be fulfilled from the metadata cache

for queries that have previously run and their results are stored in the result cache

for queries that make use of clustering keys

for queries that process less then 10 MB of data

check_circle

Correct AnswersB, C

Queries, for which results can be fulfilled from cache do not require a virtual warehouse. The cache could be result cache, metadata cache

Question 15

Which of the following simple transformations can be used while loading data through the COPY command?

Select all that apply

Pivot

Truncate

Re-order Columns

Cast

Omit Columns

Transpose

check_circle

Correct AnswersB, C, D, E

You can perform basic transformations such as column re-ordering, column omission, cast data types & truncating text data while load it through the COPY command

Question 16

A Small virtual warehouse (comprising of 2 servers) executing for 2 hours will consume same number of credits as a Medium virtual warehouse (comprising of 4 servers) executing for 1 hour.

TRUE

FALSE

check_circle

Correct AnswerA

Correct. With a larger size the credit consumption is more. In the given example it is exactly double.

Question 17

The COPY command can load data from which of the following?

Select all that apply

Detachable hard disks

Internal stage

Tape drives

External Stage i.e. Cloud Storage

check_circle

Correct AnswersB, D

The COPY command can load data from external stages i.e. Snowflake Stage defined on data already present in Cloud Storage. It can also load data from a Snowflake Internal stage

Question 18

The provider of data can add multiple databases in a Share definition.

FALSE

TRUE

check_circle

Correct AnswerA

Incorrect. Only one database can be added to a share. However multiple schemas, tables and views can be added to a share.

Question 19

Snowflake UDFs can be written in which of the following languages?

Select all that apply

JAVA

PYTHON

JAVASCRIPT

SQL

check_circle

Correct AnswersC, D

Snowflake UDFs can be written in JavaScript or SQL

https://docs.snowflake.net/manuals/sql-reference/user-defined-functions.html

Question 20

A virtual warehouse can be resized any time, regardless if it is in suspended state or active and executing queries.

FALSE

TRUE

check_circle

Correct AnswerB

Correct, a virtual warehouse can be resized any time

chevron_left 1 2 3...16 chevron_right

AcingExam

Precision in Certification. Momentum in Career.

Product

Home
View All Exams

Company

About Us
Privacy Policy
Terms of Service

Connect

public alternate_email share

System Status: Optimal

Update History

Update History