Snowflake COF-R02 Practice Test - Questions Answers, Page 17
List of questions
Related questions
Question 161

When is the result set cache no longer available? (Select TWO)
Question 162

Which of the following describes external functions in Snowflake?
Explanation:
External functions are user-defined functions that are stored and executed outside of Snowflake.
External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.
https://docs.snowflake.com/en/sql-reference/externalfunctions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.
Question 163

What are ways to create and manage data shares in Snowflake? (Select TWO)
Question 164

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
Question 165

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Explanation:
Semi-structured JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unloadprepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)
Question 166

What is the purpose of an External Function?
Explanation:
https://docs.snowflake.com/en/sql-reference/external-functions.html
Topic 3, Exam pool C
Question 167

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
Question 168

What is the purpose of multi-cluster virtual warehouses?
Explanation:
https://docs.snowflake.com/en/user-guide/warehousesmulticluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.
Question 169

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
Question 170

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
Question