Save 15% on 2 packs BUY2 · 20% on 3+ BUY3

Skip to content

Free Snowflake SnowPro Core COF-C03 Practice Questions

29 free Snowflake SnowPro Core COF-C03 practice questions from the CertStash pack of 116, each with the correct answer and a full explanation.

Question 1

What is a key difference between the Snowflake CLI and SnowSQL?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

This reverses the roles of the two tools; application and workload management is the focus of Snowflake CLI, not SnowSQL.

Right, B is the answer.

Why B is right

Snowflake CLI is the newer open-source command-line tool built for developer workloads: it creates, deploys and manages applications and objects such as Streamlit apps, Snowpark functions and procedures, Native App packages, notebooks and Snowpark Container Services, and it can also run SQL. SnowSQL is the older command-line client focused on connecting to Snowflake and executing SQL statements and operations, including loading and unloading data with PUT and GET. The deciding difference is therefore purpose: workload and application management for Snowflake CLI versus statement execution for SnowSQL.

Not this one. Try another answer.

Why C is wrong

Neither tool is limited to one class of SQL; both can run DDL and DML statements.

Not this one. Try another answer.

Why D is wrong

Snowflake CLI is not limited to queries, and SnowSQL is a SQL client rather than a Python package manager.

Question 2

Which services are handled within the Cloud Services layer? (Choose two.)

Tap an answer. The reason for that answer shows here.

Right, A is one of the answers.

Why A is right

The cloud services layer is the coordinating tier of Snowflake's architecture. It handles authentication of users and clients, access control, infrastructure management, query parsing and optimization, and metadata management, including the statistics and object definitions that make features such as cloning, Time Travel and pruning possible. Authentication and metadata management therefore both belong to this layer. Actual query execution happens in the compute layer, where virtual warehouses process the data, while the storage layer holds the table data itself.

Not this one. Try another answer.

Why B is wrong

Query processing (execution) is performed by virtual warehouses in the compute layer, not by cloud services.

Not this one. Try another answer.

Why C is wrong

Secure socket is not one of the services that Snowflake lists for the cloud services layer.

Not this one. Try another answer.

Why D is wrong

Virtual warehouses make up the separate query processing (compute) layer rather than being hosted as a cloud service.

Right, E is one of the answers.

Why E is right

The cloud services layer is the coordinating tier of Snowflake's architecture. It handles authentication of users and clients, access control, infrastructure management, query parsing and optimization, and metadata management, including the statistics and object definitions that make features such as cloning, Time Travel and pruning possible. Authentication and metadata management therefore both belong to this layer. Actual query execution happens in the compute layer, where virtual warehouses process the data, while the storage layer holds the table data itself.

Question 3

A user is automating a data pipeline using the Snowflake CLI and needs to pass variables into SQL scripts.

Which variable templating syntaxes should be used? (Choose two.)

Tap an answer. The reason for that answer shows here.

Right, A is one of the answers.

Why A is right

When Snowflake CLI runs SQL from a script, it can substitute variables using several templating syntaxes chosen with the enable-templating option. Two are switched on by default and need no extra configuration in an automated pipeline. STANDARD uses the <% variable_name %> form, which Snowflake recommends for new work. LEGACY uses the older &{ variable_name } form inherited from SnowSQL and remains enabled so existing scripts keep working. Together these are the syntaxes a pipeline should rely on when passing values into SQL scripts, with STANDARD as the preferred choice and LEGACY supported for compatibility.

Right, B is one of the answers.

Why B is right

When Snowflake CLI runs SQL from a script, it can substitute variables using several templating syntaxes chosen with the enable-templating option. Two are switched on by default and need no extra configuration in an automated pipeline. STANDARD uses the <% variable_name %> form, which Snowflake recommends for new work. LEGACY uses the older &{ variable_name } form inherited from SnowSQL and remains enabled so existing scripts keep working. Together these are the syntaxes a pipeline should rely on when passing values into SQL scripts, with STANDARD as the preferred choice and LEGACY supported for compatibility.

Not this one. Try another answer.

Why C is wrong

JINJA templating is disabled by default and must be turned on explicitly, so it is not one of the default syntaxes a pipeline should rely on.

