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

 

Question 241

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

1. Auto-suspend
2. Resource Monitor
3. Auto-resume
4. Fail-safe

Correct Answer: 3

Explanation:

Auto-resume allows a suspended virtual warehouse to automatically start when a workload requires compute resources. It is commonly configured together with auto-suspend. Auto-suspend stops the warehouse after a specified period of inactivity, helping reduce unnecessary credit consumption, while auto-resume brings it back online when required. Resource Monitors are used to monitor and control credit consumption, and Fail-safe is associated with data recovery. Auto-resume therefore improves warehouse availability while allowing organizations to take advantage of warehouse suspension for cost management.

Question 242

Which Snowflake object is the primary compute resource used to execute SQL queries?

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

Correct Answer: 1

Explanation:

A virtual warehouse provides the compute resources required to execute SQL queries and perform data-processing operations in Snowflake. Warehouses are independent from the storage layer, allowing compute resources to be resized, suspended, resumed, or separated by workload. A database and schema organize Snowflake objects, while a stage provides a location for files used in loading and unloading operations. Because Snowflake separates compute from storage, multiple warehouses can access the same underlying data. Therefore, the virtual warehouse is the primary compute resource responsible for executing SQL workloads.

Question 243

Which Snowflake feature allows users to access historical versions of data within the applicable retention period?

1. Snowpipe
2. Time Travel
3. Resource Monitor
4. Search Optimization Service

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, examining previous states of data, and recovering from certain data modifications. Snowflake’s historical data capabilities are separate from Fail-safe, which is intended primarily for recovery after the Time Travel period. Snowpipe is used for continuous ingestion, Resource Monitors manage credit consumption, and Search Optimization Service improves supported selective searches. Therefore, Time Travel is the correct feature when users need to query or recover historical data.

Question 244

Which Snowflake object tracks changes to table data so that downstream processes can perform incremental processing?

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

Correct Answer: 2

Explanation:

A Stream records information about changes to table data and can be used to support incremental data-processing workflows. Rather than processing an entire table repeatedly, downstream logic can use stream information to identify relevant changes. Streams are frequently combined with Tasks to automate transformation and ingestion pipelines. A stage is associated with files, a warehouse provides compute resources, and a file format defines how files should be interpreted. Therefore, the Stream object is the appropriate Snowflake feature for capturing table changes for downstream processing.

Question 245

Which Snowflake feature provides row-level control over which records a user can access?

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

Correct Answer: 3

Explanation:

A Row Access Policy provides fine-grained control over which rows are visible to a user. Policies can use conditions involving roles or other contextual information to determine whether specific records should be returned. This enables multiple users to query the same table while receiving different subsets of data according to their access permissions. Masking Policies are primarily used to protect column values, Resource Monitors manage credit usage, and Search Optimization Service improves certain query patterns. Therefore, Row Access Policy is the appropriate feature for controlling access at the row level.

Question 246

Which Snowflake feature can help optimize supported point-lookup queries on large tables?

1. Search Optimization Service
2. Time Travel
3. Snowpipe
4. Fail-safe

Correct Answer: 1

Explanation:

Search Optimization Service is designed to improve performance for supported selective search patterns, including certain point-lookup workloads. It maintains additional search-related information that can help Snowflake locate relevant records more efficiently. This can be useful when queries frequently search for specific values in large tables and scanning many micro-partitions would otherwise be inefficient. Time Travel provides historical data access, Snowpipe handles continuous ingestion, and Fail-safe provides a recovery mechanism. Therefore, Search Optimization Service is the feature most directly associated with optimizing supported selective lookup queries.

Question 247

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

1. IMPORT DATA
2. LOAD FILE
3. INSERT FILE
4. COPY INTO

Correct Answer: 4

Explanation:

COPY INTO is a core Snowflake command used to load data from staged files into target tables. It supports internal and external stages and can work with named or inline file-format specifications. The command also provides options for handling errors and controlling which files are processed. IMPORT DATA, LOAD FILE, and INSERT FILE are not the standard Snowflake commands for bulk loading staged files. Therefore, COPY INTO is the correct command for loading files into a Snowflake table.

Question 248

Which Snowflake object defines how a CSV file should be interpreted during a loading operation?

1. Stream
2. File Format
3. Role
4. Warehouse

Correct Answer: 2

Explanation:

A File Format object contains settings that tell Snowflake how to interpret files during loading or unloading. For CSV files, these settings can include field delimiters, record delimiters, quotation characters, compression, and other file-related properties. File formats can be created as reusable database objects or specified directly in certain SQL commands. Streams track changes to table data, roles manage access, and warehouses provide compute resources. Therefore, a File Format is the correct object for defining the structure and interpretation rules of a CSV file.

Question 249

Which Snowflake capability allows supported objects to be cloned without initially making a full physical copy of their data?

1. Zero-copy cloning
2. Snowpipe
3. Materialized View
4. Fail-safe

Correct Answer: 1

Explanation:

Zero-copy cloning allows supported Snowflake objects to be cloned without immediately creating an independent physical copy of the underlying data. Initially, the clone can reference the same underlying micro-partitions as the source. When modifications occur, Snowflake manages the changed data appropriately. This capability is particularly valuable for development, testing, and temporary environments because users can create copies of large datasets quickly without the initial storage requirements of traditional duplication. Snowpipe handles ingestion, Materialized Views support performance, and Fail-safe provides recovery capabilities.

Question 250

Which Snowflake feature helps monitor credit consumption and can be configured with usage thresholds?

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

Correct Answer: 3

Explanation:

A Resource Monitor helps organizations monitor Snowflake credit consumption and establish usage thresholds. Depending on its configuration, it can provide notifications or take supported actions when consumption reaches specified levels. Resource Monitors are therefore useful for cost governance and workload management. A stage is used for file storage or references, a stream tracks table changes, and a file format defines file interpretation rules. Resource Monitors do not provide compute or data storage; their purpose is to help administrators monitor and manage credit consumption.

Question 251

Which Snowflake feature can automatically stop an idle virtual warehouse after a configured period?

1. Auto-resume
2. Auto-suspend
3. Time Travel
4. Snowpipe

Correct Answer: 2

Explanation:

Auto-suspend automatically stops a virtual warehouse after it remains inactive for the configured amount of time. This feature is commonly used to reduce unnecessary compute credit consumption. Once suspended, the warehouse can remain inactive until a workload requires it, at which point auto-resume can start it again if that feature is enabled. Time Travel provides historical data access, while Snowpipe is designed for continuous data ingestion. Therefore, Auto-suspend is specifically responsible for automatically stopping an idle virtual warehouse.

Question 252

Which Snowflake data type is commonly used to store JSON and other semi-structured data?

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

Correct Answer: 1

Explanation:

VARIANT is a Snowflake data type designed to store semi-structured data such as JSON. It can contain nested structures and different data types, providing flexibility when incoming data does not follow a fixed relational schema. Snowflake provides functions and operators for accessing and manipulating information stored in VARIANT values. DATE is used for calendar dates, BOOLEAN represents logical values, and NUMBER stores numeric information. Therefore, VARIANT is the most appropriate data type when storing flexible semi-structured data such as JSON documents.

Question 253

Which Snowflake feature is intended to improve performance by avoiding unnecessary micro-partition scans?

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

Correct Answer: 3

Explanation:

Query pruning allows Snowflake to eliminate micro-partitions that are unlikely to contain data matching the query conditions. Snowflake maintains metadata associated with micro-partitions, and this information can be used to determine which partitions can safely be skipped. Effective pruning reduces the amount of data scanned and can improve query performance. Resource Monitors focus on credit management, Snowpipe handles ingestion, and Fail-safe provides recovery capabilities. Therefore, query pruning is the capability directly associated with reducing unnecessary micro-partition scans.

