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.
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?
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?
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).
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?
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?
What is the primary purpose of defining a clustering key on a very large Snowflake table?
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?
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.
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.