Not this one. Try another answer.

Why D is wrong

NONE is a setting that turns variable templating off entirely, so it provides no syntax for passing variables.

Not this one. Try another answer.

Why E is wrong

ALL is a setting that enables every syntax at once, including JINJA; it is not a templating syntax itself.

Question 4

What is the MINIMUM Snowflake edition needed to apply 90 days of Time Travel to an object?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Standard Edition caps Time Travel retention at 1 day, so 90 days is not possible.

Right, B is the answer.

Why B is right

Standard Edition allows Time Travel retention of only 0 or 1 day. Extended Time Travel, which lets DATA_RETENTION_TIME_IN_DAYS be set as high as 90 days on permanent objects, requires Enterprise Edition or higher. Because the stem asks for the minimum edition that supports a 90-day retention period, Enterprise is the lowest tier that qualifies. Business Critical and Virtual Private Snowflake also allow it, but they sit above Enterprise and are not the minimum.

Not this one. Try another answer.

Why C is wrong

Business Critical supports 90 days but is a higher tier than the minimum required.

Not this one. Try another answer.

Why D is wrong

Virtual Private Snowflake supports 90 days but is the highest tier, not the minimum.

Question 5

Which objects can be recovered after being dropped? (Choose two.)

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

A dropped view cannot be recovered with UNDROP; it must be recreated from its definition.

Right, B is one of the answers.

Why B is right

Dropped tables are kept for the Time Travel retention period, and UNDROP TABLE restores them as long as that period has not expired. Permanent tables support Time Travel (1 day by default, configurable up to 90 days on Enterprise Edition or higher) followed by Fail-safe. Transient tables also have Time Travel, with a default and maximum of 1 day, so a dropped transient table can be restored within that window even though it has no Fail-safe. Both table types can therefore be recovered after a DROP.

Not this one. Try another answer.

Why C is wrong

A temporary table exists only for its session, has no Fail-safe and is purged when the session ends, so it cannot be recovered once its session is over.

Right, D is one of the answers.

Why D is right

Dropped tables are kept for the Time Travel retention period, and UNDROP TABLE restores them as long as that period has not expired. Permanent tables support Time Travel (1 day by default, configurable up to 90 days on Enterprise Edition or higher) followed by Fail-safe. Transient tables also have Time Travel, with a default and maximum of 1 day, so a dropped transient table can be restored within that window even though it has no Fail-safe. Both table types can therefore be recovered after a DROP.

Not this one. Try another answer.

Why E is wrong

Snowflake documents that dropped materialized views cannot be recovered and must be recreated.

Question 6

How does Snowflake support storage for external tables?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

External table data stays in the customer's cloud storage; Snowflake does not copy or replicate the files.

Right, B is the answer.

Why B is right

An external table lets Snowflake query files that remain in an external stage, such as Amazon S3, Google Cloud Storage or Azure storage. The data files are not loaded into Snowflake storage. Instead, Snowflake keeps file-level metadata about them, such as file names, paths and version identifiers, which it uses to locate and scan the files and which can be refreshed automatically or manually as files change. Storage support for external tables is therefore limited to that metadata.

Not this one. Try another answer.

Why C is wrong

Directory tables catalog files on a stage, but they are not the mechanism that defines or stores external tables.

Not this one. Try another answer.

Why D is wrong

Transient tables are a native table type for Snowflake-managed data and play no role in referencing external files.

Question 7

Which Snowflake features support the ability to write to a Git repository?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Dashboards have no Git push support, and stages store files rather than committing to Git repositories.

Not this one. Try another answer.

Why B is wrong

Snowpipe loads files and dynamic tables refresh query results; neither writes to a Git repository.

Not this one. Try another answer.

Why C is wrong

Stored procedures and tasks can read code from a Git repository clone, but they do not commit or push to it.

Right, D is the answer.

Why D is right

Snowflake's Git integration lets several Snowsight development surfaces both pull from and push to a remote repository. Workspaces can be connected to a Git repository so files can be committed and pushed, notebooks can be synced with a repository so changes are committed back, and Streamlit applications can likewise be connected to Git so app source is versioned there. These are the features that write to Git, whereas a Git repository clone used from SQL is read-only.

