Free Access Snowflake.COF-C02.v2025-06-30.q512 Practice Test (Page 90)

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

A.The primary cluster in the virtual warehouse

B.The entire virtual warehouse

C.The database in which the virtual warehouse resides

D.The Queries currently being run on the virtual warehouse

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

A.Role

B.Schema

C.User

D.Database

E.Account

F.Tables

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

A.ROLES

B.POLICY_REFERENCES

C.QUERY_HISTORY

D.RESOURCE_MONIT ORS

E.ACCESS_HISTORY

Which Snowflake object does not consume any storage costs?

A.Secure view

B.Materialized view

C.Temporary table

D.Transient table

What is a characteristic of the Snowflake Query Profile?

A.It provides detailed statistics about which queries are using the greatest number of compute resources.

B.It can be used by third-party software using the Query Profile API.

C.It provides a graphic representation of the main components of the query processing.

D.It can provide statistics on a maximum number of 100 queries per week.

Other Version: 1081Snowflake.COF-C02.v2023-09-01.q136; 1030Snowflake.COF-C02.v2023-02-20.q85

Latest Upload: 115Genesys.GCX-GCD.v2025-09-13.q25; 115Huawei.H12-725_V4.0.v2025-09-13.q21; 116Oracle.1z0-1196-25.v2025-09-12.q18; 112NetworkAppliance.NS0-162.v2025-09-12.q86; 363OCEG.GRCP.v2025-09-11.q211; 115HP.HPE0-V27.v2025-09-11.q78; 138Oracle.1Z0-1057-23.v2025-09-10.q47; 183Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 148SAP.C-S4EWM-2023.v2025-09-08.q83; 298TheSecOpsGroup.CNSP.v2025-09-08.q20

Download PDF File