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

Question 261

Which Snowflake feature is used to share selected data with another Snowflake account without requiring traditional data duplication?

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

Correct Answer: 1

Explanation:

Secure Data Sharing allows a Snowflake provider to share selected database objects with consumers without requiring traditional copies of the shared data. The provider controls which objects are made available, while consumers can access the shared data through the supported sharing mechanism. This approach can simplify collaboration between teams or organizations and reduce unnecessary duplication. Time Travel provides historical data access, auto-suspend manages warehouse activity, and Resource Monitors manage credit consumption. Therefore, Secure Data Sharing is the appropriate Snowflake feature for controlled sharing of data without traditional copying.

Question 262

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

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

Correct Answer: 2

Explanation:

A schema is a logical container within a Snowflake database. It can contain tables, views, stages, file formats, sequences, procedures, and other supported objects. The database-to-schema hierarchy provides an organized structure for managing data objects and permissions. A warehouse supplies compute resources, a stage supports file-based loading and unloading, and a stream tracks changes to table data. Therefore, when the requirement is to organize database objects inside a database, the appropriate Snowflake object is a schema.

Question 263

Which Snowflake capability allows a suspended warehouse to start automatically when a workload requires it?

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

Correct Answer: 3

Explanation:

Auto-resume automatically starts a suspended virtual warehouse when a workload requires compute resources. It is often paired with auto-suspend, which stops a warehouse after a configured period of inactivity. Together, these settings can help organizations balance performance and cost by making compute available when needed while avoiding unnecessary runtime during idle periods. Fail-safe is a recovery mechanism, and Time Travel provides historical data access. Therefore, Auto-resume is the correct feature when the requirement is to automatically restart a suspended warehouse.

Question 264

Which Snowflake data type is designed to store key-value pairs in semi-structured data?

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

Correct Answer: 2

Explanation:

OBJECT is a Snowflake data type used to represent key-value pairs in semi-structured data. It is particularly useful for JSON-like structures where named attributes contain associated values. ARRAY is used for ordered collections of values, BOOLEAN stores true or false values, and DATE stores calendar dates. OBJECT values can also be nested inside other semi-structured structures and are commonly encountered within VARIANT data. Therefore, when a data structure consists of named keys associated with values, OBJECT is the appropriate Snowflake data type.

Question 265

Which Snowflake feature can help reduce unnecessary data scanning by eliminating irrelevant micro-partitions?

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

Correct Answer: 1

Explanation:

Query pruning allows Snowflake to skip micro-partitions that are unlikely to contain rows matching the query conditions. Snowflake maintains metadata about micro-partitions, including information that can help determine whether particular partitions are relevant. By reducing the number of partitions scanned, pruning can improve query performance and reduce unnecessary compute work. Snowpipe is designed for continuous ingestion, Resource Monitors help manage credit consumption, and Fail-safe is associated with recovery. Therefore, query pruning is the capability directly responsible for eliminating unnecessary micro-partition scans.

Question 266

Which Snowflake command is used to remove an existing table object?

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

Correct Answer: 3

Explanation:

DROP TABLE is the standard SQL command used to remove a table object from Snowflake. This is different from DELETE, which removes rows while leaving the table object in place. Dropping a table is therefore an object-level operation rather than simply a row-level data modification. Depending on applicable retention settings, Snowflake’s Time Travel capabilities may provide historical recovery options after certain object operations. REMOVE TABLE and CLEAR TABLE are not standard Snowflake commands. Therefore, DROP TABLE is the correct command for removing a table object.

Question 267

Which Snowflake feature is designed to continuously load newly arriving files into a table?

1. Materialized View
2. Snowpipe
3. Row Access Policy
4. Search Optimization Service

Correct Answer: 2

Explanation:

Snowpipe is designed for continuous or near-continuous ingestion of newly arrived files. It can detect files through supported cloud-storage notification mechanisms and initiate loading into Snowflake tables. This makes Snowpipe useful when data arrives frequently and organizations want automated ingestion rather than repeatedly running manual bulk-loading commands. Materialized Views are used for supported performance optimization, Row Access Policies control row visibility, and Search Optimization Service improves certain selective queries. Therefore, Snowpipe is the feature specifically designed for continuous file ingestion.

