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

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

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

B.ALTER FILE FORMAT my_format SET TYPE=JSON;

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

D.REPLACE FILE FORMAT my format TYPE-JSON;

A user needs to create a materialized view in the schema MYDB.MYSCHEM A.
Which statements will provide this access?

A.GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

B.GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

C.GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;

D.GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

A.SQL

B.Python

C.Swift

D.JavaScript

What is the default File Format used in the COPY command if one is not specified?

A.XML

B.JSON

C.Parquet

D.CSV

Which of the following describes external functions in Snowflake?

A.They are a type of User-defined Function (UDF).

B.They contain their own SQL code.

C.They call code that is stored inside of Snowflake.

D.They can return multiple rows for each row received

Other Version: 1153Snowflake.COF-C02.v2026-02-23.q464; 1300Snowflake.COF-C02.v2025-07-10.q294; 2397Snowflake.COF-C02.v2024-07-08.q327; 1925Snowflake.COF-C02.v2023-08-31.q139; 1888Snowflake.COF-C02.v2023-03-21.q116; 1854Snowflake.COF-C02.v2023-02-11.q92

Latest Upload: 172CompTIA.220-1202.v2026-06-16.q110; 124TheInstitutes.CPCU-500.v2026-06-16.q25; 175ACAMS.CAMS7-CN.v2026-06-16.q170; 188CBIC.CIC.v2026-06-15.q123; 133Peoplecert.ITIL-4-Specialist-High-velocity-IT.v2026-06-15.q16; 227HashiCorp.Terraform-Associate-004.v2026-06-15.q126; 133Peoplecert.ITILFNDv5.v2026-06-15.q26; 133Workday.Workday-Pro-HCM-Reporting.v2026-06-15.q28; 135Fortinet.NSE5_SSE_AD-7.6.v2026-06-15.q17; 349PMI.PMI-ACP.v2026-06-15.q523

Download PDF File