View Full Snowflake SnowPro Core COF-C03 Exam Dumps and Practice Test Dumps.

 

Question 1

Which Snowflake architecture component is primarily responsible for storing persistent table data?

1. Virtual warehouse
2. Cloud services layer
3. Database storage layer
4. Query optimizer

Correct Answer: 3

Explanation

Snowflake separates data storage from compute and cloud services. The storage layer is responsible for persisting table data in Snowflake’s optimized, compressed, and columnar storage format. Users do not manage the underlying storage infrastructure directly. Virtual warehouses provide compute resources for executing queries, while the cloud services layer handles functions such as authentication, metadata management, query optimization, and access control. This separation allows storage and compute to scale independently. As a result, organizations can store large amounts of data without keeping a dedicated compute cluster running continuously when queries are not being executed.

Question 2

A company needs to run queries without affecting the compute resources used by another workload. What should it use?

1. A separate virtual warehouse
2. A new database
3. A new schema
4. A new file format

Correct Answer: 1

Explanation

A separate virtual warehouse provides independent compute resources for a workload. Snowflake allows multiple virtual warehouses to operate independently against the same underlying data. This architecture helps isolate workloads such as reporting, data loading, and transformation jobs. Creating another database or schema would organize or separate logical data objects, but it would not provide independent compute resources. A file format defines how data is interpreted during loading or unloading and also does not isolate query execution. Therefore, when the requirement is compute isolation between workloads, creating a separate virtual warehouse is the appropriate approach.

Question 3

What happens when a virtual warehouse is suspended in Snowflake?

1. Stored table data is deleted
2. Running queries continue indefinitely
3. The warehouse’s compute resources are released
4. Database objects become inaccessible

Correct Answer: 3

Explanation

When a Snowflake virtual warehouse is suspended, its compute resources are released. Suspending a warehouse does not delete databases, schemas, tables, or stored data. It simply stops the compute infrastructure associated with that warehouse, which can reduce compute costs while the warehouse is not processing workloads. When a query later requires the warehouse, it can be resumed manually or automatically if auto-resume is enabled. This separation between persistent storage and compute is an important Snowflake architectural characteristic. Data remains available because it is maintained independently of the warehouse’s temporary compute resources.

Question 4

Which Snowflake object provides the logical container for schemas and database objects?

1. Database
2. Virtual warehouse
3. Role
4. Stage

Correct Answer: 1

Explanation

A Snowflake database is a logical container that holds schemas, which in turn contain objects such as tables, views, stages, and other database objects. This hierarchical organization helps administrators structure data according to business domains, environments, or applications. A virtual warehouse is a compute resource rather than a data container. A role is used for access control and privileges, while a stage provides a location for files used in data loading and unloading. Understanding Snowflake’s object hierarchy is important because fully qualified object names commonly follow the database.schema.object pattern.

Question 5

Which Snowflake feature allows multiple users or applications to query the same data using separate compute resources?

1. Data sharing
2. Multi-cluster warehouses
3. Independent virtual warehouses
4. Database replication

Correct Answer: 3

Explanation

Independent virtual warehouses allow different users, teams, or applications to execute workloads against the same Snowflake data while using separate compute resources. Because compute is separated from storage, multiple warehouses can access the same databases and tables without requiring duplicate copies of the data. Data sharing is designed to provide controlled access to data between accounts, while replication focuses on copying supported objects and data across Snowflake accounts or regions. Multi-cluster warehouses address concurrency within a warehouse by adding clusters when needed. Therefore, independent warehouses are the appropriate mechanism for workload compute separation.

Question 6

Which Snowflake layer handles authentication, metadata management, and access control?

1. Storage layer
2. Cloud services layer
3. Compute layer
4. Local client layer

Correct Answer: 2

Explanation

Snowflake’s cloud services layer provides many centralized platform services, including authentication, authorization, metadata management, infrastructure management, and query coordination. It also participates in query parsing and optimization before workloads are executed by virtual warehouses. The storage layer persists data, while the compute layer executes queries and other processing tasks through virtual warehouses. A client application connects to Snowflake but is not itself a Snowflake architecture layer responsible for these centralized services. Understanding the separation of responsibilities among Snowflake’s layers helps explain how the platform can independently scale storage, compute, and management functions.

Question 7

An administrator wants a warehouse to automatically start when a query is submitted after the warehouse has been suspended. Which setting should be enabled?

1. AUTO_SUSPEND
2. AUTO_RESUME
3. STATEMENT_TIMEOUT_IN_SECONDS
4. RESOURCE_MONITOR

Correct Answer: 2

Explanation