Question 8

A Snowflake Practitioner is tasked with designing a data lakehouse architecture that requires:

1. Support for ACID transactions to ensure data consistency

2. The ability to evolve schemas over time without rewriting existing data

3. Efficient querying capabilities on large datasets

Which table type meets these requirements?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Permanent tables store data in Snowflake's internal format rather than an open lakehouse format.

Right, B is the answer.

Why B is right

Apache Iceberg tables in Snowflake are built on the open Iceberg table format, which is designed for data lakehouse architectures. The format provides ACID transactions so concurrent changes remain consistent, supports schema evolution through metadata changes rather than rewriting existing data files, and keeps file-level statistics that allow efficient pruning on large datasets. Snowflake adds its query engine on top, so the table type satisfies all three stated requirements while keeping the data in open storage.

Not this one. Try another answer.

Why C is wrong

External tables are read-only references to files and do not offer ACID writes or managed schema evolution.

Not this one. Try another answer.

Why D is wrong

Transient tables are internal tables without Fail-safe and are not an open lakehouse format.

Question 9

What is SnowSQL used for?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Dashboards are built in Snowsight, not in a command-line client.

Right, B is the answer.

Why B is right

SnowSQL is Snowflake's command-line client for connecting to an account and executing SQL queries and DDL and DML operations. A common use is bulk data movement: it runs PUT to upload local files to an internal stage before COPY INTO loads them, and GET to download unloaded files from a stage to a local machine. Loading and unloading data is therefore its defining use among the listed options.

Not this one. Try another answer.

Why C is wrong

Native App development is handled with Snowflake CLI and application packages, not SnowSQL.

Not this one. Try another answer.

Why D is wrong

Monitoring of transformation activity is done in Snowsight and with views such as task and query history.

Question 10

What is the impact on storage when a user clones a 1 TB sized table and updates 10% of the rows in the cloned table?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Metadata-only storage applies at the moment of cloning, but updates write new micro-partitions that consume storage.

Not this one. Try another answer.

Why B is wrong

Cloning never copies the full table; unchanged micro-partitions stay shared with the source.

Not this one. Try another answer.

Why C is wrong

Modifying rows in the clone creates new micro-partitions, so some additional storage is consumed.

Right, D is the answer.

Why D is right

Cloning is zero-copy: the new table initially points to the same micro-partitions as the source, so creating it adds no storage. When rows in the clone are updated, Snowflake writes new micro-partitions for the changed data, and only those new partitions are owned by and billed to the clone. Updating 10% of the rows therefore adds storage roughly proportional to the micro-partitions rewritten for those changes, while the unchanged data remains shared with the original table.

What people say about the full COF-C03 pack 4.5 from 2

I passed with the Snowflake COF-C03 learning materials, Thank you so much.
EricaCOF-C03

Question 11

What is the recommended use for the COPY INTO <location> SINGLE = TRUE; command?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Avoiding duplicate loads depends on load metadata for COPY INTO <table>, not on the SINGLE option.

Not this one. Try another answer.

Why B is wrong

SINGLE is an unloading option of COPY INTO <location>; it is not used to load files.

Not this one. Try another answer.

Why C is wrong

SINGLE controls the number of output files, not the creation or parsing of stages.

Right, D is the answer.

Why D is right

COPY INTO <location> unloads table or query results to a stage, and by default it writes data in parallel to several files. Setting SINGLE = TRUE tells Snowflake to write all the output to one file instead. This is useful when a downstream consumer expects exactly one file, and MAX_FILE_SIZE can be raised so the single file can hold larger result sets.

Question 12

Which option will define the column type when unloading data into Parquet-formatted files?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

BINARY_AS_TEXT governs how binary columns are interpreted when reading Parquet, not how output types are defined.

Not this one. Try another answer.

Why B is wrong

EMPTY_FIELD_AS_NULL deals with empty fields in delimited files and does not set Parquet column types.

Right, C is the answer.

Why C is right

