SNOWFLAKE SNOWPRO
CORE COF-C03 PRACTICE
TEST 100 QUESTIONS
Question 1: A team wants to run a large ELT workload without slowing down
analysts who query the same tables. Which Snow�ake design characteristic best supports this requirement?
Choices:
1) Storage and compute are tightly coupled in each database 2) Independent virtual warehouses can access the same centralized data 3) Each schema must have its own physical storage cluster 4) Analysts must query replicated copies of the tables Correct Answer: Independent virtual warehouses can access the same centralized data Explanation: Snow�ake separates storage from compute. Independent virtual warehouses can query the same centralized data, so compute-heavy ELT can be isolated from analyst workloads without copying the tables.Page 1
Question 2: Query Pro�le shows a large amount of bytes spilled to remote storage during a hash aggregation. What is the most likely interpretation?
Choices:
1) The result cache was reused successfully 2) The query pruned all micro-partitions 3) The operation exceeded available warehouse memory and spilled intermediate data 4) The table is in Fail-safe
Correct Answer: The operation exceeded available warehouse memory and spilled
intermediate data Explanation: Remote spillage indicates that intermediate processing exceeded available memory and had to spill to remote storage, which can signi�cantly slow execution.
Question 3: Which access-control model is the recommended basis for granting
privileges to users in Snow�ake?
Choices:
1) Grant object privileges directly to every user 2) Grant privileges to roles and grant roles to users 3) Share ACCOUNTADMIN credentials among teams 4) Use network policies instead of roles
Correct Answer: Grant privileges to roles and grant roles to users
Explanation: Snow�ake RBAC assigns privileges to roles and then roles to users. This makes access easier to manage and supports role hierarchies.Page 2
Question 4: Which internal stage is automatically available to each Snow�ake user and is referenced with @~?
Choices:
1) Table stage 2) User stage 3) Named stage 4) External stage
Correct Answer: User stage
Explanation: Every user has a personal user stage referenced with @~. It can hold �les for that user and can be used with multiple target tables.Question 5: Which Snow�ake architecture layer is responsible for query parsing, optimization, authentication, and metadata management?
Choices:
1) Database Storage 2) Compute 3) External Functions 4) Cloud Services
Correct Answer: Cloud Services
Explanation: The Cloud Services layer coordinates services such as authentication, access control, metadata management, query parsing, and query optimization.Page 3