The AUTO_RESUME setting allows a suspended virtual warehouse to automatically resume when a statement requiring that warehouse is submitted. This is useful for workloads where administrators want compute resources to become available without manually starting the warehouse. AUTO_SUSPEND controls when an inactive warehouse should suspend after a specified period, helping reduce unnecessary compute consumption. STATEMENT_TIMEOUT_IN_SECONDS limits how long statements may execute, while a resource monitor helps monitor or control credit usage. Therefore, AUTO_RESUME directly addresses the requirement for automatic warehouse startup when new work arrives.

Question 8

Which Snowflake object is commonly used to organize tables and views within a database?

1. Schema
2. Warehouse
3. Role
4. Share

Correct Answer: 1

Explanation

A schema is a logical container inside a Snowflake database that organizes database objects such as tables, views, stages, file formats, sequences, and other supported objects. Using schemas helps organizations structure data according to departments, applications, environments, or functional areas. A warehouse provides compute resources and does not contain database objects. A role controls privileges and is part of Snowflake’s security model, while a share is used to make selected data available to other Snowflake accounts. The hierarchy of database, schema, and object is fundamental when creating, referencing, and securing Snowflake data objects.

Question 9

Which statement about Snowflake virtual warehouses is correct?

1. A warehouse permanently stores table data
2. A warehouse is required to maintain metadata
3. A warehouse provides compute resources
4. A warehouse replaces database objects

Correct Answer: 3

Explanation

A Snowflake virtual warehouse is a cluster of compute resources used to execute operations such as SQL queries, data loading, and data transformation. Warehouses are independent from Snowflake’s persistent storage, allowing compute capacity to be scaled or suspended without removing stored data. Metadata and platform management functions are primarily handled through the cloud services layer. Databases, schemas, tables, and views remain logical data objects and are not replaced by warehouses. This separation enables organizations to select different warehouse sizes for different workloads and independently manage compute consumption according to workload requirements.

Question 10

A Snowflake administrator needs to give a user permission to query a table without granting ownership of it. Which privilege is required?

1. OWNERSHIP
2. SELECT
3. CREATE TABLE
4. USAGE

Correct Answer: 2

Explanation

The SELECT privilege allows a role to retrieve data from a table or view without giving that role ownership of the object. Snowflake uses role-based access control, so privileges are generally granted to roles and roles are then assigned to users. OWNERSHIP provides extensive control over an object and is not necessary merely to query its data. CREATE TABLE is associated with creating tables in a schema, while USAGE is commonly required on parent objects such as databases, schemas, or warehouses depending on the operation. Therefore, SELECT is the specific table privilege needed for querying data.

Question 11

Which Snowflake capability is designed to separate storage costs from compute costs?

1. Virtual warehouse architecture
2. Stored procedure execution
3. Role hierarchy
4. Database naming

Correct Answer: 1

Explanation

Snowflake’s architecture separates persistent storage from compute through virtual warehouses. Data is stored independently, while warehouses provide compute resources when queries or data-processing operations need to run. Because warehouses can be resized, suspended, resumed, or created separately for different workloads, organizations can manage compute consumption without changing how data is stored. This separation also allows several warehouses to access the same data concurrently. Role hierarchies and database naming are important for security and organization but do not provide storage and compute separation. The independent architecture is a fundamental reason Snowflake can scale workloads flexibly.

Question 12

Which command is commonly used to make a suspended virtual warehouse available for query execution?

1. ALTER WAREHOUSE … RESUME
2. ALTER DATABASE … RESUME
3. START TABLE
4. RESUME SCHEMA

Correct Answer: 1

Explanation

The ALTER WAREHOUSE command can be used to modify a virtual warehouse, including resuming a warehouse that is currently suspended. Once resumed, the warehouse can provide compute resources for queries and other supported operations. Snowflake does not use START TABLE or RESUME SCHEMA commands for this purpose because tables and schemas are logical objects rather than compute resources. The database command also does not control warehouse availability. Administrators can additionally configure AUTO_RESUME so that Snowflake automatically resumes a suspended warehouse when work requires it, reducing the need for manual intervention.

Question 13

Which Snowflake feature helps automatically add compute clusters when query concurrency increases?

1. Time Travel
2. Multi-cluster warehouses
3. Secure views
4. Fail-safe

Correct Answer: 2

Explanation

Multi-cluster warehouses are designed to improve workload concurrency by allowing Snowflake to use multiple compute clusters within a warehouse. When configured appropriately, additional clusters can be started as concurrency requirements increase, helping accommodate more simultaneous queries. Time Travel provides historical access to changed or deleted data, while secure views support controlled data exposure and Fail-safe is a separate data recovery mechanism. Multi-cluster capability addresses a compute concurrency challenge rather than a storage recovery or data governance requirement. This makes it useful for workloads where many users or applications submit queries at the same time.

Question 14

What is the primary purpose of Snowflake Time Travel?