When unloading to Parquet, the column types in the output files follow the data types produced by the SELECT inside COPY INTO <location>. To control the Parquet type of a column, the query casts it explicitly with the CAST function or the :: operator, for example converting a value to a specific numeric or date type. This shapes the file schema without changing the source table.

Not this one. Try another answer.

Why D is wrong

SINGLE = TRUE unloads output to one file and has no effect on column types.

Question 13

Which copy option is used to include column headers when unloading data to Parquet files?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

PARSE_HEADER is a CSV file format option used when loading to read column names from the first line.

Not this one. Try another answer.

Why B is wrong

SKIP_HEADER tells a CSV load how many leading lines to ignore; it does not write headers on unload.

Right, C is the answer.

Why C is right

The HEADER copy option of COPY INTO <location> controls whether table column names are written to the unloaded files. For Parquet output, HEADER = TRUE keeps the actual column names from the query in the file schema. When it is left FALSE, the default, the columns are given generic names such as col1 and col2, so setting it to TRUE is what preserves meaningful headers.

Not this one. Try another answer.

Why D is wrong

This syntax is not how HEADER works; the option takes TRUE or FALSE, and custom HTTP style headers belong to other features.

Question 14

How can a user optimize the performance of a COPY INTO <table> query that is being run on a very large file?

Tap an answer. The reason for that answer shows here.

Right, A is the answer.

Why A is right

COPY INTO <table> achieves its speed by loading many files in parallel across the threads of a warehouse. A single very large file cannot be spread across that parallelism efficiently, so most of the warehouse sits idle. Splitting the file into multiple smaller files, close to the recommended compressed size of roughly 100 to 250 MB each, lets Snowflake distribute the work and greatly improves load throughput.

Not this one. Try another answer.

Why B is wrong

A bigger warehouse adds parallel capacity, but one large file cannot use it effectively, so splitting the file comes first.

Not this one. Try another answer.

Why C is wrong

SIZE_LIMIT caps the amount of data a COPY statement loads; raising it does not make loading faster.

Not this one. Try another answer.

Why D is wrong

COMPRESSION = AUTO only detects the compression type of the files; it does not speed up the load.

Question 15

Which tools, services, or features should be used to write code when using the Snowpark API? (Choose two.)

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Snowpark Container Services runs containerized applications on compute pools; it is not a language library for the Snowpark API.

Right, B is one of the answers.

Why B is right

The Snowpark API is offered as client libraries for Java, Python and Scala. Developers write DataFrame code in one of these languages, and Snowpark translates it into SQL that runs inside Snowflake on a warehouse. Snowpark for Scala and Snowpark for Python are therefore the listed options used to write code against the Snowpark API, and functions and procedures can also be built with them.

Right, C is one of the answers.

Why C is right

The Snowpark API is offered as client libraries for Java, Python and Scala. Developers write DataFrame code in one of these languages, and Snowpark translates it into SQL that runs inside Snowflake on a warehouse. Snowpark for Scala and Snowpark for Python are therefore the listed options used to write code against the Snowpark API, and functions and procedures can also be built with them.

Not this one. Try another answer.

Why D is wrong

Streamlit in Snowflake is an app framework that can call Snowpark, but it is not one of the Snowpark API libraries.

Not this one. Try another answer.

Why E is wrong

SQL Scripting is Snowflake's procedural SQL extension, separate from the Snowpark API.

Question 16

Which function is used to retrieve all errors of the past execution of a COPY INTO <table> command?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

LIST shows the files present in a stage; it does not report load errors.

Right, B is the answer.

Why B is right

The VALIDATE table function checks the files processed by a previous COPY INTO <table> execution and returns every error encountered during that load. It is called with the table name and a job ID, which can be the query ID of the COPY statement or the value _last for the most recent load in the session. This lets users review all rejected rows and their error messages after the load has already finished.

Not this one. Try another answer.

Why C is wrong

RESULT_SCAN returns the result set of a previous query, which for COPY is a summary per file, not all errors.

Not this one. Try another answer.

Why D is wrong

COPY_HISTORY shows load activity per file, including only the first error, rather than every error.

Question 17

Which table type is supported by Open Catalog to provide centralized, read and write access to a table?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Hybrid tables are Snowflake-native tables for transactional workloads and are not managed by Open Catalog.

