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

 

Question 141

Which Snowflake capability allows a warehouse to automatically restart when a query is submitted after the warehouse has been suspended?

1. Time Travel
2. Resource Monitor
3. Snowpipe
4. Auto-resume

Correct Answer: 4

Explanation:

Auto-resume allows a suspended virtual warehouse to start automatically when a workload requires compute resources. This is particularly useful when combined with auto-suspend. A warehouse can suspend after a period of inactivity to reduce unnecessary credit consumption and then resume automatically when a new query or eligible operation requires it. Time Travel is used for historical data access, Resource Monitors help manage credit consumption, and Snowpipe handles continuous data ingestion. Auto-resume therefore improves convenience and availability while allowing organizations to use warehouse suspension for cost control.

Question 142

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

1. Schema
2. Warehouse
3. Resource Monitor
4. Role

Correct Answer: 1

Explanation:

A schema is a logical container within a Snowflake database that organizes objects such as tables, views, stages, file formats, and other supported objects. The database and schema hierarchy helps administrators structure data in a manageable way. A virtual warehouse provides compute resources rather than organizing objects. Resource Monitors are used for credit management, while roles are primarily associated with access control. Understanding the database and schema hierarchy is important when referencing objects and managing permissions in Snowflake environments.

Question 143

Which Snowflake data type is commonly used to store semi-structured data such as JSON?

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

Correct Answer: 3

Explanation:

VARIANT is a Snowflake data type designed to store semi-structured data, including JSON, Avro, ORC, and Parquet data. It allows different structures and data types to be represented within a single column. Snowflake provides functions and operators that allow users to query and manipulate information stored in VARIANT values. VARCHAR is primarily used for character strings, NUMBER stores numeric values, and DATE represents calendar dates. VARIANT is therefore particularly useful when working with flexible or nested data structures that do not fit neatly into traditional relational columns.

Question 144

Which Snowflake command is commonly used to remove a table from a schema?

1. REMOVE TABLE
2. DROP TABLE
3. DELETE OBJECT
4. CLEAR TABLE

Correct Answer: 2

Explanation:

DROP TABLE is the standard SQL command used to remove a table from a Snowflake schema. Dropping a table removes the table object and its current data representation, although Snowflake recovery capabilities such as Time Travel may provide access to historical versions depending on the circumstances and retention settings. DELETE TABLE is not the standard syntax; DELETE is instead used to remove rows from a table. REMOVE TABLE and CLEAR TABLE are not standard Snowflake commands for deleting a table object. Therefore, DROP TABLE is the correct command.

Question 145

Which Snowflake data type can represent an ordered collection of values within semi-structured data?

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

Correct Answer: 1

Explanation:

ARRAY is a Snowflake data type used to represent an ordered collection of values. It is particularly useful when working with semi-structured data where a field can contain multiple elements. OBJECT represents key-value pairs, while BOOLEAN stores true or false values and DATE stores calendar dates. Snowflake supports working with ARRAY values through SQL functions and operators, making it possible to access individual elements and process nested data. ARRAY is therefore the appropriate type when the semi-structured structure contains an ordered list of values.

Question 146

Which Snowflake feature can distribute concurrent queries across multiple clusters within a multi-cluster warehouse?

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

Correct Answer: 4

Explanation:

Multi-cluster warehouses can add or remove compute clusters according to workload demand and configured scaling policies. This capability is especially useful when many users or queries compete for warehouse resources at the same time. Instead of relying only on a larger single cluster, Snowflake can use multiple clusters to improve concurrency handling. Time Travel provides historical access, Snowpipe supports continuous ingestion, and Resource Monitors manage credit consumption. Multi-cluster warehouses therefore address concurrency and workload scaling rather than historical data, ingestion, or credit monitoring.

Question 147

Which Snowflake feature helps identify which micro-partitions can be skipped during query execution?

1. Resource Monitor
2. Micro-partition metadata
3. Snowpipe
4. Secure Data Sharing

Correct Answer: 2

Explanation:

Snowflake stores metadata about micro-partitions, including information that can help determine whether a micro-partition may contain relevant values for a query. During query processing, Snowflake can use this metadata to eliminate unnecessary micro-partitions from scanning. This process, commonly referred to as pruning, can reduce the amount of data that must be examined and improve query performance. Resource Monitors deal with credit usage, Snowpipe handles ingestion, and Secure Data Sharing handles controlled data access. Micro-partition metadata is therefore an important component of Snowflake’s query optimization architecture.

