Free Access Snowflake.COF-C02.v2025-06-30.q512 Practice Test (Page 62)

Question 301

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

A.Stored Procedures

B.Secure User-Defined Functions (UDFs)

C.Roles

D.Secure Views

E.Schemas

F.Tables

Question 302

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

A.Create a task that runs a copy into operation from an external stage every 5 minutes

B.Create a task that puts the files in an internal stage and automate the data loading wizard

C.Create a task that runs a GET operation to intermittently check for new files

D.Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Question 303

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

A.4

B.8

C.16

D.32

Question 304

The following settings are configured:

For how many days will the data be retained at the object level?

A.3

B.5

C.2

D.7

Question 305

A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

A.Query against the result set cache

B.Query against a virtual warehouse cache

C.Query against the most-recently created micro-partition

D.Query against the metadata excite

Other Version: 1082Snowflake.COF-C02.v2023-09-01.q136; 1030Snowflake.COF-C02.v2023-02-20.q85

Latest Upload: 117Genesys.GCX-GCD.v2025-09-13.q25; 116Huawei.H12-725_V4.0.v2025-09-13.q21; 121Oracle.1z0-1196-25.v2025-09-12.q18; 113NetworkAppliance.NS0-162.v2025-09-12.q86; 377OCEG.GRCP.v2025-09-11.q211; 125HP.HPE0-V27.v2025-09-11.q78; 138Oracle.1Z0-1057-23.v2025-09-10.q47; 194Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 149SAP.C-S4EWM-2023.v2025-09-08.q83; 300TheSecOpsGroup.CNSP.v2025-09-08.q20

Question 301

Question 302

Question 303

Question 304

Question 305

Download PDF File