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

 

Question 381

Which Snowflake feature is used to provide additional protection and recovery capabilities after the Time Travel period has ended?

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

Correct Answer: 4

Explanation:

Fail-safe is a separate Snowflake recovery mechanism that provides additional protection after the applicable Time Travel retention period has ended. It is important to understand that Fail-safe is not intended for normal user-driven historical querying. Time Travel is the primary feature for accessing historical data during the configured retention period, while Fail-safe is intended for recovery scenarios when Time Travel is no longer available. Snowpipe handles continuous data ingestion, Query Profile helps analyze query execution, and Resource Monitor tracks credit consumption. Therefore, Fail-safe is the correct answer for post-Time Travel recovery protection.

Question 382

Which Snowflake object contains schemas and provides a higher-level organizational container for database objects?

1. Database
2. Warehouse
3. Stage
4. Task

Correct Answer: 1

Explanation:

A Database is a high-level organizational container in Snowflake that contains schemas. Schemas then contain objects such as tables, views, stages, file formats, tasks, and other supported objects. A Warehouse provides compute resources and is separate from the database hierarchy. A Stage provides a location for files used in data loading and unloading, while a Task automates SQL execution. Understanding the hierarchy of account, database, schema, and object is important when managing data and privileges. Therefore, Database is the correct answer because it contains schemas.

Question 383

Which Snowflake feature can be used to automatically process newly arriving files with minimal manual intervention?

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

Correct Answer: 3

Explanation:

Snowpipe is designed to continuously or near-continuously ingest newly arriving files into Snowflake. It can use supported event-driven mechanisms to detect and process new files, reducing the need for users to repeatedly run manual loading commands. This makes Snowpipe suitable for workloads where data arrives frequently or continuously. Materialized Views maintain precomputed query results, Row Access Policies control row visibility, and Time Travel provides access to historical data. Therefore, Snowpipe is the correct feature when newly arriving files need to be loaded automatically with minimal manual intervention.

Question 384

Which privilege is generally required to allow a role to read data from a Snowflake table?

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

Correct Answer: 2

Explanation:

The SELECT privilege allows a role to read data from a Snowflake table. Depending on the object’s location, the role generally also needs the appropriate USAGE privileges on the parent database and schema. Snowflake’s hierarchical privilege model means access to a table is affected by privileges granted at multiple levels. INSERT permits adding rows, UPDATE permits modifying rows, and DELETE permits removing rows. These privileges should be granted according to the principle of least privilege. Therefore, SELECT is the appropriate privilege when a role needs to read table data.

Question 385

Which Snowflake feature can reduce compute costs by automatically stopping an unused virtual warehouse?

1. AUTO_SUSPEND
2. AUTO_RESUME
3. Time Travel
4. Search Optimization Service

Correct Answer: 1

Explanation:

AUTO_SUSPEND allows a virtual warehouse to automatically suspend after remaining inactive for a configured period. Because running warehouses consume compute resources, suspending unused warehouses can help reduce unnecessary credit consumption. AUTO_RESUME performs the opposite function by restarting a suspended warehouse when workload requires it. Time Travel provides historical data access, while Search Optimization Service improves performance for supported selective search patterns. Properly configuring auto-suspend is an important cost-management practice, especially for development and intermittent workloads. Therefore, AUTO_SUSPEND is the correct answer.

Question 386

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

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

Correct Answer: 3

Explanation:

PUT is used to upload files from a local environment to an internal Snowflake stage. After the files are staged, COPY INTO can be used to load their contents into a target table. GET generally performs the reverse operation by downloading files from an internal stage to a local environment. GRANT is used to manage privileges and does not transfer data files. Understanding the distinction between PUT, GET, and COPY INTO is important for Snowflake data-loading workflows. Therefore, PUT is the correct command for uploading local files to an internal stage.

Question 387

Which Snowflake object tracks changes to table data for use in incremental data-processing workflows?

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

Correct Answer: 2

Explanation:

A Stream records change information for a supported source table and allows downstream processes to identify changes such as inserts, updates, and deletes. This makes Streams useful for incremental processing because a downstream pipeline can focus on changed data instead of repeatedly processing an entire table. Views provide logical query definitions, Stages provide file locations, and File Formats define how files should be interpreted during loading or unloading. Streams are often combined with Tasks to automate processing. Therefore, Stream is the correct Snowflake object for tracking table changes.

