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

 

Question 41

Which Snowflake feature allows users to recover a dropped table within the applicable Time Travel retention period?

1. Fail-safe
2. Data sharing
3. Time Travel
4. Search optimization

Correct Answer: 3

Explanation

Snowflake Time Travel provides the ability to access historical data and recover supported objects within the configured retention period. If a table is accidentally dropped, an administrator can use the appropriate undrop capability while the object remains recoverable through Time Travel. Fail-safe is a separate recovery mechanism that applies after the Time Travel period and is not intended for routine user-controlled recovery. Data sharing concerns controlled data access, while search optimization improves query performance for eligible workloads. Time Travel is therefore the appropriate Snowflake capability when recovering a dropped table within its retention window.

Question 42

Which command can be used to recover a dropped table when it is still available through Time Travel?

1. RESTORE TABLE
2. UNDROP TABLE
3. RECOVER TABLE
4. REVERT TABLE

Correct Answer: 2

Explanation

The UNDROP TABLE command is used to restore a dropped table when the table remains within the applicable recovery period. Snowflake’s Time Travel capability makes this recovery possible by retaining historical information for the configured period. The command restores the table as a database object so that it can become available again according to the applicable Snowflake rules. RESTORE TABLE, RECOVER TABLE, and REVERT TABLE are not the standard Snowflake commands for this purpose. Understanding UNDROP is important for administrators because accidental object deletion is a common operational recovery scenario.

Question 43

Which Snowflake feature is primarily intended to improve query performance for highly selective access patterns?

1. Search Optimization Service
2. Data sharing
3. Time Travel
4. Role hierarchy

Correct Answer: 1

Explanation

Snowflake Search Optimization Service is designed to improve query performance for certain highly selective access patterns. It maintains additional search access paths that can help Snowflake locate relevant rows more efficiently instead of scanning large portions of a table. It is particularly useful for workloads where queries frequently filter on selective values and the underlying table is large. Time Travel serves historical recovery and querying purposes, while data sharing handles controlled data distribution. Role hierarchies address authorization. Search optimization should therefore be considered a performance feature rather than a storage, recovery, or security mechanism.

Question 44

What does clustering primarily help Snowflake optimize?

1. User authentication
2. Data organization for query performance
3. Cross-account data sharing
4. File encryption

Correct Answer: 2

Explanation

Clustering helps organize table data based on clustering keys so that Snowflake can more efficiently scan relevant micro-partitions for certain query patterns. Better clustering can improve performance when queries frequently filter or join on columns that benefit from this organization, particularly for large tables with appropriate workloads. Clustering does not authenticate users, provide cross-account sharing, or serve as the primary mechanism for file encryption. It is a performance-oriented capability that should be considered based on actual query behavior and data distribution. Not every table requires a clustering key, so workload characteristics should guide its use.

Question 45

Which Snowflake object contains metadata about a table’s micro-partitions and helps support efficient data scanning?

1. Database
2. Micro-partition metadata
3. User role
4. File format

Correct Answer: 2

Explanation

Snowflake maintains metadata about micro-partitions that can help determine which portions of a table need to be scanned for a query. Micro-partitions are automatically created as Snowflake stores table data, and metadata associated with them includes information that can support partition pruning. When query predicates align with the values represented in this metadata, Snowflake can avoid scanning irrelevant micro-partitions. A database organizes schemas and objects, a role controls privileges, and a file format describes staged file structure. Understanding micro-partition metadata is therefore important when learning how Snowflake can optimize table scans automatically.

Question 46

What is the main purpose of micro-partition pruning?

1. To restrict users from logging in
2. To avoid scanning unnecessary micro-partitions
3. To create additional virtual warehouses
4. To duplicate tables between accounts

Correct Answer: 2

Explanation

Micro-partition pruning allows Snowflake to skip micro-partitions that cannot contain rows satisfying a query’s filtering conditions. Snowflake automatically maintains metadata about the values within micro-partitions, allowing the query engine to identify which partitions are relevant. By reducing the amount of data that must be scanned, pruning can improve query performance and reduce the resources required for eligible queries. It does not control authentication, create warehouses, or duplicate tables. Effective pruning depends on factors such as data organization and query predicates, making it an important concept when understanding Snowflake’s columnar storage and query execution behavior.

Question 47

A table contains millions of rows, but a query filters on a value that occurs in very few rows. Which Snowflake behavior can reduce unnecessary scanning?

1. Micro-partition pruning
2. Role inheritance
3. Secure sharing
4. Warehouse suspension

Correct Answer: 1

Explanation