1. To increase warehouse size
2. To recover or query historical data within the retention period
3. To create user roles automatically
4. To accelerate external network transfers

Correct Answer: 2

Explanation

Snowflake Time Travel allows authorized users to access historical versions of data within the configured retention period. It can be used to query or restore data that was changed or accidentally deleted, subject to applicable retention settings and object support. Time Travel is a data protection and recovery capability rather than a compute scaling mechanism. Warehouse sizing affects query compute resources, while roles control access privileges. External network transfer is unrelated to Time Travel. By maintaining historical data information for the configured period, Snowflake provides users with a convenient way to investigate changes and recover from certain accidental modifications.

Question 15

Which object is used to define a named collection of privileges that can be granted to users?

1. Stage
2. Role
3. Warehouse
4. File format

Correct Answer: 2

Explanation

A Snowflake role is a named collection of privileges that can be granted to users or other roles. Roles form the foundation of Snowflake’s role-based access control model. Instead of granting every privilege independently to each user, administrators can create roles that represent responsibilities and then assign the appropriate roles to users. A stage manages file locations for loading and unloading, a warehouse supplies compute resources, and a file format defines how data files are interpreted. Role hierarchies can also be used to inherit privileges, simplifying security administration across larger Snowflake environments.

Question 16

A user can connect to Snowflake but receives an authorization error when selecting from a table. What should an administrator primarily check?

1. The user’s screen resolution
2. The table’s assigned file format
3. The active role and required privileges
4. The warehouse’s auto-suspend duration

Correct Answer: 3

Explanation

An authorization error after successful authentication generally requires checking the active role and its privileges on the requested objects. Snowflake separates authentication from authorization, so a user may successfully connect while still lacking the necessary permissions. For table access, the role may need appropriate privileges on the database, schema, and table, depending on the operation. File format settings do not determine whether a user can select from a table, and warehouse auto-suspend settings affect compute availability rather than object authorization. Checking the role hierarchy, active role, and relevant grants is therefore an appropriate troubleshooting approach.

Question 17

Which Snowflake feature allows a query to access data as it existed at an earlier point in time?

1. Clustering
2. Time Travel
3. Result caching
4. Search optimization

Correct Answer: 2

Explanation

Time Travel enables supported historical data access by allowing users to query data as it existed at an earlier point within the configured retention period. This capability is useful for investigating accidental changes, recovering dropped or modified data, and comparing historical states. Result caching can return previously generated query results when applicable, but it does not provide historical versions of table data. Clustering can improve data organization for query performance, while search optimization can improve certain selective searches. Therefore, when the requirement specifically involves viewing an earlier version of data, Time Travel is the relevant Snowflake capability.

Question 18

Which Snowflake feature can reduce the need to repeatedly execute an identical query when its cached result is still valid?

1. Result cache
2. Time Travel
3. Fail-safe
4. Data sharing

Correct Answer: 4

Explanation

Snowflake’s result caching capability can allow eligible queries to reuse previously generated results rather than processing the underlying data again. This can reduce query execution time and avoid unnecessary compute work when the required conditions for result reuse are satisfied. Time Travel addresses historical data access, Fail-safe provides a separate recovery mechanism, and data sharing enables controlled access to data across accounts. Result caching is therefore the feature associated with reusing query results. It is important to understand that cache reuse depends on factors such as query equivalence, underlying data changes, and other Snowflake conditions.

Question 19

Which Snowflake capability is intended primarily for recovering historical data after the Time Travel retention period?

1. Fail-safe
2. Result cache
3. Query acceleration
4. Multi-cluster warehouse

Correct Answer: 1

Explanation

Fail-safe provides a separate, limited recovery mechanism for historical data after the applicable Time Travel period has ended. It is not intended to function as a user-controlled replacement for Time Travel or as a general data backup system. Time Travel is the primary feature users can use for querying and restoring historical data during its configured retention period. Result caching improves query efficiency, while query acceleration and multi-cluster warehouses address compute performance and concurrency. Fail-safe is managed by Snowflake and is primarily designed as a recovery option in circumstances where historical data is no longer available through Time Travel.

Question 20

A company wants to organize data objects for separate development and production environments within one Snowflake database. Which object is most appropriate for this organization?

1. Virtual warehouse
2. Schema
3. Role
4. Stage

Correct Answer: 2

Explanation

Schemas are appropriate for logically organizing database objects within a Snowflake database. An organization could use separate schemas for development and production objects, provided that the chosen structure fits its governance and access requirements. Virtual warehouses provide compute resources rather than organizing data objects. Roles are used for authorization, while stages provide locations for files involved in data loading and unloading. Using schemas to separate environments can make object names, permissions, and administrative responsibilities easier to manage. The exact design may vary, but schema-level organization is the relevant Snowflake construct for this requirement.