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

Question 226

A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?

A.Grant the additional privileges to the ACCOUNTADMIN role.

B.Grant the additional privileges to the SYSADMIN role.

C.Grant the additional privileges to the ORGADMIN role.

D.Grant the additional privileges to a custom role.

Question 227

When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

A.When users will be using compute at different times throughout a 24/7 period

B.When you don't want to have to manually turn on the Warehouse each time a user needs it

C.When the compute must be available with no delay or lag time

D.When managing a steady workload

Question 228

What type of query benefits the MOST from search optimization?

A.A query that uses only disjunction (i.e., OR) predicates

B.A query that includes analytical expressions

C.A query that uses equality predicates or predicates that use IN

D.A query that filters on semi-structured data types

Question 229

Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).

A.Synchronization

B.Remote disk IO

C.Local disk IO

D.Pruning

E.Spillage

Question 230

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data.
Will the developer be able to modify the table to read the masked data?

A.Yes, because masking policies only apply to cloned tables.

B.No, because masking policies must always reference specific access roles.

C.No, because ownership of a table does not include the ability to change masking policies

D.Yes, because a table owner has full control and can unset masking policies.

Other Version: 1083Snowflake.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; 386OCEG.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; 303TheSecOpsGroup.CNSP.v2025-09-08.q20

Question 226

Question 227

Question 228

Question 229

Question 230

Download PDF File