Snowpro Core Recertification Free Sample Questions

Description

Covers Snowflake architecture and editions, authentication and network security updates, query and resource performance, continuous data loading, semi-structured data protection, and data sharing.

20 free sample questions283 in the full practice test

Try simulator

COF-R02 Sample Questions

  1. Question 1

    Advanced

    Performance Concepts · Search Optimization Service Cost Management

    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?

    Answer and explanation

    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.

  2. Question 2

    Intermediate

    Data Transformation and Protection · Dynamic Tables

    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?

    Answer and explanation

    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.

  3. Question 3

    IntermediateMultiple answers

    Snowflake Cloud Data Platform Features and Architecture · Git Integration

    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).

    Answer and explanation

    Correct answers: 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.

  4. Question 4

    Beginner

    Performance Concepts · Resource Monitors

    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.

    Answer and explanation

    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.

  5. Question 5

    Intermediate

    Snowflake Cloud Data Platform Features and Architecture · Snowpark Container Services

    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?

    Answer and explanation

    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.

  6. Question 6

    Advanced

    Data Sharing and Marketplace · Data Clean Rooms

    A marketing analytics company and a retail company want to collaborate on a dataset containing customer purchase history and demographic information. Due to privacy regulations, neither party can move or see the other's raw data. They need a secure environment to run joint queries that analyze the combined data without exposing the underlying PII. Which Snowflake feature is specifically designed for this privacy-preserving collaboration?

    Answer and explanation

    Correct answer: B

    Snowflake Data Clean Rooms provide a secure environment where multiple parties can collaborate on sensitive data without sharing the raw data itself. Each party maintains control over their data, and they can run joint queries with predefined restrictions to protect privacy. This directly addresses the requirement for privacy-preserving analysis without data movement. While Secure Data Sharing with policies is a component, the 'Clean Room' concept holistically addresses this specific multi-party collaboration use case.

  7. Question 7

    Intermediate

    Snowflake Cloud Data Platform Features and Architecture · Hybrid Tables (Unistore)

    A development team is building an application that requires both transactional and analytical queries on the same dataset. They need low-latency point lookups and fast analytical scans without managing two separate systems or dealing with data movement latency. Which Snowflake table type is engineered to handle this hybrid workload?

    Answer and explanation

    Correct answer: C

    Hybrid Tables, the core of Snowflake's Unistore workload, are designed for Hybrid Transactional/Analytical Processing (HTAP). They use a row-based storage engine for fast, single-row operations (transactional) while integrating with Snowflake's existing columnar engine for fast analytical scans. This allows a single table to efficiently serve both types of queries.

  8. Question 8

    Advanced

    Account Access and Security · Dynamic Data Masking with Role Checking

    A security administrator needs to create a masking policy that redacts a string value differently based on the user's role. For users with the ANALYST role, it should show the last four characters (e.g., '1234'). For all other roles, it should be fully masked (e.g., '*'). Which SQL function or construct would be used within the masking policy body to determine the current user's role?

    Answer and explanation

    Correct answer: B

    The IS_ROLE_IN_SESSION() function is specifically designed to be used within masking and row access policies. It checks if the specified role (e.g., 'ANALYST') is in the hierarchy of the current active primary or secondary roles for the user executing the query. This allows for conditional logic within the policy body. CURRENT_ROLE() only returns the primary active role, and CURRENT_USER() returns the user name, not their roles.

  9. Question 9

    Beginner

    Snowflake Cloud Data Platform Features and Architecture · Streamlit in Snowflake

    A data analyst needs to build an interactive web application on top of data stored in Snowflake. The goal is to create and share data apps quickly without extensive web development experience. The application must be hosted and run securely within the Snowflake environment. Which Snowflake capability should the analyst use?

    Answer and explanation

    Correct answer: C

    Streamlit in Snowflake allows users to build, deploy, and share interactive data applications using Python, all within Snowflake's secure environment. It is specifically designed for rapidly creating data-centric web apps without needing front-end web development skills. Snowsight is for dashboards, and the Python Connector is a library for connecting to Snowflake from an external Python application, but it doesn't provide the application framework or hosting.

  10. Question 10

    Intermediate

    Performance Concepts · Result Cache

    An administrator is investigating query history and observes that some queries are being fulfilled by the RESULT_SCAN command. What does this indicate about those queries?

    Answer and explanation

    Correct answer: B

    The RESULT_SCAN command is used to retrieve results from a previous query. When Snowflake can reuse the results of a previously executed query from the result cache, it does so without engaging a virtual warehouse for computation. This is a key performance and cost-saving feature. The local disk cache is used for data, not query results, and if a warehouse were used, the query profile would show compute activity.

Register free for 10 more questions

Or unlock all 283 COF-R02 questions with explanations, timed mode and flashcards.