Snowpro Core Recertification Practice Questions
Prepare for COF-R02 with more than an answer.
- Exam fee
- $175 USD
- Level
- Foundational
- Valid for
- 2 years from passing date
Domains covered on the exam 6
- Snowflake Cloud Data Platform Features and Architecture20%
- Account Access and Security15%
- Performance Concepts15%
- Data Loading and Unloading15%
- Data Transformation and Protection20%
- Data Sharing and Marketplace15%
- 1
A compliance officer needs to track all login attempts, both successful and failed, for all users in a Snowflake account over the past year for a security audit. The
QUERY_HISTORYview in theACCOUNT_USAGEschema only retains data for a limited time. What is the most reliable method to ensure this data is retained long-term and is accessible for auditing?Show answer details
Correct answer: B
The
ACCOUNT_USAGE.LOGIN_HISTORYview is specifically designed for this purpose. It contains historical login data for the past 365 days (1 year), including user name, client IP, success/failure status, and error messages. This view provides a much longer retention period for login events than theQUERY_HISTORYview and is the standard way to perform this type of security audit. Increasing data retention affects user tables, not theSNOWFLAKEdatabase. - 2
What is the primary purpose of defining a clustering key on a very large Snowflake table?
Show answer details
Correct answer: B
Clustering co-locates rows with similar values for the clustering key columns within the same micro-partitions. This allows Snowflake's query optimizer to prune (skip scanning) a large number of micro-partitions for queries that filter on the clustering key, significantly improving performance and reducing compute costs. It does not enforce uniqueness or guarantee query result order.
- 3
A company has defined a tag
pii_leveland applied it to various columns across multiple tables. A security administrator now needs to apply a single masking policyssn_maskto all columns that have been tagged withpii_level = 'ssn'. What is the most efficient way to accomplish this?Show answer details
Correct answer: B
Snowflake's tag-based masking feature allows a masking policy to be set directly on a tag itself. By executing
ALTER TAG pii_level SET MASKING POLICY ssn_mask;, thessn_maskpolicy is automatically applied to all columns that currently have or will in the future have this tag set. This is a highly efficient and scalable method for data governance. - 4
True or False: Using the
UNDROPcommand to restore a dropped table will also automatically restore any streams that were pointing to that table before it was dropped.Show answer details
Correct answer: B
The statement is false. When a table is dropped, any streams on that table also become invalid. Using
UNDROPon the table does NOT restore the associated streams. The streams must be manually recreated after the table has been restored. - 5
A data engineer is using Snowpark Python to process data. They have written a Python function that they want to execute in parallel on a virtual warehouse. The function should be temporary and only exist for the duration of the current session. Which Snowpark feature should be used to accomplish this?
Show answer details
Correct answer: B
Snowpark allows Python functions to be registered as UDFs that run on Snowflake's compute. The
session.udf.registermethod is used for this. To make the UDF temporary (session-scoped), theis_permanentparameter should be set toFalse. This ensures the UDF is automatically dropped at the end of the session, which is ideal for development and ad-hoc analysis. - 6
A financial services firm is using Snowflake's Search Optimization Service on a large transactions table to accelerate point-lookup queries. A data architect notices that while performance has improved, the storage costs associated with the search access paths are higher than anticipated. Which action would be most effective in managing these costs without completely disabling the service?
Show answer details
Correct answer: B
The Search Optimization Service can be configured for specific columns. By targeting only the columns used in point-lookup queries (e.g.,
WHERE column = 'value'), the size of the search access path and its associated maintenance and storage costs can be significantly reduced. Increasing warehouse size affects compute, not storage costs of this service. Disabling the service removes the performance benefit. Reclustering the table is a different optimization technique that wouldn't reduce the search access path's storage cost. - 7
A data engineering team wants to build a declarative data pipeline that automatically updates a summary table whenever the underlying base tables change. They want to avoid writing complex procedural code using tasks and streams. The pipeline should define the final state of the target table using a SQL query. Which Snowflake feature is designed specifically for this use case?
Show answer details
Correct answer: C
Dynamic Tables are designed for building declarative data pipelines. You define the target table using a SQL query, and Snowflake automatically manages the refresh process to keep it synchronized with the source tables. This abstracts away the complexity of managing streams, tasks, and dependencies, which is the primary drawback of the traditional approach for this use case. Materialized views are for accelerating queries on a single table, not for complex multi-table transformations.
- 8
A DevOps team is adopting Git-based workflows for their Snowflake environment. They want to store their SQL scripts, UDFs, and stored procedures in a Git repository and have them accessible directly within Snowflake for version control and CI/CD integration. Which two objects must be created in Snowflake to enable this workflow? (Select TWO).
Show answer details
Correct answer: A, C
An API Integration is required to securely store the credentials needed to authenticate with the Git provider (e.g., GitHub, GitLab).
A Git Repository Stage is a new type of stage object that represents the linked Git repository within Snowflake, allowing you to access files from it.
- 9
True or False: When a resource monitor is configured with a 'Suspend & Notify' action, it will immediately terminate all running queries on the assigned warehouses once the credit quota is reached.
Show answer details
Correct answer: B
The statement is false. The 'Suspend & Notify' action allows currently running queries to complete before suspending the warehouse. Only the 'Suspend Immediately & Notify' action will cancel all running queries and statements before suspending the warehouse.
- 10
A data science team needs to deploy a complex machine learning model, packaged as a Docker container, for inference directly within Snowflake. They want to avoid managing external infrastructure and ensure the model runs securely next to their data. Which recently introduced Snowflake feature allows them to achieve this?
Show answer details
Correct answer: D
Snowpark Container Services enables the deployment of OCI-compliant containers directly within Snowflake's compute infrastructure. This is the ideal solution for running containerized applications like complex ML models, ensuring data remains within Snowflake's security boundary and eliminating the need for external infrastructure management. External Functions call out to external services, while Java/Python UDFs/UDTFs run code within Snowflake's environment but do not support full container deployment.
