Online Access Free Snowflake.COF-C02.v2024-02-26.q242 Practice Test (Page 10)

Which function is used to convert rows in a relational table to a single VARIANT column?

A.ARRAY_CONSTRUCT

B.ARRAY_AGG

C.OBJECT_CONSTRUCT

D.OBJECT_AGG

Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

A.OBJECT

B.STRING

C.VARIANT

D.VARCHAR

E.NUMBER

Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).

A.VARCHAK

B.BINARY

C.VARIANT

D.ARRAY

E.TEXT

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

A.Information Schema -> TABLE_FUNCTION

B.SHOW STORAGE BY TABLE;

C.Information Schema -> TABLE_HISTORY

D.Information Schema -> TABLE_STORAGE_METRICS

E.SHOW TABLES;

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

A.The shared objects are copied.

B.The shared objects are transferred.

C.The shared objects can be re-shared.

D.The shared objects become accessible.

Other Version: 1137Snowflake.COF-C02.v2026-02-23.q464; 1294Snowflake.COF-C02.v2025-07-10.q294; 2391Snowflake.COF-C02.v2024-07-08.q327; 1920Snowflake.COF-C02.v2023-08-31.q139; 1883Snowflake.COF-C02.v2023-03-21.q116; 1848Snowflake.COF-C02.v2023-02-11.q92

Latest Upload: 163CBIC.CIC.v2026-06-15.q123; 125Peoplecert.ITIL-4-Specialist-High-velocity-IT.v2026-06-15.q16; 161HashiCorp.Terraform-Associate-004.v2026-06-15.q126; 130Peoplecert.ITILFNDv5.v2026-06-15.q26; 127Workday.Workday-Pro-HCM-Reporting.v2026-06-15.q28; 127Fortinet.NSE5_SSE_AD-7.6.v2026-06-15.q17; 274PMI.PMI-ACP.v2026-06-15.q523; 153LinuxFoundation.CKAD.v2026-06-15.q118; 157CrowdStrike.CCSE-204.v2026-06-12.q25; 188VMware.2V0-17.25.v2026-06-12.q49

Download PDF File