Online Access Free Snowflake.COF-C02.v2023-03-21.q116 Practice Test (Page 9)

Which statement describes pruning?

A.A service that is handled by the Snowflake Cloud Services layer to optimize caching.

B.The ability to allow the result of a query to be accessed as if it were a table.

C.The return of micro-partitions values that overlap with each other to reduce a query's runtime.

D.The filtering or disregarding of micro-partitions that are not needed to return a query.

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

A.MODIFY

B.MONITOR

C.USAGE

D.OPERATE

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

A.When the system has enough load for 10 minutes

B.When the system has enough load for 6 minutes

C.When the system has enough load for 8 minutes

D.When the system has enough load for 2 minutes

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

A.Internal stages

B.Incremental backups

C.Time Travel

D.Zero-copy clones

E.Fail-safe

What SQL command would be used to view all roles that were granted to user.1?

A.describe user USER1;

B.show grants of user USER1;

C.show grants on user USER1;

D.show grants to user USER1;

Other Version: 1094Snowflake.COF-C02.v2026-02-23.q464; 1273Snowflake.COF-C02.v2025-07-10.q294; 2375Snowflake.COF-C02.v2024-07-08.q327; 2110Snowflake.COF-C02.v2024-02-26.q242; 1911Snowflake.COF-C02.v2023-08-31.q139; 1844Snowflake.COF-C02.v2023-02-11.q92

Latest Upload: 143CrowdStrike.CCSE-204.v2026-06-12.q25; 163VMware.2V0-17.25.v2026-06-12.q49; 153Appian.ACA-100.v2026-06-11.q23; 208CompTIA.220-1202.v2026-06-11.q114; 164CheckPoint.156-590.v2026-06-11.q47; 224CompTIA.220-1202.v2026-06-10.q109; 208CertiProf.CEHPC.v2026-06-10.q54; 152Hitachi.HQT-4160.v2026-06-10.q25; 405PMI.PMI-ACP-CN.v2026-06-09.q453; 193Splunk.SPLK-5002.v2026-06-08.q52

Download PDF File