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

 

Question 341

Which Snowflake object is used to store and organize data in rows and columns?

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

Correct Answer: 2

Explanation:

A table is the primary Snowflake object used to store structured data in rows and columns. Tables can contain columns with different supported data types and can be queried using SQL. Stages serve as locations for files used in loading and unloading, Tasks automate SQL execution, and Streams track changes to supported tables. Tables are stored within schemas, which themselves belong to databases. Understanding the distinction between tables and other Snowflake objects is essential when designing data solutions. Therefore, Table is the correct answer because it directly stores structured tabular data.

Question 342

Which Snowflake feature can help maintain data organization according to a defined clustering key as table data changes?

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

Correct Answer: 1

Explanation:

Automatic Clustering helps maintain the organization of eligible table data according to a defined clustering key as data changes over time. Maintaining appropriate clustering can help Snowflake efficiently prune micro-partitions for supported query patterns. Without appropriate maintenance, the relationship between the physical organization of data and the clustering key can become less effective as new data is added or existing data changes. Time Travel provides historical access, Snowpipe supports continuous file ingestion, and Resource Monitors track credit consumption. Therefore, Automatic Clustering is the correct feature for automated clustering maintenance.

Question 343

Which Snowflake data type is most appropriate for storing a collection of key-value attributes in a semi-structured structure?

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

Correct Answer: 2

Explanation:

The OBJECT data type is designed to represent key-value pairs in Snowflake’s semi-structured data model. It is useful for representing structures similar to JSON objects, where each named key corresponds to a value. ARRAY is designed for ordered collections, while DATE stores calendar dates and NUMBER stores numeric values. Snowflake also supports VARIANT, which can hold flexible semi-structured values and may contain objects or arrays. Choosing the appropriate semi-structured type helps make data easier to query and manipulate. Therefore, OBJECT is the correct answer for key-value attributes.

Question 344

Which Snowflake command can be used to remove an existing table object?

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

Correct Answer: 3

Explanation:

DROP TABLE removes the table object from the database. This is different from DELETE, which removes rows from a table while leaving the table structure available. Dropping a table is an object-level operation and can have important consequences, so appropriate privileges and recovery considerations should be evaluated before performing it. Snowflake’s Time Travel capabilities may provide recovery options depending on the circumstances and retention configuration. DELETE TABLE, REMOVE TABLE, and CLEAR TABLE are not the standard Snowflake commands for dropping a table. Therefore, DROP TABLE is correct.

Question 345

Which Snowflake feature allows a table to be copied for development without initially creating a complete physical duplicate of the source data?

1. Secure Data Sharing
2. Zero-copy cloning
3. Snowpipe
4. Query pruning

Correct Answer: 2

Explanation:

Zero-copy cloning enables supported Snowflake objects to be cloned without initially duplicating all of the underlying micro-partitions. The source and clone can initially share the same underlying storage, while subsequent changes cause the relevant data to diverge. This makes zero-copy cloning particularly useful for development, testing, troubleshooting, and creating temporary environments. Secure Data Sharing is intended for controlled data sharing between accounts, Snowpipe handles file ingestion, and Query Pruning reduces unnecessary data scanning. Therefore, zero-copy cloning is the appropriate feature for creating a development copy efficiently.

Question 346

Which privilege would normally be required on a schema for a role to access objects within that schema?

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

Correct Answer: 1

Explanation:

USAGE on a schema is generally required for a role to access objects within that schema, along with the appropriate privileges on the target objects. Snowflake’s privilege hierarchy means that having a privilege such as SELECT on a table does not by itself necessarily provide all required access through the parent database and schema. DELETE, INSERT, and UPDATE are table-related data manipulation privileges rather than the standard schema access privilege. Proper privilege management through roles helps administrators enforce least-privilege access. Therefore, USAGE is the correct privilege for schema access.

Question 347

Which Snowflake capability is intended to continuously ingest new files into tables as they become available?

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

Correct Answer: 2

Explanation:

Snowpipe is designed for continuous or near-continuous ingestion of files into Snowflake. It can automatically process newly arrived files through supported event-driven or ingestion mechanisms, reducing the need for users to repeatedly execute manual bulk-loading commands. This makes Snowpipe suitable for workloads where data arrives continuously or frequently. Materialized Views maintain precomputed results, Time Travel provides historical data access, and Row Access Policies control which rows users can see. Therefore, Snowpipe is the appropriate Snowflake capability for ongoing file ingestion.

