Free Snowflake COF-R02 Exam Dumps Questions & Answers

What happens to historical data when the retention period for an object ends?

• A.  Time Travel on the historical data is dropped.
• B.  The data moves to Fail-safe
• C.  The object containing the historical data is dropped.
• D.  The data is cloned into a historical object.

Which feature is only available in the Enterprise or higher editions of Snowflake?

• A.  Object-level access control
• B.  SOC 2 type II certification
• C.  Column-level security
• D.  Multi-factor Authentication (MFA)

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

• A.  Use auto-ingest Snowpipes to load large files in a serverless model.
• B.  Produce the largest files possible, reducing the overall number of files to process.
• C.  Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
• D.  Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

• A.  Microsoft Azure Cloud
• B.  Google Cloud Platform
• C.  Docker
• D.  IBM Cloud
• E.  Oracle Cloud
• F.  Amazon Web Services

Which of the following can be executed/called with Snowpipe?

• A.  A stored procedure
• B.  A single insert__into statement
• C.  A single copy_into statement
• D.  A User Defined Function (UDF)