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

 

Question 321

Which Snowflake feature is designed to provide historical access to data that has been changed or deleted within the applicable retention period?

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

Correct Answer: 3

Explanation:

Time Travel allows users to access historical versions of data within the configured retention period. It can be used to investigate previous states of tables, recover accidentally modified or deleted data, and query information as it existed at an earlier point in time. Time Travel is different from Fail-safe, which is a separate recovery mechanism intended for situations after the Time Travel period has ended. Snowpipe is used for continuous data ingestion, while Resource Monitors help manage credit consumption. Therefore, Time Travel is the correct feature for accessing historical data during its retention period.

Question 322

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

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

Correct Answer: 1

Explanation:

A Virtual Warehouse provides the compute resources used by Snowflake to execute SQL queries, DML operations, and other supported workloads. Warehouses can be independently configured, resized, suspended, and resumed. This is possible because Snowflake separates compute from storage. A database organizes schemas, a schema organizes database objects, and a stage provides a location for data files used in loading and unloading. Multiple warehouses can access the same underlying Snowflake data, allowing different workloads to use separate compute resources. Therefore, Virtual Warehouse is the correct answer.

Question 323

Which Snowflake feature is most suitable for protecting sensitive column values by displaying different values depending on the requesting user’s privileges?

1. Row Access Policy
2. Network Policy
3. Masking Policy
4. Resource Monitor

Correct Answer: 3

Explanation:

A Masking Policy provides fine-grained control over how sensitive column values are presented to users. Organizations can define conditions that determine whether a user sees the original value, a partially masked value, or another protected representation. This is useful for sensitive information such as personal identifiers, financial information, or confidential business data. A Row Access Policy controls which rows are visible rather than how column values are displayed. Network Policies restrict network access, while Resource Monitors manage credit usage. Therefore, Masking Policy is the appropriate feature for controlling sensitive column values.

Question 324

Which command is commonly used to upload files from a local machine to an internal Snowflake stage?

1. COPY INTO
2. PUT
3. GET
4. SELECT

Correct Answer: 2

Explanation:

The PUT command is commonly used to upload files from a local client environment to an internal Snowflake stage. Once the files are available in the stage, the COPY INTO command can be used to load the staged data into a target table. GET performs the reverse type of file movement by downloading files from an internal stage to a local environment. SELECT retrieves data through SQL queries rather than transferring files. Therefore, PUT is the correct command for uploading local files to an internal stage.

Question 325

Which Snowflake capability helps reduce the amount of data scanned by eliminating micro-partitions that cannot contain relevant rows?

1. Query pruning
2. Snowpipe
3. Auto-resume
4. Secure Data Sharing

Correct Answer: 1

Explanation:

Query pruning uses metadata associated with Snowflake micro-partitions to determine which partitions are relevant to a query. When Snowflake can determine that a micro-partition cannot contain rows matching the query conditions, it can skip scanning that partition. This can reduce the amount of data processed and improve query performance. Snowpipe is designed for continuous file ingestion, Auto-resume starts suspended warehouses when needed, and Secure Data Sharing provides controlled access to shared data. Therefore, query pruning is the capability that reduces unnecessary micro-partition scanning.

Question 326

Which Snowflake object tracks changes made to data in a source table for use by downstream processing?

1. View
2. Task
3. Stream
4. Stage

Correct Answer: 3

Explanation:

A Stream records change information for a supported source table, allowing downstream processes to identify changes such as inserted, updated, or deleted rows. Streams are particularly useful for implementing incremental data-processing pipelines because downstream operations do not necessarily need to process the entire source table repeatedly. Tasks can then be used to automate processing based on schedules or dependencies. Views provide logical query definitions, while stages provide file locations. Therefore, Stream is the correct object when the primary requirement is to track changes in table data.

Question 327

Which Snowflake capability is primarily used to automate SQL execution on a schedule or according to dependencies?

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

Correct Answer: 2

Explanation:

A Task is a Snowflake object designed to automate the execution of SQL statements or supported procedures. Tasks can run according to schedules or dependencies, making them useful for automated data pipelines, transformations, and maintenance processes. Tasks can also work together with Streams to process only newly changed data. A Stage stores or references files, a Stream tracks table changes, and a File Format defines how files are interpreted. Therefore, Task is the correct answer when the requirement is to automate SQL processing based on schedules or dependencies.