Question 348

Which Snowflake feature can restrict account access based on approved IP addresses or network locations?

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

Correct Answer: 2

Explanation:

A Network Policy can restrict access to a Snowflake account according to defined network rules, such as allowed or blocked IP addresses. This can help organizations limit account access to approved corporate networks, trusted locations, or other defined network ranges. Network Policies operate at the access-control level rather than controlling individual table rows or column values. Masking Policies protect sensitive column values, Row Access Policies control row visibility, and Resource Monitors track credit usage. Therefore, Network Policy is the correct feature for restricting account access based on network information.

Question 349

Which Snowflake feature allows users to inspect the operations performed during execution of a query?

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

Correct Answer: 1

Explanation:

Query Profile provides detailed information about the execution of a query and helps users understand how Snowflake processed the request. It can show execution steps and information that may help identify expensive operations, large scans, joins, or other performance considerations. Resource Monitors focus on credit consumption, Network Policies manage network access, and File Formats control how staged files are interpreted. Query Profile is therefore an important diagnostic tool when investigating query performance and understanding the behavior of SQL workloads. Thus, Query Profile is the correct answer.

Question 350

Which Snowflake feature is designed to maintain precomputed results for supported query definitions?

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

Correct Answer: 2

Explanation:

A Materialized View maintains precomputed results for supported query definitions so that eligible queries can benefit from previously computed data. This can improve performance for suitable workloads, especially when the underlying query is expensive and the materialized result can be reused. A Standard View is primarily a logical SQL definition and does not maintain a complete independent result set in the same manner. A Stage stores or references files, while a Stream records table changes. Therefore, Materialized View is the correct Snowflake object for maintaining precomputed query results.

Question 351

Which command is used to assign a Snowflake privilege to a role?

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

Correct Answer: 1

Explanation:

The GRANT command is used to assign privileges or roles within Snowflake’s access-control framework. For example, administrators can grant SELECT on a table or USAGE on a database or schema to an appropriate role. Roles can then be assigned to users according to organizational requirements. COPY is used for data loading or unloading, MERGE performs conditional data modification, and PUT transfers local files to an internal stage. Proper use of GRANT is central to implementing role-based access control and least-privilege security. Therefore, GRANT is the correct answer.

Question 352

Which Snowflake object is used to automate SQL execution based on a schedule or dependency chain?

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

Correct Answer: 2

Explanation:

A Task automates the execution of SQL statements or supported procedures according to schedules or dependencies. Tasks can be connected into task graphs, allowing multiple processing steps to execute in a defined order. They are often combined with Streams to create incremental data-processing pipelines where only changed data is processed. Streams track changes but do not themselves schedule execution. Stages provide file locations, while File Formats define how files are parsed. Therefore, Task is the appropriate object for automating SQL execution through scheduled or dependent workflows.

Question 353

Which Snowflake data type can store flexible values including strings, numbers, arrays, and objects in semi-structured form?

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

Correct Answer: 3

Explanation:

VARIANT is designed to store flexible semi-structured data and can contain different underlying value types, including strings, numbers, arrays, and objects. It is commonly used when source data has a dynamic or nested structure, such as JSON. Snowflake provides functions and syntax for accessing elements within VARIANT values, and FLATTEN can be used to expand nested arrays or objects for processing. DATE, BOOLEAN, and NUMBER are more specialized structured data types. Therefore, VARIANT is the correct answer for flexible semi-structured values.

Question 354

Which Snowflake feature is intended to control how a sensitive column’s value is displayed to different users?

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

Correct Answer: 2

Explanation:

A Masking Policy controls how values in a sensitive column are presented to users. Depending on the conditions defined by the policy, authorized users may see the original value while other users receive a masked or transformed representation. This is useful for protecting sensitive information while still allowing broader access to the underlying table. A Row Access Policy controls visibility of rows, a Network Policy controls network-based account access, and a Resource Monitor tracks credit usage. Therefore, Masking Policy is the correct feature for protecting column values.

Question 355

