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

If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

A.There are no users loaned into Snowflake.

B.All Snowflake sessions using the warehouse are terminated.

C.The last query using the warehouse completes.

D.The Warehouse is inactive for a specified period of time.

True or False: It is possible to load data into Snowflake without creating a named File Format object.

A.False

B.True

Which Snowflake objects can be restored using Time Travel? (Select VNO).

A.Schemas

B.Virtual warehouses

C.Databases

D.Users

E.Roles

What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

A.5 minutes

B.1 minutes

C.15 minutes

D.10 minutes

How can a Snowflake user access a JSON object, given the following table? (Select TWO).

A.src:salesperson.name

B.src:sa1esPerson. name

C.src:salesperson.Name

D.SRC:salesperson.name

E.SRC:salesperson.Name

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; 122Oracle.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

Download PDF File