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

 

Question 21

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

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

Correct Answer: 3

Explanation:

A virtual warehouse provides the compute resources used to execute SQL queries and perform data-processing operations in Snowflake. Warehouses operate independently from Snowflake’s storage layer, allowing organizations to increase or decrease compute capacity without changing the stored data. A database is used to organize schemas, while schemas contain tables, views, and other objects. A stage is used to store files for loading and unloading data. Virtual warehouses can also be suspended, resumed, and resized according to workload requirements, making them an important component of Snowflake performance and cost management.

Question 22

Which Snowflake feature allows users to create a copy of a table without immediately duplicating all of its underlying storage?

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

Correct Answer: 2

Explanation:

Zero-copy cloning allows supported Snowflake objects to be cloned without immediately creating a complete physical copy of the underlying data. The clone initially references the same micro-partitions as the source. If changes are later made to either the source or clone, Snowflake manages the affected data separately. This approach makes cloning very fast and storage-efficient. It is commonly useful for development, testing, and temporary environments. Time Travel provides historical data access, Snowpipe handles continuous data ingestion, and Fail-safe provides a recovery mechanism after the applicable Time Travel period.

Question 23

What is the primary purpose of a Snowflake database?

1. To provide compute resources
2. To automatically load files
3. To monitor credit consumption
4. To organize schemas and database objects

Correct Answer: 4

Explanation:

A Snowflake database is a logical container used to organize schemas and the objects contained within those schemas. Tables, views, stages, file formats, and other objects can be organized under schemas within a database. A database itself does not provide compute resources; virtual warehouses perform that function. Automatic file ingestion is handled by services such as Snowpipe, while Resource Monitors can help track credit usage. Understanding the hierarchy of account, database, schema, and objects is important for managing Snowflake environments and applying appropriate access privileges.

Question 24

Which Snowflake feature is primarily used to continuously ingest newly arrived files into a table?

1. Snowpipe
2. Time Travel
3. Fail-safe
4. Resource Monitor

Correct Answer: 1

Explanation:

Snowpipe is designed for continuous or near-continuous data ingestion into Snowflake. It can detect newly available files in supported cloud storage locations and initiate loading into target tables. This is useful when organizations need data to become available shortly after it arrives rather than waiting for a manually executed batch process. Time Travel is used to access historical data, Fail-safe provides an additional recovery mechanism, and Resource Monitors help manage credit consumption. Snowpipe therefore addresses automated file ingestion rather than historical recovery, cost management, or storage recovery.

Question 25

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

1. Clustering
2. Time Travel
3. Snowpipe
4. Secure Data Sharing

Correct Answer: 2

Explanation:

Time Travel allows users to access historical versions of supported Snowflake data within the configured retention period. It can be used to investigate accidental changes, recover from certain user errors, and query data as it existed at an earlier point in time. Time Travel is different from Fail-safe, which is a Snowflake-managed recovery mechanism after the Time Travel period. Clustering is associated with organizing data for performance, Snowpipe handles continuous ingestion, and Secure Data Sharing enables controlled data sharing. Time Travel is therefore the appropriate feature for historical data access.

Question 26

Which Snowflake capability allows multiple independent compute workloads to access the same underlying data?

1. Virtual warehouses
2. Internal stages
3. Resource Monitors
4. Roles

Correct Answer: 1

Explanation:

Virtual warehouses enable independent compute resources to process workloads while accessing the same Snowflake storage layer. For example, an organization can use one warehouse for reporting and another for data engineering without maintaining separate copies of the underlying data. This architecture helps isolate workloads and allows compute resources to be sized according to specific requirements. Internal stages provide file storage, Resource Monitors manage credit usage, and roles control access privileges. The ability to separate compute from storage is one of the central architectural characteristics of Snowflake.

Question 27

Which Snowflake feature is used to control access to objects through assigned privileges?

1. Snowpipe
2. Role-based access control
3. Time Travel
4. Search Optimization Service

Correct Answer: 2

Explanation:

Snowflake uses role-based access control, commonly called RBAC, to manage access to objects and actions. Privileges can be granted to roles, and users can receive permissions by being assigned appropriate roles. This approach allows organizations to manage access according to responsibilities and security requirements. Snowpipe is designed for data ingestion, Time Travel provides historical access, and Search Optimization Service supports specific query-performance patterns. RBAC is therefore fundamental to Snowflake security and helps organizations implement least-privilege access by giving users only the permissions required for their responsibilities.

