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

Question 301

Which Snowflake feature provides a way to monitor credit consumption and define actions when usage reaches specified thresholds?

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

Correct Answer: 3

Explanation:

A Resource Monitor is designed to monitor Snowflake credit usage and can be configured with thresholds for notifications and supported actions. Administrators can use resource monitors to help control compute consumption and improve cost governance. Depending on the configuration, notifications can alert administrators when usage approaches or reaches defined limits. Time Travel is used for historical data access, Search Optimization Service improves supported selective search workloads, and Network Policies control account access based on network rules. Resource Monitors are therefore particularly useful when an organization wants visibility into credit consumption and wants to establish controls around Snowflake compute usage.

Question 302

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

1. Schema
2. Warehouse
3. Resource Monitor
4. Network Policy

Correct Answer: 1

Explanation:

A Schema is a logical container inside a Snowflake database that organizes database objects. These objects can include tables, views, stages, file formats, tasks, streams, procedures, and other supported objects. Schemas make it easier to organize data and manage permissions at an appropriate level. A Virtual Warehouse provides compute resources rather than organizing objects. A Resource Monitor manages credit consumption, while a Network Policy controls account access based on network conditions. Snowflake’s hierarchy generally consists of an account containing databases, databases containing schemas, and schemas containing objects. Therefore, Schema is the correct answer.

Question 303

Which Snowflake capability allows a query to avoid scanning micro-partitions that cannot contain relevant data?

1. Result Cache
2. Clustering
3. Query Pruning
4. Auto-resume

Correct Answer: 3

Explanation:

Query Pruning allows Snowflake to avoid scanning micro-partitions that cannot contain data relevant to a query. Snowflake maintains metadata about micro-partitions, including information about the values they contain. When query predicates allow Snowflake to determine that certain partitions cannot contain matching rows, those partitions can be skipped. This reduces unnecessary data scanning and can improve query performance. Result Cache works by reusing eligible previous query results, while clustering helps organize data according to defined keys. Auto-resume controls warehouse startup. Therefore, Query Pruning is the correct capability for eliminating irrelevant micro-partitions from query processing.

Question 304

Which command is primarily used to remove rows from a table while keeping the table object available?

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

Correct Answer: 2

Explanation:

The DELETE command removes rows from a Snowflake table while leaving the table object and its structure available. A WHERE clause can be included to remove only rows that satisfy specific conditions. This makes DELETE useful for targeted data removal. DROP TABLE has a different effect because it removes the table object itself. DROP DATABASE operates at the database level, and REMOVE TABLE is not the standard Snowflake SQL command for deleting table rows. Therefore, DELETE is the correct answer when the requirement is to remove data rows while keeping the table available for future queries and operations.

Question 305

Which authentication capability can provide an additional verification step beyond a user’s password?

1. Multi-factor authentication
2. Data clustering
3. Time Travel
4. File formatting

Correct Answer: 1

Explanation:

Multi-factor authentication, commonly called MFA, adds an additional verification step to the authentication process. Instead of depending only on a password, users can be required to provide another authentication factor. This improves account security because knowing or obtaining a password alone may not be sufficient to gain access. Data clustering is related to data organization and query performance, Time Travel provides access to historical data, and file formatting controls how staged files are interpreted. MFA is therefore an important security mechanism for protecting Snowflake user accounts. It strengthens authentication by requiring additional verification beyond the user’s primary password.

Question 306

Which Snowflake capability is most appropriate when an organization needs to share selected data securely with another Snowflake account?

1. Zero-copy cloning
2. Secure Data Sharing
3. Resource Monitor
4. Auto-suspend

Correct Answer: 2

Explanation:

Secure Data Sharing allows a Snowflake provider to share selected data with another Snowflake account without requiring a traditional physical duplicate of the shared data for the consumer. The provider determines which objects are included in the share, helping maintain control over what information is exposed. The consumer can then access the shared information according to the configured sharing relationship. Zero-copy cloning is mainly used to create clones of supported objects, while Resource Monitors track credit consumption and Auto-suspend manages warehouse inactivity. Therefore, Secure Data Sharing is the correct capability for securely sharing selected Snowflake data with another account.

Question 307

What is the main purpose of a masking policy in Snowflake?

1. To automatically suspend warehouses
2. To track changed rows
3. To control how sensitive column values are presented
4. To upload files to a stage

Correct Answer: 3

Explanation:

