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

 

Question 221

Which Snowflake feature allows a table to be copied for testing without immediately duplicating the underlying data storage?

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

Correct Answer: 3

Explanation:

Zero-copy cloning allows supported Snowflake objects to be cloned without initially creating a complete physical copy of the underlying data. The clone can reference the same underlying micro-partitions as the source object. If either object is subsequently changed, Snowflake manages the affected data appropriately. This makes cloning useful for development, testing, troubleshooting, and temporary environments. Snowpipe is designed for continuous data ingestion, Time Travel provides access to historical data, and Resource Monitors help manage credit consumption. Therefore, zero-copy cloning is the appropriate feature for creating a rapid copy without an immediate full storage duplication.

Question 222

Which Snowflake object is used to store data files before they are loaded into a table?

1. Stage
2. Stream
3. Warehouse
4. Role

Correct Answer: 1

Explanation:

A stage provides a location for files that are involved in Snowflake data-loading and unloading operations. Snowflake supports internal stages as well as external stages that reference supported cloud storage locations. Once files are available in a stage, commands such as COPY INTO can load their contents into target tables. A stream tracks changes to table data, a warehouse supplies compute resources, and a role manages access permissions. Therefore, when the requirement is to provide a file location for data-loading workflows, a stage is the appropriate Snowflake object.

Question 223

Which Snowflake feature can dynamically mask sensitive data in a column based on access conditions?

1. Stream
2. Masking policy
3. Materialized view
4. Snowpipe

Correct Answer: 2

Explanation:

A masking policy allows Snowflake to dynamically control how sensitive column values are displayed to users. Depending on conditions such as the user’s role or other context, the policy can return the original value or a masked representation. This provides centralized protection without requiring separate copies of the same dataset for different users. Streams track changes, Materialized Views are primarily used for performance optimization, and Snowpipe supports continuous data ingestion. Therefore, a masking policy is the Snowflake feature specifically designed for dynamic column-level data protection.

Question 224

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

1. COPY INTO
2. LOAD FROM
3. IMPORT TABLE
4. MOVE DATA

Correct Answer: 1

Explanation:

COPY INTO is a core Snowflake command used to load data from staged files into tables. It can work with internal and external stages and can use named or inline file-format configurations. COPY INTO also provides options for handling errors, selecting files, and controlling how data is loaded. LOAD FROM, IMPORT TABLE, and MOVE DATA are not the standard Snowflake commands for this operation. Understanding COPY INTO is essential for Snowflake data-loading scenarios because it is one of the primary SQL interfaces for moving staged file data into database tables.

Question 225

Which Snowflake data type is designed to store an ordered collection of values?

1. OBJECT
2. ARRAY
3. BOOLEAN
4. DATE

Correct Answer: 2

Explanation:

ARRAY is a Snowflake data type used to represent an ordered collection of values. Arrays are common in semi-structured data such as JSON, where a property may contain a list of values rather than a single value. Snowflake provides functions and operators for accessing and processing array elements. OBJECT is used for key-value structures, BOOLEAN stores true or false values, and DATE stores calendar dates. Therefore, ARRAY is the appropriate Snowflake data type when the requirement is to represent an ordered collection of values within structured or semi-structured data.

Question 226

Which feature can automatically stop a virtual warehouse after it has been inactive for a configured amount of time?

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

Correct Answer: 2

Explanation:

Auto-suspend automatically stops a virtual warehouse after it has been inactive for the configured period. This can reduce unnecessary credit consumption because a warehouse does not need to remain running when there is no workload. Auto-resume can be enabled separately so that the warehouse starts again when a new workload requires compute resources. Time Travel and Fail-safe are data recovery-related capabilities and do not control warehouse activity. Therefore, auto-suspend is the correct feature for automatically stopping an idle warehouse.

Question 227

Which Snowflake feature can help improve query performance by maintaining additional information for selective searches?

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

Correct Answer: 1

Explanation:

Search Optimization Service is designed to improve performance for supported selective search patterns. It maintains additional search-related information that can help Snowflake identify relevant data more efficiently for suitable workloads. This can be valuable for point-lookups and other selective queries where scanning large amounts of data would otherwise be inefficient. Snowpipe focuses on continuous ingestion, Resource Monitors manage credit usage, and Fail-safe provides recovery capabilities. Therefore, Search Optimization Service is the appropriate Snowflake feature for optimizing supported selective search workloads.