Question 388

Which Snowflake feature provides detailed information about how a query was executed?

1. Resource Monitor
2. Network Policy
3. Query Profile
4. File Format

Correct Answer: 3

Explanation:

Query Profile provides detailed information about the execution of a Snowflake query. It can help users understand execution steps, identify expensive operations, investigate large scans, and analyze areas that may contribute to poor performance. Resource Monitors focus on credit consumption, Network Policies control network-based account access, and File Formats define file interpretation rules. Query Profile is therefore a valuable diagnostic capability for understanding query behavior and investigating performance problems. When optimizing SQL, reviewing the execution profile can help identify where improvements may be possible.

Question 389

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

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

Correct Answer: 2

Explanation:

OBJECT is a Snowflake semi-structured data type designed to represent key-value pairs. It is particularly useful for JSON-style structures where named attributes are associated with corresponding values. ARRAY is used for ordered collections, while DATE represents calendar dates and BOOLEAN represents true or false values. Snowflake also provides VARIANT for flexible semi-structured values that can contain objects, arrays, and other supported types. Understanding these data types helps users select an appropriate representation for semi-structured information. Therefore, OBJECT is the correct answer for key-value structures.

Question 390

Which Snowflake feature automatically starts a suspended warehouse when a workload requires it?

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

Correct Answer: 4

Explanation:

AUTO_RESUME allows a suspended virtual warehouse to start automatically when a workload requires compute resources. This eliminates the need for users to manually resume the warehouse before executing queries. AUTO_SUSPEND instead stops an inactive warehouse after a configured period. Time Travel manages historical data access, while Resource Monitors are used to monitor credit consumption. AUTO_RESUME and AUTO_SUSPEND are commonly configured together to balance convenience and compute-cost management. Therefore, AUTO_RESUME is the correct feature for automatically starting a suspended warehouse when work is submitted.

Question 391

Which Snowflake feature controls how sensitive column values are displayed based on defined conditions?

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

Correct Answer: 1

Explanation:

A Masking Policy controls the representation of values in sensitive columns. Depending on defined conditions, users with appropriate authorization may see the original value, while other users may receive a masked or transformed value. This provides fine-grained protection for sensitive information without necessarily restricting access to the entire table. Row Access Policies control which rows are visible, Network Policies control network-based account access, and Resource Monitors manage credit usage. Therefore, Masking Policy is the correct Snowflake security feature for controlling how sensitive column values are presented.

Question 392

Which Snowflake feature is used to create an independent development environment from a table without initially duplicating all underlying micro-partitions?

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

Correct Answer: 3

Explanation:

Zero-copy cloning allows supported Snowflake objects to be cloned quickly without initially creating a complete physical copy of the source data. The source and clone can initially reference the same underlying micro-partitions. As changes are made, Snowflake manages the affected data separately, so storage usage can increase as the clone diverges from the source. This makes cloning useful for development, testing, and experimentation. Secure Data Sharing is for sharing data with other accounts, Time Travel provides historical access, and Snowpipe handles file ingestion. Therefore, zero-copy cloning is correct.

Question 393

Which Snowflake feature is designed to improve performance for supported selective searches on large datasets?

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

Correct Answer: 2

Explanation:

Search Optimization Service is designed to improve performance for supported selective search patterns. It can be particularly useful when queries frequently search for specific values in large datasets and normal micro-partition pruning is not sufficient to provide the desired performance. The service maintains additional search-related structures that help Snowflake locate relevant data more efficiently. It does not universally improve every query. Time Travel handles historical data, Resource Monitors track credit usage, and Fail-safe provides recovery support. Therefore, Search Optimization Service is the correct answer.

Question 394

Which Snowflake object is used to automate SQL statements according to a schedule or dependency?

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

Correct Answer: 1

Explanation:

A Task is designed to automate the execution of SQL statements or supported procedures. Tasks can run according to schedules or dependencies and can be combined into task graphs for multi-step data-processing workflows. They are also commonly used with Streams to process changed data incrementally. Streams track changes but do not themselves provide scheduling, while Stages manage files and Views provide logical SQL definitions. Therefore, Task is the appropriate Snowflake object for automated SQL execution based on schedules or dependencies.

Question 395

Which Snowflake capability allows multiple warehouses to access the same stored data without requiring separate copies for each warehouse?

1. Zero-copy cloning
2. Secure Data Sharing
3. Separation of storage and compute
4. Multi-factor authentication

Correct Answer: 3

Explanation:

Snowflake separates storage from compute, allowing multiple virtual warehouses to access the same underlying stored data. Each warehouse provides independent compute resources, which supports workload isolation and flexible scaling. Organizations can therefore use separate warehouses for reporting, data loading, development, or other workloads without maintaining a separate copy of the same data for every warehouse. Zero-copy cloning is used to create clones, Secure Data Sharing is used to share data across accounts, and MFA strengthens authentication. Therefore, separation of storage and compute is the correct answer.

Question 396

Which Snowflake function converts valid JSON text into a semi-structured value that can be queried?

1. FLATTEN
2. PARSE_JSON
3. COUNT
4. COALESCE

Correct Answer: 2

Explanation:

PARSE_JSON converts valid JSON-formatted text into a semi-structured value, commonly stored or returned as VARIANT. After parsing, users can access nested attributes and array elements using Snowflake’s semi-structured data functionality. FLATTEN has a different purpose: it expands elements from arrays or nested structures into rows. COUNT is an aggregation function, while COALESCE returns the first non-null expression among its arguments. Therefore, PARSE_JSON is the appropriate function when JSON text needs to be converted into a queryable semi-structured representation.

Question 397

Which Snowflake feature allows selected data to be shared with another Snowflake account without creating a traditional duplicate of the provider’s data?

1. Secure Data Sharing
2. Time Travel
3. Automatic Clustering
4. Resource Monitor

Correct Answer: 1

Explanation:

Secure Data Sharing allows a provider to share selected Snowflake data with 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 configured sharing relationship. This architecture makes data collaboration efficient and can reduce unnecessary duplication. Time Travel provides historical data access, Automatic Clustering maintains data organization according to clustering strategies, and Resource Monitors manage credit consumption. Therefore, Secure Data Sharing is the correct answer.

Question 398

Which Snowflake command is used to load data from files stored in a stage into a table?

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

Correct Answer: 2

Explanation:

COPY INTO is used to load data from staged files into Snowflake tables. The command can reference an internal or external stage and can use a specified file format to determine how the files should be interpreted. Additional options can control error handling, file selection, and other loading behavior. PUT is used to upload local files to an internal stage, GET downloads files from an internal stage, and GRANT manages privileges. Therefore, COPY INTO is the correct command for loading staged files into a target table.

Question 399

Which Snowflake feature provides a logical representation of data based on a SQL query without normally maintaining a complete independent result set?

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

Correct Answer: 3

Explanation:

A Standard View is a logical representation defined by a SQL query. It allows users to query the defined result as though it were a table, while the view itself does not normally maintain a complete independent physical result set. A Materialized View differs because Snowflake maintains precomputed results for supported definitions. A Table stores data directly, while a Stream records changes to supported source tables. Standard Views are useful for abstraction, simplifying complex queries, and controlling which columns or rows are exposed. Therefore, Standard View is correct.

Question 400

Which Snowflake feature is most appropriate for automatically stopping an idle virtual warehouse after a specified period?

1. AUTO_SUSPEND
2. AUTO_RESUME
3. Search Optimization Service
4. Time Travel

Correct Answer: 1

Explanation:

AUTO_SUSPEND controls how long a virtual warehouse can remain inactive before Snowflake automatically suspends it. Suspending an idle warehouse can help reduce unnecessary compute credit consumption, particularly for workloads that run intermittently. AUTO_RESUME performs the opposite function by automatically starting a suspended warehouse when workload requires compute resources. Search Optimization Service addresses supported selective query patterns, while Time Travel provides historical data access. Therefore, AUTO_SUSPEND is the correct feature for automatically stopping an idle virtual warehouse and supporting efficient compute-cost management.