(PDF) SnowPro Core COF-C03 Exam and Certification Test Engine
Use COF-C03 Exam Dumps (2026 PDF Dumps) To Have Reliable COF-C03 Test Engine
NEW QUESTION # 648
In which use cases does Snowflake apply egress charges?
- A. Data sharing within a specific region
- B. Query result retrieval
- C. Database replication
- D. Loading data into Snowflake
Answer: C
Explanation:
Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region to another region or cloud provider. This is because the data transfer incurs costs associated with moving data across different networks. Egress charges are not applied for data sharing within the same region, query result retrieval, or loading data into Snowflake, as these actions do not involve data transfer across regions.
References:
[ COF-C03 ] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Data Replication and Egress Charges1
NEW QUESTION # 649
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
- A. Partitions total
- B. Bytes scanned
- C. Partitions scanned
- D. Bytes written to result
- E. Percentage scanned from cache
Answer: A,C
Explanation:
The statistics that can be used to identify queries with inefficient pruning are 'Partitions scanned' and
'Partitions total'. These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.
NEW QUESTION # 650
What information is found within the Statistic output in the Query Profile Overview?
- A. Nodes by execution time
- B. Operator tree
- C. Most expensive nodes
- D. Table pruning
Answer: C
Explanation:
The Statistic output in the Query Profile Overview of Snowflake provides detailed insights into the performance of different parts of the query. Specifically, it highlights the "Most expensive nodes," which are the operations or steps within the query execution that consume the most resources, such as CPU and memory. Identifying these nodes helps in pinpointing performance bottlenecks and optimizing query execution by focusing efforts on the most resource-intensive parts of the query.
References:
Snowflake Documentation on Query Profile Overview: It details the components of the profile overview, emphasizing how to interpret the statistics section to improve query performance by understanding which nodes are most resource-intensive.
NEW QUESTION # 651
What task can a data consumer perform using third-party datasets from the Snowflake Marketplace?
- A. Integrate Marketplace data with data in the consumer's Snowflake environment.
- B. Modify the data structures and schemas in the provider's dataset.
- C. Export Marketplace datasets to local files for offline analysis.
- D. Republish listings from the data provider.
Answer: A
Explanation:
Snowflake Marketplace allows consumers to discover and access third-party datasets without building separate ingestion pipelines for each provider. Consumers can combine Marketplace data with data already stored in their Snowflake environment and query the combined information to produce new analytics and business insights. The provider continues to control and update the shared data product, while the consumer generally receives read-only access through a listing. Consumers cannot modify the provider's underlying schemas or source data, and imported shared databases cannot be re-shared as the consumer's own listing. Exporting data to local files is not the defining Marketplace capability described in this question. Therefore, integrating third-party Marketplace data with the consumer's existing Snowflake data is the supported task represented by option B.
NEW QUESTION # 652
When should a stored procedure be created with caller ' s rights?
- A. When the stored procedure needs to operate on objects that the caller does not have privileges on
- B. When the caller needs to run a statement that could not execute outside of the stored procedure
- C. When the caller needs to be prevented from viewing the source code of the stored procedure
- D. When the stored procedure needs to run with the privileges of the role that called the stored procedure
Answer: D
Explanation:
Stored procedures in Snowflake can be created with either ' owner ' s rights ' or ' caller ' s rights ' . A stored procedure created with caller ' s rights executes with the privileges of the role that calls the procedure, not the privileges of the role that owns the procedure. This is particularly useful in scenarios where the procedure needs to perform operations that depend on the caller ' s access permissions, ensuring that the procedure can only access objects that the caller is authorized to access.
Reference: Snowflake ' s official documentation on stored procedures, specifically the section on execution context (caller ' s rights vs. owner ' s rights), provides detailed guidance on when to use caller ' s rights:
https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#caller-s-rights-vs-owner-s-rights
NEW QUESTION # 653
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
- A. CREATE TABLE <table_name> LIKE TABLE_A;
- B. CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
- C. CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
- D. CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;
Answer: C
Explanation:
When a tag object is assigned to a table, using the statement CREATE TABLE <table_name> AS SELECT * FROM TABLE_A will automatically assign the TABLE_A tag to the newly created table2.
NEW QUESTION # 654
What can be interpreted based on the number of nodes reported in a Query Profile?
- A. Compute required for metadata management
- B. Network bandwidth during query execution
- C. Query execution time
- D. Data spillage
Answer: C
NEW QUESTION # 655
What is the most efficient method to share a subset of data from a table with a consumer account?
- A. Create a secure User-Defined Function, or UDF.
- B. Create an external table.
- C. Create a secure view.
- D. Use a dynamic table.
Answer: C
Explanation:
The correct answer is D. Create a secure view .
A secure view is the recommended and efficient way to share a filtered subset of data with a consumer account using Snowflake Secure Data Sharing. The provider can define the rows and columns that should be visible, then share the secure view instead of sharing the full base table.
Why D is correct:
A secure view protects the view definition from unauthorized users and can be used to expose only selected rows or columns from an underlying table.
Example concept:
CREATE SECURE VIEW shared_sales_west AS
SELECT order_id, customer_id, amount, region
FROM sales
WHERE region = ' WEST ' ;
The provider can then include this secure view in a share, allowing the consumer to query only the approved subset of data.
Why the other options are incorrect:
A). A secure UDF can protect function logic, but it is not the most efficient method for sharing a subset of table data.
B). A dynamic table materializes transformation results, but it is not the standard method for secure data sharing with filtered access.
C). An external table allows querying data in external cloud storage. It is not the best method for sharing a subset of Snowflake table data.
Official Snowflake documentation reference:
Snowflake documentation explains that secure views are used with Secure Data Sharing when a provider wants to share filtered or restricted data while protecting the underlying query definition.
Reference: Snowflake Documentation - Secure Data Sharing; Snowflake Documentation - Secure views; SnowPro Core Study Guide - Data Protection and Governance.
NEW QUESTION # 656
What is a fundamental characteristic of Snowflake micro-partitions?
- A. They can be read directly as files.
- B. They are sized based on Time Travel requirements.
- C. Once established they cannot be changed.
- D. They serve as an index for Snowflake tables.
Answer: B
NEW QUESTION # 657
A user wants to upload a file to an internal Snowflake stage using a put command.
Which tools and or connectors could be used to execute this command? (Select TWO).
- A. SnowSQL
- B. Python connector
- C. SnowCD
- D. SQL API
- E. Snowsight worksheets
Answer: A,E
Explanation:
To upload a file to an internal Snowflake stage using a PUT command, you can use:
B . SnowSQL: SnowSQL, the command-line client for Snowflake, supports the PUT command, allowing users to upload files directly to Snowflake stages from their local file systems.
E . Snowsight worksheets: Snowsight, the web interface for Snowflake, provides a user-friendly environment for executing SQL commands, including the PUT command, through its interactive worksheets.
References:
Snowflake Documentation: Loading Data into Snowflake using SnowSQL
Snowflake Documentation: Using Snowsight
NEW QUESTION # 658
A data team needs to connect Snowflake to a remote Git repository over a public network using a personal access token for authentication.
Which components should be created in Snowflake to implement this connection? (Choose two.)
- A. A secret
- B. A security integration
- C. A storage integration
- D. An API integration
- E. Azure Private Link
Answer: A,D
Explanation:
For a Git repository reached over the public network with a personal access token, Snowflake requires a secret and an API integration. The secret stores the repository username and token, typically as a PASSWORD-type secret. The API integration defines the Git HTTPS API provider, allowed repository URL prefixes, and the authentication secrets Snowflake is permitted to use. A Git repository object can then reference both components through API_INTEGRATION and GIT_CREDENTIALS. A storage integration is used for external cloud storage, not Git authentication. Azure Private Link applies to private connectivity, and a security integration is not the object used for this Git HTTPS configuration.
Therefore, the answer supplied in the candidate file has been corrected from C and E to C and D.
NEW QUESTION # 659
What information is stored in the ACCESS_HlSTORY view?
- A. Names and owners of the roles that are currently enabled in the session
- B. Details around the privileges that have been granted for all objects in an account
- C. Query details such as the objects included and the user who executed the query
- D. History of the files that have been loaded into Snowflake
Answer: B
Explanation:
Details around the privileges that have been granted for all objects in an account. The ACCESS_HISTORY view in Snowflake provides a comprehensive log of access control changes, including grants and revocations of privileges on all securable objects within the account. This information is crucial for auditing and monitoring the security posture of your Snowflake environment.
Here's how to understand and use the ACCESS_HISTORY view:
Purpose of ACCESS_HISTORY View: It is designed to track changes in access controls, such as when a user or role is granted or revoked privileges on various Snowflake objects. This includes tables, schemas, databases, and more.
Querying ACCESS_HISTORY: To access this view, you can use the following SQL query pattern:
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY WHERE EVENT_TYPE = 'GRANT' OR EVENT_TYPE = 'REVOKE'; Interpreting the Results: The results from the ACCESS_HISTORY view include the object type, the specific privilege granted or revoked, the grantee (who received or lost the privilege), and the timestamp of the event. This data is invaluable for audits and compliance checks.
NEW QUESTION # 660
In addition to the SELECT privilege, what other privilege must a role have to select from a table in database1.
schema1?
- A. The REFERENCES privilege on the table and the schema.
- B. The OWNERSHIP privilege on the schema.
- C. The USAGE privilege on the database and the schema.
- D. The USAGE privilege on the table.
Answer: C
Explanation:
The correct answer is D. The USAGE privilege on the database and the schema .
To query a table in Snowflake, a role needs the SELECT privilege on the table. In addition, the role must have USAGE on the containing database and schema so it can resolve and access the object path.
Why D is correct:
For a table named:
database1.schema1.table1
A role generally needs:
USAGE ON DATABASE database1
USAGE ON SCHEMA database1.schema1
SELECT ON TABLE database1.schema1.table1
Without USAGE on the database and schema, the role cannot access the namespace that contains the table, even if SELECT exists on the table.
Why the other options are incorrect:
A). There is no USAGE privilege on a table for this purpose. SELECT is the table-level privilege needed to read data.
B). OWNERSHIP on the schema is not required to query a table.
C). REFERENCES is used for foreign key/reference-related behavior and is not required for simple SELECT queries.
Official Snowflake documentation reference:
Snowflake documentation explains that access to objects requires privileges on the object and appropriate USAGE privileges on parent containers, such as the database and schema.
Reference: Snowflake Documentation - Access control privileges; Snowflake Documentation - Overview of access control; SnowPro Core Study Guide - Security and Access Control.
==
NEW QUESTION # 661
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
- A. A column that is most actively used in selective filters
- B. A column with very low cardinality
- C. A column that is most actively used in join predicates
- D. A VARIANT column
- E. A column with very high cardinality
Answer: A,E
Explanation:
Snowflake recommends using columns with very high cardinality and those that are most actively used in selective filters as clustering keys. High cardinality columns have a wide range of unique values, which helps in evenly distributing the data across micro-partitions. Columns used in selective filters help in pruning the number of micro-partitions to scan, thus improving query performance. References: Based on general database optimization principles.
NEW QUESTION # 662
Which statement describes Snowflake tables?
- A. Snowflake tables are owned by a use.
- B. Snowflake tables require that clustering keys be defined lo perform optimally.
- C. Snowflake tables arc logical representation of underlying physical data.
- D. Snowflake tables are the physical instantiation of data loaded into Snowflake.
Answer: C
Explanation:
In Snowflake, tables represent a logical structure through which users interact with the stored data. The actual physical data is stored in micro-partitions managed by Snowflake, and the logical table structure provides the means by which SQL operations are mapped to this data. This architecture allows Snowflake to optimize storage and querying across its distributed, cloud-based data storage system.
References: Snowflake Documentation on Tables
NEW QUESTION # 663
Which table function will automatically detect the file metadata schema for a set of staged semi-structured data files, and then retrieve the column definitions?
- A. INFER_SCHEMA
- B. VALIDATE
- C. SPLIT_TO_TABLE
- D. GET_OBJECT_REFERENCES
Answer: A
NEW QUESTION # 664
To use the overwrite option on insert, which privilege must be granted to the role?
- A. SELECT
- B. truncate
- C. UPDATE
- D. DELETE
Answer: D
Explanation:
To use the overwrite option on insert in Snowflake, the DELETE privilege must be granted to the role. This is because overwriting data during an insert operation implicitly involves deleting the existing data before inserting the new data.
Understanding the Overwrite Option: The overwrite option (INSERT OVERWRITE) allows you to replace existing data in a table with new data. This operation is particularly useful for batch-loading scenarios where the entire dataset needs to be refreshed.
Why DELETE Privilege is Required: Since the overwrite operation involves removing existing rows in the table, the executing role must have the DELETE privilege to carry out both the deletion of old data and the insertion of new data.
Granting DELETE Privilege:
To grant the DELETE privilege to a role, an account administrator can execute the following SQL command:
sqlCopy code
GRANT DELETE ON TABLE my_table TO ROLE my_role;
NEW QUESTION # 665
Which commands can only be executed using SnowSQL? (Select TWO).
- A. PUT
- B. COPY INTO
- C. REMOVE
- D. LIST
- E. GET
Answer: A,D
Explanation:
The LIST and PUT commands are specific to SnowSQL and cannot be executed in the web interface or other SQL clients.LIST is used to display the contents of a stage, and PUTis used to upload files to a stage. References: [COF-C02] SnowPro Core Certification Exam Study Guide
NEW QUESTION # 666
Which Snowflake database object can be shared with other accounts?
- A. Stored Procedures
- B. Tasks
- C. Pipes
- D. Secure User-Defined Functions (UDFs)
Answer: D
Explanation:
In Snowflake, Secure User-Defined Functions (UDFs) can be shared with other accounts using Snowflake's data sharing feature. This allows different Snowflake accounts to securely execute the UDFs without having direct access to the underlying data the functions operate on, ensuring privacy and security. The sharing is facilitated through shares created in Snowflake, which can contain Secure UDFs along with other database objects like tables and views.References: Snowflake Documentation on Data Sharing and Secure UDFs
NEW QUESTION # 667
Which command will consume credits from a virtual warehouse?
- A. SELECT COUNT(*) FROM SNOWFLAKE;
- B. SELECT MAX(UUID) FROM SNOWFLAKE;
- C. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY UUID;
- D. SHOW TABLES LIKE ' SNOWFL% ' IN SCHEMA( ' PUBLIC ' );
Answer: A,B,C
Explanation:
The correct answers are A, B, and D , assuming SNOWFLAKE is a table or queryable object.
Important exam-note correction:
This question is written as a single-answer question, but more than one listed command can consume virtual warehouse credits. Any SELECT query that scans or processes table data generally requires a running virtual warehouse and can consume warehouse credits.
Why A, B, and D are correct:
These are SELECT statements against a table-like object. Query execution that scans or aggregates data uses compute resources from a virtual warehouse.
Examples:
SELECT MAX(UUID) FROM SNOWFLAKE;
SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY UUID;
SELECT COUNT(*) FROM SNOWFLAKE;
These involve SQL query processing and therefore require warehouse compute unless the result is fully served from cache.
Why C is incorrect:
SHOW commands are metadata commands handled by Snowflake's cloud services layer. They do not require an active virtual warehouse in the same way table-scanning SELECT queries do.
Official Snowflake documentation reference:
Snowflake documentation explains that virtual warehouses provide the compute resources required to execute SQL queries and DML operations. Metadata commands such as SHOW are handled by the cloud services layer.
Reference: Snowflake Documentation - Virtual warehouses; Snowflake Documentation - SHOW commands; SnowPro Core Study Guide - Snowflake Architecture and Resource Management.
==
NEW QUESTION # 668
What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).
- A. Default role
- B. Auto-suspend
- C. Resource monitor
- D. Cache size
- E. Storage size
Answer: B,C
Explanation:
When creating a virtual warehouse in Snowflake, users have the option to set several properties to manage its behavior and resource usage. Two of these optional properties are Auto-suspend and Resource monitor.
Auto-suspend: This property defines the period of inactivity after which the warehouse will automatically suspend. This helps in managing costs by stopping the warehouse when it is not in use.
CREATE WAREHOUSE my_warehouse
WITH WAREHOUSE_SIZE = 'XSMALL'
AUTO_SUSPEND = 300; -- Auto-suspend after 5 minutes of inactivity
Resource monitor: Users can assign a resource monitor to a warehouse to control and limit the amount of credit usage. Resource monitors help in setting quotas and alerts for warehouse usage.
CREATE WAREHOUSE my_warehouse
WITH WAREHOUSE_SIZE = 'XSMALL'
RESOURCE_MONITOR = 'my_resource_monitor';
References:
Snowflake Documentation: Creating Warehouses
Snowflake Documentation: Resource Monitors
NEW QUESTION # 669
......
COF-C03 Dumps Full Questions with Free PDF Questions to Pass: https://www.vcedumps.com/COF-C03-examcollection.html
