CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-R02

Free COF-R02 Exam Braindumps (page: 42)

Page 41 of 83
PDF with 330 Questions

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

  1. When another warehouse is used to execute the query
  2. When another user executes the query
  3. When the underlying data has changed
  4. When the warehouse used to execute the query is suspended
  5. When it has been 24 hours since the last query

Answer(s): C,E



Which of the following describes external functions in Snowflake?

  1. They are a type of User-defined Function (UDF).
  2. They contain their own SQL code.
  3. They call code that is stored inside of Snowflake.
  4. 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.



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

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

Answer(s): C,D



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?


  1. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;

  2. SELECT EVENT_TIMESTAMP, USER_NAME
    FROM table(information_schema.login_history_by_user())

  3. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;

  4. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Answer(s): D






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts