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

 

Question 1

Which Snowflake feature allows compute resources to be scaled independently from data storage?

1. Virtual warehouses
2. Snowpipe
3. Time Travel
4. Fail-safe

Correct Answer: 1

Explanation:

Snowflake separates compute from storage, allowing organizations to independently scale the compute resources used to process queries. Virtual warehouses provide the compute layer in Snowflake. A warehouse can be resized to increase or decrease processing power, and multiple warehouses can operate against the same underlying data without duplicating that data. Snowpipe is designed for continuous data ingestion, while Time Travel provides access to historical data. Fail-safe is a recovery mechanism managed by Snowflake. This separation of compute and storage is one of Snowflake’s fundamental architectural advantages because it provides flexibility, workload isolation, and independent resource management.

Question 2

Which Snowflake object provides the compute resources required to execute SQL queries?

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

Correct Answer: 2

Explanation:

A virtual warehouse is a cluster of compute resources used by Snowflake to execute queries and perform data-processing operations. Warehouses can be started, stopped, resized, and configured independently of the storage layer. A database is a logical container for schemas and data objects, while a schema organizes tables, views, and other objects. A stage is primarily used as a location for loading or unloading data. Because Snowflake separates compute from storage, users can choose an appropriately sized virtual warehouse for a workload without changing how the underlying data is stored.

Question 3

What is the primary purpose of Snowflake Time Travel?

1. Automatically encrypting database backups
2. Moving data between regions
3. Accessing or restoring historical versions of data
4. Increasing warehouse compute capacity

Correct Answer: 3

Explanation:

Snowflake Time Travel allows users to access historical data and recover data that may have been accidentally modified or deleted. For example, a query can reference a previous point in time to inspect what a table looked like before an accidental change. Time Travel is useful for recovering from user errors, analyzing historical states, and restoring objects within the applicable retention period. It does not increase compute capacity or provide automatic cross-region movement of data. Encryption is handled through Snowflake’s security architecture. Time Travel is therefore an important data-protection and recovery capability within Snowflake.

Question 4

Which Snowflake capability is designed for continuously loading new data from files into a table?

1. Snowpipe
2. Time Travel
3. Clustering
4. Resource Monitor

Correct Answer: 1

Explanation:

Snowpipe is designed for continuous, automated data ingestion into Snowflake tables. It can load data as new files become available in supported cloud storage locations. This makes Snowpipe particularly useful for near-continuous ingestion scenarios where organizations do not want to manually execute bulk loading commands every time new files arrive. Time Travel serves historical data recovery, clustering helps organize table data for query performance, and Resource Monitors are used to control and monitor credit consumption. Snowpipe therefore addresses the ingestion requirement rather than query optimization, historical recovery, or warehouse cost management.

Question 5

Which Snowflake feature can help reduce unnecessary credit consumption by automatically suspending an idle virtual warehouse?

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

Correct Answer: 2

Explanation:

Auto-suspend allows a virtual warehouse to automatically stop after remaining idle for a configured period. Since a running warehouse consumes compute credits, automatically suspending an inactive warehouse can help control costs. When new work arrives, the warehouse can be resumed if auto-resume is configured. Fail-safe is related to data recovery, Data Sharing allows data to be shared with other Snowflake accounts, and Time Travel provides historical data access. Auto-suspend is therefore an important warehouse-management setting for environments where workloads are intermittent or where controlling unnecessary compute consumption is a priority.

Question 6

Which Snowflake object is primarily used to organize tables, views, and other database objects?

1. Warehouse
2. Account
3. Schema
4. Stage

Correct Answer: 3

Explanation:

A schema is a logical container within a Snowflake database that organizes objects such as tables, views, stages, file formats, and other supported objects. This organization makes it easier to manage data assets and apply permissions at appropriate levels. A virtual warehouse provides compute resources rather than organizing data objects. An account represents the Snowflake environment, while a stage provides a location for files used during data loading and unloading. Understanding the database-schema-object hierarchy is fundamental to working with Snowflake because it also affects object naming, ownership, and access-control management.

Question 7

What happens when a virtual warehouse is resized to a larger size?

1. The underlying table storage is duplicated
2. The database retention period automatically increases
3. The warehouse receives more compute resources
4. Existing users are automatically removed

Correct Answer: 3

Explanation:

Resizing a virtual warehouse changes the amount of compute resources available to that warehouse. A larger warehouse generally provides more processing capacity, which can improve performance for workloads that can benefit from additional parallel compute resources. Resizing does not duplicate the underlying table data, change Time Travel retention automatically, or remove users. Because Snowflake separates compute from storage, warehouse size can be adjusted independently of the stored data. Organizations can therefore select different warehouse sizes based on workload requirements, query complexity, concurrency, and performance expectations.

Question 8

Which Snowflake feature allows data to be shared with other Snowflake accounts without requiring the recipient to copy the underlying data?

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

Correct Answer: 2

Explanation:

Snowflake Secure Data Sharing enables providers to share data with other Snowflake accounts without physically copying the shared data into the consumer’s environment. This approach can provide efficient and governed data distribution while keeping the provider in control of the shared objects. Snowpipe is an ingestion service, Time Travel provides historical data access, and Search Optimization Service is designed to improve query performance for certain access patterns. Secure Data Sharing is particularly useful for organizations that need to collaborate with customers, partners, business units, or other Snowflake accounts while avoiding unnecessary data duplication.

Question 9

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

1. COPY INTO
2. CREATE WAREHOUSE
3. ALTER ROLE
4. SHOW USERS

Correct Answer: 1

Explanation:

The COPY INTO command is commonly used to load data from staged files into Snowflake tables. It supports bulk data loading from internal or external stages and can work with supported file formats and loading options. CREATE WAREHOUSE is used to create compute resources, ALTER ROLE manages role properties, and SHOW USERS displays user information. During a typical batch-loading workflow, files are placed in a stage and then COPY INTO is executed to load the relevant data into the target table. Proper file formats, stages, and loading options are important for successful ingestion.

Question 10

Which Snowflake feature is intended to help improve query performance for selective point-lookup queries on large tables?

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

Correct Answer: 3

Explanation:

Search Optimization Service is designed to improve query performance for certain selective access patterns, particularly when queries frequently search for specific values within large tables. Snowflake can maintain additional search access structures that help locate relevant rows more efficiently. This feature is different from simply increasing warehouse size, because its purpose is related to improving data-access efficiency for supported query patterns. Resource Monitors manage credit usage, Snowpipe handles continuous ingestion, and Fail-safe is associated with data recovery. Search Optimization Service can therefore be useful when selective searches would otherwise require significant scanning.

Question 11

Which Snowflake concept is used to control what actions a user is allowed to perform on database objects?

1. Virtual warehouse
2. Role-based access control
3. Snowpipe
4. Time Travel

Correct Answer: 2

Explanation:

Snowflake uses role-based access control (RBAC) to manage permissions. Privileges can be granted to roles, and users can be assigned roles to obtain the permissions associated with those roles. This approach allows administrators to manage access according to job responsibilities and security requirements. Virtual warehouses provide compute resources, Snowpipe handles data ingestion, and Time Travel provides historical data access. RBAC can be applied to many Snowflake objects and operations, making it a core component of Snowflake security. Proper role design also helps organizations follow the principle of least privilege.

Question 12

What is the purpose of a Snowflake internal stage?

1. To provide compute resources
2. To store metadata about users
3. To hold files for loading into or unloading from Snowflake
4. To automatically create database roles

Correct Answer: 3

Explanation:

An internal stage provides storage within Snowflake for files that are involved in data loading and unloading operations. Files can be uploaded to an internal stage and subsequently loaded into tables, or data can be unloaded from Snowflake into staged files. Internal stages are different from virtual warehouses, which provide compute resources. They also do not function as user metadata repositories or role-creation mechanisms. Understanding stages is important because Snowflake supports multiple approaches for moving files between external storage systems and Snowflake tables, depending on the ingestion and export architecture.

Question 13

Which Snowflake capability allows multiple workloads to use separate compute resources while accessing the same underlying data?

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

Correct Answer: 3

Explanation:

Snowflake virtual warehouses allow different workloads to use separate compute resources while accessing the same centralized storage layer. For example, an organization can use one warehouse for reporting and another for data engineering without creating separate copies of the underlying tables. This architecture helps isolate workloads and allows compute resources to be scaled independently. Zero-copy cloning creates logical copies of objects without immediately duplicating the underlying storage, while Time Travel and Fail-safe address data recovery. Virtual warehouses are therefore the key component for independent compute execution across Snowflake workloads.

Question 14

What is a key characteristic of zero-copy cloning in Snowflake?

1. It immediately duplicates all physical data
2. It creates a clone without initially copying the underlying micro-partitions
3. It permanently deletes the source object
4. It requires a separate virtual warehouse for every clone

Correct Answer: 2

Explanation:

Zero-copy cloning allows Snowflake objects such as databases, schemas, and tables to be cloned without immediately creating a complete physical copy of the underlying data. The clone initially references the existing micro-partitions, which can make cloning very fast and storage-efficient. When changes are made to the clone or source, Snowflake manages the affected data separately as needed. This capability is useful for development, testing, and temporary environments. A clone does not automatically require a dedicated warehouse, and creating a clone does not delete the source object.

Question 15

Which Snowflake service helps monitor and control credit consumption for virtual warehouses?

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

Correct Answer: 1

Explanation:

Resource Monitors are used to monitor Snowflake credit usage and can help control consumption by defining thresholds and actions. Organizations can configure resource monitors to track credit usage and trigger notifications or other supported actions when specified limits are reached. This makes them useful for cost governance and preventing unexpected compute consumption. Snowpipe is focused on data ingestion, Secure Data Sharing enables data sharing between accounts, and Time Travel supports historical data access. Resource Monitors are therefore an important administrative feature for organizations that need visibility and controls around Snowflake credit usage.

Question 16

Which Snowflake storage concept represents the immutable units used internally to store table data?

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

Correct Answer: 2

Explanation:

Snowflake automatically organizes table data into micro-partitions, which are compressed and optimized units of storage. Micro-partitioning occurs automatically as data is loaded into Snowflake, so users generally do not manually define partitions in the traditional database sense. Snowflake uses metadata associated with micro-partitions to help eliminate unnecessary data during query processing. Virtual warehouses provide compute, roles control access, and stages hold files used for data movement. Understanding micro-partitions is important for understanding Snowflake’s storage architecture and why certain data-loading patterns and clustering strategies can influence query performance.

Question 17

Which Snowflake capability provides an additional recovery period after the Time Travel retention period has ended?

1. Secure Data Sharing
2. Fail-safe
3. Snowpipe
4. Search Optimization Service

Correct Answer: 2

Explanation:

Fail-safe provides a limited additional recovery period after the Time Travel retention period has ended. It is designed as a Snowflake-managed recovery mechanism for certain data-recovery scenarios rather than as a general-purpose historical querying feature. Users should not treat Fail-safe as an alternative to Time Travel because it is not intended for routine querying of historical data. Secure Data Sharing is used for sharing data, Snowpipe handles ingestion, and Search Optimization Service helps with certain query-performance patterns. Understanding the distinction between Time Travel and Fail-safe is important for designing appropriate data-protection strategies.

Question 18

Which Snowflake feature allows users to query historical data by specifying a previous point in time?

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

Correct Answer: 1

Explanation:

Time Travel allows users to access historical versions of Snowflake data within the applicable retention period. Queries can reference an earlier point in time or another supported historical specification to examine data as it existed previously. This can be valuable when investigating accidental updates, deletes, or other changes. Resource Monitors manage credit consumption, Snowpipe provides continuous data ingestion, and Data Sharing supports sharing data with other accounts. Time Travel is therefore the Snowflake feature most directly associated with querying and recovering historical states of supported objects.

Question 19

Which Snowflake architecture characteristic allows storage and compute to scale independently?

1. Automatic clustering
2. Separation of storage and compute
3. Secure Data Sharing
4. Role hierarchy

Correct Answer: 2

Explanation:

Snowflake’s architecture separates data storage from compute resources. Data is maintained in the storage layer, while virtual warehouses provide the compute required to execute queries and processing tasks. Because these layers are independent, organizations can scale compute without having to scale storage at the same time. This is particularly useful when data volume remains stable but query demand changes significantly. Automatic clustering addresses data organization, Secure Data Sharing addresses data distribution, and role hierarchy relates to access control. The separation of storage and compute is therefore a fundamental architectural characteristic of Snowflake.

Question 20

Which Snowflake feature is most appropriate for automatically detecting and processing newly arrived files in cloud storage for continuous ingestion?

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

Correct Answer: 3

Explanation:

Snowpipe is designed for continuous data ingestion and can automatically process newly available files from supported cloud storage locations. It is useful when organizations need data to become available in Snowflake shortly after files arrive rather than waiting for a manually initiated batch-loading process. Time Travel focuses on historical data access, Resource Monitors manage credit usage, and zero-copy cloning creates efficient copies of Snowflake objects. Snowpipe therefore fits scenarios where a steady stream of new files must be detected and loaded into Snowflake tables with minimal manual intervention.