support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. COF-C02

Free COF-C02 Exam Braindumps
SnowPro Core Questions 326–330 (page: 67)

Updated On: 10-Feb-2026
Page 67 of 221
PDF with 1300 Questions

In which use case does Snowflake apply egress charges?

  1. Data sharing within a specific region
  2. Query result retrieval
  3. Database replication
  4. Loading data into Snowflake

Answer(s): C



Which of the following compute resources or features are managed by Snowflake? (Choose two.)

  1. Execute a COPY command
  2. Updating data
  3. Snowpipe
  4. AUTOMATIC_CLUSTERING
  5. Scaling up a warehouse

Answer(s): C,D



A materialized view should be created when which of the following occurs? (Choose two.)

  1. There is minimal cost associated with running the query.
  2. The query consumes many compute resources every time it runs.
  3. The base table gets updated frequently.
  4. The query is highly optimized and does not consume many compute resources.
  5. The results of the query do not change often and are used frequently.

Answer(s): B,E



What privilege should a user be granted to change permissions for new objects in a managed access schema?

  1. Grant the OWNERSHIP privilege on the schema.
  2. Grant the OWNERSHIP privilege on the database.
  3. Grant the MANAGE GRANTS global privilege.
  4. Grant ALL privileges on the schema.

Answer(s): C



What happens when a Data Provider revokes privileges to a share on an object in their source database?

  1. The object immediately becomes unavailable for all Data Consumers.
  2. Any additional data arriving after this point in time will not be visible to Data Consumers.
  3. The Data Consumers stop seeing data updates and become responsible for storage charges for the object.
  4. A static copy of the object at the time the privilege was revoked is created in the Data Consumers account.

Answer(s): A



  PDF
Viewing page 67 of 221
Viewing questions 331 - 335 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!