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

 

Question 201

Which Snowflake capability allows a user to create a new object based on an existing object without initially duplicating the underlying data?

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

Correct Answer: 4

Explanation:

Zero-copy cloning allows supported Snowflake objects to be cloned without immediately creating a complete physical copy of the underlying data. The clone initially shares the underlying micro-partitions with the source object. When changes occur, Snowflake manages the affected data separately. This capability is particularly useful for development, testing, and temporary environments because users can create copies of large datasets quickly while avoiding the initial storage requirements of a traditional full copy. Time Travel provides historical access, Snowpipe handles data ingestion, and Resource Monitors manage credit consumption.

Question 202

Which Snowflake privilege is generally required to allow a role to access objects within a schema?

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

Correct Answer: 1

Explanation:

The USAGE privilege on a schema allows a role to access objects within that schema, assuming the role also has the necessary privileges on the specific objects. Snowflake access control commonly requires privileges at multiple levels. For example, a role may need USAGE on the database and schema and SELECT on a table before it can successfully query that table. DELETE, INSERT, and UPDATE are data-manipulation privileges rather than the general schema access privilege. Therefore, USAGE is the appropriate privilege in this scenario.

Question 203

Which Snowflake object is used to define reusable rules for interpreting files such as CSV or JSON during data loading?

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

Correct Answer: 2

Explanation:

A File Format object defines how Snowflake should interpret files during loading or unloading operations. Depending on the file type, it can specify settings such as delimiters, compression, quotation characters, null handling, and other relevant properties. File formats can be created as reusable objects and referenced by loading commands such as COPY INTO. Streams track changes to table data, warehouses provide compute resources, and roles manage access permissions. Therefore, a File Format is the correct object for storing reusable file interpretation settings.

Question 204

Which Snowflake feature is used to prevent unnecessary micro-partitions from being scanned during query execution?

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

Correct Answer: 2

Explanation:

Query pruning allows Snowflake to eliminate micro-partitions that are unlikely to contain rows satisfying the query conditions. Snowflake maintains metadata about micro-partitions, and this metadata can help determine which partitions can safely be skipped. Reducing the amount of data scanned can improve query performance and reduce compute requirements. Snowpipe is focused on continuous ingestion, Resource Monitors manage credit usage, and Fail-safe is related to data recovery. Therefore, query pruning is the capability directly associated with avoiding unnecessary micro-partition scans.

Question 205

Which Snowflake feature is used to continuously ingest newly arrived files from supported cloud storage locations?

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

Correct Answer: 1

Explanation:

Snowpipe is designed for continuous or near-continuous ingestion of files into Snowflake. It can detect newly arrived files through supported notification mechanisms and load them into target tables without requiring a user to repeatedly initiate a traditional bulk-loading operation. This makes Snowpipe suitable for event-driven ingestion workflows where data arrives frequently. Materialized Views are designed for query performance, Time Travel provides historical data access, and Row Access Policies control which rows users can see. Therefore, Snowpipe is the correct choice for continuous file ingestion.

Question 206

Which Snowflake feature allows a suspended warehouse to automatically start when a query requires it?

1. Auto-suspend
2. Fail-safe
3. Auto-resume
4. Time Travel

Correct Answer: 3

Explanation:

Auto-resume automatically starts a suspended virtual warehouse when a workload requires compute resources. It is commonly paired with auto-suspend. Auto-suspend stops a warehouse after a configured period of inactivity, while auto-resume brings it back online when needed. This combination can help organizations balance availability and cost management. Fail-safe and Time Travel are related to data recovery and historical access rather than warehouse lifecycle management. Therefore, Auto-resume is the feature that automatically starts a suspended warehouse when a new workload requires it.

Question 207

Which Snowflake data type is most suitable for storing JSON-like objects containing named fields and values?

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

Correct Answer: 2

Explanation:

OBJECT is a Snowflake data type designed to represent key-value structures commonly found in JSON-like data. Each field has a key associated with a value, and objects can be nested within other semi-structured structures. ARRAY is used for ordered collections, DATE stores calendar dates, and BOOLEAN stores true or false values. OBJECT values are often stored within VARIANT columns when working with semi-structured datasets. Therefore, when the data consists of named fields and their corresponding values, OBJECT is the most appropriate choice.

