ExamGecko
Home / Snowflake / COF-R02
Ask Question

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

Question list
Search

Question 161

Report
Export
Collapse

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

When another warehouse is used to execute the query
When another warehouse is used to execute the query
When another user executes the query
When another user executes the query
When the underlying data has changed
When the underlying data has changed
When the warehouse used to execute the query is suspended
When the warehouse used to execute the query is suspended
When it has been 24 hours since the last query
When it has been 24 hours since the last query
Suggested answer: C, E
asked 23/09/2024
Christopher Harden
46 questions

Question 162

Report
Export
Collapse

Which of the following describes external functions in Snowflake?

They are a type of User-defined Function (UDF).
They are a type of User-defined Function (UDF).
They contain their own SQL code.
They contain their own SQL code.
They call code that is stored inside of Snowflake.
They call code that is stored inside of Snowflake.
They can return multiple rows for each row received
They can return multiple rows for each row received
Suggested answer: A

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.

asked 23/09/2024
Sankalp Wadiwa
34 questions

Question 163

Report
Export
Collapse

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

Through the Snowflake web interface (Ul)
Through the Snowflake web interface (Ul)
Through the DATA_SHARE=TRUE parameter
Through the DATA_SHARE=TRUE parameter
Through SQL commands
Through SQL commands
Through the enable__share=true parameter
Through the enable__share=true parameter
Using the CREATE SHARE AS SELECT * TABLE command
Using the CREATE SHARE AS SELECT * TABLE command
Suggested answer: C, D
asked 23/09/2024
Deshawn Sharpe
38 questions

Question 164

Report
Export
Collapse

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?

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAMEFROM ACCOUNT_USAGE.USERS;
SELECT LAST_SUCCESS_LOGIN, LOGIN_NAMEFROM ACCOUNT_USAGE.USERS;
SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())
SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())
SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.ACCESS_HISTORY;
SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.ACCESS_HISTORY;
SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.LOGIN_HISTORY;
SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.LOGIN_HISTORY;
Suggested answer: D
asked 23/09/2024
Ibrahim SACCA
38 questions

Question 165

Report
Export
Collapse

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

ORC
ORC
XML
XML
Avro
Avro
Parquet
Parquet
JSON
JSON
Suggested answer: D, E

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.)

asked 23/09/2024
Vyas Dookhun
31 questions

Question 166

Report
Export
Collapse

What is the purpose of an External Function?

To call code that executes outside of Snowflake
To call code that executes outside of Snowflake
To run a function in another Snowflake database
To run a function in another Snowflake database
To share data in Snowflake with external parties
To share data in Snowflake with external parties
To ingest data from on-premises data sources
To ingest data from on-premises data sources
Suggested answer: A

Explanation:

https://docs.snowflake.com/en/sql-reference/external-functions.html

Topic 3, Exam pool C

asked 23/09/2024
Tyler Smith
42 questions

Question 167

Report
Export
Collapse

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

Create a zero-copy clone of the worksheet and grant permissions to teammates
Create a zero-copy clone of the worksheet and grant permissions to teammates
Create a private Data Exchange so that any teammate can use the worksheet
Create a private Data Exchange so that any teammate can use the worksheet
Share the worksheet with teammates within Snowsight
Share the worksheet with teammates within Snowsight
Create a database and grant all permissions to teammates
Create a database and grant all permissions to teammates
Suggested answer: C
asked 23/09/2024
Abdelilah BAKIR
27 questions

Question 168

Report
Export
Collapse

What is the purpose of multi-cluster virtual warehouses?

To create separate data warehouses to increase query optimization
To create separate data warehouses to increase query optimization
To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
To eliminate or reduce Queuing of concurrent queries
To eliminate or reduce Queuing of concurrent queries
To allow the warehouse to resize automatically
To allow the warehouse to resize automatically
Suggested answer: C

Explanation:

https://docs.snowflake.com/en/user-guide/warehousesmulticluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.

asked 23/09/2024
Liam Harris
51 questions

Question 169

Report
Export
Collapse

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

Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
Suggested answer: D, E, F
asked 23/09/2024
Matthew Wood
22 questions

Question 170

Report
Export
Collapse

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

Materialized view
Materialized view
Sequence
Sequence
Secure view
Secure view
Transient table
Transient table
Clustered table
Clustered table
Suggested answer: D, E
asked 23/09/2024
Bruno Soriano
34 questions
Total 330 questions
Go to page: of 33