Question 254

Which Snowflake object provides a logical query-based representation of data without creating a traditional copy of the underlying table?

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

Correct Answer: 1

Explanation:

A standard View provides a logical representation of data based on a stored SQL query. It can simplify complex queries, expose selected columns, and provide an abstraction layer over underlying tables. A standard view does not create a separate traditional copy of the underlying table data. A stage is associated with files, a stream captures changes, and a warehouse supplies compute resources. Views are also useful for controlling what information users can access by exposing only selected columns or records through an appropriate query definition.

Question 255

Which Snowflake feature can execute SQL statements automatically according to a schedule or dependency?

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

Correct Answer: 3

Explanation:

Snowflake Tasks are designed to automate SQL execution. A task can run according to a schedule or be configured as part of a task graph where execution depends on another task. This makes Tasks useful for recurring transformations, data processing, maintenance operations, and automated workflows. Streams can provide change information that a task processes, while stages and file formats support file-based data loading. Therefore, Task is the appropriate Snowflake object when SQL operations need to be executed automatically according to a schedule or dependency.

Question 256

Which Snowflake feature provides a separate recovery mechanism after the applicable Time Travel period?

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

Correct Answer: 3

Explanation:

Fail-safe is a separate Snowflake recovery mechanism that applies after the applicable Time Travel period. It is primarily intended for disaster recovery rather than normal user-driven historical data access. During the Time Travel period, users can use supported historical querying and recovery capabilities. Once that period has ended, Fail-safe may provide additional recovery assistance according to Snowflake’s applicable service procedures. Snowpipe handles ingestion, Search Optimization Service improves supported selective searches, and auto-suspend manages warehouse activity. Therefore, Fail-safe is the correct answer.

Question 257

Which Snowflake feature can support high-concurrency workloads by using multiple compute clusters?

1. Multi-cluster warehouse
2. Time Travel
3. Snowpipe
4. Resource Monitor

Correct Answer: 1

Explanation:

A multi-cluster warehouse can provide multiple compute clusters to support workloads with many concurrent queries. When demand increases, additional clusters can provide more compute capacity and potentially reduce query queuing, depending on the warehouse’s scaling configuration. This capability is particularly useful when the primary challenge is concurrency rather than only the complexity of individual queries. Time Travel handles historical data, Snowpipe supports continuous ingestion, and Resource Monitors manage credit consumption. Therefore, a multi-cluster warehouse is the appropriate feature for supporting high levels of query concurrency.

Question 258

Which Snowflake security feature can dynamically transform sensitive column values for unauthorized users?

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

Correct Answer: 2

Explanation:

A Masking Policy can dynamically control how sensitive column values are presented to users. Depending on the user’s role or other conditions, the policy can return the original value or a masked representation. This allows organizations to protect sensitive information while keeping a common underlying dataset for different users. A Row Access Policy controls which rows are visible, Resource Monitors manage credit consumption, and Streams capture table changes. Therefore, Masking Policy is the feature specifically designed for dynamic column-level protection.

Question 259

Which Snowflake architecture principle allows multiple warehouses to work with the same stored data independently?

1. Role hierarchy
2. Storage and compute separation
3. Automatic Clustering
4. File format abstraction

Correct Answer: 2

Explanation:

Snowflake’s separation of storage and compute allows multiple virtual warehouses to access the same underlying stored data independently. Each warehouse provides its own compute resources, allowing organizations to isolate workloads such as reporting, data engineering, or business intelligence without maintaining separate physical copies of the same data. Role hierarchy is related to access control, Automatic Clustering maintains table organization, and file format abstraction concerns file interpretation. Therefore, storage and compute separation is the architectural principle that enables independent compute resources to work against shared stored data.

Question 260

Which Snowflake function is commonly used to expand elements of nested arrays or objects into rows?

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

Correct Answer: 4

Explanation:

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