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

Question 281

Which Snowflake feature allows administrators to restrict access to an account based on network location or IP address?

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

Correct Answer: 2

Explanation:

A Network Policy can be used to restrict access to a Snowflake account based on allowed or blocked network identifiers, such as IP addresses. This provides an additional layer of access control before users can access account resources. Network policies are particularly useful when an organization wants to limit access to approved corporate networks or specific locations. Resource Monitors manage credit consumption, while Masking Policies and Row Access Policies protect data after access is established. Therefore, Network Policy is the appropriate feature for restricting account access based on network information.

Question 282

Which Snowflake object is primarily used to define how data files should be interpreted during loading or unloading?

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

Correct Answer: 1

Explanation:

A File Format object stores specifications describing how data files should be interpreted when Snowflake loads or unloads data. Settings can include delimiters, compression, file type, header handling, and other parsing options depending on the format. Reusable named file formats can simplify data-loading configurations across multiple operations. A Stream tracks changes to table data, a Task automates processing, and a Warehouse supplies compute resources. Therefore, File Format is the Snowflake object used to define file interpretation rules.

Question 283

Which privilege allows a role to use a database as part of accessing objects within it?

1. MODIFY
2. OWNERSHIP
3. USAGE
4. OPERATE

Correct Answer: 3

Explanation:

The USAGE privilege on a database allows a role to access the database namespace and is generally required along with appropriate privileges on the schema and target objects. Snowflake uses a hierarchical privilege model, so having SELECT on a table alone may not be sufficient if the role lacks the required privileges on its parent database or schema. MODIFY is associated with changing certain object properties or data depending on the object, OWNERSHIP represents control of an object, and OPERATE is commonly associated with operational actions on supported objects. Therefore, USAGE is the correct privilege.

Question 284

Which Snowflake capability allows data consumers to access shared data without the provider transferring a separate physical copy of the data?

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

Correct Answer: 2

Explanation:

Secure Data Sharing allows a provider to make selected Snowflake data available to another account without creating a traditional duplicate copy of the underlying data for the consumer. The provider determines which objects are shared, while the consumer receives controlled access to the shared data. This architecture can make collaboration more efficient and reduce unnecessary data duplication. Time Travel handles historical data access, Auto-suspend controls warehouse inactivity, and Clustering concerns data organization for performance. Therefore, Secure Data Sharing is the correct capability for this requirement.

Question 285

Which Snowflake feature is most appropriate for recovering or querying historical versions of data within the configured retention period?

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

Correct Answer: 1

Explanation:

Time Travel allows users to access historical versions of data within the applicable retention period. It can support use cases such as investigating previous data states, recovering accidentally changed or deleted data, and querying information as it existed at an earlier point in time. Fail-safe is a separate recovery mechanism that is not intended for normal user querying of historical data. Resource Monitors manage credit usage, while Snowpipe supports continuous data ingestion. Therefore, Time Travel is the appropriate feature when users need historical data access within the configured retention period.

Question 286

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

1. PUT
2. GET
3. COPY INTO
4. CREATE FILE

Correct Answer: 3

Explanation:

COPY INTO is used to load data from a stage into a Snowflake table. It can work with internal or external stages and can use file formats and loading options to control how source files are interpreted. The PUT command is commonly used to upload local files to an internal stage, while GET downloads files from an internal stage to a local environment. CREATE FILE is not the standard command for loading staged files into a table. Therefore, COPY INTO is the correct command for this operation.

Question 287

Which Snowflake data type is commonly used to store JSON, XML, and other semi-structured values in a flexible representation?

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

Correct Answer: 1

Explanation:

VARIANT is a Snowflake data type designed to store semi-structured data such as JSON and other supported formats. It can contain different underlying types and supports querying nested structures using Snowflake’s semi-structured data functions and path notation. NUMBER is intended for numeric values, DATE stores calendar dates, and BOOLEAN represents true or false values. VARIANT is therefore particularly useful when source data has a flexible or nested structure that does not fit neatly into a traditional relational schema.

