View Full Snowflake SnowPro Core COF-C03 Exam Dumps and Practice Test Dumps.

 

Question 201

Which Snowflake feature provides metadata about databases, schemas, tables, columns, and other database objects?

1. Information Schema
2. Time Travel
3. Resource Monitor
4. Query Profile

Correct Answer: 1

Explanation

Information Schema provides metadata about objects within a Snowflake database. It includes views that expose information about databases, schemas, tables, columns, views, privileges, and other supported objects. Users can query this metadata using SQL to discover object definitions, inspect database structures, and build administrative reports. Information Schema is different from Query Profile, which focuses on the execution of a particular query. It is also different from Account Usage, which provides broader historical account-level metadata. Understanding metadata sources is important for administration, auditing, troubleshooting, and automated database management tasks.

Question 202

Which Snowflake metadata source is designed to provide historical account-level usage information?

1. Information Schema
2. Account Usage
3. Query Profile
4. Stage

Correct Answer: 2

Explanation

Account Usage provides historical metadata and usage information for an entire Snowflake account. It contains views that can be used to analyze areas such as query activity, storage, warehouses, users, roles, and other account-level activity. Account Usage is especially useful for reporting and long-term analysis because it provides historical information beyond the immediate object-discovery needs of Information Schema. Information Schema is generally focused on metadata within the relevant database context. Choosing the appropriate metadata source depends on whether the requirement involves object information or broader historical account-level usage analysis.

Question 203

Which Snowflake metadata source is generally more suitable for retrieving recent object metadata with low latency?

1. Account Usage
2. Query Profile
3. Information Schema
4. Resource Monitor

Correct Answer: 3

Explanation

Information Schema is generally useful when users need current or near-current metadata about objects within a database. It provides SQL-accessible views for information such as tables, columns, schemas, views, and privileges. Account Usage provides broader historical information but may have latency before recently generated metadata becomes available. Therefore, the choice depends on the requirement. Information Schema is particularly useful for administrative queries that need current object details, while Account Usage is often more appropriate for historical reporting, usage analysis, and account-wide monitoring.

Question 204

Which Snowflake feature provides detailed information about the execution steps of a specific query?

1. Query Profile
2. Account Usage
3. Information Schema
4. Resource Monitor

Correct Answer: 1

Explanation

Query Profile provides detailed information about how an individual query was executed. It displays execution operators and processing steps that can help users understand activities such as scans, joins, aggregations, and data movement. This makes it useful for diagnosing query performance and identifying operations that consume significant processing resources. Information Schema and Account Usage focus primarily on metadata rather than detailed execution plans. Resource Monitor addresses credit consumption controls. Query Profile is therefore the appropriate feature when the goal is to investigate the internal execution behavior of a particular SQL statement.

Question 205

Which Snowflake capability can automatically adjust compute resources by adding clusters when concurrency increases?

1. Auto-suspend
2. Multi-cluster warehouse
3. Time Travel
4. Materialized view

Correct Answer: 2

Explanation

A multi-cluster warehouse can provide additional compute clusters when workload concurrency increases, subject to its configured minimum and maximum cluster counts and scaling policy. This helps Snowflake handle multiple concurrent queries without relying solely on increasing the size of a single cluster. The feature is especially useful for workloads where many users or applications submit queries at the same time. Auto-suspend addresses inactive warehouse shutdown, while Time Travel handles historical data access. Materialized views are designed for specific query-performance scenarios and do not provide dynamic compute scaling.

Question 206

Which warehouse scaling approach increases the compute capacity of an individual cluster rather than adding more clusters?

1. Scaling up
2. Scaling out
3. Auto-resume
4. Auto-suspend

Correct Answer: 1

Explanation

Scaling up means increasing the size of the virtual warehouse, which provides more compute resources within each cluster. For example, moving from a smaller warehouse size to a larger size increases the resources available to queries running on that cluster. Scaling out is different because it increases the number of clusters in a multi-cluster warehouse. Auto-resume and auto-suspend manage warehouse lifecycle rather than compute capacity. Understanding the difference between scaling up and scaling out helps organizations select a compute strategy based on query complexity, resource requirements, and concurrency.

Question 207

Which Snowflake scaling approach primarily addresses a workload with many concurrent queries?

1. Scaling up
2. Scaling out with multiple clusters
3. Increasing Time Travel retention
4. Increasing result-cache size

Correct Answer: 2

Explanation

