ExamDumpster

Free COF-R02 sample questions

Start with these free COF-R02 sample questions, each with an answer and an explanation. They focus on recent changes: access security, continuous loading and data clean rooms. Any miss points to a new feature you still need to learn.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose one

**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?

Question 2Choose one

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?

Question 3Choose one

A data engineer is designing a data loading process for a table that will store sensitive PII. They need to ensure that the data is masked as it is being loaded using a `COPY INTO` statement, rather than applying masking policies for queries after the data has landed in plain text. Which feature allows for the application of a masking policy during the data loading process?

Question 4Choose 3

An organization needs to process unstructured data, such as PDFs and images, that are stored in an external stage. They want to use external libraries to perform Optical Character Recognition (OCR) and extract text. The processing logic will be invoked via a SQL call from Snowflake. Which components are required to build this solution? (Select THREE).

Question 5Choose one

A data administrator is reviewing the cost of a multi-cluster warehouse. They notice that the warehouse frequently scales up to its maximum cluster count during peak hours but then remains at that high count for a significant time after the query load decreases, leading to excess credit consumption. Which warehouse parameter should be adjusted to make the warehouse scale down more quickly once the query load subsides?

Question 6Choose one

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_HISTORY` view in the `ACCOUNT_USAGE` schema 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?

Question 7Choose one

What is the primary purpose of defining a clustering key on a very large Snowflake table?

Question 8Choose one

A company has defined a tag `pii_level` and applied it to various columns across multiple tables. A security administrator now needs to apply a single masking policy `ssn_mask` to all columns that have been tagged with `pii_level = 'ssn'`. What is the most efficient way to accomplish this?

Question 9Choose one

True or False: Using the `UNDROP` command to restore a dropped table will also automatically restore any streams that were pointing to that table before it was dropped.

Question 10Choose one

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?

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.

Create account