A Masking Policy controls how sensitive column values are presented to users. Depending on defined conditions, authorized users may see the original value while other users receive a masked or transformed representation. This is useful for protecting sensitive information such as personal identifiers, financial data, or confidential business information. A masking policy does not automatically suspend warehouses, track table changes, or upload files. Warehouse suspension is controlled by settings such as AUTO_SUSPEND, Streams track changes, and commands such as PUT can upload files to internal stages. Therefore, controlling the presentation of sensitive column values is the correct purpose of a masking policy.

Question 308

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

1. AUTO_SUSPEND
2. AUTO_RESUME
3. Time Travel
4. Fail-safe

Correct Answer: 2

Explanation:

AUTO_RESUME allows a suspended Snowflake virtual warehouse to automatically start when a workload requires compute resources. This can make warehouse management easier because users do not need to manually resume a suspended warehouse before running queries. AUTO_SUSPEND performs the opposite function by suspending an inactive warehouse after the configured period. Time Travel is used for historical data access, while Fail-safe provides a separate recovery mechanism. AUTO_RESUME is particularly useful when warehouses are configured to suspend during periods of inactivity to control costs and then restart automatically when new workloads arrive.

Question 309

Which Snowflake data type is specifically designed to represent an ordered collection of semi-structured values?

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

Correct Answer: 2

Explanation:

ARRAY is a Snowflake semi-structured data type used to represent an ordered collection of values. Arrays are common when working with JSON and other nested datasets where multiple elements are grouped together in a defined order. OBJECT is used to represent key-value pairs, while VARIANT can contain different types of semi-structured values. VARCHAR is a traditional string data type. Snowflake also provides functions such as FLATTEN that can expand array elements into separate rows for analysis. Therefore, ARRAY is the correct answer when the requirement is to represent an ordered collection of semi-structured values.

Question 310

Which Snowflake feature is primarily intended to provide continuous or near-continuous loading of files as they become available?

1. Time Travel
2. Resource Monitor
3. Snowpipe
4. Materialized View

Correct Answer: 3

Explanation:

Snowpipe is designed to support continuous or near-continuous file ingestion into Snowflake. It can automatically process newly arriving files through supported ingestion mechanisms, reducing the need for users to repeatedly initiate traditional bulk-loading operations. Snowpipe is useful for workloads where data arrives frequently and needs to become available in Snowflake with minimal manual intervention. Time Travel provides historical data access, Resource Monitors track credit consumption, and Materialized Views maintain precomputed results for supported queries. Therefore, Snowpipe is the correct feature when an organization needs continuous or near-continuous ingestion of files into Snowflake.

Question 311

Which Snowflake object maintains precomputed results to improve performance for supported query patterns?

1. Materialized View
2. Standard View
3. Network Policy
4. Stream

Correct Answer: 1

Explanation:

A Materialized View maintains precomputed results for supported query definitions. Maintaining these results can allow eligible workloads to retrieve data more efficiently than repeatedly performing the complete underlying computation. Materialized Views are useful for appropriate performance-sensitive workloads but also involve maintenance and storage considerations. A Standard View is primarily a logical SQL definition, a Network Policy controls network-based account access, and a Stream records changes to supported source tables. Therefore, Materialized View is the correct answer when the requirement is to maintain precomputed results for supported query patterns and potentially improve query performance.

Question 312

Which Snowflake feature can allow a query to reuse an eligible previously computed result instead of executing the query again?

1. Micro-partitioning
2. Result Cache
3. Row Access Policy
4. Network Policy

Correct Answer: 2

Explanation:

Snowflake’s Result Cache can allow an eligible query result to be reused rather than requiring the query to execute again from the beginning. When the necessary conditions for result reuse are satisfied, this can reduce response time and avoid unnecessary compute processing. Result caching is different from micro-partition pruning, which reduces the amount of underlying data that needs to be scanned during query execution. Row Access Policies control which rows users can see, while Network Policies control network-based account access. Therefore, Result Cache is the correct feature for reusing eligible previously computed query results.

Question 313

Which Snowflake command can be used to grant a privilege on an object to a role?

1. GRANT
2. COPY
3. MERGE
4. FLATTEN

Correct Answer: 1

Explanation:

The GRANT command is used to assign privileges to roles within Snowflake’s access-control system. For example, administrators can grant SELECT on a table, USAGE on a database or schema, or other supported privileges depending on the required access. Roles can then be granted to users or other roles as part of role-based access control. COPY is used for data loading or unloading, MERGE performs conditional data modifications, and FLATTEN expands nested semi-structured data. Therefore, GRANT is the correct command when an administrator needs to assign a Snowflake privilege on an object to a role.

Question 314

Which Snowflake capability can automatically maintain clustering for eligible tables when a clustering key has been defined?

1. Search Optimization Service
2. Materialized View
3. Automatic Clustering
4. Snowpipe

