COF-R02 Exam Questions
329 real COF-R02 exam questions with expert-verified answers and explanations. Page 3 of 7.
- Question #101
Which of the following objects can be shared through secure data sharing?
- Question #102
Which of the following commands cannot be used within a reader account?
- Question #103
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?
- Question #104
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
- Question #105
Which command is used to unload data from a Snowflake table into a file in a stage?
- Question #106
How often are encryption keys automatically rotated by Snowflake?
- Question #107
What are value types that a VARIANT column can store? (Select TWO)
- Question #108
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?
- Question #109
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- Question #110
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...
- 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...
- 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 #121
What is the MOST performant file format for loading data in Snowflake?
- Question #122
Which copy INTO command outputs the data into one file?
- Question #123
Where would a Snowflake user find information about query activity from 90 days ago?
- Question #124
Which Snowflake technique can be used to improve the performance of a query?
- Question #125
User-level network policies can be created by which of the following roles? (Select TWO).
- Question #126
Which command can be used to load data into an internal stage?
- Question #127
What happens when an external or an internal stage is dropped? (Select TWO).
- Question #128
How long is Snowpipe data load history retained?
- Question #129
In which use cases does Snowflake apply egress charges?
- Question #130
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
- Question #131
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- Question #132
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?
- Question #133
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
- Question #134
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...
- Question #135
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
- Question #136
Which stage type can be altered and dropped?
- Question #137
Which command can be used to stage local files from which Snowflake interface?
- Question #138
What is the recommended file sizing for data loading using Snowpipe?
- Question #139
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
- Question #140
What data is stored in the Snowflake storage layer? (Select TWO).
- Question #141
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
- Question #142
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
- Question #143
What is a responsibility of Snowflake's virtual warehouses?
- Question #144
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
- Question #145
What happens when a virtual warehouse is resized?
- Question #146
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
- Question #147
Which of the following describes how clustering keys work in Snowflake?
- Question #148
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
- Question #149
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- Question #150
Which data type can be used to store geospatial data in Snowflake?