Right, B is the answer.

Why B is right

Snowflake Open Catalog is a managed service for Apache Polaris, an open-source catalog that implements the Apache Iceberg REST catalog specification. It gives centralized governance and read and write access to Apache Iceberg tables from many engines, such as Snowflake, Apache Spark and Trino, so different tools can work on the same table data. Iceberg is therefore the table type Open Catalog supports.

Not this one. Try another answer.

Why C is wrong

Dynamic tables are Snowflake objects refreshed from a query, not tables cataloged by Open Catalog.

Not this one. Try another answer.

Why D is wrong

Event tables store logs and traces from Snowflake code and are unrelated to Open Catalog.

Question 18

Which view or command provides the MOST detailed storage information for a table?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

SHOW TABLES gives row counts and total bytes but no breakdown across Time Travel, Fail-safe or clones.

Not this one. Try another answer.

Why B is wrong

DESC TABLE describes columns and their properties, not storage usage.

Not this one. Try another answer.

Why C is wrong

STORAGE_USAGE reports daily storage totals for the whole account, not per table.

Right, D is the answer.

Why D is right

The ACCOUNT_USAGE.TABLE_STORAGE_METRICS view reports storage for each table broken down into active bytes, Time Travel bytes, Fail-safe bytes and bytes retained for clones, along with related lifecycle details. This breakdown shows how storage is attributed between a table and the history it keeps, which makes it the most detailed table-level storage source among the options listed.

Question 19

Which feature allows a user to review the monthly projected costs of a Snowflake resource against the monthly actual costs?

Tap an answer. The reason for that answer shows here.

Right, A is the answer.

Why A is right

Budgets define a monthly spending limit for the account or for a custom group of objects and track credit usage against it. Snowsight shows current spending alongside a forecast of the month's projected spending, and Snowflake can send notifications when projected spending is likely to exceed the limit. That comparison of projected and actual monthly cost is exactly what the stem describes.

Not this one. Try another answer.

Why B is wrong

Auto-suspend stops an idle warehouse to save credits; it provides no cost reporting or projection.

Not this one. Try another answer.

Why C is wrong

A scaling policy controls how a multi-cluster warehouse starts and shuts down clusters, not cost tracking.

Not this one. Try another answer.

Why D is wrong

A resource monitor tracks warehouse credit usage against a quota and can suspend warehouses, but it does not show projected spending.

Question 20

How can a user work with multiple assigned roles without the need to frequently switch roles?

Tap an answer. The reason for that answer shows here.

Right, A is the answer.

Why A is right

Every session has one primary role, and secondary roles let a user activate additional granted roles at the same time, for example with USE SECONDARY ROLES ALL. Privileges from the secondary roles are then combined with those of the primary role for most operations, while the primary role governs object creation and ownership. This lets the user work with several assigned roles without switching between them repeatedly.

Not this one. Try another answer.

Why B is wrong

Granting ACCOUNTADMIN gives excessive privileges and breaks least privilege rather than combining the existing roles.

Not this one. Try another answer.

Why C is wrong

Granting a parent role changes the hierarchy and grants extra access, rather than using the roles already assigned.

Not this one. Try another answer.

Why D is wrong

Building a new wrapper role adds administrative overhead and alters the hierarchy, while secondary roles achieve the goal directly.

Question 21

If a query is being used to unload a 1 TB table into a stage, which keyword will be shown in the Query History?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

INSERT adds rows into a table; it does not write data out to a stage.

Not this one. Try another answer.

Why B is wrong

Snowflake has no UNLOAD SQL statement; unloading is performed through COPY INTO <location>.

Right, C is the answer.

Why C is right

Snowflake unloads data with the COPY INTO <location> command, which writes table or query results into an internal or external stage. There is no separate unload statement in Snowflake SQL, so the query text recorded in Query History for unloading a large table begins with the COPY keyword. The same command family is used for loading, distinguished by whether the target is a table or a location.

Not this one. Try another answer.

Why D is wrong

UPDATE modifies existing table rows and has nothing to do with unloading data.

Question 22

What can load data from an external stage immediately after the data is taken in?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

