Online Access Free Snowflake.COF-C02.v2023-02-11.q92 Practice Test (Page 15)

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

A.Materialized view

B.Clustered table

C.Secure view

D.Transient table

E.Sequence

What is the lowest Snowflake edition that offers Time Travel up to 90 days.

A.standard Edition

B.Business Critical Edition

C.Enterprise Edition

D.Premier Edition

When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

A.When users will be using compute at different times throughout a 24/7 period

B.When managing a steady workload

C.When you don't want to have to manually turn on the Warehouse each time a user needs it

D.When the compute must be available with no delay or lag time

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A.A Google Cloud storage bucket

B.An HTTPS server with WebDAV

C.An FTP server with TLS encryption

D.A Windows server file share on Azure

What are the default Time Travel and Fail-safe retention periods for transient tables?

A.Time Travel - 1 day. Fail-safe - 1 day

B.Time Travel - 0 days. Fail-safe - 1 day

C.Transient tables are retained in neither Fail-safe nor Time Travel

D.Time Travel - 1 day. Fail-safe - 0 days

Other Version: 1078Snowflake.COF-C02.v2026-02-23.q464; 1265Snowflake.COF-C02.v2025-07-10.q294; 2356Snowflake.COF-C02.v2024-07-08.q327; 2107Snowflake.COF-C02.v2024-02-26.q242; 1904Snowflake.COF-C02.v2023-08-31.q139; 1873Snowflake.COF-C02.v2023-03-21.q116

Latest Upload: 142CrowdStrike.CCSE-204.v2026-06-12.q25; 161VMware.2V0-17.25.v2026-06-12.q49; 148Appian.ACA-100.v2026-06-11.q23; 208CompTIA.220-1202.v2026-06-11.q114; 163CheckPoint.156-590.v2026-06-11.q47; 223CompTIA.220-1202.v2026-06-10.q109; 201CertiProf.CEHPC.v2026-06-10.q54; 151Hitachi.HQT-4160.v2026-06-10.q25; 387PMI.PMI-ACP-CN.v2026-06-09.q453; 191Splunk.SPLK-5002.v2026-06-08.q52

Download PDF File