Question 288

Which Snowflake object records information about changes made to rows in a source table for downstream processing?

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

Correct Answer: 2

Explanation:

A Stream records change information for a supported source table, allowing downstream processes to identify changes such as inserts, updates, and deletes. Streams are commonly used together with Tasks to build incremental data-processing workflows. A View provides a logical query definition, a Stage provides a location for files, and a File Format defines how staged files are interpreted. Therefore, Stream is the correct Snowflake object when the requirement is to track table changes for subsequent processing.

Question 289

Which Snowflake feature is specifically intended to improve performance for certain selective point-lookups and similar search patterns?

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

Correct Answer: 2

Explanation:

Search Optimization Service can improve performance for supported selective search patterns by maintaining additional search access structures. It is particularly useful for workloads where queries frequently search for specific values within large datasets. It is not intended to improve every possible query automatically, so workload characteristics should be evaluated before enabling it. Time Travel provides historical access, Snowpipe handles continuous ingestion, and Fail-safe supports recovery scenarios. Therefore, Search Optimization Service is the appropriate feature for supported selective search workloads.

Question 290

Which statement best describes a Snowflake view?

1. It always stores a complete physical copy of its query results.
2. It is a logical definition based on a SQL query.
3. It is a compute resource used to execute SQL.
4. It is a file location for staged data.

Correct Answer: 2

Explanation:

A standard Snowflake view is a logical representation defined by a SQL query. It does not normally maintain a separate stored copy of all query results like a materialized view. When users query the view, Snowflake evaluates its underlying query according to the view definition and current data. A virtual warehouse provides compute resources, while a stage provides a location for files. Materialized Views are different because Snowflake maintains precomputed results for supported definitions. Therefore, a logical SQL-based definition best describes a standard view.

Question 291

Which Snowflake setting can help prevent a warehouse from continuing to consume compute resources while it is idle?

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

Correct Answer: 1

Explanation:

AUTO_SUSPEND controls how long a warehouse can remain inactive before Snowflake automatically suspends it. Suspending an idle warehouse helps avoid unnecessary compute consumption and can therefore support cost management. AUTO_RESUME performs the opposite function by starting a suspended warehouse when workload requires it. TIME_TRAVEL controls historical data retention, while DATA_RETENTION relates to retention behavior rather than warehouse activity. Therefore, AUTO_SUSPEND is the setting that helps stop idle compute resources automatically.

Question 292

Which Snowflake component is responsible for executing queries and DML operations?

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

Correct Answer: 3

Explanation:

A Virtual Warehouse provides the compute resources required to execute queries, DML operations, and other supported workloads. Snowflake separates this compute layer from the storage layer, allowing warehouses to be independently sized and configured. Databases and schemas organize objects and data, while stages are used for file-based data movement. Because the warehouse supplies the processing resources needed for SQL execution, it is the correct answer. Multiple warehouses can also access the same underlying data while maintaining workload isolation.

Question 293

Which Snowflake security feature can restrict which rows a user is allowed to see?

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

Correct Answer: 1

Explanation:

A Row Access Policy controls visibility at the row level. The policy can evaluate user identity, roles, or other conditions and determine whether specific rows should be returned. This provides fine-grained data access without necessarily creating separate physical tables for every user group. File Formats control file parsing, Resource Monitors manage credit consumption, and Search Optimization Service supports selected query-performance scenarios. Therefore, Row Access Policy is the Snowflake security feature designed specifically to control which rows users can see.

Question 294

What is a primary benefit of using zero-copy cloning in a development environment?

1. It permanently duplicates all source storage immediately.
2. It allows rapid creation of a logical copy without initially duplicating all underlying micro-partitions.
3. It automatically encrypts every table with a new key.
4. It disables Time Travel on the source object.

