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

 

Question 181

Which Snowflake feature allows a user to create a copy of a table for development without immediately duplicating the underlying storage?

1. Snowpipe
2. Zero-copy cloning
3. Resource Monitor
4. Materialized View

Correct Answer: 2

Explanation:

Zero-copy cloning allows Snowflake users to create a clone of supported objects without immediately making a complete physical copy of the underlying data. The cloned object initially references the same underlying micro-partitions as the source. When changes are made, Snowflake’s storage architecture manages the affected data separately. This makes cloning particularly useful for development, testing, and temporary environments because large datasets can be made available quickly without the initial storage overhead of a traditional full copy. Snowpipe, Resource Monitors, and Materialized Views serve different purposes.

Question 182

Which Snowflake component provides the compute resources required to execute a query?

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

Correct Answer: 3

Explanation:

A virtual warehouse is Snowflake’s compute resource for executing SQL queries and performing data-processing operations. Warehouses are separate from Snowflake’s storage layer, allowing compute resources to be managed independently from stored data. A database and schema organize data objects, while a stage provides a location for files used in loading and unloading workflows. Virtual warehouses can be resized, suspended, resumed, and configured for concurrency. Understanding this separation is important because query performance and compute cost are directly affected by warehouse configuration and workload requirements.

Question 183

Which SQL command is used to remove rows from a table while keeping the table object itself?

1. DELETE
2. DROP TABLE
3. REMOVE TABLE
4. DESTROY TABLE

Correct Answer: 1

Explanation:

The DELETE command removes rows from a table while leaving the table object available for future use. A DELETE statement can include a WHERE condition to target specific rows, or it can be used without a condition to remove all rows. DROP TABLE is different because it removes the table object itself. REMOVE TABLE and DESTROY TABLE are not standard Snowflake SQL commands for deleting table rows. Understanding the distinction between DELETE and DROP is important when performing data modifications because they have substantially different effects on database objects.

Question 184

Which Snowflake feature can help reduce the amount of data scanned by using metadata about micro-partition values?

1. Fail-safe
2. Snowpipe
3. Query pruning
4. Resource Monitor

Correct Answer: 3

Explanation:

Query pruning allows Snowflake to avoid scanning micro-partitions that are determined to be irrelevant to a query. Snowflake maintains metadata associated with micro-partitions, including information about values and ranges, which can help determine whether a partition may contain qualifying rows. Effective pruning can significantly reduce the amount of data that needs to be examined and therefore improve query performance. Fail-safe provides recovery capabilities, Snowpipe handles continuous ingestion, and Resource Monitors track credit consumption. Query pruning is therefore the capability directly associated with reducing unnecessary micro-partition scans.

Question 185

Which Snowflake data type is designed to store arbitrary semi-structured data?

1. DATE
2. VARIANT
3. INTEGER
4. BOOLEAN

Correct Answer: 2

Explanation:

VARIANT is designed to store semi-structured data in Snowflake. It can represent values originating from formats such as JSON and can contain different types and nested structures within the same column. This flexibility makes VARIANT useful when incoming data does not conform to a fixed relational schema. Snowflake provides functions and operators for querying fields and elements within VARIANT values. DATE is used for calendar dates, INTEGER represents whole numbers, and BOOLEAN stores logical true or false values. VARIANT is therefore the most appropriate option for flexible semi-structured data.

Question 186

Which Snowflake feature allows a warehouse to automatically start when a workload requires compute resources?

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

Correct Answer: 1

Explanation:

Auto-resume allows a suspended virtual warehouse to start automatically when a workload requires it. This feature is commonly used together with auto-suspend. Auto-suspend stops a warehouse after a configured period of inactivity, helping reduce unnecessary credit consumption, while auto-resume starts it again when required. Fail-safe and Time Travel are data recovery and historical-access capabilities rather than warehouse management features. By combining auto-suspend and auto-resume, organizations can make warehouses available when needed while reducing the amount of time they remain running without active workloads.

Question 187

Which Snowflake object can store a reusable definition describing how CSV files should be interpreted during loading?

1. Stream
2. Role
3. File format
4. Resource Monitor

Correct Answer: 3

Explanation:

A file format object can store reusable settings describing how Snowflake should interpret files during loading or unloading. For CSV data, settings can include the field delimiter, record delimiter, quotation behavior, compression, and related file properties. Defining a file format as a database object can simplify repeated loading operations because the same configuration can be referenced by multiple commands. Streams track changes, roles control access, and Resource Monitors manage credit consumption. Therefore, a file format is the appropriate Snowflake object for defining the structure and interpretation of CSV files.

Question 188

Which Snowflake feature is designed to support continuous ingestion of files as they arrive in a stage?

1. Time Travel
2. Snowpipe
3. Materialized View
4. Row Access Policy

Correct Answer: 2

Explanation:

Snowpipe provides continuous or near-continuous ingestion of newly arrived files into Snowflake. It is designed for scenarios where files are generated or delivered regularly and should be loaded without relying on repeated manual bulk-load commands. Snowpipe can work with supported cloud storage and notification mechanisms to detect new files and initiate loading. Time Travel provides historical data access, Materialized Views support query performance, and Row Access Policies control row visibility. Therefore, Snowpipe is the feature specifically intended for continuous file ingestion.

Question 189

Which Snowflake object is used to logically group tables, views, stages, and other objects within a database?

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

Correct Answer: 2

Explanation:

A schema is a logical container inside a Snowflake database. It can contain tables, views, stages, file formats, sequences, procedures, and other supported objects. The database and schema hierarchy helps organizations structure their data environment and manage privileges at appropriate levels. A warehouse supplies compute resources, a Resource Monitor manages credit consumption, and a role controls access rather than serving as a data-object container. Therefore, when the requirement is to logically organize database objects within a database, the correct Snowflake object is a schema.

Question 190

Which Snowflake capability can increase compute capacity by running multiple clusters to handle high query concurrency?

1. Multi-cluster warehouse
2. Time Travel
3. Snowpipe
4. Search Optimization Service

Correct Answer: 1

Explanation:

A multi-cluster warehouse can use multiple compute clusters to handle workloads with high concurrency. When many users or queries compete for resources, additional clusters can provide more capacity and help reduce query queuing, depending on the configured scaling policy and workload. This capability addresses concurrency rather than historical data access or file ingestion. Time Travel handles historical versions of data, Snowpipe supports continuous ingestion, and Search Optimization Service improves certain selective search workloads. Multi-cluster warehouses are therefore particularly useful when a workload involves many concurrent queries.

Question 191

Which command is used to give a role a privilege on a Snowflake object?

1. ALLOW
2. AUTHORIZE
3. GRANT
4. PERMIT

Correct Answer: 3

Explanation:

GRANT is the standard Snowflake SQL command used to assign privileges to roles. For example, a role can be granted privileges such as SELECT on a table or USAGE on a database or schema. Snowflake’s role-based access control model allows administrators to organize permissions through roles rather than assigning every privilege directly to individual users. ALLOW, AUTHORIZE, and PERMIT are not the standard SQL commands used for granting Snowflake object privileges. Therefore, GRANT is the correct command for assigning access permissions.

Question 192

Which Snowflake feature can protect sensitive column values by dynamically returning different values depending on the user’s access context?

1. Masking policy
2. Stream
3. Stage
4. Snowpipe

Correct Answer: 1

Explanation:

A masking policy provides dynamic protection for sensitive column data. It can determine how a value should be presented based on conditions such as the querying user’s role or other contextual information. Authorized users may see the original value, while other users can receive a masked or transformed representation. This approach allows organizations to protect sensitive information without necessarily maintaining separate copies of the data. Streams track table changes, stages support file workflows, and Snowpipe handles continuous ingestion. Masking policies are therefore the appropriate feature for dynamic column-level protection.

Question 193

Which Snowflake capability allows a role to inherit privileges from another role?

1. Search Optimization
2. Role hierarchy
3. Time Travel
4. Automatic Clustering

Correct Answer: 2

Explanation:

Snowflake role hierarchies allow one role to be granted to another role. The higher-level role can then inherit the privileges associated with the lower-level role. This supports scalable access management because administrators can build groups of permissions and assign those groups through role relationships rather than repeatedly granting individual privileges. Search Optimization improves certain query patterns, Time Travel provides historical access, and Automatic Clustering maintains clustering for configured tables. Role hierarchy is therefore the concept directly responsible for privilege inheritance between roles.

Question 194

Which Snowflake feature is intended to improve performance for supported highly selective search queries?

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

Correct Answer: 3

