← Back to exam page

Free SNOWPRO-ADVANCED-DATA-ENGINEER – Snowflake SNOWPRO-ADVANCED-DATA-ENGINEER Practice Test Question

Loading demo links...

Showing 7–9 of 13 questions

Question 7 (Topic 1)

Which callback function is required within a JavaScript User-Defined Function (UDF) for it to execute successfully?

Select an option, then click Submit answer.

  • ○ initialize()
  • ○ processRow()
  • ○ handler()
  • ○ finalize()
Question 8 (Topic 1)

A Data Engineer has created two custom roles, MARKETING_ROLE and FINANCE_ROLE, to be granted to the users of an application. According to best practices, what action should be taken next?

Select an option, then click Submit answer.

  • ○ Use the USERADMIN role to give all the required grants to the users.
  • ○ Use the SECURITYADMIN role to configure the required parameters for the users at the account level.
  • ○ Use the ACCOUNTADMIN role to create the new users that will be granted the new roles.
  • ○ Assign the custom roles to the SYSADMIN role.
Question 9 (Topic 1)

A Data Engineer is querying a large table (+100 million rows) with the following SQL: select name , address , datediff(year, birthdate, current_date()) from customers; The Engineer notices that the results cache is not being used on subsequent executions of the query. The underlying table does not change and the data is not updated in between query executions. What is causing this to occur?

Select an option, then click Submit answer.

  • ○ Calculations are not stored in the results cache.
  • ○ Large results are not stored in the results cache.
  • ○ Date functions are not stored in the results cache.
  • ○ Non-deterministic calculations are not stored in the results cache.