QUESTION: 161

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

When another warehouse is used to execute the query
When another user executes the query
When the underlying data has changed
When the warehouse used to execute the query is suspended
When it has been 24 hours since the last query

Answer(s): C,E

Reveal Solution Next Question

QUESTION: 162

Which of the following describes external functions in Snowflake?

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

Answer(s): 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.

Reference:

https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outsi de%20of%20Snowflake.

Reveal Solution Next Question

QUESTION: 163

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

Through the Snowflake web interface (Ul)
Through the DATA_SHARE=TRUE parameter
Through SQL commands
Through the enable share=true parameter
Using the CREATE SHARE AS SELECT * TABLE command

Answer(s): C,D

Reveal Solution Next Question

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?

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;
SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())
SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;
SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Answer(s): D

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 41)

QUESTION: 161

QUESTION: 162

Explanation:

Reference:

QUESTION: 163

QUESTION: 164