Question 28

What is the main purpose of a Snowflake stage?

1. To execute SQL queries
2. To manage user authentication
3. To hold files used for loading or unloading data
4. To create virtual warehouses

Correct Answer: 3

Explanation:

A Snowflake stage is a location used to hold files involved in data loading and unloading operations. Stages can be internal to Snowflake or reference external cloud storage, depending on the architecture. Files can be placed in a stage before being loaded into tables, or data can be unloaded from Snowflake into staged files. Stages do not provide query compute resources or authenticate users. Virtual warehouses perform compute operations, while Snowflake’s security features manage authentication and authorization. Understanding stages is important for designing file-based ingestion and export workflows.

Question 29

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

1. COPY INTO
2. SHOW WAREHOUSES
3. CREATE ROLE
4. ALTER USER

Correct Answer: 1

Explanation:

The COPY INTO command is commonly used to load data from staged files into Snowflake tables. It supports loading files from internal and external stages and can work with different supported file formats and loading options. A typical workflow involves placing files in a stage and then using COPY INTO to load their contents into the target table. SHOW WAREHOUSES displays warehouse information, CREATE ROLE creates an access-control role, and ALTER USER modifies user properties. Therefore, COPY INTO is the command most directly associated with bulk file-based table loading.

Question 30

Which Snowflake capability allows data to be shared with another Snowflake account without physically copying the underlying data?

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

Correct Answer: 2

Explanation:

Secure Data Sharing allows Snowflake data providers to share supported data with other Snowflake accounts without requiring traditional physical data copies. This can simplify collaboration with customers, partners, suppliers, or other business units. The provider maintains control over the shared objects, while the consumer can access the data according to the sharing arrangement. Snowpipe is used for ingestion, Time Travel provides historical access, and auto-suspend controls warehouse activity. Secure Data Sharing is therefore particularly valuable when organizations need governed data distribution while avoiding unnecessary duplication.

Question 31

What does a virtual warehouse’s auto-suspend setting control?

1. How long historical data is retained
2. How long an idle warehouse remains running before suspending
3. How many users can access a database
4. How many tables a schema can contain

Correct Answer: 2

Explanation:

The auto-suspend setting determines how long a virtual warehouse can remain idle before Snowflake automatically suspends it. Suspending an inactive warehouse can reduce unnecessary consumption of compute credits. When new work arrives, the warehouse can resume if appropriate auto-resume behavior is configured. Auto-suspend does not control Time Travel retention, database access, or the number of objects within a schema. Properly configuring auto-suspend is an important cost-management practice, especially for development environments and workloads that are active only during specific periods.

Question 32

Which Snowflake feature can automatically stop an idle virtual warehouse to help control compute costs?

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

Correct Answer: 1

Explanation:

Auto-suspend automatically stops a virtual warehouse after it has remained idle for the configured amount of time. Because active warehouses consume compute credits, suspending unused warehouses can help organizations avoid unnecessary costs. Auto-resume can be configured to restart a suspended warehouse when new work is submitted. Fail-safe is a recovery mechanism, Time Travel provides historical data access, and Data Sharing enables controlled sharing between accounts. Auto-suspend is therefore a warehouse-management feature primarily associated with controlling idle compute consumption.

Question 33

Which Snowflake storage structure is automatically created as data is loaded into tables?

1. External stages
2. Micro-partitions
3. Virtual warehouses
4. Roles

Correct Answer: 2

Explanation:

Snowflake automatically organizes table data into micro-partitions as data is loaded. Micro-partitions are compressed and optimized storage units that contain a subset of table rows along with metadata. Snowflake can use metadata about these micro-partitions to eliminate unnecessary data during query processing. Users do not manually create traditional partitions in the same way they might in some other database systems. External stages are used for files, virtual warehouses provide compute resources, and roles manage permissions. Understanding micro-partitions is important when learning Snowflake storage and query-performance behavior.

Question 34

Which feature is designed to improve performance for certain highly selective queries on large Snowflake tables?

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

Correct Answer: 3

Explanation:

