Snowflake COF-C02 Exam Practice Test Instant Access

Question 1

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

AROLEADMIN

BACCOUNTADMIN

CSYSADMIN

DSECURITYADMIN

EUSERADMIN

Answer : B, D

User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN role has the highest level of privileges across the account, including the ability to manage network policies. The SECURITYADMIN role is specifically responsible for managing security objects within Snowflake, which includes the creation and management of network policies.

References:

[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Network Policies1

Section 1.3 - SnowPro Core Certification Study Guide

Question 2

Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)

ARange searches

BEquality searches

CSubstring searches

DQueries with IN predicates

EQueries with aggregation

Answer : A, B

The search optimization service in Snowflake significantly improves the performance of range searches and equality searches. Range searches involve looking for values within a specific range (e.g., BETWEEN, <, >). Equality searches involve looking for values that match a specific value (e.g., =).

References:

Snowflake Documentation: Search Optimization Service

Question 3

A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

AData:employee.name

BDATA:employee.name

Cdata:Employee.name

Ddata:employee.name

Answer : D

In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive. Therefore, to extract the employee's name from the ''Data'' column, the correct syntax isdata:employee.name.

Question 4

When should a stored procedure be created with caller's rights?

AWhen the caller needs to be prevented from viewing the source code of the stored procedure

BWhen the caller needs to run a statement that could not execute outside of the stored procedure

CWhen the stored procedure needs to run with the privileges of the role that called the stored procedure

DWhen the stored procedure needs to operate on objects that the caller does not have privileges on

Answer : C

Stored procedures in Snowflake can be created with either 'owner's rights' or 'caller's rights'. A stored procedure created with caller's rights executes with the privileges of the role that calls the procedure, not the privileges of the role that owns the procedure. This is particularly useful in scenarios where the procedure needs to perform operations that depend on the caller's access permissions, ensuring that the procedure can only access objects that the caller is authorized to access.

Question 5

The customer table in the T1 database is accidentally dropped.

Which privileges are required to restore this table? {Select TWO).

ASELECT privilege on the customer table

Bownership privilege on the customer table

CAll privileges on the customer table

DAll privileges on the T1 database

ECREATE TABIE privilege on the T1 database

Answer : D, E

Question 6

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

ACompute resources

BQuery execution

CAuthentication

DData storage

EMetadata

Answer : C, E

The Snowflake Cloud Services layer manages a variety of services that are crucial for the operation of the Snowflake platform. Among these services, Authentication and Metadata management are key components. Authentication is essential for controlling access to the Snowflake environment, ensuring that only authorized users can perform actions within the platform. Metadata management involves handling all the metadata related to objects within Snowflake, such as tables, views, and databases, which is vital for the organization and retrieval of data.

References:

[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation12

https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Question 7

Which pages are included in the Activity area of Snowsight? (Select TWO).

AContacts

BSharing settings

CCopy History

DQuery History

EAutomatic Clustering History

Answer : D, E

The Activity area of Snowsight includes the Query History page, which allows users to monitor and view details about queries executed in their account, including performance data1.It also includes the Automatic Clustering History, which provides insights into the automatic clustering operations performed on tables2.

Snowflake COF-C02 SnowPro Core Certification Exam Practice Test