Which Snowflake feature is most directly associated with monitoring and managing warehouse credit consumption?

1. Resource Monitor
2. Time Travel
3. Stream
4. Stage

Correct Answer: 1

Explanation:

Resource Monitors are designed to monitor credit usage and can be configured with thresholds and supported actions. They are useful for cost governance because administrators can track consumption and receive notifications or trigger configured behavior when usage approaches specified limits. Time Travel manages historical data, Streams record changes to tables, and Stages provide locations for files. Resource Monitors do not directly optimize query execution or manage table permissions. Their primary purpose is usage and credit monitoring. Therefore, Resource Monitor is the correct answer for managing warehouse credit consumption.

Question 356

Which Snowflake feature helps identify changed rows so that only incremental data can be processed by a downstream task?

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

Correct Answer: 2

Explanation:

A Stream captures change information for supported source tables and can be used by downstream processing to identify newly inserted, updated, or deleted data. When combined with Tasks, Streams can support incremental processing pipelines that avoid repeatedly processing an entire table. A standard View provides a logical query definition, while a Materialized View maintains precomputed results for supported queries. A File Format controls file parsing during loading and unloading. Therefore, Stream is the correct Snowflake object for identifying changes for incremental processing.

Question 357

Which Snowflake setting helps automatically restart a warehouse when a query is submitted while the warehouse is suspended?

1. AUTO_SUSPEND
2. AUTO_RESUME
3. MAX_CLUSTER_COUNT
4. DATA_RETENTION_TIME_IN_DAYS

Correct Answer: 2

Explanation:

AUTO_RESUME controls whether a suspended virtual warehouse automatically starts when work requires compute resources. This can provide a smoother user experience because users do not need to manually resume the warehouse before executing workloads. AUTO_SUSPEND instead controls when an inactive warehouse should stop. MAX_CLUSTER_COUNT is associated with multi-cluster warehouse configuration, while DATA_RETENTION_TIME_IN_DAYS relates to data retention rather than warehouse lifecycle. Therefore, AUTO_RESUME is the correct setting for automatically restarting a suspended warehouse when a query requires compute.

Question 358

Which Snowflake feature allows multiple compute clusters to support concurrent workloads on a multi-cluster warehouse?

1. Time Travel
2. Multi-cluster Warehouses
3. Search Optimization Service
4. Secure Data Sharing

Correct Answer: 2

Explanation:

Multi-cluster Warehouses allow Snowflake to use multiple compute clusters within a warehouse to handle concurrency. When many queries or users compete for the same warehouse resources, additional clusters can help distribute workloads and reduce queuing under appropriate configurations. This capability is primarily designed to address concurrency rather than simply making one individual query execute faster. Time Travel handles historical data access, Search Optimization Service targets supported selective search patterns, and Secure Data Sharing enables controlled data sharing. Therefore, Multi-cluster Warehouses are the correct answer for improving concurrency handling.

Question 359

Which Snowflake function is commonly used to expand elements from an ARRAY or nested semi-structured value into separate rows?

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

Correct Answer: 2

Explanation:

FLATTEN is a table function used to expand elements of semi-structured data such as arrays or nested objects into separate rows. It is particularly useful when working with JSON stored in VARIANT columns and when individual nested elements need to be queried or transformed. PARSE_JSON converts JSON text into a semi-structured value, while COUNT performs aggregation and COALESCE returns the first non-null expression among its arguments. Therefore, FLATTEN is the appropriate function when the goal is to expand nested semi-structured elements into rows.

Question 360

Which Snowflake architectural characteristic allows multiple virtual warehouses to access the same underlying data?

1. Separation of storage and compute
2. Mandatory data duplication
3. Schema isolation
4. File format inheritance

Correct Answer: 1

Explanation:

Snowflake separates storage from compute, allowing multiple virtual warehouses to access the same underlying stored data. Each warehouse provides its own compute resources, so different workloads can operate independently without requiring separate copies of the data for every warehouse. This architecture supports workload isolation, flexible scaling, and efficient resource management. Mandatory data duplication is not required, schema isolation does not provide this compute architecture, and file format inheritance is unrelated to compute resources. Therefore, separation of storage and compute is the architectural characteristic that enables multiple warehouses to access shared data.