Free COF-R02 sample questions
Real questions from the Snowpro Core Recertification practice bank, with the correct answer and an explanation for each one. No junk, no filler.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
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.
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?
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?
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?
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?
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?
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?
**Case Study:** A large e-commerce company, ShopSphere, uses Snowflake as its central data platform. They have a critical `ORDERS` table that is several terabytes in size and receives millions of new records daily via Snowpipe. The data analytics team frequently runs queries that filter by `ORDER_DATE` and `STATUS`. The BI team runs dashboards that aggregate sales by `PRODUCT_ID`. The fraud detection team runs urgent, low-latency queries filtering by `CUSTOMER_ID` to check for suspicious activity. Currently, query performance is inconsistent. The analytics team's date-range queries are slow. The fraud team's point lookups on `CUSTOMER_ID` often take several seconds, which is too long for their real-time needs. The company wants to optimize performance for all three use cases while managing costs effectively. They have an Enterprise edition account. **The proposed architecture is as follows:** graph TD subgraph Ingestion S3[S3 Bucket] --> Snowpipe end subgraph Snowflake Snowpipe --> Orders[ORDERS Table] Orders -->|Clustering| AnalyticsWH[Analytics WH] Orders -->|Search Opt.| FraudWH[Fraud WH] Orders -->|Materialized View| BI_WH[BI WH] end AnalyticsWH -->|Filter by ORDER_DATE| Analytics[Analytics Team] FraudWH -->|Filter by CUSTOMER_ID| Fraud[Fraud Team] BI_WH -->|Aggregate by PRODUCT_ID| BI[BI Team] Which combination of Snowflake optimization features represents the most effective solution for meeting all of ShopSphere's requirements?
A data provider on the Snowflake Marketplace wants to offer a usage-based pricing model for their data share. They want to charge consumers based on the number of queries they run against the shared data. How can the provider implement this?
10 more free samples are waiting
Create a free account to unlock the whole COF-R02 sample bank, or get full access to all 283 practice questions in the simulator.