Free Access Snowflake.COF-R02.v2023-09-22.q114 Practice Test (Page 2)

Question 1

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

A.Virtual Private Snowflake

B.Enterprise

C.Standard

D.Business Critical

Question 2

What data is stored in the Snowflake storage layer? (Select TWO).

A.Snowflake parameters

B.Micro-partitions

C.Persisted query results

D.Standard and secure view results

E.Query history

Question 3

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

A.SHOW TABLES;

B.Information Schema -> TABLE_HISTORY

C.Information Schema -> TABLE_STORAGE_METRICS

D.Information Schema -> TABLE_FUNCTION

E.SHOW STORAGE BY TABLE;

Question 4

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

Question 5

Which Snowflake tool would be BEST to troubleshoot network connectivity?

A.SnowCLI

B.SnowUI

C.SnowSQL

D.SnowCD

Latest Upload: 143Fortinet.NSE7_SSE_AD-25.v2026-09-05.q85; 205Microsoft.PL-400.v2026-09-05.q375; 306Snowflake.DEA-C01.v2026-09-04.q215; 198HP.HPE0-V27.v2026-09-04.q127; 293NAHQ.CPHQ.v2026-09-03.q481; 128SAP.C-S4CPB-2602.v2026-09-02.q7; 140Cisco.700-805.v2026-09-02.q86; 176MSSC.CLT-4.0.v2026-09-02.q43; 137Fitness.NCSF-CPT.v2026-09-02.q18; 207Google.Generative-AI-Leader.v2026-09-02.q77

Question 1

Question 2

Question 3

Question 4

Question 5

Download PDF File