View Full Snowflake SnowPro Core Exam Dumps and Practice Test Dumps.

 

Question 101

Which Snowflake feature allows users to recover or examine data from an earlier point in time?

1. Time Travel
2. Snowpipe
3. Resource Monitor
4. Search Optimization Service

Correct Answer: 1

Explanation:

Time Travel allows users to access historical versions of supported Snowflake data within the applicable retention period. It is useful for investigating accidental updates, deletes, or other unintended changes. Users can query data as it existed at an earlier point in time and use the results to support recovery workflows. Snowpipe is designed for continuous data ingestion, Resource Monitors help manage credit consumption, and Search Optimization Service improves certain selective query patterns. Time Travel is therefore the primary Snowflake feature for user-accessible historical data and recovery from recent data changes.

Question 102

Which Snowflake feature is designed to automatically ingest newly arrived files into Snowflake tables?

1. Fail-safe
2. Snowpipe
3. Time Travel
4. Zero-copy cloning

Correct Answer: 2

Explanation:

Snowpipe provides continuous or near-continuous data ingestion into Snowflake tables. It can process newly arrived files from supported cloud storage locations, reducing the need for administrators to repeatedly execute manual loading operations. This makes Snowpipe useful for event-driven ingestion and workloads where data needs to become available shortly after files arrive. Fail-safe provides a recovery mechanism, Time Travel enables historical data access, and zero-copy cloning creates efficient copies of Snowflake objects. Snowpipe is therefore the feature specifically designed for automated, continuous file ingestion.

Question 103

What is the primary purpose of a virtual warehouse in Snowflake?

1. To provide compute resources
2. To store database objects
3. To retain historical data
4. To manage user authentication

Correct Answer: 1

Explanation:

A virtual warehouse provides the compute resources used to execute SQL queries and perform data-processing workloads in Snowflake. Warehouses are separate from the storage layer, allowing organizations to independently scale compute resources according to workload requirements. Databases and schemas organize objects, Time Travel provides historical data access, and authentication is handled through Snowflake’s security architecture. Virtual warehouses can also be resized, suspended, and resumed, which gives administrators flexibility in managing both performance and compute costs.

Question 104

Which Snowflake feature allows a table to be cloned without immediately making a full physical copy of its underlying data?

1. Secure Data Sharing
2. Zero-copy cloning
3. Snowpipe
4. Resource Monitor

Correct Answer: 2

Explanation:

Zero-copy cloning creates a logical copy of supported Snowflake objects without immediately duplicating all of the underlying storage. The clone can initially reference the same micro-partitions as the source. When changes are made to the source or clone, Snowflake manages the affected storage separately. This makes cloning useful for development, testing, quality assurance, and temporary environments. Secure Data Sharing is designed for sharing data between accounts, Snowpipe handles ingestion, and Resource Monitors track credit usage. Zero-copy cloning therefore provides a fast and storage-efficient way to create object copies.

Question 105

Which Snowflake feature allows an organization to share data with another Snowflake account without requiring a traditional physical copy?

1. Secure Data Sharing
2. Time Travel
3. Snowpipe
4. Auto-suspend

Correct Answer: 1

Explanation:

Secure Data Sharing allows supported Snowflake data to be shared with other Snowflake accounts without requiring the provider to create and transfer a traditional physical copy. The provider can control what objects are shared, while consumers can access the shared data according to the configured permissions. This is useful for collaboration with customers, partners, suppliers, or other business units. Time Travel provides historical access, Snowpipe handles continuous ingestion, and auto-suspend manages warehouse activity. Secure Data Sharing is therefore the appropriate feature for governed cross-account data collaboration.

Question 106

Which Snowflake storage structure is automatically created as table data is loaded?

1. Micro-partitions
2. Virtual warehouses
3. Stages
4. Roles

Correct Answer: 1

Explanation:

Snowflake automatically organizes table data into micro-partitions as data is loaded. Micro-partitions are compressed storage units containing subsets of rows and metadata about the stored data. Snowflake can use this metadata to eliminate irrelevant micro-partitions during query processing, which can reduce unnecessary scanning. Users generally do not manually create or manage individual micro-partitions. Virtual warehouses provide compute resources, stages are used for file-based data movement, and roles control access. Micro-partitioning is therefore an important part of Snowflake’s automatic storage and query-optimization architecture.

Question 107

Which Snowflake setting can automatically stop a warehouse after it has been idle for a specified period?

1. Auto-suspend
2. Time Travel
3. Fail-safe
4. Snowpipe

Correct Answer: 1

Explanation:

Auto-suspend allows Snowflake to automatically suspend a virtual warehouse after it has remained idle for the configured period. Because running warehouses consume compute credits, automatically suspending unused warehouses can help reduce unnecessary costs. Auto-resume can be configured to restart a suspended warehouse when new work arrives. Time Travel provides historical data access, Fail-safe provides recovery capabilities, and Snowpipe handles continuous data ingestion. Auto-suspend is therefore a warehouse-management feature primarily used to control idle compute consumption.

Question 108

Which Snowflake capability can improve performance for certain selective searches against large tables?

1. Resource Monitor
2. Search Optimization Service
3. Snowpipe
4. Fail-safe

Correct Answer: 2

Explanation:

Search Optimization Service is designed to improve performance for certain selective search patterns, particularly when queries frequently look for specific values in large tables. Snowflake maintains additional search access structures that can help locate relevant data more efficiently for supported workloads. Resource Monitors are focused on credit management, Snowpipe handles continuous data ingestion, and Fail-safe provides recovery capabilities. Search Optimization Service is therefore a performance feature that may be useful when workload analysis identifies selective point-lookups or similar searches as an important performance requirement.

Question 109

Which command is commonly used to load data from staged files into a Snowflake table?

1. SELECT
2. COPY INTO
3. SHOW TABLES
4. CREATE ROLE

Correct Answer: 2

Explanation:

COPY INTO is commonly used to load data from staged files into Snowflake tables. It supports multiple file formats and loading options and can work with internal or external stages. A typical loading workflow involves placing files in a stage and then executing COPY INTO against the target table. SELECT is primarily used to query data, SHOW TABLES displays table information, and CREATE ROLE creates a role for access control. COPY INTO is therefore the command most directly associated with loading file-based data into Snowflake tables.

Question 110

What is the primary purpose of a Snowflake stage?

1. To provide compute resources
2. To hold or reference files used for loading and unloading data
3. To store user roles
4. To manage warehouse credits

Correct Answer: 2

Explanation:

A Snowflake stage provides a location for files involved in loading and unloading data. Internal stages can store files using Snowflake-managed storage, while external stages can reference supported cloud storage locations. Files can be placed in a stage before being loaded into tables, or data can be unloaded from Snowflake into staged files. Virtual warehouses provide compute resources, roles manage access privileges, and Resource Monitors track credit consumption. Stages are therefore an important part of Snowflake’s file-based data movement and ingestion architecture.

Question 111

Which Snowflake feature provides a Snowflake-managed recovery mechanism after the applicable Time Travel period has ended?

1. Fail-safe
2. Snowpipe
3. Secure Data Sharing
4. Auto-suspend

Correct Answer: 1

Explanation:

Fail-safe provides an additional Snowflake-managed recovery mechanism after the applicable Time Travel retention period has ended. It is intended for certain recovery scenarios and should not be treated as a replacement for Time Travel. Time Travel is designed for user-accessible historical queries and recovery during its retention period, while Fail-safe is managed by Snowflake. Snowpipe handles continuous ingestion, Secure Data Sharing enables cross-account data sharing, and auto-suspend manages warehouse inactivity. Understanding the distinction between Time Travel and Fail-safe is important for designing appropriate data-protection strategies.

Question 112

Which architectural characteristic allows multiple Snowflake warehouses to access the same stored data?

1. Separation of compute and storage
2. Fail-safe
3. Time Travel
4. Internal staging

Correct Answer: 1

Explanation:

Snowflake separates compute from storage, allowing multiple virtual warehouses to access the same underlying data. Each warehouse can provide independent compute resources for different workloads without requiring separate physical copies of the data. For example, an organization can use one warehouse for reporting and another for data engineering. Time Travel and Fail-safe are data-recovery capabilities, while staging supports file movement. Separation of compute and storage is therefore a fundamental architectural principle that enables workload isolation, independent scaling, and flexible resource management.

Question 113

Which Snowflake feature helps monitor credit consumption and enforce usage thresholds?

1. Resource Monitor
2. Snowpipe
3. Time Travel
4. Zero-copy cloning

Correct Answer: 1

Explanation:

Resource Monitors help organizations monitor Snowflake credit consumption and establish usage thresholds. Administrators can configure monitors to generate notifications or take supported actions when consumption reaches defined limits. This makes Resource Monitors useful for cost governance and preventing unexpected compute usage. Snowpipe focuses on continuous data ingestion, Time Travel provides historical data access, and zero-copy cloning creates efficient copies of Snowflake objects. Resource Monitors are therefore the feature most directly associated with monitoring and controlling Snowflake credit consumption.

Question 114

Which Snowflake feature is best suited for creating a development copy of an existing database or schema with minimal initial storage duplication?

1. Zero-copy cloning
2. Search Optimization Service
3. Snowpipe
4. Resource Monitor

Correct Answer: 1

Explanation:

Zero-copy cloning can create logical copies of supported databases, schemas, and tables without immediately duplicating all underlying storage. Initially, the clone can reference the same micro-partitions as the source. As changes occur, Snowflake manages the affected storage independently. This makes zero-copy cloning particularly useful for development, testing, and quality-assurance environments. Search Optimization Service focuses on query performance, Snowpipe handles continuous ingestion, and Resource Monitors manage credit usage. Zero-copy cloning is therefore the appropriate feature when a fast and storage-efficient copy of existing objects is required.

Question 115

Which Snowflake feature allows users to query historical table data after an accidental UPDATE?

1. Time Travel
2. Snowpipe
3. Resource Monitor
4. Secure Data Sharing

Correct Answer: 1

Explanation:

Time Travel allows users to access historical versions of supported Snowflake data within the configured retention period. If an accidental UPDATE changes important rows, users can use historical querying to examine the data as it existed before the modification. This capability can support investigation and recovery workflows. Snowpipe is designed for continuous ingestion, Resource Monitors track credit consumption, and Secure Data Sharing enables controlled cross-account data access. Time Travel is therefore the most appropriate feature when the requirement involves accessing data from before a recent accidental change.

Question 116

Which Snowflake service is designed for continuous file-based data ingestion?

1. Snowpipe
2. Time Travel
3. Fail-safe
4. Search Optimization Service

Correct Answer: 1

Explanation:

Snowpipe provides continuous or near-continuous ingestion of files into Snowflake tables. It can process newly available files from supported cloud storage locations and reduce the need for manually triggered batch-loading processes. Snowpipe is particularly useful for workloads where files arrive frequently and the organization wants them loaded soon after arrival. Time Travel provides historical access, Fail-safe provides recovery capabilities, and Search Optimization Service addresses certain query-performance patterns. Snowpipe is therefore the Snowflake capability specifically designed for automated, ongoing file ingestion.

Question 117

Which Snowflake feature is most appropriate for monitoring warehouse credit usage against configured limits?

1. Resource Monitor
2. Zero-copy cloning
3. Snowpipe
4. Time Travel

Correct Answer: 1

Explanation:

Resource Monitors are designed to monitor credit consumption and provide controls around Snowflake resource usage. Administrators can define thresholds and configure supported notifications or actions when consumption reaches those thresholds. This is useful for organizations that want to establish cost controls around warehouses and workloads. Zero-copy cloning is used to create efficient object copies, Snowpipe handles continuous data ingestion, and Time Travel provides historical data access. Resource Monitors therefore address the requirement for monitoring and governing credit consumption.

Question 118

Which Snowflake capability allows users to create a fast copy of a table for testing without immediately duplicating all storage?

1. Zero-copy cloning
2. Secure Data Sharing
3. Fail-safe
4. Auto-suspend

Correct Answer: 1

Explanation:

Zero-copy cloning allows users to create logical copies of supported Snowflake objects without immediately duplicating the entire underlying storage. This is useful for testing because teams can create copies of tables or other objects quickly while minimizing initial storage requirements. As modifications occur, Snowflake manages the affected data separately. Secure Data Sharing is used to share data between accounts, Fail-safe supports recovery, and auto-suspend manages warehouse inactivity. Zero-copy cloning is therefore a practical solution for quickly creating test or development copies.

Question 119

Which Snowflake feature allows an organization to provide controlled access to shared data without physically moving the data to another account?

1. Secure Data Sharing
2. Snowpipe
3. Time Travel
4. Search Optimization Service

Correct Answer: 1

Explanation:

Secure Data Sharing enables providers to share supported Snowflake data with other Snowflake accounts without requiring traditional physical data movement or duplication. The provider can control which objects are shared and manage access through Snowflake’s security and sharing mechanisms. This makes it useful for governed collaboration with external organizations or internal business units. Snowpipe handles data ingestion, Time Travel provides historical access, and Search Optimization Service improves certain query patterns. Secure Data Sharing is therefore the best choice when controlled data access is required without copying the underlying data.

Question 120

Which statement best describes the relationship between Snowflake storage and virtual warehouses?

1. A warehouse permanently stores all table data
2. Storage and compute are separated, with warehouses providing compute
3. Each table requires a dedicated warehouse
4. Storage is available only while a warehouse is running

Correct Answer: 2

Explanation:

Snowflake separates the storage layer from the compute layer. Virtual warehouses provide the compute resources required to execute queries and data-processing workloads, while Snowflake’s storage layer maintains the data independently. Because of this separation, multiple warehouses can access the same data, and warehouses can be resized or suspended without moving the stored data. A table does not require its own warehouse, and data remains stored even when a warehouse is suspended. This architecture gives Snowflake flexibility for workload isolation, independent scaling, and efficient compute management.