Explanation:

Search Optimization Service is designed to improve performance for supported selective search patterns. It can maintain additional information that helps Snowflake locate relevant data more efficiently, which can be especially useful for point-lookups and similar workloads. It is not intended to replace general query optimization or solve every performance problem. Fail-safe is a recovery mechanism, Snowpipe handles continuous ingestion, and Resource Monitors manage credit usage. Therefore, Search Optimization Service is the Snowflake feature most directly associated with improving supported highly selective searches.

Question 195

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

1. Resource Monitor
2. Time Travel
3. Snowpipe
4. Auto-suspend

Correct Answer: 2

Explanation:

Time Travel allows users to access historical versions of data within the applicable retention period. It can be useful for investigating accidental changes, recovering from certain data modifications, and querying historical states. The exact retention available depends on the account configuration and applicable Snowflake capabilities. Resource Monitors track credit consumption, Snowpipe handles continuous file ingestion, and auto-suspend controls warehouse activity. Therefore, when the requirement is to query or recover historical data within the supported retention period, Time Travel is the appropriate Snowflake feature.

Question 196

Which Snowflake feature is primarily used to automate recurring SQL-based processing?

1. Tasks
2. Stages
3. File Formats
4. Resource Monitors

Correct Answer: 1

Explanation:

Snowflake Tasks can automate the execution of SQL statements or supported procedures. They can be configured to run according to schedules or can participate in task graphs where one task depends on another. Tasks are therefore useful for recurring transformations, maintenance operations, and automated data workflows. Stages are used for files, File Formats define how files are interpreted, and Resource Monitors manage credit consumption. Tasks are often combined with other Snowflake features, such as Streams, to create incremental and automated data-processing pipelines.

Question 197

Which Snowflake feature records table changes so that downstream processing can identify changed rows?

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

Correct Answer: 2

Explanation:

A Stream records information about changes to table data and can be used by downstream processing to identify changed rows. Streams are useful for incremental processing because workflows can focus on changes rather than repeatedly processing an entire dataset. They are commonly combined with Tasks to automate data pipelines. A warehouse supplies compute resources, a schema organizes database objects, and a stage provides a location for files. Therefore, a Stream is the Snowflake object designed to capture change information for downstream processing.

Question 198

Which Snowflake feature allows multiple consumers to access shared data without the provider creating separate traditional copies for each consumer?

1. Secure Data Sharing
2. Auto-suspend
3. Resource Monitor
4. Automatic Clustering

Correct Answer: 1

Explanation:

Secure Data Sharing allows a Snowflake provider to share selected data with consumers without requiring traditional copies of the shared data for each consumer. The provider controls which objects are exposed, while consumers access the shared data through the supported sharing mechanism. This architecture can simplify collaboration and reduce unnecessary data duplication. Auto-suspend manages warehouse activity, Resource Monitors manage credit usage, and Automatic Clustering maintains clustering for eligible tables. Secure Data Sharing is therefore the feature most directly associated with controlled sharing without traditional data duplication.

Question 199

Which Snowflake object is primarily responsible for storing persistent table data?

1. Virtual warehouse
2. Schema
3. Snowflake storage layer
4. Resource Monitor

Correct Answer: 3

Explanation:

Snowflake’s storage layer is responsible for persistent storage of table data, while virtual warehouses provide the compute resources used to process that data. This separation allows multiple warehouses to work with the same stored data and enables compute resources to be scaled independently. A schema organizes database objects but is not itself the physical storage layer. Resource Monitors are used for monitoring and controlling credit consumption. Therefore, the Snowflake storage layer is the component primarily responsible for persistent table-data storage.

Question 200

Which Snowflake feature can automatically maintain table organization based on a defined clustering key?

1. Search Optimization Service
2. Snowpipe
3. Automatic Clustering
4. Time Travel

Correct Answer: 3

Explanation:

Automatic Clustering helps maintain the organization of eligible tables according to a defined clustering key. As table data changes, the distribution of rows across micro-partitions can become less aligned with the desired clustering strategy. Automatic Clustering can perform background maintenance to improve that organization, potentially helping queries that benefit from effective pruning. Search Optimization Service targets different selective-search workloads, Snowpipe handles continuous file ingestion, and Time Travel provides historical data access. Therefore, Automatic Clustering is the correct feature for maintaining clustering automatically.