Scaling out with multiple clusters is designed to address concurrency by allowing Snowflake to provide additional compute clusters as workload demand increases. This can reduce queuing when many independent queries arrive at the same time. Scaling up increases the resources available within a cluster and can help individual queries that require more compute, but it does not directly provide the same concurrency-oriented capacity as multiple clusters. Time Travel and result caching address data recovery and query-result reuse respectively. Selecting the correct scaling method depends on whether the main problem is query complexity or concurrent workload demand.

Question 208

Which Snowflake setting can help prevent a warehouse from remaining active when it has no workload?

1. AUTO_SUSPEND
2. AUTO_RESUME
3. QUERY_TAG
4. SCALING_POLICY

Correct Answer: 1

Explanation

AUTO_SUSPEND allows a virtual warehouse to automatically suspend after remaining inactive for the configured period. Suspending a warehouse stops its compute resources, helping avoid unnecessary consumption when no workload is running. The setting is commonly combined with AUTO_RESUME so that a warehouse can stop during idle periods and start again automatically when needed. QUERY_TAG identifies queries, while SCALING_POLICY controls behavior for multi-cluster scaling. AUTO_SUSPEND therefore focuses specifically on managing warehouse activity during periods of inactivity and can be an important part of compute cost management.

Question 209

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

1. AUTO_SUSPEND
2. AUTO_RESUME
3. MIN_CLUSTER_COUNT
4. RESOURCE_MONITOR

Correct Answer: 2

Explanation

AUTO_RESUME enables a suspended virtual warehouse to start automatically when an operation requires its compute resources. This removes the need for users to manually resume the warehouse before running queries in many common workflows. AUTO_SUSPEND performs the opposite function by stopping an inactive warehouse after the configured period. MIN_CLUSTER_COUNT determines the minimum number of clusters in a multi-cluster warehouse, while Resource Monitor helps monitor and control credit consumption. Together, AUTO_RESUME and AUTO_SUSPEND can help balance convenience, availability, and compute-cost management.

Question 210

Which Snowflake feature can stop or notify users when configured credit thresholds are reached?

1. Query Profile
2. Resource Monitor
3. Search Optimization
4. Stream

Correct Answer: 2

Explanation

A Resource Monitor can monitor credit consumption and take configured actions when specified thresholds are reached. Depending on its configuration and supported behavior, it can generate notifications or suspend warehouses associated with the monitor when usage limits are exceeded. This makes Resource Monitor useful for managing compute consumption and preventing unexpected resource usage. Query Profile investigates individual query execution, Search Optimization improves certain selective access patterns, and Stream records data changes. Resource Monitor therefore addresses account or warehouse consumption management rather than query execution analysis or data transformation.

Question 211

Which Snowflake feature is designed to improve performance for queries that repeatedly search for a small number of rows in large tables?

1. Search Optimization Service
2. Resource Monitor
3. Secure Data Sharing
4. Snowpipe

Correct Answer: 1

Explanation

Search Optimization Service is designed to improve performance for supported selective search patterns, particularly when queries need to locate a relatively small subset of rows within large tables. It maintains additional search access structures that can help Snowflake identify relevant data more efficiently. This is different from result caching, which may reuse an already generated result when eligible conditions are met. Search Optimization is therefore useful when queries need to repeatedly perform selective lookups against large datasets. Its effectiveness depends on the workload and the supported search predicates.

Question 212

Which Snowflake feature can improve the performance of suitable queries by organizing table data around selected columns?

1. Snowpipe
2. Clustering
3. Data Sharing
4. Masking Policy

Correct Answer: 2

Explanation

Clustering helps organize table data according to selected columns, known as clustering keys when explicitly defined. Better organization can improve micro-partition pruning for queries that filter on those columns, reducing the amount of data that needs to be scanned. Clustering is most relevant for large tables and recurring query patterns where data organization can materially affect performance. Snowpipe handles continuous file ingestion, Data Sharing controls access to shared information, and masking policies protect sensitive column values. Clustering therefore addresses physical data organization and query performance rather than ingestion or security.

Question 213

Which Snowflake optimization mechanism allows the engine to skip micro-partitions that cannot contain rows matching a query filter?

1. Result caching
2. Micro-partition pruning
3. Data masking
4. Task scheduling

Correct Answer: 2

Explanation

Micro-partition pruning allows Snowflake to eliminate micro-partitions that are unlikely to contain rows satisfying a query’s filtering conditions. Snowflake maintains metadata about micro-partitions, and this metadata can help determine which partitions need to be scanned. When effective pruning occurs, the query can process less data and potentially complete more efficiently. Clustering can improve the effectiveness of pruning for suitable workloads by organizing related values together. Result caching works differently because it reuses eligible previous query results instead of reducing the amount of source data scanned during a new execution.

Question 214

Which Snowflake concept refers to the automatic division of table data into smaller storage units?

