Online Access Free Snowflake.COF-C02.v2026-02-23.q464 Practice Test (Page 18)

Which command should be used to drop files from an internal or external stage?

A.REMOVE

B.DROP

C.DELETE

D.TRUNCATE

Which Snowflake objects consume storage? (Select TWO)

A.Materialized views

B.Temporary schemas

C.Views

D.External tables

E.Permanent tables

Which security models are used in Snowflake to manage access control? (Select TWO).

A.Discretionary Access Control (DAC)

B.Identity Access Management (1AM)

C.Mandatory Access Control (MAC)

D.Role-Based Access Control (RBAC)

E.Security Assertion Markup Language (SAML)

Which command can be used to unload data into an external named stage in Snowflake?

A.CREATE <object>

B.PUT

C.COPY INTO <location>

D.COPY INTO <table>

What is required to set a stored procedure to EXECUTE AS? (Select TWO).

A.ACCOUNTADMIN role

B.USER

C.Caller's rights

D.Owner's rights

E.SCHEMA_USER

Other Version: 1288Snowflake.COF-C02.v2025-07-10.q294; 2388Snowflake.COF-C02.v2024-07-08.q327; 2120Snowflake.COF-C02.v2024-02-26.q242; 1918Snowflake.COF-C02.v2023-08-31.q139; 1880Snowflake.COF-C02.v2023-03-21.q116; 1847Snowflake.COF-C02.v2023-02-11.q92

Latest Upload: 155CrowdStrike.CCSE-204.v2026-06-12.q25; 168VMware.2V0-17.25.v2026-06-12.q49; 167Appian.ACA-100.v2026-06-11.q23; 252CompTIA.220-1202.v2026-06-11.q114; 184CheckPoint.156-590.v2026-06-11.q47; 267CompTIA.220-1202.v2026-06-10.q109; 219CertiProf.CEHPC.v2026-06-10.q54; 155Hitachi.HQT-4160.v2026-06-10.q25; 416PMI.PMI-ACP-CN.v2026-06-09.q453; 199Splunk.SPLK-5002.v2026-06-08.q52

Download PDF File