Search Optimization Service is designed to improve performance for certain selective query patterns, particularly searches that need to locate specific values within large tables. Snowflake maintains additional search access structures that can help identify relevant data more efficiently. This service is different from simply increasing warehouse size because it focuses on improving how certain data-access patterns are executed. Resource Monitors are used for credit management, Snowpipe supports continuous ingestion, and Fail-safe provides recovery capabilities. Search Optimization Service can therefore be useful when selective point-lookups or similar searches are important to workload performance.

Question 35

Which Snowflake feature provides a 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 a Snowflake-managed recovery period after the applicable Time Travel retention period has ended. It is intended for certain data-recovery situations and should not be treated as a replacement for Time Travel. Time Travel is designed for user-accessible historical data operations, whereas Fail-safe is managed by Snowflake and is intended primarily for recovery purposes. Snowpipe handles continuous ingestion, Secure Data Sharing enables controlled data sharing, and auto-suspend manages warehouse activity. Understanding the distinction between Time Travel and Fail-safe is important when designing data recovery and protection strategies.

Question 36

Which Snowflake feature is most directly associated with monitoring and controlling credit usage?

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

Correct Answer: 2

Explanation:

Resource Monitors help organizations monitor Snowflake credit consumption and establish usage thresholds. They can be configured to notify administrators or take supported actions when defined credit limits are reached. This makes Resource Monitors useful for cost governance and workload management. Time Travel handles historical data access, Snowpipe supports continuous data ingestion, and zero-copy cloning creates efficient copies of supported objects. Resource Monitors do not directly control the data stored in tables; instead, their purpose is to provide visibility and controls around Snowflake credit consumption.

Question 37

Which Snowflake capability allows a table to be copied for development while minimizing immediate storage duplication?

1. Fail-safe
2. Zero-copy cloning
3. Snowpipe
4. Resource Monitor

Correct Answer: 2

Explanation:

Zero-copy cloning is useful for creating development, testing, or temporary copies of Snowflake tables without immediately duplicating all underlying storage. The clone initially shares the underlying micro-partitions with the source. When changes occur, Snowflake separates the affected data as required. This makes the operation fast and generally storage-efficient compared with creating a completely independent physical copy from the beginning. Fail-safe is related to recovery, Snowpipe is used for ingestion, and Resource Monitors track credit consumption. Zero-copy cloning is therefore the appropriate feature for efficient object duplication.

Question 38

What is the main benefit of separating compute and storage in Snowflake?

1. Compute and storage can be scaled independently
2. All users must share one warehouse
3. Data must always be stored externally
4. Tables cannot be accessed by multiple warehouses

Correct Answer: 1

Explanation:

The separation of compute and storage allows Snowflake customers to independently scale processing resources and stored data. Organizations can increase warehouse size when query workloads become more demanding without changing their storage architecture. They can also create multiple warehouses for different workloads while allowing those warehouses to access the same underlying data. This design supports workload isolation, flexible scaling, and cost optimization. The architecture does not require all users to share one warehouse or require data to be stored externally. Independent scaling is therefore a major advantage of Snowflake’s architecture.

Question 39

Which Snowflake feature is most appropriate for continuously processing new files arriving in cloud storage?

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

Correct Answer: 2

Explanation:

Snowpipe is designed for continuous data ingestion from supported cloud storage locations. When new files become available, Snowpipe can initiate loading into Snowflake tables, providing a more automated approach than repeatedly executing manual bulk-loading commands. This is useful for event-driven or continuously arriving data workloads. Time Travel provides historical access, Resource Monitors manage credit consumption, and zero-copy cloning creates efficient object copies. Snowpipe is therefore the appropriate choice when an organization needs newly arriving files to be processed automatically and made available for analysis with minimal manual intervention.

Question 40

Which statement best describes Snowflake’s virtual warehouses?

1. They permanently store table data
2. They provide independent compute resources for workloads
3. They replace databases and schemas
4. They are used only for user authentication

Correct Answer: 2

Explanation:

Virtual warehouses provide compute resources used to execute SQL queries and perform data-processing tasks in Snowflake. They are separate from the storage layer and can be independently sized, suspended, resumed, and configured. Organizations can create different warehouses for different workloads, helping isolate compute requirements and manage performance. Virtual warehouses do not permanently store table data, replace databases or schemas, or perform user authentication. Their primary purpose is computation. This separation between storage and compute is a foundational part of Snowflake’s architecture and enables flexible workload management and independent scaling.