Online Access Free Snowflake.COF-C02.v2023-03-21.q116 Practice Test (Page 17)

COF-C02 Exam Question 76

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

A.Time Travel data

B.Security

C.Data loading

D.Authentication and access control

E.Query execution

COF-C02 Exam Question 77

Network policies can be set at which Snowflake levels? (Choose two.)

A.Role

B.Tables

C.Schema

D.User

E.Database

F.Account

COF-C02 Exam Question 78

How would a user execute a series of SQL statements using a task?

A.Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

B.A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

C.Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

D.Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..

COF-C02 Exam Question 79

Which data type can store more than one type of data structure?

A.VARCHAR

B.BINARY

C.JSON

D.VARIANT

COF-C02 Exam Question 80

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

A.It removes the last element of the outer array.

B.It removes the outer array structure and loads the records into separate table rows,

C.It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

D.It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Other Version: 1169Snowflake.COF-C02.v2026-02-23.q464; 1311Snowflake.COF-C02.v2025-07-10.q294; 2402Snowflake.COF-C02.v2024-07-08.q327; 2148Snowflake.COF-C02.v2024-02-26.q242; 1939Snowflake.COF-C02.v2023-08-31.q139; 1862Snowflake.COF-C02.v2023-02-11.q92

Latest Upload: 125ISTQB.CT-AI.v2026-06-18.q68; 235IIA.IIA-CIA-Part3.v2026-06-17.q220; 162WGU.Introduction-to-IT.v2026-06-17.q67; 201CompTIA.220-1202.v2026-06-16.q110; 134TheInstitutes.CPCU-500.v2026-06-16.q25; 216ACAMS.CAMS7-CN.v2026-06-16.q170; 253CBIC.CIC.v2026-06-15.q123; 151Peoplecert.ITIL-4-Specialist-High-velocity-IT.v2026-06-15.q16; 260HashiCorp.Terraform-Associate-004.v2026-06-15.q126; 157Peoplecert.ITILFNDv5.v2026-06-15.q26

COF-C02 Exam Question 76

COF-C02 Exam Question 77

COF-C02 Exam Question 78

COF-C02 Exam Question 79

COF-C02 Exam Question 80

Download PDF File