Micro-partition pruning can reduce unnecessary scanning when Snowflake’s metadata indicates that particular micro-partitions cannot contain rows matching the query predicate. For a highly selective filter, this may allow the query engine to skip many irrelevant partitions and focus on the portions of the table that may contain matching records. Role inheritance affects authorization rather than query scanning. Secure sharing controls data access between accounts, and warehouse suspension affects compute availability. The ability to prune irrelevant micro-partitions is one reason Snowflake can efficiently query large tables without requiring users to manually partition data in the traditional database sense.

Question 48

Which Snowflake concept describes the automatic division of table data into contiguous storage units?

1. Clusters
2. Micro-partitions
3. Roles
4. Schemas

Correct Answer: 2

Explanation

Snowflake automatically divides table data into micro-partitions, which are contiguous storage units used internally by the platform. Users generally do not need to manually define traditional partitions for standard Snowflake tables. Snowflake stores metadata about these micro-partitions and can use that information for operations such as partition pruning. Clusters in the context of virtual warehouses refer to compute resources, while roles and schemas serve security and organizational purposes. Micro-partitions are therefore a fundamental storage concept in Snowflake and help explain how the platform manages large volumes of structured table data efficiently.

Question 49

Which Snowflake feature allows a warehouse to use additional clusters to handle increased concurrent workloads?

1. Time Travel
2. Search optimization
3. Multi-cluster warehouse
4. Secure view

Correct Answer: 3

Explanation

A multi-cluster warehouse can use multiple compute clusters to help handle increased concurrency. When many users or applications submit queries at the same time, additional clusters can provide more compute capacity for concurrent execution, depending on the warehouse configuration and workload. This capability addresses concurrency rather than the storage organization of table data. Time Travel manages historical data access, search optimization targets selective query performance, and secure views support controlled data exposure. Multi-cluster warehouses are therefore useful when a workload’s main challenge is simultaneous query demand rather than insufficient storage or authorization controls.

Question 50

A workload has sufficient compute capacity for individual queries but experiences delays because many users query the warehouse simultaneously. Which capability is relevant?

1. Multi-cluster warehouses
2. Time Travel
3. External stages
4. File formats

Correct Answer: 1

Explanation

When individual queries have sufficient compute resources but users experience delays because of high concurrency, a multi-cluster warehouse can provide additional compute clusters to process simultaneous workloads. This differs from simply increasing the size of a single cluster, which primarily changes the compute capacity available to queries running on that cluster. External stages and file formats concern file-based data movement, while Time Travel provides historical data access. Multi-cluster configuration is therefore relevant when concurrency, rather than individual query complexity, is the main performance concern. Proper configuration should consider workload patterns and organizational requirements.

Question 51

Which Snowflake capability can automatically suspend a warehouse after it remains inactive for a configured period?

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

Correct Answer: 2

Explanation

AUTO_SUSPEND controls whether a virtual warehouse automatically suspends after remaining inactive for a configured period. Suspending an unused warehouse releases its compute resources, which can help prevent unnecessary compute consumption during periods of inactivity. AUTO_RESUME performs the opposite function by allowing a suspended warehouse to resume automatically when required by a workload. QUERY_TAG helps identify or categorize queries, while STATEMENT_TIMEOUT_IN_SECONDS controls how long statements may run. Therefore, AUTO_SUSPEND is the setting directly associated with automatically stopping an idle warehouse after the configured inactivity interval.

Question 52

Which setting controls whether a suspended warehouse automatically starts when a statement requires it?

1. AUTO_RESUME
2. AUTO_SUSPEND
3. MAX_CLUSTER_COUNT
4. QUERY_TAG

Correct Answer: 1

Explanation

AUTO_RESUME determines whether a suspended Snowflake virtual warehouse can automatically resume when a statement requires compute resources from it. This setting is useful for workloads where administrators want warehouses to become available automatically without manually issuing a resume command. AUTO_SUSPEND instead controls automatic suspension after inactivity. MAX_CLUSTER_COUNT relates to the maximum number of clusters available for a multi-cluster warehouse, while QUERY_TAG is used to associate identifying information with queries. AUTO_RESUME and AUTO_SUSPEND are often configured together so that compute resources can stop during inactivity and restart when new workload demand appears.

Question 53

Which Snowflake feature helps limit or monitor credit consumption by virtual warehouses?

1. Resource monitor
2. Secure view
3. Stream
4. File format

Correct Answer: 1

Explanation

A Snowflake resource monitor helps administrators monitor credit usage and can be configured with thresholds and actions for warehouses associated with the monitor. This provides a mechanism for managing and controlling consumption according to organizational policies. Resource monitors are separate from query performance features and data access objects. Secure views protect view definitions, streams track data changes, and file formats define how staged files are interpreted. Resource monitors are therefore particularly relevant for cost governance. Administrators can use them to establish usage boundaries and receive notifications or take configured actions when consumption reaches specified thresholds.

Question 54