Question 268

Which privilege is generally needed on a table for a role to query its rows?

1. INSERT
2. UPDATE
3. SELECT
4. DELETE

Correct Answer: 3

Explanation:

The SELECT privilege allows a role to query and read data from a table. In addition to the table-level SELECT privilege, the role generally needs the appropriate USAGE privileges on the parent database and schema to access the object successfully. INSERT allows adding rows, UPDATE allows modifying existing rows, and DELETE allows removing rows. Snowflake’s role-based access control model allows these privileges to be granted to roles and then assigned to users. Therefore, SELECT is the appropriate privilege when a role needs to read table data.

Question 269

Which Snowflake object provides compute capacity and can be resized independently from the storage layer?

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

Correct Answer: 1

Explanation:

A virtual warehouse provides compute resources for executing queries and processing data. Snowflake separates compute from storage, allowing warehouses to be resized independently without requiring the stored data itself to be moved or reorganized. Organizations can also create separate warehouses for different workloads to provide resource isolation. Databases and schemas organize data objects, while stages support file-based workflows. Therefore, the virtual warehouse is the Snowflake object that provides independently configurable compute capacity.

Question 270

Which Snowflake feature provides a mechanism for applying different visibility rules to rows based on a user’s access context?

1. Masking Policy
2. Resource Monitor
3. Row Access Policy
4. File Format

Correct Answer: 3

Explanation:

A Row Access Policy enables fine-grained control over which rows are visible to a user. The policy can evaluate conditions such as the user’s role or other contextual attributes and determine whether particular records should be returned. This allows different users to query the same underlying table while receiving different subsets of rows. Masking Policies primarily protect column values, Resource Monitors manage credit consumption, and File Formats define how files are interpreted. Therefore, Row Access Policy is the appropriate feature for conditional row-level visibility.

Question 271

Which Snowflake feature stores precomputed results for supported query workloads to improve performance?

1. Stream
2. Materialized View
3. Stage
4. Role

Correct Answer: 2

Explanation:

A Materialized View maintains precomputed results for a supported query definition. For suitable workloads, this can improve query performance because Snowflake can use the maintained results instead of repeatedly performing the entire underlying computation. Materialized Views are particularly useful when expensive aggregations or transformations are queried frequently. Streams track table changes, stages support file loading and unloading, and roles are used for access control. Therefore, a Materialized View is the appropriate Snowflake object when the goal is to maintain precomputed query results for performance.

Question 272

Which Snowflake feature is primarily used to track and manage credit consumption?

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

Correct Answer: 1

Explanation:

Resource Monitors are used to monitor Snowflake credit consumption and can be configured with thresholds and supported actions. They help organizations establish cost-management controls around compute usage. Depending on configuration, administrators can receive notifications or trigger supported actions when consumption reaches specified limits. Streams track changes to table data, stages provide file locations, and views provide logical representations of data. Therefore, Resource Monitor is the feature most directly associated with monitoring and controlling Snowflake credit consumption.

Question 273

Which Snowflake feature allows a user to create a development copy of a table without initially copying all of its underlying data?

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

Correct Answer: 3

Explanation:

Zero-copy cloning allows supported objects to be cloned without initially making a complete physical copy of the underlying data. The clone can initially reference the same micro-partitions as the source. If changes are later made, Snowflake manages the affected data separately. This makes cloning especially useful for development and testing environments where users need a copy of a large dataset quickly. Snowpipe handles continuous ingestion, Time Travel provides historical access, and Resource Monitors manage credit consumption. Therefore, zero-copy cloning is the correct feature.

Question 274

Which Snowflake function is used to parse a JSON string into a semi-structured value?

1. FLATTEN
2. GET
3. ARRAY_CONSTRUCT
4. PARSE_JSON

Correct Answer: 4

Explanation:

PARSE_JSON converts a string containing valid JSON into a Snowflake semi-structured value, commonly represented through VARIANT. Once parsed, users can access nested objects and arrays using Snowflake’s semi-structured data functionality. FLATTEN is used to expand nested structures into rows, GET can retrieve elements from semi-structured values, and ARRAY_CONSTRUCT creates an array. Therefore, PARSE_JSON is the correct function when the requirement is to interpret JSON text as a queryable semi-structured value.