Question 228

Which Snowflake feature is used to monitor credit consumption and optionally trigger actions when configured limits are reached?

1. Resource Monitor
2. Stream
3. File Format
4. Stage

Correct Answer: 1

Explanation:

Resource Monitors provide a mechanism for monitoring Snowflake credit consumption and configuring thresholds. Depending on configuration and supported behavior, notifications or actions can be associated with specified credit usage limits. This helps organizations establish cost controls around compute consumption. Streams track changes to table data, File Formats define how files are interpreted, and stages provide file locations for loading and unloading. Therefore, Resource Monitor is the correct Snowflake feature for monitoring and managing credit usage.

Question 229

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

1. Snowpipe
2. Time Travel
3. Auto-suspend
4. Search Optimization Service

Correct Answer: 2

Explanation:

Time Travel allows users to access historical versions of data within the applicable retention period. This capability can be useful for investigating accidental changes, recovering data, or analyzing a previous state of a table. It is important to distinguish Time Travel from Fail-safe: Time Travel is intended for supported user-accessible historical operations, while Fail-safe serves as a separate recovery mechanism. Snowpipe handles ingestion, auto-suspend controls warehouse lifecycle, and Search Optimization Service targets selective search performance. Therefore, Time Travel is the correct feature for querying historical data.

Question 230

Which Snowflake object can be granted to another role to create a role hierarchy?

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

Correct Answer: 3

Explanation:

In Snowflake, roles can be granted to other roles, creating a role hierarchy. A higher-level role can inherit the privileges associated with a lower-level role, allowing organizations to structure permissions efficiently. For example, an administrative role may inherit privileges from several specialized roles. Warehouses provide compute resources, schemas organize database objects, and stages support file workflows. Role hierarchies are a core part of Snowflake’s role-based access control model, making roles the object involved in privilege inheritance.

Question 231

Which Snowflake feature provides an additional recovery mechanism after the Time Travel retention period?

1. Fail-safe
2. Snowpipe
3. Search Optimization Service
4. Automatic Clustering

Correct Answer: 1

Explanation:

Fail-safe provides a separate recovery mechanism following the applicable Time Travel period. It is intended primarily for disaster recovery rather than normal user-driven historical querying. During the Time Travel period, users can use supported commands and features to access historical information themselves. After that period, Fail-safe may provide recovery assistance under Snowflake’s applicable service procedures. Snowpipe handles continuous ingestion, Search Optimization Service improves certain selective searches, and Automatic Clustering maintains clustering. Therefore, Fail-safe is the correct answer for post-Time Travel recovery.

Question 232

Which Snowflake feature can automatically execute SQL statements on a recurring schedule?

1. Stage
2. Task
3. File Format
4. Warehouse

Correct Answer: 2

Explanation:

Snowflake Tasks can automatically execute SQL statements or supported procedures based on a defined schedule. Tasks can also participate in task graphs, allowing one task to depend on the successful completion of another. This makes them useful for recurring transformations, data processing, maintenance, and other automated workflows. A stage stores or references files, a file format defines file interpretation settings, and a warehouse supplies compute resources. Therefore, Task is the correct Snowflake object when SQL execution needs to be automated on a schedule.

Question 233

Which Snowflake feature captures information about changes made to a table for use in incremental data processing?

1. Stream
2. Stage
3. Resource Monitor
4. View

Correct Answer: 1

Explanation:

A Stream captures change information associated with table data and can support incremental processing workflows. Instead of repeatedly processing an entire table, downstream logic can use the stream to identify relevant changes and process them. Streams are commonly combined with Tasks to create automated data pipelines. A stage is used for files, Resource Monitors track credit usage, and a standard view provides a logical query representation. Therefore, a Stream is the appropriate Snowflake object for capturing table changes for incremental processing.

Question 234

Which Snowflake object represents a logical grouping of database objects such as tables and views?

1. Warehouse
2. Schema
3. Resource Monitor
4. Stream

Correct Answer: 2

Explanation:

A schema is a logical container within a Snowflake database that can contain tables, views, stages, file formats, procedures, and other supported objects. Schemas help organizations structure their databases and simplify privilege management. A warehouse provides compute resources, a Resource Monitor manages credit consumption, and a stream tracks changes to table data. Understanding the database-to-schema hierarchy is important when creating objects and writing fully qualified object names. Therefore, a schema is the correct answer for a logical grouping of database objects.

