Free Access Snowflake.COF-C02.v2026-05-31.q637 Practice Test (Page 61)

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

A.USAGE

B.OPERATE

C.MONITOR

D.MODIFY

Which function will generate a URL that can be accessed by a non-Snowflake user?

A.GET_PRESIGNED_URL

B.BUILD_SCOPED_FILE_URL

C.BUILD_STAGE_FILE_URL

D.GET_STAGE_LOCATION

Which account usage view can be used to identify the masking policy assigned to an object?

A.ACCESS_HISTORY

B.OBJECT_DEPENDENCIES

C.POLICY_REFERENCES

D.TAG REFERENCES

When connecting to Snowflake using SnowSQL, what are ways to explicitly specify the password? (Select TWO).

A.Use an OAuth token

B.Enter through an interactive prompt

C.Run a web-based authorization flow

D.Use public and private key pair authentication

E.Specify using SNOWSQL_PWD environment variables

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

Other Version: 5290Snowflake.COF-C02.v2025-06-30.q512; 1845Snowflake.COF-C02.v2023-09-01.q136; 1455Snowflake.COF-C02.v2023-02-20.q85

Latest Upload: 154MedicalProfessional.CCM.v2026-08-20.q62; 208Cisco.300-610.v2026-08-19.q170; 230CompTIA.PT0-003.v2026-08-19.q179; 157Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 156SAP.C_CR125_2601.v2026-08-17.q28; 211Salesforce.Field-Service-Consultant.v2026-08-17.q134; 172Oracle.1Z0-1170.v2026-08-16.q64; 180Oracle.1Z1-1170.v2026-08-16.q64; 202Juniper.JN0-336.v2026-08-13.q60; 417EMC.NCP-AII.v2026-08-13.q200

Download PDF File