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

Questions 26–26

1. 26expert · hard

   A data architect is designing a solution where multiple departments need to query the same centralized data. Each department has different performance requirements and budgets. They want to ensure that a heavy workload from one department does not impact another. What is the best architectural approach in Snowflake?

   • ACreate a separate virtual warehouse for each department, sized according to their needs.
   • BStore a copy of the data for each department in a separate database.
   • CCreate a single, large virtual warehouse for all departments and use resource monitors to limit usage.
   • DUse a single warehouse and rely on the query optimizer to prioritize queries.
   Reveal Solution Discussion Select an answer first