Question 148

Which Snowflake function is commonly used to expand elements of an ARRAY or fields of nested semi-structured data into rows?

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

Correct Answer: 3

Explanation:

The FLATTEN table function is used to expand semi-structured data into a relational representation. It can be particularly useful for processing arrays and nested objects stored in VARIANT columns. FLATTEN produces rows that can be joined or queried as part of SQL statements, making it easier to analyze nested JSON and similar data structures. PARSE_JSON converts JSON text into a semi-structured value, GET accesses specific elements, and TO_VARIANT converts values into VARIANT. FLATTEN is therefore the appropriate choice for expanding nested collections into rows.

Question 149

Which Snowflake service is specifically intended to improve performance for supported point-lookups and other selective search patterns?

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

Correct Answer: 2

Explanation:

Search Optimization Service is designed to improve performance for certain selective search patterns, including supported point-lookup workloads. It maintains additional search access information that can help Snowflake locate relevant data more efficiently without scanning as much unnecessary data. It is most useful when query patterns and table characteristics justify the additional service. Snowpipe is designed for continuous ingestion, Time Travel provides historical access, and Resource Monitors manage credit consumption. Search Optimization Service is therefore the feature most directly associated with optimizing supported highly selective searches.

Question 150

Which Snowflake object provides the compute resources needed to execute SQL queries?

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

Correct Answer: 4

Explanation:

A virtual warehouse provides the compute resources used to execute SQL queries and perform data-processing operations in Snowflake. Warehouses are independent from the storage layer, which means organizations can resize or configure compute resources without restructuring the stored data. Databases and schemas organize objects, while stages provide locations for files involved in loading and unloading. Warehouses can also be suspended, resumed, resized, and configured for concurrency. Therefore, when a Snowflake workload requires processing power, the virtual warehouse is the primary compute resource involved.

Question 151

Which Snowflake role concept allows privileges granted to one role to be inherited by another role?

1. Role hierarchy
2. Time Travel
3. Search Optimization
4. Stage inheritance

Correct Answer: 1

Explanation:

Snowflake supports role hierarchies in which one role can be granted to another role. The higher-level role can inherit the privileges associated with the lower-level role, helping organizations build structured access-control models. This approach can reduce the need to grant individual privileges repeatedly and can make administration easier. Time Travel is a data-history feature, Search Optimization Service addresses query performance, and stages are used for file handling. Role hierarchy is therefore the concept that supports inheritance of privileges between roles.

Question 152

Which Snowflake feature is used to automatically execute SQL statements or stored procedures according to a defined schedule or dependency?

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

Correct Answer: 3

Explanation:

Snowflake Tasks are used to execute SQL statements or supported procedures automatically. A task can be scheduled to run at specified intervals or can participate in task graphs where execution depends on other tasks. This makes Tasks useful for automating recurring transformations, maintenance operations, and data-processing workflows. Time Travel provides historical access, Resource Monitors manage credit consumption, and Secure Data Sharing enables controlled data sharing. Tasks therefore provide an important mechanism for automating database operations without requiring a user to manually execute each operation.

Question 153

Which Snowflake object records information about changes made to table data for downstream processing?

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

Correct Answer: 3

Explanation:

A Snowflake Stream records information about changes to table data, allowing downstream processes to identify changed rows. Streams are commonly used with Tasks to create automated data pipelines and incremental processing workflows. Instead of repeatedly processing an entire table, downstream logic can use change information to process only newly changed data where appropriate. A stage is used for files, a warehouse provides compute, and a Resource Monitor manages credit consumption. Streams are therefore particularly useful when building change-data-processing workflows inside Snowflake.

Question 154

Which Snowflake security feature can dynamically hide sensitive column values from users who do not meet defined conditions?

1. Masking policy
2. Snowpipe
3. Time Travel
4. Resource Monitor

Correct Answer: 1

Explanation:

