Free Access to Snowflake.COF-C02.v2026-01-13.q618 with Valid Practice Test (Page 54)

Request Exam Contact

Home
View All Exams
New QA's
Upload

PRACTICE EXAMS:

Oracle
Fortinet
Juniper
Microsoft
Cisco
Citrix
CompTIA
VMware
SAP
EMC
PMI
HP
Salesforce
Other

Oracle
Fortinet
Juniper
Microsoft
Cisco
Citrix
CompTIA
VMware
SAP
EMC
PMI
HP
Salesforce

Home
Snowflake Certification
COF-C02 Exam
Snowflake.COF-C02.v2026-01-13.q618 Dumps

««
«
…
49
50
51
52
53
54
55
56
57
58
…
»
»»

Question 261

What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).

A.Auto-suspend
B.Cache size
C.Default role
D.Resource monitor
E.Storage size

Correct Answer: A,D

When creating a virtual warehouse in Snowflake, users have the option to set several properties to manage its behavior and resource usage. Two of these optional properties are Auto-suspend and Resource monitor.
* Auto-suspend:This property defines the period of inactivity after which the warehouse will automatically suspend. This helps in managing costs by stopping the warehouse when it is not in use.
CREATE WAREHOUSE my_warehouse
WITH WAREHOUSE_SIZE = 'XSMALL'
AUTO_SUSPEND = 300; -- Auto-suspend after 5 minutes of inactivity
* Resource monitor:Users can assign a resource monitor to a warehouse to control and limit the amount of credit usage. Resource monitors help in setting quotas and alerts for warehouse usage.
CREATE WAREHOUSE my_warehouse
WITH WAREHOUSE_SIZE = 'XSMALL'
RESOURCE_MONITOR = 'my_resource_monitor';
References:
* Snowflake Documentation: Creating Warehouses
* Snowflake Documentation: Resource Monitors

Comment: *

Name: *

Email: *

Verification: *

insert code

Question 262

Which metadata table will store the storage utilization information even for dropped tables?

A.DATABASE_STORAGE_USAGE_HISTORY
B.TABLE_STORAGE_METRICS
C.STORAGE_DAILY_HISTORY
D.STAGE STORAGE USAGE HISTORY

Correct Answer: B

The TABLE_STORAGE_METRICS metadata table stores the storage utilization information, including for tables that have been dropped but are still incurring storage costs2.

Comment: *

Name: *

Email: *

Verification: *

insert code

Question 263

Network policies can be set at which Snowflake levels? (Choose two.)

A.Role
B.Schema
C.User
D.Database
E.Account
F.Tables

Correct Answer: C,E

Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

Comment: *

Name: *

Email: *

Verification: *

insert code

Question 264

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

A.ROLES
B.POLICY_REFERENCES
C.RESOURCE_MONIT ORS
D.ACCESS_HISTORY
E.QUERY_HISTORY

Correct Answer: B,D

Comment: *

Name: *

Email: *

Verification: *

insert code

Question 265

Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

A.Security
B.Data storage
C.Data visualization
D.Query computation
E.Metadata management

Correct Answer: A,E

The Cloud Services layer in Snowflake is responsible for various services, including security (like authentication and authorization) and metadata management (like query parsing and optimization). References: Based on general cloud architecture knowledge as of 2021.

Comment: *

Name: *

Email: *

Verification: *

insert code

««
«
…
49
50
51
52
53
54
55
56
57
58
…
»
»»

[×]

Download PDF File

Enter your email address to download Snowflake.COF-C02.v2026-01-13.q618 Dumps

Email:

Our website provides the Largest and the most Latest vendors Certification Exam materials around the world.

Using dumps we provide to Pass the Exam, we has the Valid Dumps with passing guranteed just which you need.

DMCA
About
Contact Us
Privacy Policy
Terms & Conditions

©2026 FreeQAs

www.freeqas.com materials do not contain actual questions and answers from Cisco's certification exams.

Web Analytics Made Easy - Statcounter