COF-C03

Free COF-C03 practice questions

10 questions from our COF-C03 practice tests, each with the correct answer and a written explanation. Read them with the answers shown, or switch to quiz mode and answer first.

Back to the COF-C03 practice exams

Question 1 of 10, Snowflake AI Data Cloud Features and Architecture

A data science team trains a scikit-learn model in a Python stored procedure on a large dataset, and the procedure fails with out-of-memory errors on a standard Large warehouse. Which change is MOST appropriate?

  1. AEnable the query acceleration service so the training step can borrow serverless compute
  2. BRun the procedure on a Snowpark-optimized warehouse, which provides much more memory per node Correct answer
  3. CIncrease MAX_CONCURRENCY_LEVEL so the procedure is allotted a greater share of the cluster
  4. DConvert the warehouse to a multi-cluster warehouse so the procedure can spread across clusters

Answer and explanation: Snowpark-optimized warehouses are designed for memory-intensive workloads such as model training in stored procedures and offer substantially more memory per node than standard warehouses. Multi-cluster warehouses add concurrency, not memory for a single procedure; query acceleration offloads portions of eligible scans, not Python training; and raising MAX_CONCURRENCY_LEVEL lets more queries share resources rather than giving one more memory.

Question 2 of 10, Snowflake AI Data Cloud Features and Architecture

A table stores intermediate ETL output that can easily be regenerated. The team wants to avoid Fail-safe storage costs but keep the table available to other sessions. Which table type should they use?

  1. AAn external table pointing to a stage
  2. BA temporary table
  3. CA transient table Correct answer
  4. DA permanent table with a 0-day retention period

Answer and explanation: Transient tables persist across sessions and are visible to other users, but they have no Fail-safe period, which removes Fail-safe storage costs. Temporary tables exist only for the session that created them, permanent tables always have 7 days of Fail-safe even with zero Time Travel, and external tables only reference files in a stage rather than storing ETL output inside Snowflake.

Question 3 of 10, Snowflake AI Data Cloud Features and Architecture

An analyst runs the exact same SELECT statement twice within an hour. The underlying table did not change, and the second run returned instantly without the warehouse being resumed. Which cache served the second request?

  1. AThe metadata cache of micro-partition statistics
  2. BThe query result cache held in the cloud services layer Correct answer
  3. CThe remote storage cache that keeps recently read micro-partitions in object storage
  4. DThe local disk cache of the virtual warehouse that ran the first query

Answer and explanation: Persisted query results live in the cloud services layer, so an identical query against unchanged data can be answered without any running warehouse. The warehouse local disk cache requires the warehouse to be running, the metadata cache answers only certain metadata-based queries such as COUNT or MIN/MAX, and there is no separate remote storage cache of micro-partitions.

Question 4 of 10, Account Management and Data Governance

A financial company on Business Critical Edition must ensure that Snowflake cannot decrypt its data if the company revokes access to its own key. Which feature provides this control?

  1. AClient-side encryption of files in an external stage with a master key
  2. BPeriodic rekeying of data encrypted with keys that are older than one year
  3. CTri-Secret Secure using a customer-managed key in the cloud provider's KMS Correct answer
  4. DSnowflake's hierarchical key model with automatic rotation of keys every 30 days

Answer and explanation: Tri-Secret Secure combines a Snowflake-maintained key with a customer-managed key to create a composite master key; revoking the customer key makes the data unreadable. Periodic rekeying and automatic rotation strengthen Snowflake-managed encryption but leave Snowflake in control of the keys, and client-side stage encryption protects only staged files, not data in tables.

Question 5 of 10, Account Management and Data Governance

A company wants a secondary account in another region that can take over if the primary region has an outage, including databases, users, roles, and warehouses. Which feature fits BEST?

  1. AA reader account in the secondary region with secure views over data
  2. BA share containing those objects created for the secondary account
  3. CZero-copy clones of each database made in the secondary account
  4. DA failover group replicating those objects to the secondary account Correct answer