A masking policy can dynamically protect sensitive column values based on conditions such as the role or context of the user accessing the data. Instead of creating separate copies of the data for different users, Snowflake can apply the policy when the data is queried. This supports centralized data protection and controlled exposure of sensitive information. Snowpipe is used for ingestion, Time Travel provides historical access, and Resource Monitors manage credit usage. Masking policies are therefore an important Snowflake feature for protecting sensitive column-level information.

Question 155

Which Snowflake feature can restrict which rows a user is allowed to see based on defined access rules?

1. Time Travel
2. Resource Monitor
3. Search Optimization Service
4. Row access policy

Correct Answer: 4

Explanation:

A row access policy allows organizations to control which rows are visible to users based on defined security rules. This provides fine-grained access control at the row level and can be useful when different users should see different subsets of the same table. For example, access could be restricted based on role, region, department, or another security attribute. Time Travel handles historical access, Resource Monitors manage credit consumption, and Search Optimization Service improves supported query patterns. Row access policies therefore provide row-level data security.

Question 156

Which Snowflake semi-structured data type stores key-value pairs?

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

Correct Answer: 2

Explanation:

OBJECT is a Snowflake data type used to represent key-value pairs within semi-structured data. It is commonly encountered when working with JSON-like structures where attributes are associated with named keys. ARRAY, by contrast, represents an ordered collection of values. NUMBER stores numeric values, while BOOLEAN represents true or false values. OBJECT is useful for representing nested structures and can be stored within VARIANT values. Understanding the difference between ARRAY and OBJECT is important when querying and transforming semi-structured data in Snowflake.

Question 157

Which Snowflake capability can provide a precomputed result for frequently executed supported queries to improve performance?

1. Snowpipe
2. Resource Monitor
3. Materialized view
4. Fail-safe

Correct Answer: 3

Explanation:

A materialized view stores precomputed query results so that supported queries can potentially access prepared data rather than repeatedly performing the full underlying computation. This can improve performance for suitable workloads, especially when the same types of aggregations or transformations are queried frequently. Snowflake manages the materialized view and keeps it maintained as underlying data changes. Snowpipe focuses on continuous ingestion, Resource Monitors manage credit usage, and Fail-safe provides recovery capabilities. Materialized views are therefore a performance optimization option for appropriate repeated query patterns.

Question 158

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

1. ASSIGN PRIVILEGE
2. GRANT
3. PERMIT
4. AUTHORIZE

Correct Answer: 2

Explanation:

GRANT is the standard SQL command used in Snowflake to assign privileges on objects to roles. Snowflake uses role-based access control, allowing administrators to grant appropriate permissions to roles and then assign those roles to users or other roles. This approach supports centralized and scalable security administration. Commands such as ASSIGN PRIVILEGE, PERMIT, and AUTHORIZE are not the standard Snowflake syntax for granting object privileges. GRANT is therefore the correct command for assigning permissions such as SELECT or USAGE to a role.

Question 159

Which Snowflake capability is most useful when a workload requires many users to run queries concurrently?

1. Time Travel
2. Snowpipe
3. Multi-cluster warehouse
4. Fail-safe

Correct Answer: 3

Explanation:

A multi-cluster warehouse is designed to help Snowflake handle workloads with high levels of concurrent query activity. Depending on configuration and workload demand, additional clusters can become available to provide more compute capacity for concurrent users and queries. This can help reduce queuing caused by insufficient compute resources. Time Travel is used for historical data, Snowpipe handles continuous ingestion, and Fail-safe provides a recovery mechanism. Multi-cluster warehouses are therefore particularly useful when concurrency, rather than only individual query complexity, is the primary workload challenge.

Question 160

Which Snowflake hierarchy correctly represents the relationship between a database and its schemas?

1. A database contains schemas, and schemas contain database objects
2. A schema contains databases, and databases contain warehouses
3. A warehouse contains databases, and databases contain schemas
4. A role contains databases, and databases contain warehouses

Correct Answer: 1

Explanation:

In Snowflake, a database contains schemas, and schemas contain objects such as tables, views, stages, and other supported objects. This hierarchy provides logical organization for data and database objects. Virtual warehouses are compute resources and are separate from this object hierarchy. Roles are security objects used to control access rather than containers for databases. Understanding the database-to-schema relationship is important when creating objects, referencing them with fully qualified names, and managing privileges. Therefore, the correct hierarchy is that a database contains schemas, which in turn contain database objects.