Correct Answer: 2

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. When changes occur, Snowflake manages the affected data separately, so storage behavior can change as the clone diverges from the source. This makes cloning particularly useful for development, testing, and experimentation. The clone does not permanently duplicate all source storage immediately, making option 2 the correct answer.

Question 295

Which Snowflake feature is designed to automate a sequence of data-processing operations using scheduled or dependent executions?

1. Task
2. Stage
3. File Format
4. Network Policy

Correct Answer: 1

Explanation:

Tasks automate the execution of SQL statements or supported procedures and can be scheduled or configured with dependencies. Multiple tasks can form a task graph, allowing organizations to create automated data-processing pipelines with ordered steps. This is useful for transformations, maintenance, and incremental processing workflows, especially when combined with Streams. Stages handle files, File Formats define file parsing rules, and Network Policies control network-based access. Therefore, Task is the appropriate Snowflake object for automating scheduled or dependent data-processing operations.

Question 296

Which Snowflake command can be used to transfer a local file to an internal stage?

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

Correct Answer: 2

Explanation:

The PUT command is used to upload local files to an internal Snowflake stage. It is commonly used as part of a workflow in which files are first transferred to an internal stage and then loaded into a target table using COPY INTO. GET performs the opposite direction by downloading files from an internal stage to a local environment. COPY INTO loads data between stages and tables rather than serving as the standard local-to-stage upload command. Therefore, PUT is the correct command.

Question 297

Which Snowflake feature allows different users or workloads to use separate compute resources while accessing the same stored data?

1. Separate databases
2. Multiple virtual warehouses
3. Multiple file formats
4. Multiple stages

Correct Answer: 2

Explanation:

Snowflake allows multiple virtual warehouses to access the same underlying stored data. Each warehouse provides independent compute resources, making it possible to isolate workloads such as reporting, data loading, analytics, and development. This architecture is a major benefit of Snowflake’s separation of storage and compute. Creating separate databases does not itself provide separate compute resources, while file formats and stages serve different purposes. Therefore, multiple virtual warehouses are the correct mechanism for providing separate compute resources against shared data.

Question 298

Which Snowflake object can be used to define reusable rules for interpreting CSV files during loading?

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

Correct Answer: 2

Explanation:

A File Format object can define reusable settings for interpreting CSV files during data loading and unloading. Depending on the requirements, settings may specify field delimiters, record delimiters, header handling, compression, quoting, and other parsing behavior. Creating a named File Format can simplify repeated COPY operations because the same parsing configuration can be reused. Roles control permissions, Streams track changes, and Tasks automate SQL execution. Therefore, File Format is the correct object for reusable CSV interpretation rules.

Question 299

Which Snowflake capability can be used to examine information about query execution and identify potential performance issues?

1. Query Profile
2. Secure Data Sharing
3. Time Travel
4. Fail-safe

Correct Answer: 1

Explanation:

Query Profile provides detailed information about how a query was executed and can help users understand execution steps and identify potential performance bottlenecks. Reviewing the query profile can help determine where processing time or data movement is occurring and can support optimization decisions. Secure Data Sharing is for controlled data sharing, Time Travel provides historical access, and Fail-safe is associated with recovery. Therefore, Query Profile is the appropriate Snowflake capability for examining query execution behavior and investigating performance issues.

Question 300

Which statement correctly describes the relationship between a Snowflake database and schema?

1. A database exists inside a schema.
2. A schema and database are interchangeable terms.
3. A database contains schemas, and schemas contain database objects.
4. A schema provides compute resources for a database.

Correct Answer: 3

Explanation:

Snowflake uses a hierarchy in which a database contains schemas, and schemas contain objects such as tables, views, stages, and other supported objects. This structure helps organize data and database resources logically. A virtual warehouse supplies compute resources independently of this hierarchy. Therefore, a database does not exist inside a schema, and the two terms are not interchangeable. The correct relationship is that a database contains schemas, while schemas contain the objects used to organize and access data.