COF-R02 Exam Questions

Which of the following objects can be shared through secure data sharing?

Which of the following commands cannot be used within a reader account?

A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Which command is used to unload data from a Snowflake table into a file in a stage?

How often are encryption keys automatically rotated by Snowflake?

What are value types that a VARIANT column can store? (Select TWO)

A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The ne...

A user has unloaded data from Snowflake to a stage. Which SQL command should be used to validate which data was loaded into the stage?

What happens when a cloned table is replicated to a secondary database? (Select TWO)

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP...

What are the default Time Travel and Fail-safe retention periods for transient tables?

What is a best practice after creating a custom role?

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Will data cached in a warehouse be lost when the warehouse is resized?

Which Snowflake partner specializes in data catalog solutions?

What is the MOST performant file format for loading data in Snowflake?

Which copy INTO command outputs the data into one file?

Where would a Snowflake user find information about query activity from 90 days ago?

Which Snowflake technique can be used to improve the performance of a query?

User-level network policies can be created by which of the following roles? (Select TWO).

Which command can be used to load data into an internal stage?

What happens when an external or an internal stage is dropped? (Select TWO).

How long is Snowpipe data load history retained?

In which use cases does Snowflake apply egress charges?

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate thi...

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Which stage type can be altered and dropped?

Which command can be used to stage local files from which Snowflake interface?

What is the recommended file sizing for data loading using Snowpipe?

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

What data is stored in the Snowflake storage layer? (Select TWO).

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

What is a responsibility of Snowflake's virtual warehouses?

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

What happens when a virtual warehouse is resized?

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked dat

Which of the following describes how clustering keys work in Snowflake?

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Which data type can be used to store geospatial data in Snowflake?