Free Access Snowflake.COF-C02.v2023-02-20.q85 Practice Test (Page 14)

Which TABLE function helps to convert semi-structured data to a relational representation?

A.PARSE_JSON

B.FLATTEN

C.CHECK_JSON

D.TO_JSON

In a Snowflake role hierarchy, what is the top-level role?

A.SECURITYADMIN

B.ORGADMIN

C.SYSADMIN

D.ACCOUNTADMIN

When is the result set cache no longer available? (Select TWO)

A.When the underlying data has changed

B.When the warehouse used to execute the query is suspended

C.When it has been 24 hours since the last query

D.When another warehouse is used to execute the query

E.When another user executes the query

Which of the following accurately describes shares?

A.Shares can be shared

B.Data consumers can clone a new table from a share

C.Access to a share cannot be revoked once granted

D.Tables, secure views, and secure UDFs can be shared

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

A.True

B.False

Other Version: 766Snowflake.COF-C02.v2025-06-30.q512; 1077Snowflake.COF-C02.v2023-09-01.q136

Latest Upload: 101OCEG.GRCP.v2025-09-11.q211; 101HP.HPE0-V27.v2025-09-11.q78; 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 156PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 140Adobe.AD0-E605.v2025-09-05.q50

Download PDF File