Online Access Free Snowflake.COF-C02.v2024-07-08.q327 Practice Test (Page 27)

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A.How often the materialized view is queried

B.How often the underlying base table is queried

C.Whether the materialized view has a cluster key defined

D.Whether or not it is also a secure view

E.How often the base table changes

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.Time Travel - 1 day. Fail-safe - 0 days

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

How often are encryption keys automatically rotated by Snowflake?

A.365 Days

B.90 Days

C.60 Days

D.30 Days

What is the recommended way to change the existing file format type in my format from CSV to JSON?

A.ALTER FILE FORMAT my_format SET TYPE=JSON;

B.ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

C.CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

D.REPLACE FILE FORMAT my format TYPE-JSON;

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

A.ROW_NUMBER

B.TABLE

C.TABULAR

D.VALUES

Other Version: 1088Snowflake.COF-C02.v2026-02-23.q464; 1271Snowflake.COF-C02.v2025-07-10.q294; 2107Snowflake.COF-C02.v2024-02-26.q242; 1910Snowflake.COF-C02.v2023-08-31.q139; 1873Snowflake.COF-C02.v2023-03-21.q116; 1844Snowflake.COF-C02.v2023-02-11.q92

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

Download PDF File