Question 235

Which Snowflake feature is designed to support high levels of concurrent query activity by using multiple compute clusters?

1. Time Travel
2. Multi-cluster warehouse
3. Snowpipe
4. File Format

Correct Answer: 2

Explanation:

A multi-cluster warehouse can provide multiple compute clusters to support workloads with high query concurrency. When many users submit queries simultaneously, additional clusters can provide more compute capacity and help reduce queuing, depending on the warehouse’s configuration and scaling policy. This capability is different from simply increasing the size of a single cluster because it specifically addresses concurrent workload demand. Time Travel provides historical data access, Snowpipe supports continuous ingestion, and File Formats describe file structure. Therefore, a multi-cluster warehouse is the appropriate choice for high-concurrency workloads.

Question 236

Which Snowflake feature can store a precomputed result for supported workloads to improve query performance?

1. Materialized View
2. Stream
3. Stage
4. Resource Monitor

Correct Answer: 1

Explanation:

A Materialized View stores maintained, precomputed results for a supported query definition. When appropriate workloads query the materialized view, Snowflake can use the precomputed information rather than repeatedly performing the entire underlying computation. This can improve performance for suitable workloads, particularly when expensive transformations or aggregations are frequently needed. Streams capture table changes, stages support file-based workflows, and Resource Monitors manage credit consumption. Therefore, a Materialized View is the Snowflake object specifically associated with maintaining precomputed query results for performance.

Question 237

Which Snowflake command is used to modify the properties of an existing virtual warehouse?

1. MODIFY COMPUTE
2. ALTER WAREHOUSE
3. UPDATE WAREHOUSE
4. CHANGE COMPUTE

Correct Answer: 2

Explanation:

ALTER WAREHOUSE is used to modify properties of an existing Snowflake virtual warehouse. Administrators can use it to change supported settings such as warehouse size, auto-suspend, auto-resume, and other configuration options. Adjusting warehouse settings can influence both workload performance and credit consumption, so changes should be made according to workload requirements. MODIFY COMPUTE, UPDATE WAREHOUSE, and CHANGE COMPUTE are not the standard Snowflake commands for modifying an existing warehouse. Therefore, ALTER WAREHOUSE is the correct SQL command.

Question 238

Which Snowflake data type is used to represent logical true or false values?

1. BOOLEAN
2. VARIANT
3. ARRAY
4. OBJECT

Correct Answer: 1

Explanation:

BOOLEAN is the Snowflake data type used to represent logical true or false values. It is useful for columns such as active status, eligibility indicators, completion flags, or other binary conditions. VARIANT is designed for semi-structured data, ARRAY represents ordered collections, and OBJECT represents key-value structures. Choosing the correct data type helps ensure that values are represented appropriately and can make SQL operations clearer. Therefore, BOOLEAN is the correct type whenever the intended values are logical true and false states.

Question 239

Which Snowflake architecture principle allows compute resources to be scaled independently from stored data?

1. Storage and compute separation
2. Role inheritance
3. File format abstraction
4. Stage organization

Correct Answer: 1

Explanation:

Snowflake separates storage from compute, allowing organizations to manage virtual warehouses independently from the underlying stored data. A warehouse can be resized or additional warehouses can be created without requiring the organization to move or duplicate the stored data. This architecture also allows different workloads to use separate compute resources while accessing the same centralized storage. Role inheritance controls security permissions, file formats define file structures, and stages support file-based workflows. Therefore, storage and compute separation is the key architectural principle that enables independent scaling.

Question 240

Which Snowflake feature is most appropriate for restricting users to specific rows of a table based on security rules?

1. Resource Monitor
2. Masking Policy
3. Row Access Policy
4. Search Optimization Service

Correct Answer: 3

Explanation:

A Row Access Policy provides row-level security by controlling which rows are visible to users based on defined conditions. The policy can evaluate factors such as roles or other contextual information and determine whether a particular row should be returned. This enables different users to access different subsets of the same table without requiring separate physical tables for each audience. A Masking Policy protects column values, Resource Monitors manage credit consumption, and Search Optimization Service improves supported query patterns. Therefore, Row Access Policy is the correct feature for row-level access control.