Which Snowflake capability provides detailed information about query execution to help identify performance bottlenecks?

1. Query Profile
2. Data Share
3. User Stage
4. Time Travel

Correct Answer: 1

Explanation

Snowflake Query Profile provides information about how a query was executed, including operators and processing details that can help identify performance bottlenecks. Administrators and developers can use this information to investigate issues such as expensive operations, large data scans, or inefficient processing stages. Data sharing is concerned with controlled data access, user stages support file staging, and Time Travel provides historical data access. Query Profile is therefore an important troubleshooting tool when a query is slower than expected. Reviewing execution details can help determine whether optimization should focus on SQL design, data organization, or compute resources.

Question 55

Which Snowflake feature provides a way to label queries with user-defined identifying information?

1. Query tag
2. File format
3. Stage
4. Stream

Correct Answer: 1

Explanation

A query tag allows users or administrators to associate a custom identifier with queries. Query tags can be useful for workload identification, monitoring, troubleshooting, and usage analysis because administrators can distinguish queries belonging to different applications, teams, or processes. A file format defines how staged files are interpreted, a stage provides a file location, and a stream records changes to supported data objects. Query tags do not change the underlying query logic; instead, they provide metadata that can help organize and analyze query activity. This makes them useful in environments with many concurrent workloads.

Question 56

Which Snowflake feature is designed to improve performance for eligible queries without requiring users to rewrite the SQL statement?

1. Query Acceleration Service
2. User stage
3. Role hierarchy
4. Time Travel

Correct Answer: 1

Explanation

Snowflake Query Acceleration Service can provide additional compute resources for portions of eligible queries, helping improve performance for certain workloads without requiring users to redesign the query itself. It is intended for situations where query processing can benefit from additional resources beyond those available through the standard warehouse execution model. User stages handle file staging, role hierarchies manage privileges, and Time Travel addresses historical data access. Query Acceleration Service should not be viewed as a universal performance solution; its usefulness depends on workload characteristics and query patterns. Administrators should evaluate actual performance behavior before enabling it.

Question 57

Which Snowflake object can contain SQL logic that is reused by multiple queries or applications?

1. Stored procedure
2. Warehouse
3. Stage
4. Resource monitor

Correct Answer: 1

Explanation

A Snowflake stored procedure can encapsulate procedural or SQL-based logic that can be invoked by users or applications. Stored procedures are useful for implementing reusable operations, administrative workflows, and data-processing logic that may involve multiple statements or procedural behavior. A warehouse supplies compute resources, a stage manages files, and a resource monitor tracks credit consumption. Stored procedures are distinct from views because a view primarily represents a reusable query definition for retrieving data, whereas a procedure can execute logic and perform supported operations. Their use should follow appropriate security and operational design practices.

Question 58

Which Snowflake feature can automatically execute SQL at defined intervals without requiring an external scheduler?

1. Task
2. Stage
3. Share
4. File format

Correct Answer: 1

Explanation

Snowflake Tasks can schedule SQL statements or supported procedures to execute automatically according to defined schedules. This allows organizations to automate recurring transformations, maintenance operations, and other data-processing activities without requiring a separate external scheduling system for every workflow. Tasks can also participate in task graphs to establish dependencies between processing steps. Stages are used for files, shares provide controlled data access, and file formats define file interpretation. Tasks therefore provide a native mechanism for scheduled execution within Snowflake and can be combined with streams for incremental data-processing pipelines.

Question 59

Which statement best describes a Snowflake stream?

1. It stores a complete independent copy of a table
2. It tracks metadata about changes to supported source objects
3. It replaces the need for all warehouses
4. It automatically schedules SQL statements

Correct Answer: 2

Explanation

A Snowflake stream records metadata that enables downstream processing to identify changes made to supported source objects. It is commonly used in change data capture workflows where only newly inserted, updated, or deleted rows need to be processed. A stream does not represent a complete independent copy of the source table and does not provide compute resources. It also does not schedule SQL statements; Tasks provide scheduling and automated execution. By exposing change information from a source object, streams can help organizations build incremental pipelines that avoid repeatedly processing an entire dataset.

Question 60

A data pipeline uses a stream to identify changed records and a task to process them periodically. What does the stream primarily provide?

1. Compute capacity
2. Change tracking information
3. User authentication
4. File compression

Correct Answer: 2

Explanation

In this pipeline design, the stream primarily provides information about changes made to the source object since the relevant stream offset. The task then executes processing logic that consumes or acts on those changes according to its schedule or dependency configuration. The stream itself does not provide compute capacity, authenticate users, or compress files. Compute is supplied by a virtual warehouse, authentication is handled through Snowflake’s security architecture, and file compression is associated with supported file formats and data movement operations. This separation of responsibilities allows streams and tasks to work together in incremental data pipelines.