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

 

Question 361

Which Snowflake feature allows users to query data stored in files using SQL without first loading that data into an internal table?

1. External table
2. Temporary table
3. Materialized view
4. Sequence

Correct Answer: 1

Explanation

An external table provides a table-like interface to data stored in external cloud storage. Instead of loading the underlying files into Snowflake-managed table storage, Snowflake maintains metadata that describes the external data and allows users to query it through SQL. This approach can be useful when organizations maintain data lakes and want Snowflake to access that information directly. External tables can work with supported file formats and cloud storage locations. They therefore provide a way to integrate externally stored datasets into Snowflake query workflows without conventional table loading.

Question 362

What does the AUTO_REFRESH property of an external table primarily control?

1. Automatic warehouse resizing
2. Automatic metadata refresh for new files
3. Automatic table clustering
4. Automatic user authentication

Correct Answer: 2

Explanation

AUTO_REFRESH controls whether Snowflake can automatically refresh external-table metadata when new or changed files are detected through supported event-notification integrations. Without an appropriate refresh mechanism, metadata may not immediately reflect newly added files in the external storage location. Automatic refreshing can reduce the need for users to manually execute metadata refresh operations. The property does not control warehouse sizing, clustering, or authentication. Its purpose is specifically connected with keeping external-table metadata synchronized with changes occurring in the referenced external storage.

Question 363

Which external-table component can expose partition-related information as columns for querying?

1. Partition columns
2. Sequence columns
3. Identity columns
4. Session columns

Correct Answer: 1

Explanation

Partition columns can expose partition-related information from externally stored data so that users can reference that information through SQL queries. Partitioning can organize external data according to values such as dates, regions, or other logical attributes. Making partition information available as columns can help queries apply filters based on those attributes. Identity columns instead generate numeric values, sequence objects produce sequential numbers, and session columns are not an external-table construct. Partition columns are therefore useful when external storage is organized into logical partitions.

Question 364

Which Snowflake object can maintain metadata describing files located in an external cloud storage path?

1. Sequence
2. External table
3. Stored procedure
4. Resource monitor

Correct Answer: 2

Explanation

An external table maintains metadata about files stored in an external location and exposes that information through a table-like SQL interface. The underlying files remain in external cloud storage rather than being copied into Snowflake’s internal table storage. This makes external tables useful for querying data lakes and integrating externally managed datasets into Snowflake workloads. Sequences generate numeric values, stored procedures execute reusable procedural logic, and Resource Monitors manage credit-related thresholds. The external table is therefore the object specifically designed for metadata-based access to externally stored files.

Question 365

Which Snowflake object provides a way to expose the list of files in a stage through SQL metadata?

1. Directory table
2. Sequence
3. Materialized view
4. Row access policy

Correct Answer: 1

Explanation

A directory table provides metadata about files contained in a stage and allows users to query information about those staged files using SQL. Depending on the configuration and supported stage type, the directory table can expose file-related details useful for applications and data pipelines. This is different from a sequence, which generates numeric values, and a materialized view, which maintains query results. A row access policy controls which rows users can see. Directory tables are therefore useful when SQL-accessible file metadata is needed for staged-data workflows.

Question 366

Which stage configuration is intended to connect Snowflake securely to external cloud storage without embedding cloud credentials directly in each stage definition?

1. Storage integration
2. Sequence integration
3. Query integration
4. Warehouse integration

Correct Answer: 1

Explanation

A storage integration provides a centralized and secure way for Snowflake to connect with supported external cloud storage services. It allows access configuration to be managed through Snowflake rather than repeatedly embedding cloud credentials in individual stage definitions. External stages can reference the storage integration when accessing locations such as cloud object storage. This approach supports centralized credential and permission management and can simplify administration across multiple stages. The other listed integration types are not standard Snowflake objects used to establish secure external cloud-storage access.

Question 367

What is a major benefit of using a storage integration with external stages?

1. It eliminates all file formats
2. It centralizes external-storage access configuration
3. It converts tables into views
4. It automatically creates warehouses

Correct Answer: 2

Explanation

A storage integration centralizes configuration required for Snowflake to access supported external cloud storage. External stages can reference the integration instead of independently storing cloud-provider credentials. This provides a more manageable security model when multiple stages or workloads use the same external storage environment. Storage integrations do not eliminate file formats, transform tables into views, or create warehouses. Their primary value is centralized and controlled authorization for external storage access. This can also simplify administration when organizations maintain numerous external locations across their Snowflake environment.

