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

Question 261

Which key access control concept does Snowflake descibe as a defined level of access to an object?

A.Role

B.Grant

C.Session

D.Privilege

Question 262

How is unstructured data retrieved from data storage?

A.SOL functions like the GET command can be used to copy the unstructured data to a location on the client.

B.SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

C.SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

D.SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

Question 263

Which of the following objects can be shared through secure data sharing?

A.Masking policy

B.Stored procedure

C.Task

D.External table

Question 264

A directory table that references an external stage is being refreshed manually.
What will happen to any scheduled automatic-refresh operations occurring at the same time as the manual- refresh operations?

A.The manual-refresh operations and the automatic-refresh operations will both take place.

B.The automatic-refresh operations will be aborted.

C.The automatic-refresh operations will be performed more often.

D.The automatic-refresh operations will continue on the established schedule.

Question 265

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

A.4 minutes

B.10 minutes

C.14 minutes

D.24 minutes

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

Latest Upload: 118Genesys.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; 380OCEG.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; 301TheSecOpsGroup.CNSP.v2025-09-08.q20

Question 261

Question 262

Question 263

Question 264

Question 265

Download PDF File