Free Access Snowflake.COF-C02.v2023-02-20.q85 Practice Test (Page 10)

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

A.SHOW GRANTS TO ROLE MY_ROLE

B.SHOW GRANTS OF ROLE MY_ROLE

C.SHOW GRANTS FOR ROLE MY_ROLE

D.SHOW GRANTS ON ROLE MY_ROLE

Which statement about billing applies to Snowflake credits?

A.Credits are billed per-minute with a 60-minute minimum

B.Credits are used to pay for cloud data storage usage

C.Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.Credits are consumed based on the warehouse size and the time the warehouse is running

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

A.DELETE

B.MODIFY

C.REMOVE

D.PURGE

What feature can be used to reorganize a very large table on one or more columns?

A.Micro-partitions

B.Clustering keys

C.Key partitions

D.Clustered partitions

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A.All data in Snowflake is compressed.

B.All data in Snowflake is encrypted.

C.Snowflake leverages a Role-Based Access Control (RBAC) model.

D.Snowflake requires a user to configure an IAM user to connect to the database.

E.Snowflake can run within a user's own Virtual Private Cloud (VPC).

Other Version: 4230Snowflake.COF-C02.v2025-06-30.q512; 1682Snowflake.COF-C02.v2023-09-01.q136

Latest Upload: 200PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 292Nokia.4A0-113.v2026-05-01.q69; 250EC-COUNCIL.312-49v11.v2026-04-30.q214; 227Microsoft.MB-820.v2026-04-30.q101; 207Salesforce.MC-202.v2026-04-30.q57; 204BICSI.INSTC_V8.v2026-04-29.q53; 332NMLS.MLO.v2026-04-28.q82; 241NCARB.Project-Management.v2026-04-28.q27; 457EMC.D-AV-DY-23.v2026-04-27.q184; 1109ServiceNow.CSA.v2026-04-27.q483

Download PDF File