Describe Snowflake's Multi-Cluster Shared Data Architecture COF-C03 Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A new administrator is trying to understand how Snowflake can offer 'near-zero maintenance' compared to traditional databases. Which architectural design is the primary reason for this?

   • AThe use of a single, monolithic server that is fully managed by the user.
   • BThe reliance on the cloud provider to manage all database software and hardware.
   • CThe separation of storage, compute, and services into independent, fully managed layers.
   • DThe requirement for users to manually manage indexes and partitioning.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A security administrator needs to understand which component of Snowflake's architecture is responsible for enforcing access control policies and managing user authentication. Which layer should they investigate?

   • AThe cloud provider's IAM, as it manages all access to Snowflake.
   • BThe services layer, which manages security, metadata, and infrastructure.
   • CThe storage layer, as it holds the data that needs to be protected.
   • DThe compute layer, as it processes queries and can filter data.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A company runs a nightly ETL workload and a separate interactive BI dashboard. The ETL job consumes significant compute, while the BI dashboard needs consistent performance for a small team. The company wants to ensure that the ETL workload does not degrade the BI dashboard's performance. What should the company do?

   • AMove the BI dashboard to a different cloud provider to avoid any potential performance issues.
   • BCreate two separate virtual warehouses, one for ETL and one for BI, and assign them to the respective workloads.
   • CIncrease the size of the single warehouse to the largest available size to handle both workloads.
   • DRun both workloads on the same virtual warehouse and rely on the warehouse's automatic scaling.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A company wants to share a live, read-only view of their sales data with a partner. The partner should be able to query the data with their own compute resources, but the company wants to ensure the partner cannot modify the data. What is the most appropriate way to achieve this?

   • ACreate a share on the table and grant the partner's account the 'SELECT' privilege on the share.
   • BGrant the partner's account access to the underlying storage layer.
   • CExport the data to a file and send it to the partner.
   • DCreate a copy of the table in the partner's account and keep it synchronized.
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A security team needs to audit all queries run against a specific table. They want to know who ran the query, when, and what the query was. Where can they find this information?

   • AIn the storage layer's transaction logs.
   • BIn the services layer's query history and access logs.
   • CIn the virtual warehouse's query cache.
   • DIn the cloud provider's network logs.
   Reveal Solution Discussion Select an answer first