A task runs COPY on a schedule, so files wait until the next run instead of loading immediately on arrival.

Not this one. Try another answer.

Why B is wrong

The Kafka connector reads from Kafka topics, not from files arriving in an external stage.

Right, C is the answer.

Why C is right

Snowpipe with auto-ingest enabled loads files from an external stage as soon as they arrive. The cloud provider's event notification service, such as Amazon S3 event notifications delivered through SQS, alerts Snowflake when a new file lands, and Snowpipe queues and loads it using serverless compute. No schedule or manual command is needed, so data is loaded shortly after it is written to the stage.

Not this one. Try another answer.

Why D is wrong

An external table queries files in place; it does not load data into Snowflake tables.

Question 23

Which methods for a second factor of authentication does Snowflake support? (Choose two.)

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Snowflake does not offer codes sent by email as an MFA second factor.

Right, B is one of the answers.

Why B is right

Snowflake multi-factor authentication lets a user enroll a second factor after the password. Authenticator applications generate time-based one-time passcodes that the user enters at sign-in, and passkeys use a device-bound credential, such as a platform biometric or a hardware security key, to confirm the user's identity. Both are supported second-factor methods that users can enroll in Snowsight, alongside Duo Mobile.

Not this one. Try another answer.

Why C is wrong

Social logins are not a Snowflake authentication method; federated sign-in uses SAML SSO with an identity provider.

Right, D is one of the answers.

Why D is right

Snowflake multi-factor authentication lets a user enroll a second factor after the password. Authenticator applications generate time-based one-time passcodes that the user enters at sign-in, and passkeys use a device-bound credential, such as a platform biometric or a hardware security key, to confirm the user's identity. Both are supported second-factor methods that users can enroll in Snowsight, alongside Duo Mobile.

Not this one. Try another answer.

Why E is wrong

Security questions are not a Snowflake second factor for authentication.

Question 24

A user needs to load Snowflake files from a stage that contains data from the past 5 years while using the LEAST amount of operational overhead. The file names include the year in this format: SALES_2025_01.gz.

What command should be used to load the data from 2024?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Naming each 2024 file individually works but requires far more manual effort than one pattern.

Right, B is the answer.

Why B is right

The year is embedded in each file name, such as SALES_2025_01.gz, so a regular expression can select only the 2024 files. The PATTERN option of COPY INTO <table> filters the staged files by name, for example matching names that contain SALES_2024_. A single statement then loads all the required files without listing each one and without altering or moving the stage contents, which keeps operational effort to a minimum.

Not this one. Try another answer.

Why C is wrong

Removing files from the stage is destructive, loses the other years' data and adds steps.

Not this one. Try another answer.

Why D is wrong

Downloading and restaging files adds several unnecessary steps and much more overhead.

Question 25

An organization is preparing for a data structure change on a critical table, SALES_BUDGET, and needs to identify which users, dashboards, reports and processes might be affected.

What action should be performed to determine the impact of this change?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

A stream tracks row changes made to a table, not who read the table or which columns they used.

Not this one. Try another answer.

Why B is wrong

SHOW GRANTS lists privileges that have been granted, not actual access or query frequency.

Right, C is the answer.

Why C is right

The SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY view records, for each query, which user ran it and which tables and columns were read or written. Querying it for SALES_BUDGET shows the users, service accounts and the queries behind dashboards, reports and pipelines that depend on the table, down to the specific columns they read. That is exactly what is needed to judge which consumers a structural change would affect.

Not this one. Try another answer.

Why D is wrong

TABLE_STORAGE_METRICS reports storage bytes and gives no information about who reads the table.

25 questions in. Want the rest? The first half of the pack, free by email · The full pack

Question 26

Which feature allows users to audit how sensitive data is being accessed over time?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Column-level security masks values when queried; it protects data rather than auditing access.

Not this one. Try another answer.

Why B is wrong

Row-level security filters the rows a role can see but does not track usage over time.

Not this one. Try another answer.

Why C is wrong

A tag-based masking policy applies masking to tagged columns; its job is protection, not auditing.

Right, D is the answer.

Why D is right