Question 328

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

1. ARRAY
2. VARCHAR
3. NUMBER
4. OBJECT

Correct Answer: 4

Explanation:

OBJECT is a Snowflake semi-structured data type used to represent key-value pairs. It is especially useful when working with JSON-like structures where data is organized through named attributes and corresponding values. ARRAY is used for ordered collections of values, while VARIANT can hold values of different underlying types and is commonly used for flexible semi-structured data. VARCHAR stores character strings and NUMBER stores numeric values. Understanding the differences between OBJECT, ARRAY, and VARIANT is important when processing semi-structured information. Therefore, OBJECT is the correct answer for key-value structures.

Question 329

Which Snowflake feature allows a provider to share selected data with another Snowflake account without requiring a traditional copy of the shared data?

1. Secure Data Sharing
2. Time Travel
3. Zero-copy cloning
4. Materialized View

Correct Answer: 1

Explanation:

Secure Data Sharing allows a Snowflake provider to make selected data available to another Snowflake account without creating a traditional duplicate copy for the consumer. The provider controls which objects are included in the share, while the consumer accesses the shared data according to the sharing configuration. Zero-copy cloning is primarily used to create clones of supported objects, often for development and testing. Time Travel provides historical access, while Materialized Views maintain precomputed query results. Therefore, Secure Data Sharing is the appropriate feature for controlled cross-account data sharing.

Question 330

Which Snowflake setting automatically suspends an inactive virtual warehouse after a configured period?

1. AUTO_RESUME
2. TIME_TRAVEL
3. AUTO_SUSPEND
4. DATA_RETENTION

Correct Answer: 3

Explanation:

AUTO_SUSPEND controls how long a virtual warehouse can remain inactive before Snowflake automatically suspends it. Suspending an unused warehouse can help reduce unnecessary compute consumption and therefore support cost management. AUTO_RESUME serves a different purpose by automatically starting a suspended warehouse when workload requires it. TIME_TRAVEL controls historical data access, while DATA_RETENTION relates to how long historical data may be retained rather than warehouse activity. Therefore, AUTO_SUSPEND is the correct setting for automatically stopping an inactive warehouse.

Question 331

Which Snowflake feature can automatically start a suspended warehouse when a query requires compute resources?

1. AUTO_SUSPEND
2. AUTO_RESUME
3. Time Travel
4. Resource Monitor

Correct Answer: 2

Explanation:

AUTO_RESUME allows a suspended virtual warehouse to start automatically when a workload requires compute resources. This reduces the need for users or applications to manually start the warehouse before executing queries. AUTO_SUSPEND performs the opposite function by stopping an inactive warehouse after a configured period. Time Travel manages historical data access, while Resource Monitors help monitor credit usage. Together, Auto-suspend and Auto-resume can help manage warehouse availability and compute consumption efficiently. Therefore, AUTO_RESUME is the correct setting for automatically starting a suspended warehouse.

Question 332

Which Snowflake feature can be used to monitor credit consumption and issue notifications when configured thresholds are reached?

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

Correct Answer: 1

Explanation:

A Resource Monitor helps administrators monitor Snowflake credit consumption and configure thresholds for notifications and supported actions. This makes it useful for cost management and governance, particularly in environments where compute consumption needs to be monitored closely. Row Access Policies control visibility of rows, Search Optimization Service improves performance for supported selective search patterns, and File Formats define how files are parsed during loading or unloading. Resource Monitors do not control data permissions or file interpretation. Therefore, Resource Monitor is the correct Snowflake feature for tracking credit usage.

Question 333

Which Snowflake service is specifically designed to improve performance for supported queries that search for specific values in large tables?

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

Correct Answer: 2

Explanation:

Search Optimization Service is designed to improve performance for supported selective search patterns, especially when queries frequently search for specific values within large datasets. It maintains additional search access structures that can help Snowflake locate relevant data more efficiently. It is not a universal optimization for every type of query, so organizations should evaluate whether their workload benefits from it. Automatic Clustering focuses on maintaining clustering organization, Snowpipe handles file ingestion, and Time Travel provides historical data access. Therefore, Search Optimization Service is the correct answer.

Question 334

Which Snowflake object is a logical SQL definition that does not normally maintain its own complete physical copy of query results?