Question 275

Which Snowflake feature automatically stops a warehouse after a specified period of inactivity?

1. Auto-resume
2. Auto-suspend
3. Multi-cluster
4. Time Travel

Correct Answer: 2

Explanation:

Auto-suspend automatically stops a virtual warehouse after it has been inactive for the configured period. This is an important cost-optimization setting because compute credits are not unnecessarily consumed by an idle warehouse. Organizations can combine auto-suspend with auto-resume so that the warehouse stops when unused and starts again when a workload requires it. Multi-cluster warehouses address concurrency, Time Travel provides historical data access, and auto-resume starts suspended warehouses. Therefore, auto-suspend is the feature responsible for stopping inactive warehouses automatically.

Question 276

Which Snowflake feature can provide additional compute clusters when many queries need to execute concurrently?

1. Time Travel
2. Snowpipe
3. Multi-cluster warehouse
4. Masking Policy

Correct Answer: 3

Explanation:

A multi-cluster warehouse is designed to support workloads with high query concurrency by allowing multiple compute clusters to be used. When workload demand increases, additional clusters can provide more compute capacity and help reduce queuing, depending on the configured scaling policy. This is different from simply increasing the size of a single cluster because the primary goal is handling concurrent workloads. Time Travel provides historical access, Snowpipe supports continuous ingestion, and Masking Policies protect sensitive column values. Therefore, a multi-cluster warehouse is the correct choice for high-concurrency workloads.

Question 277

Which Snowflake feature can dynamically hide or transform sensitive column values according to defined security rules?

1. Masking Policy
2. Stream
3. Stage
4. Task

Correct Answer: 1

Explanation:

A Masking Policy provides dynamic protection for sensitive column values. Depending on the user’s role or other defined conditions, Snowflake can return the original value or a masked representation. This enables organizations to protect sensitive information while keeping the underlying dataset centralized. Streams capture changes to table data, stages support file workflows, and Tasks automate SQL execution. Therefore, a Masking Policy is the appropriate Snowflake security feature for dynamically controlling how sensitive column values are displayed.

Question 278

Which Snowflake object can automatically execute SQL statements based on a schedule?

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

Correct Answer: 2

Explanation:

A Task can automatically execute SQL statements or supported procedures based on a configured schedule. Tasks can also be connected through dependencies to create task graphs for more complex workflows. They are useful for recurring transformations, maintenance operations, and automated data pipelines. A File Format defines file interpretation settings, a Stream records table changes, and a Stage provides a file location. Therefore, Task is the Snowflake object designed to automate SQL execution based on a schedule or dependency.

Question 279

Which Snowflake architecture characteristic allows storage to remain independent from compute resources?

1. Role-based access control
2. Storage and compute separation
3. Automatic Clustering
4. Secure Data Sharing

Correct Answer: 2

Explanation:

Storage and compute separation is a fundamental Snowflake architectural principle. Snowflake stores data independently from the virtual warehouses that process it. This allows organizations to resize compute resources, create multiple warehouses, or isolate workloads without needing separate copies of the stored data. Role-based access control manages permissions, Automatic Clustering maintains organization of eligible table data, and Secure Data Sharing provides controlled data access between consumers. Therefore, storage and compute separation is the characteristic that allows compute resources and storage to be managed independently.

Question 280

Which Snowflake function is commonly used to expand nested semi-structured arrays into individual rows?

1. TO_VARIANT
2. GET
3. FLATTEN
4. PARSE_JSON

Correct Answer: 3

Explanation:

FLATTEN is a table function used to expand semi-structured data into rows. It is particularly useful for arrays and nested objects stored in VARIANT values. By converting nested elements into a row-based result, FLATTEN makes semi-structured data easier to analyze using SQL. TO_VARIANT converts values to VARIANT, GET can retrieve specific elements, and PARSE_JSON converts JSON text into a semi-structured value. Therefore, FLATTEN is the correct function when nested arrays or objects need to be expanded into individual rows.