Question 368

Which Snowflake command can be used to inspect information about a storage integration?

1. DESCRIBE INTEGRATION
2. SHOW STORAGE DATA
3. LIST INTEGRATION FILES
4. SELECT INTEGRATION STATUS

Correct Answer: 1

Explanation

DESCRIBE INTEGRATION can be used to display configuration information about an integration object. For storage integrations, this can help administrators inspect relevant properties and understand how the integration is configured for external access. The command is useful during configuration verification and troubleshooting because it exposes the integration’s defined properties without requiring users to inspect unrelated database objects. LIST is associated with staged files, while SHOW commands have their own object-specific syntax. DESCRIBE INTEGRATION is therefore the appropriate command for inspecting integration configuration.

Question 369

Which Snowflake capability allows data providers to publish datasets that consumers can discover and access through a governed data marketplace environment?

1. Snowflake Marketplace
2. Temporary schema
3. Query Profile
4. Resource Monitor

Correct Answer: 1

Explanation

Snowflake Marketplace provides an environment where data providers can publish data products for discovery and consumption by other organizations. It builds on Snowflake’s sharing capabilities while providing a marketplace-oriented experience for finding available datasets and services. Consumers can discover relevant offerings and obtain access according to the provider’s terms and configuration. Temporary schemas are used for database organization, Query Profile analyzes query execution, and Resource Monitors manage credit-related thresholds. Snowflake Marketplace is therefore associated with discovering and consuming governed external data offerings.

Question 370

What is a key characteristic of a Snowflake Marketplace listing?

1. It can make a provider’s data product discoverable to consumers
2. It automatically converts all data to CSV
3. It permanently copies provider data into every account
4. It requires every consumer to become the data owner

Correct Answer: 1

Explanation

A Snowflake Marketplace listing allows a provider’s data product or related offering to be made discoverable to potential consumers. Access is governed by the provider’s configuration and applicable marketplace terms. Marketplace consumption does not inherently require every consumer to become the owner of the provider’s underlying data, nor does it require all information to be converted to CSV. Snowflake’s sharing architecture is designed to provide controlled access rather than automatically producing conventional duplicate copies for every consumer. Marketplace listings therefore focus on discoverability and governed data consumption.

Question 371

Which Snowflake account type can provide data access to consumers who do not maintain a standard Snowflake account?

1. Reader account
2. Temporary account
3. Warehouse account
4. File account

Correct Answer: 1

Explanation

A reader account allows a provider to offer shared data access to consumers who do not have their own standard Snowflake account. The provider manages the reader account relationship and makes selected shared information available to the consumer. This can be useful when an organization wants to distribute data to external parties without requiring them to establish a full Snowflake account independently. Temporary, warehouse, and file accounts are not standard Snowflake account types for this purpose. Reader accounts therefore support controlled external consumption of shared Snowflake data.

Question 372

Which object is used by a provider to define the collection of objects that will be shared with another Snowflake account?

1. Share
2. Sequence
3. Stage
4. Task

Correct Answer: 1

Explanation

A share defines the data and database objects that a provider makes available to another Snowflake account. The provider can add supported objects and grant the appropriate privileges within the share, establishing what the consumer can access. This approach enables controlled data collaboration without requiring conventional duplication of the shared underlying data. A sequence generates numeric values, a stage identifies file locations, and a task automates SQL execution. The share is therefore the central object used by providers to package access to selected Snowflake data.

Question 373

Which Snowflake command can display the privileges that have been granted on an object?

1. SHOW GRANTS
2. SHOW PRIVILEGES ONLY
3. LIST ACCESS
4. DISPLAY AUTHORIZATION

Correct Answer: 1

Explanation

SHOW GRANTS is used to display privilege-grant information for Snowflake objects, roles, users, or other supported authorization targets depending on the specific syntax. Administrators can use these commands to investigate which roles have access and understand the current authorization configuration. This is useful when troubleshooting access issues or reviewing security settings. LIST is primarily associated with staged-file information, while the other listed statements are not standard Snowflake commands. SHOW GRANTS therefore provides an important administrative mechanism for inspecting authorization relationships.

Question 374

Which Snowflake privilege allows a role to use a warehouse for executing queries?

1. OPERATE
2. USAGE
3. SELECT
4. MONITOR

Correct Answer: 2

Explanation

