Snowflake COF-R02 Practice Test - Questions Answers, Page 12

List of questions
Question 111

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?
Question 112

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

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

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

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_OUTER_ARRAY file format do?
Question 116

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

What is a best practice after creating a custom role?
Question 118

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

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

Which Snowflake partner specializes in data catalog solutions?
Question