1. Materialized View
2. Table
3. Standard View
4. Stage

Correct Answer: 3

Explanation:

A standard View is a logical SQL definition based on a query. It does not normally maintain a separate physical copy of its complete query results. When users query the view, Snowflake processes its underlying query against the current data according to the view definition. A Materialized View differs because Snowflake maintains precomputed results for supported definitions. A Table stores data, while a Stage provides a location for files used in data movement. Therefore, Standard View is the correct answer when describing a logical query definition without maintained complete physical results.

Question 335

Which Snowflake feature allows users to create a clone of a supported object without initially duplicating all of its underlying data storage?

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

Correct Answer: 2

Explanation:

Zero-copy cloning allows supported Snowflake objects to be cloned quickly without initially creating a complete physical copy of all underlying micro-partitions. The source and clone can initially share underlying storage, while changes made to either object are handled separately as they diverge. This makes the feature particularly useful for development, testing, troubleshooting, and experimentation. Snowpipe is used for continuous ingestion, Time Travel provides historical access, and Resource Monitors track credit consumption. Therefore, zero-copy cloning is the correct feature for rapidly creating an initially storage-efficient clone.

Question 336

Which Snowflake privilege is generally required on a table when a role needs to read its rows?

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

Correct Answer: 3

Explanation:

The SELECT privilege allows a role to read rows from a table through queries such as SELECT statements. In Snowflake’s access-control model, the role may also need appropriate privileges on the parent database and schema, such as USAGE, before it can access the table successfully. INSERT allows adding rows, UPDATE allows modifying existing rows, and DELETE allows removing rows. Privileges can be granted directly or through roles according to the organization’s security model. Therefore, SELECT is the appropriate privilege when the requirement is to read table data.

Question 337

Which Snowflake capability is intended to provide recovery assistance after the Time Travel retention period has ended?

1. Fail-safe
2. Snowpipe
3. Search Optimization Service
4. Auto-resume

Correct Answer: 1

Explanation:

Fail-safe is a separate Snowflake data recovery mechanism that can provide additional protection after the applicable Time Travel period has ended. It is not intended to function as a normal historical querying feature for everyday users. Time Travel is the feature used for user-accessible historical data operations during the configured retention period. Snowpipe supports continuous data ingestion, Search Optimization Service supports selected performance patterns, and Auto-resume manages warehouse startup. Therefore, Fail-safe is the appropriate capability when discussing recovery after Time Travel is no longer available.

Question 338

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

1. PUT
2. COPY INTO
3. GET
4. GRANT

Correct Answer: 2

Explanation:

COPY INTO is the standard Snowflake command used to load data from staged files into a target table. It can work with internal or external stages and can reference file formats and loading options to control how the source data is processed. PUT is generally used to upload local files to an internal stage, while GET downloads files from an internal stage to a local environment. GRANT manages privileges rather than moving data. Therefore, COPY INTO is the correct command for loading staged files into a Snowflake table.

Question 339

Which Snowflake feature controls access to specific rows based on conditions such as the user’s role or identity?

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

Correct Answer: 3

Explanation:

A Row Access Policy provides row-level security by determining whether specific rows should be visible to a user based on defined conditions. Conditions can use information such as the user’s role, identity, or other attributes available to the policy. This enables organizations to provide different users with different subsets of the same underlying table. A Masking Policy protects column values, a Resource Monitor manages credit consumption, and a File Format defines file parsing behavior. Therefore, Row Access Policy is the correct feature for controlling access to individual rows.

Question 340

Which statement best describes Snowflake’s separation of storage and compute?

1. Each table requires its own virtual warehouse.
2. Stored data and compute resources can be managed independently.
3. Compute resources are permanently stored inside database objects.
4. Only one warehouse can access a database at a time.

Correct Answer: 2

Explanation:

Snowflake separates data storage from compute resources, allowing them to be managed independently. Data is stored within Snowflake’s storage architecture, while virtual warehouses provide the compute resources needed to process workloads. This design allows organizations to resize, suspend, resume, or create additional warehouses without having to create separate copies of the underlying data. Different warehouses can also access the same data, supporting workload isolation and concurrency. Therefore, the ability to manage stored data and compute resources independently is a fundamental characteristic of Snowflake’s architecture.