The USAGE privilege on a warehouse allows a role to use that warehouse for query execution. Having access to a warehouse is separate from other permissions such as SELECT on a table. A user may therefore need both the required data privileges and warehouse USAGE before successfully querying a table. OPERATE is associated with managing warehouse state, while MONITOR provides monitoring-related capabilities. SELECT applies to data objects rather than warehouse usage. Understanding this distinction is important when troubleshooting situations where a user has table access but cannot execute queries.

Question 375

Which privilege allows a role to start, stop, or otherwise operate a Snowflake warehouse?

1. OPERATE
2. SELECT
3. USAGE
4. CREATE

Correct Answer: 1

Explanation

The OPERATE privilege on a warehouse provides the ability to perform operational actions on that warehouse, such as changing its running state. This differs from USAGE, which permits a role to use the warehouse for query execution. A role may therefore require USAGE to run queries and OPERATE when it must manage the warehouse itself. SELECT is associated with querying data objects, while CREATE is used for object creation where applicable. Separating these privileges helps organizations assign warehouse administration responsibilities without granting unnecessary data access.

Question 376

Which privilege is associated with viewing monitoring information about a Snowflake warehouse without necessarily allowing its use for query execution?

1. MONITOR
2. INSERT
3. SELECT
4. CREATE

Correct Answer: 1

Explanation

The MONITOR privilege on a warehouse provides monitoring-related access without being equivalent to USAGE for executing queries on that warehouse. This distinction allows organizations to separate operational visibility from the ability to consume warehouse compute resources. A monitoring role may need information about warehouse activity while not requiring permission to run workloads. INSERT and SELECT apply primarily to data operations, while CREATE concerns object creation. MONITOR is therefore appropriate when a user needs warehouse visibility for administration, auditing, or operational observation without automatically receiving warehouse usage rights.

Question 377

Which Snowflake capability allows a role to inherit privileges from another role?

1. Role hierarchy
2. File inheritance
3. Stage chaining
4. Warehouse mapping

Correct Answer: 1

Explanation

A role hierarchy allows one role to inherit privileges granted to another role. This enables organizations to build structured authorization models in which higher-level roles receive the permissions associated with subordinate roles. Role hierarchies can reduce the need to duplicate individual grants and make access administration more manageable as responsibilities grow. The hierarchy concerns roles and privileges rather than files, stages, or warehouses. Properly designed hierarchies can support separation of duties and least-privilege principles by organizing permissions according to job responsibilities.

Question 378

Which Snowflake function returns the current database associated with the session?

1. CURRENT_SCHEMA()
2. CURRENT_ROLE()
3. CURRENT_DATABASE()
4. CURRENT_USER()

Correct Answer: 3

Explanation

CURRENT_DATABASE() returns the database currently associated with the session context. It is useful when SQL logic or administrative troubleshooting needs to identify which database is active without relying on manually entered names. CURRENT_SCHEMA() provides the active schema, CURRENT_ROLE() identifies the active primary role, and CURRENT_USER() identifies the current user. These functions provide different pieces of session context. CURRENT_DATABASE() is therefore specifically appropriate when the requirement is to determine the database currently selected for unqualified object references.

Question 379

Which Snowflake function returns the current user’s login identity within the session?

1. CURRENT_ROLE()
2. CURRENT_DATABASE()
3. CURRENT_USER()
4. CURRENT_SCHEMA()

Correct Answer: 3

Explanation

CURRENT_USER() returns the identity of the user associated with the current session. This function can be useful in SQL expressions, auditing logic, or security-related conditions where behavior depends on the current authenticated user. It differs from CURRENT_ROLE(), which returns the active primary role, and from CURRENT_DATABASE() and CURRENT_SCHEMA(), which identify session object contexts. Because these functions provide different information, selecting the appropriate one depends on what the SQL logic needs to determine. CURRENT_USER() is specifically intended for identifying the current session user.

Question 380

Which Snowflake function returns the active schema associated with the current session?

1. CURRENT_SCHEMA()
2. CURRENT_ROLE()
3. CURRENT_USER()
4. CURRENT_DATABASE()

Correct Answer: 1

Explanation

CURRENT_SCHEMA() returns the schema currently active in the session. It can be useful when SQL logic needs to determine the current schema context or when troubleshooting object-resolution behavior involving unqualified names. CURRENT_DATABASE() identifies the active database, CURRENT_ROLE() identifies the primary role, and CURRENT_USER() identifies the session user. These context functions provide complementary information about the current execution environment. CURRENT_SCHEMA() is therefore the appropriate choice when the requirement is specifically to determine which schema is currently active for the session.