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

In which use cases does Snowflake apply egress charges?

A.Data sharing within a specific region

B.Query result retrieval

C.Database replication

D.Loading data into Snowflake

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

A.SHOW STORAGE BY TABLE;

B.SHOW TABLES;

C.Information Schema -> TABLE_FUNCTION

D.Information Schema -> TABLE_STORAGE_METRICS

E.Information Schema -> TABLE_HISTORY

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

A.Table definition

B.Stage definition

C.Session level

D.COPY INTO TABLE statement

Which Snowflake objects can be defined with future grants? (Select TWO).

A.Masking policies

B.Databases

C.Virtual warehouses

D.Schemas

E.External functions

How can a user improve the performance of a single large complex query in Snowflake?

A.Enable standard warehouse scaling.

B.Scale out the virtual warehouse.

C.Scale up the virtual warehouse.

D.Enable economy warehouse scaling.

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

Latest Upload: 147MedicalProfessional.CCM.v2026-08-20.q62; 206Cisco.300-610.v2026-08-19.q170; 205CompTIA.PT0-003.v2026-08-19.q179; 155Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 148SAP.C_CR125_2601.v2026-08-17.q28; 211Salesforce.Field-Service-Consultant.v2026-08-17.q134; 168Oracle.1Z0-1170.v2026-08-16.q64; 176Oracle.1Z1-1170.v2026-08-16.q64; 201Juniper.JN0-336.v2026-08-13.q60; 393EMC.NCP-AII.v2026-08-13.q200

Download PDF File