1. Micro-partitioning
2. Manual partitioning
3. File partitioning
4. Row grouping

Correct Answer: 1

Explanation

Snowflake automatically divides table data into micro-partitions as data is loaded. Users do not normally define traditional physical partitions in the same manner used by some other database systems. Each micro-partition contains a group of rows and associated metadata that Snowflake can use for storage management and query optimization. This automatic organization supports features such as micro-partition pruning. Clustering can influence how data is organized over time but does not replace Snowflake’s underlying micro-partition architecture. Understanding micro-partitions is fundamental to understanding Snowflake storage and query-performance behavior.

Question 215

Which Snowflake feature allows multiple accounts to access shared data while keeping the provider’s underlying data in place?

1. Secure Data Sharing
2. Temporary tables
3. Materialized views
4. Time Travel

Correct Answer: 1

Explanation

Secure Data Sharing allows a Snowflake provider to share selected objects with another Snowflake account without requiring a traditional physical copy of the underlying data. The provider determines which objects are included and controls the sharing arrangement. Consumers can access the shared information through the appropriate shared database. This capability supports collaboration between organizations, departments, and business partners while reducing unnecessary data duplication. It is distinct from zero-copy cloning because cloning creates a new Snowflake object environment, whereas Secure Data Sharing is primarily designed to provide controlled access to provider-managed data.

Question 216

Which Snowflake authentication method uses a public-private key pair instead of a password for supported connections?

1. OAuth
2. Key-pair authentication
3. Username-only authentication
4. Anonymous authentication

Correct Answer: 2

Explanation

Key-pair authentication uses a cryptographic public-private key pair to authenticate a user or service to Snowflake. The private key is securely retained by the client, while the corresponding public key is registered appropriately for authentication. This method is commonly useful for automated processes, applications, and service accounts because it avoids relying on a traditional password. Proper private-key protection remains essential because possession of the private credential can affect authentication security. Key-pair authentication is one of several authentication approaches available in Snowflake environments.

Question 217

Which Snowflake access-control principle recommends granting users only the privileges necessary for their responsibilities?

1. Maximum access
2. Shared ownership
3. Least privilege
4. Universal authorization

Correct Answer: 3

Explanation

The principle of least privilege means users and roles should receive only the permissions required to perform their legitimate responsibilities. In Snowflake, this principle can be implemented through role-based access control, role hierarchies, object privileges, and carefully designed security policies. Granting excessive privileges increases the potential impact of accidental or unauthorized actions. Least privilege does not mean denying all access; instead, it seeks to provide appropriate access while minimizing unnecessary permissions. This principle is particularly important when designing roles for analysts, developers, administrators, applications, and service accounts.

Question 218

Which privilege generally allows a role to access objects within a Snowflake schema?

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

Correct Answer: 1

Explanation

USAGE on a schema generally allows a role to access objects within that schema when combined with the appropriate privileges on the objects themselves. For example, a role may need USAGE on the database and schema in addition to SELECT on a table to query that table. USAGE does not by itself grant permission to read table rows. SELECT provides the ability to query table data, while INSERT and UPDATE control specific data modifications. Understanding these privilege layers is important when troubleshooting authorization errors and implementing least-privilege access.

Question 219

Which privilege is generally required to query rows from a Snowflake table?

1. INSERT
2. SELECT
3. DELETE
4. OWNERSHIP

Correct Answer: 2

Explanation

SELECT is the privilege that allows a role to query data from a Snowflake table or compatible object. In addition to SELECT on the table, the role generally needs the necessary USAGE privileges on the containing database and schema. INSERT allows rows to be added, DELETE removes rows, and OWNERSHIP provides a broader level of control over an object. Understanding the difference between object-level privileges and container-level USAGE privileges is essential for configuring access correctly. A user may therefore have access to a schema but still be unable to query a table without SELECT.

Question 220

Which role is designed to provide broad account-level administrative capabilities in Snowflake?

1. SYSADMIN
2. SECURITYADMIN
3. USERADMIN
4. ACCOUNTADMIN

Correct Answer: 4

Explanation

ACCOUNTADMIN is Snowflake’s highest-level system-defined administrative role and is intended for broad account-level administration. It has extensive capabilities that span areas such as account management, security, billing-related administration, and other high-level operations. Because of its broad authority, organizations should avoid using ACCOUNTADMIN for routine tasks when a more narrowly scoped role is sufficient. SYSADMIN generally focuses on managing databases, schemas, warehouses, and related objects, while SECURITYADMIN focuses heavily on security privileges and grants. Understanding Snowflake’s system-defined role hierarchy supports safer administrative practices.