Question 208

Which Snowflake feature is designed to improve performance for supported selective point-lookup queries?

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

Correct Answer: 1

Explanation:

Search Optimization Service is designed to improve performance for certain selective search patterns, including supported point-lookup workloads. It maintains additional search information that can help Snowflake locate relevant records more efficiently. This feature is particularly useful when queries frequently search for a small number of values in large tables. Snowpipe handles continuous ingestion, Fail-safe provides a recovery mechanism, and Resource Monitors help manage credit consumption. Therefore, Search Optimization Service is the feature most directly associated with optimizing supported selective searches.

Question 209

Which command is used to assign an object privilege to a role in Snowflake?

1. PERMIT
2. AUTHORIZE
3. GRANT
4. ALLOW

Correct Answer: 3

Explanation:

GRANT is the standard Snowflake SQL command used to assign privileges to roles. For example, administrators can grant SELECT on a table, USAGE on a schema, or other supported privileges depending on the object and security requirement. Snowflake uses role-based access control, so privileges are commonly granted to roles and those roles are then assigned to users or other roles. PERMIT, AUTHORIZE, and ALLOW are not the standard SQL syntax for granting Snowflake privileges. Therefore, GRANT is the correct answer.

Question 210

Which Snowflake object provides compute resources for executing SQL statements?

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

Correct Answer: 4

Explanation:

A virtual warehouse provides the compute resources Snowflake uses to execute SQL queries and perform data-processing workloads. Warehouses are independent of the storage layer, allowing organizations to scale or configure compute separately from stored data. Databases and schemas organize objects, while stages provide locations for files used in loading and unloading operations. Warehouses can also be suspended, resumed, resized, and configured for concurrency. Therefore, when Snowflake needs compute resources to execute SQL statements, the virtual warehouse is the component responsible for providing them.

Question 211

Which Snowflake feature allows users to query or recover historical data within its configured retention period?

1. Time Travel
2. Snowpipe
3. Search Optimization Service
4. Auto-suspend

Correct Answer: 1

Explanation:

Time Travel allows users to access historical versions of data within the applicable retention period. It can be useful when data has been accidentally modified or deleted and users need to inspect or recover a previous state. The feature supports historical querying and recovery scenarios depending on the object and account configuration. Snowpipe handles continuous data ingestion, Search Optimization Service improves certain selective workloads, and auto-suspend controls warehouse activity. Therefore, Time Travel is the appropriate feature when users need access to a previous state of Snowflake data.

Question 212

Which Snowflake object captures information about changes to table data for incremental processing?

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

Correct Answer: 2

Explanation:

A Stream captures information about changes made to table data and can be used to support incremental processing. Instead of repeatedly processing an entire table, a downstream workflow can use the change information to identify newly inserted, updated, or deleted rows as applicable. Streams are frequently combined with Tasks to automate data pipelines. Stages are associated with files, warehouses provide compute resources, and File Formats define how files are interpreted. Therefore, a Stream is the Snowflake object designed for tracking table changes for downstream processing.

Question 213

Which Snowflake security feature can control which rows are visible to different users?

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

Correct Answer: 2

Explanation:

A Row Access Policy provides fine-grained control over which rows a user can access. The policy can evaluate information such as the user’s role or other conditions and determine whether specific rows should be visible. This allows multiple users to query the same table while receiving different subsets of data according to their access requirements. A Masking Policy primarily protects column values, Resource Monitors manage credit consumption, and File Formats define file interpretation rules. Therefore, Row Access Policy is the appropriate feature for row-level access control.

Question 214

Which Snowflake feature provides a mechanism for recovering data after the Time Travel period under applicable circumstances?

1. Fail-safe
2. Snowpipe
3. Materialized View
4. Auto-resume

Correct Answer: 1

Explanation:

Fail-safe is a separate recovery mechanism that follows the applicable Time Travel period. It is intended primarily for disaster-recovery purposes rather than normal user-driven historical querying. During the Time Travel period, users can perform supported historical access and recovery operations themselves. After that period, Fail-safe may provide additional recovery assistance according to Snowflake’s service behavior. Snowpipe is used for continuous ingestion, Materialized Views support performance optimization, and Auto-resume manages warehouses. Therefore, Fail-safe is the correct feature for post-Time Travel recovery scenarios.

Question 215

Which Snowflake capability can maintain the organization of table data according to a defined clustering key?

1. Time Travel
2. Automatic Clustering
3. Snowpipe
4. Resource Monitor

Correct Answer: 2

Explanation:

Automatic Clustering helps maintain the organization of eligible table data according to a defined clustering key. As data is added or modified, micro-partitions can become less aligned with the desired clustering strategy. Automatic Clustering can perform background maintenance to improve that organization. This can support better pruning for queries that benefit from the selected clustering dimensions. Time Travel provides historical access, Snowpipe supports continuous ingestion, and Resource Monitors manage credit consumption. Therefore, Automatic Clustering is the feature specifically associated with maintaining clustering automatically.

Question 216

Which Snowflake feature allows several compute clusters to support workloads with high concurrency?

1. Time Travel
2. Snowpipe
3. Multi-cluster warehouse
4. Secure Data Sharing

Correct Answer: 3

Explanation:

A multi-cluster warehouse allows Snowflake to use multiple compute clusters to handle workloads with high query concurrency. When many users submit queries simultaneously, additional clusters can provide additional compute capacity and help reduce queuing, depending on the configured scaling policy. This feature is especially useful for workloads where concurrency is a major challenge. Time Travel handles historical data, Snowpipe supports continuous ingestion, and Secure Data Sharing enables controlled data sharing. Therefore, a multi-cluster warehouse is the appropriate solution for increasing compute capacity for concurrent workloads.

Question 217

Which Snowflake object provides a logical representation of data based on a SQL query without being a traditional physical copy of the underlying table data?

1. View
2. Stage
3. Warehouse
4. Resource Monitor

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 only selected columns, and provide an abstraction layer over underlying tables. Unlike a traditional physical copy, a standard view does not independently store a full copy of the underlying table data. A stage is associated with files, a warehouse provides compute, and a Resource Monitor manages credit usage. Therefore, a View is the correct Snowflake object when the requirement is to provide a logical query-based representation of data.

Question 218

Which Snowflake function can transform nested arrays or objects into a set of rows?

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

Correct Answer: 3

Explanation:

The FLATTEN table function is commonly used to expand nested semi-structured data into rows. It is particularly useful for processing arrays and nested objects stored in VARIANT values. By converting nested structures into a row-oriented representation, FLATTEN makes it easier to analyze and join 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 to VARIANT. Therefore, FLATTEN is the appropriate function for expanding nested arrays or objects into rows.

Question 219

Which Snowflake feature is used to automate the execution of SQL statements according to a schedule or dependency?

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

Correct Answer: 2

Explanation:

A Task can automatically execute SQL statements or supported procedures according to a defined schedule or dependency. Tasks can be organized into task graphs, allowing complex data-processing workflows to execute in a controlled sequence. They are commonly used for recurring transformations, maintenance operations, and automated pipelines. Streams can provide change information for such workflows, while stages and file formats support file-based data loading. Therefore, the Snowflake Task object is the appropriate feature for automatically executing SQL-based processing according to schedules or dependencies.

Question 220

Which Snowflake architecture principle allows multiple virtual warehouses to access the same stored data independently?

1. Storage and compute separation
2. File format inheritance
3. Role hierarchy
4. Stage replication

Correct Answer: 1

Explanation:

Snowflake separates storage from compute, allowing multiple virtual warehouses to work with the same underlying stored data. This architecture means that compute resources can be independently created, resized, suspended, or assigned to different workloads without requiring separate copies of the data for each warehouse. It also enables organizations to isolate workloads by using different warehouses while maintaining centralized storage. File formats describe file structures, role hierarchy controls privilege inheritance, and stage replication is not the principle responsible for this behavior. Therefore, storage and compute separation is the correct answer.