Answer and explanation: Failover groups replicate databases and account objects such as users, roles, and warehouses to another account and allow promotion of the secondary for business continuity (Business Critical Edition or higher). Shares cannot contain users or roles, clones work only within one account, and reader accounts are for data consumers.

Question 6 of 10, Data Loading, Unloading, and Connectivity

A security team does not want cloud storage credentials stored in stage definitions. Which object should be used to give external stages access to an S3 bucket?

  1. AAn API integration that calls the S3 REST endpoint
  2. BA storage integration that uses an IAM role Correct answer
  3. CA secret holding an access key
  4. DA network policy that allows the bucket's IP range

Answer and explanation: A storage integration stores a generated identity (for AWS, an IAM role trust relationship) so stages can reach the bucket without embedding credentials, and the integration can be limited to specific locations. Network policies control inbound client access, API integrations are used for external functions and Git repositories, and storing an access key in a secret still relies on long-lived credentials.

Question 7 of 10, Data Loading, Unloading, and Connectivity

A team receives Parquet files with a schema they do not yet know and wants Snowflake to derive the column definitions and create the table automatically. Which combination achieves this?

  1. ACREATE EXTERNAL TABLE with AUTO_REFRESH set to TRUE
  2. BCOPY INTO with MATCH_BY_COLUMN_NAME on a table with no columns
  3. CCREATE TABLE ... CLONE pointing at the staged Parquet files
  4. DCREATE TABLE ... USING TEMPLATE over INFER_SCHEMA results Correct answer

Answer and explanation: INFER_SCHEMA reads staged files and returns column names and types, and CREATE TABLE ... USING TEMPLATE turns that result into a table definition. Cloning works only between Snowflake objects, an external table with auto refresh keeps data outside Snowflake rather than creating a matching table, and COPY needs an existing table with columns to match against.

Question 8 of 10, Performance Optimization, Querying, and Transformation

Analysts run highly selective point lookups such as WHERE SESSION_ID = 'abc123' on a large table, where SESSION_ID has very high cardinality and is not used for clustering. Which feature is designed to speed up these queries?

  1. AA materialized view grouped by SESSION_ID
  2. BThe search optimization service Correct answer
  3. CThe query acceleration service
  4. DA multi-cluster warehouse in auto-scale mode

Answer and explanation: Search optimization builds a persistent search access path that lets point lookups and selective filters on high-cardinality columns skip most micro-partitions. Query acceleration offloads parts of large scan-heavy queries, a materialized view grouped by the lookup column would roughly duplicate the table, and extra clusters improve concurrency rather than single-query pruning.

Question 9 of 10, Performance Optimization, Querying, and Transformation

A warehouse runs a mix of short dashboard queries and occasional ad hoc queries that scan huge amounts of data with selective filters. The outliers slow down the warehouse. Which feature lets these outlier queries borrow serverless compute without resizing the warehouse?

  1. AA Snowpark-optimized warehouse assigned to the dashboard users
  2. BThe query acceleration service enabled on the warehouse Correct answer
  3. CAutomatic Clustering on the tables used by the outlier queries
  4. DThe search optimization service enabled on the scanned tables

Answer and explanation: Query acceleration offloads eligible portions of large scan and filter work to shared serverless compute, bounded by a scale factor, so outliers finish faster without upsizing. Search optimization targets point lookups, clustering improves pruning over time rather than adding compute, and Snowpark-optimized warehouses give more memory per node for different workloads.

Question 10 of 10, Data Collaboration

An organization has accounts in several business units in different regions, and data owners want to share curated datasets internally across those accounts with discovery and request workflows. Which feature fits BEST?

  1. AReader accounts created by each data owner
  2. BPublic listings on the Snowflake Marketplace
  3. CDirect shares created manually in each account by every data owner
  4. DInternal listings in the organization's Internal Marketplace Correct answer

Answer and explanation: Internal listings published to the organization's Internal Marketplace let business units discover and request curated datasets across accounts and regions with governance. Public listings expose data outside the organization, reader accounts are for non-Snowflake consumers, and manual direct shares do not provide discovery and do not span regions.