Correct Answer: 3

Explanation:

Automatic Clustering helps maintain the organization of eligible table data according to a defined clustering key. As data changes over time, the physical organization of micro-partitions can become less aligned with the intended clustering strategy. Snowflake can perform background maintenance to improve this organization without requiring administrators to manually reorganize the table after every data change. Search Optimization Service addresses supported selective search workloads, Materialized Views maintain precomputed results, and Snowpipe supports continuous file ingestion. Therefore, Automatic Clustering is the correct capability for maintaining clustering automatically as table data changes.

Question 315

What is a primary benefit of separating storage and compute in Snowflake?

1. Data can only be accessed by one warehouse.
2. Compute resources can be scaled or isolated independently from stored data.
3. Storage automatically becomes a virtual warehouse.
4. Tables no longer require databases or schemas.

Correct Answer: 2

Explanation:

Snowflake’s separation of storage and compute allows organizations to manage computing resources independently from stored data. Virtual warehouses provide compute resources while the storage layer holds the underlying data. This architecture means organizations can resize, suspend, resume, or create additional warehouses without creating separate copies of the same data for every workload. Different warehouses can access the same data while maintaining workload isolation. This is useful for separating reporting, loading, development, and analytical workloads. Therefore, the ability to scale or isolate compute independently from stored data is one of the major benefits of Snowflake’s architecture.

Question 316

Which Snowflake function is commonly used to convert valid JSON text into a semi-structured value?

1. SPLIT
2. CAST
3. PARSE_JSON
4. LENGTH

Correct Answer: 3

Explanation:

PARSE_JSON converts valid JSON-formatted text into a semi-structured Snowflake value, commonly represented using the VARIANT data type. After the JSON has been parsed, users can access nested fields, arrays, and objects using Snowflake’s semi-structured data capabilities. Functions such as FLATTEN can also be used when nested arrays or objects need to be expanded for processing. SPLIT divides strings, CAST converts values between supported data types, and LENGTH returns the length of a string. Therefore, PARSE_JSON is the appropriate function for converting JSON text into a queryable semi-structured representation.

Question 317

Which Snowflake feature controls whether specific rows are visible to a user based on defined conditions?

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

Correct Answer: 1

Explanation:

A Row Access Policy controls row-level visibility based on conditions defined by the organization. These conditions can evaluate information such as a user’s role or identity and determine which rows should be returned. This provides fine-grained security without requiring separate physical tables for every user group. A Masking Policy controls how column values are displayed, while Resource Monitors manage credit consumption and File Formats define how staged files are interpreted. Therefore, Row Access Policy is the correct feature when an organization needs to determine which individual rows a particular user or role can access.

Question 318

Which Snowflake object provides a reusable location for files used in data loading or unloading operations?

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

Correct Answer: 2

Explanation:

A Stage provides a location where files can be stored or referenced for Snowflake data loading and unloading operations. Stages may be internal to Snowflake or may reference supported external cloud storage locations. They are commonly used together with commands such as COPY INTO for loading data into tables. Tasks automate SQL processing, Streams track changes in source tables, and Roles manage access privileges. Stages are therefore an important part of file-based data movement workflows. When files need to be made available to Snowflake for loading or unloading, a Stage is the appropriate object.

Question 319

Which statement best describes Snowflake micro-partitions?

1. They are manually created database schemas.
2. They are small logical units used to organize table data and store metadata for efficient scanning.
3. They are virtual warehouses used for query execution.
4. They are user authentication policies.

Correct Answer: 2

Explanation:

Snowflake automatically organizes table data into micro-partitions. These are contiguous storage units containing portions of table data, and Snowflake maintains metadata about the values contained within them. This metadata enables query optimization techniques such as partition pruning, allowing Snowflake to skip micro-partitions that cannot contain relevant rows. Users do not manually create micro-partitions in the same way they create schemas or warehouses. Micro-partitioning is part of Snowflake’s underlying storage architecture and contributes to efficient query processing. Therefore, option 2 correctly describes micro-partitions and their role in Snowflake.

Question 320

Which Snowflake capability is most appropriate for creating a development copy of a table quickly while initially sharing underlying storage with the source?

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

Correct Answer: 3

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. As changes are made to either object, Snowflake manages the affected data separately, meaning storage usage can increase as the objects diverge. This makes zero-copy cloning particularly useful for development, testing, troubleshooting, and experimentation. Snowpipe is designed for continuous file ingestion, Time Travel provides historical data access, and Resource Monitors manage credit consumption. Therefore, zero-copy cloning is the correct choice for quickly creating a development copy.