Object tagging lets data stewards label tables and columns that hold sensitive data and then track that data for compliance and auditing. Because tag assignments are recorded as metadata, they can be joined with access records such as ACCESS_HISTORY to see over time which users queried tagged objects and columns. The tags are what make it possible to focus an audit on sensitive data rather than on every object in the account.

Question 27

Which action can be performed by the SYSADMIN role without requiring elevated privileges from the ACCOUNTADMIN or SECURITYADMIN role?

Tap an answer. The reason for that answer shows here.

Not this one. Try another answer.

Why A is wrong

Broad privilege granting relies on MANAGE GRANTS, held by SECURITYADMIN; SYSADMIN can only grant on objects it owns.

Not this one. Try another answer.

Why B is wrong

Creating users requires the CREATE USER privilege, which is held by USERADMIN and roles above it, not SYSADMIN.

Right, C is the answer.

Why C is right

SYSADMIN is the system role intended for creating and managing objects. It holds the privileges to create warehouses, databases and other objects by default, so it can create, resize, suspend and otherwise manage virtual warehouses without help from a higher role. Creating users belongs to USERADMIN, account-wide grant management belongs to SECURITYADMIN through MANAGE GRANTS, and billing and usage data is available to ACCOUNTADMIN unless access is explicitly granted to others.

Not this one. Try another answer.

Why D is wrong

Billing and usage information is visible to ACCOUNTADMIN by default and requires explicit grants for other roles.

Question 28

Which Snowflake feature can be used to identify tables, views, and columns that contain sensitive information by assigning and querying metadata?

Tap an answer. The reason for that answer shows here.

Right, A is the answer.

Why A is right

Tags are schema-level objects that can be assigned as key and value pairs to tables, views and columns, among other objects. Data stewards can tag objects that hold sensitive data, for example with a classification such as PII, and then find them later by querying tag references through functions and Account Usage views. Assigning and querying this metadata is exactly how tags identify where sensitive information lives.

Not this one. Try another answer.

Why B is wrong

External Tokenization replaces sensitive values with tokens through an external function; it does not label or locate data.

Not this one. Try another answer.

Why C is wrong

Row access policies filter which rows a role can see rather than identifying sensitive objects.

Not this one. Try another answer.

Why D is wrong

Tag-based masking policies protect columns that carry tags; the identification itself comes from the tags.

Question 29

Which interface or service allow users to connect to Snowflake with Python? (Choose two.)

Tap an answer. The reason for that answer shows here.

Right, A is one of the answers.

Why A is right

The Snowpark API includes a Python library that opens a session to Snowflake from any Python environment, so code can query and transform data using DataFrames. Snowflake CLI is an open-source command-line tool built in Python and installed with pip, and it connects to Snowflake to run SQL and to deploy Python-based objects such as Snowpark functions, procedures and Streamlit apps. Both give a user a Python-based way to connect to Snowflake from their own environment.

Not this one. Try another answer.

Why B is wrong

Snowsight is Snowflake's browser interface, not a Python connection method.

Not this one. Try another answer.

Why C is wrong

Streamlit in Snowflake runs apps that are hosted inside Snowflake rather than serving as a client that connects to it.

Not this one. Try another answer.

Why D is wrong

AI_EXTRACT is a Cortex AI SQL function for extracting information, not a way to connect to Snowflake.

Right, E is one of the answers.

Why E is right

The Snowpark API includes a Python library that opens a session to Snowflake from any Python environment, so code can query and transform data using DataFrames. Snowflake CLI is an open-source command-line tool built in Python and installed with pip, and it connects to Snowflake to run SQL and to deploy Python-based objects such as Snowpark functions, procedures and Streamlit apps. Both give a user a Python-based way to connect to Snowflake from their own environment.

About the COF-C03 exam

The rule is the same for every exam: ten free on the product page, 29 free here, all 116 in the pack, and each step includes the one before it.

That was 29 of 116.

The full Snowflake SnowPro Core COF-C03 pack has all 116 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. US$39, paid once, with free updates for life and a pass-or-your-money-back guarantee.

Get the full pack

Not ready yet? Get the first 58 free as one PDF by email. Get the free PDF →

All 116 questionsUS$39Get the pack