SnowPro Advanced: Data Engineer Free Practice Exam Questions

105 real SnowPro Advanced: Data Engineer exam questions with answers and AI explanations. Snowflake certification prep — page 5 of 11.

  1. Question 51: Which system role is recommended for a custom role hierarchy to be ultimately assigned to?
  2. Question 52: Which callback function is required within a JavaScript User-Defined Function (UDF) for it to execute successfully?
  3. Question 53: Which Snowflake feature facilitates access to external API services such as geocoders, data transformation, machine learning models, and other custom code?
  4. Question 54: A Data Engineer needs to know the details regarding the micro-partition layout for a table named Invoice using a built-in function. Which query will provide th…
  5. Question 55: A Data Engineer needs to ingest invoice data in PDF format into Snowflake so that the data can be queried and used in a forecasting solution. What is the recom…
  6. Question 56: A Data Engineer would like to define a file structure for loading and unloading data. Where can the file structure be defined? (Choose three.)
  7. Question 57: Assuming that the session parameter USE_CACHED_RESULT is set to false, what are characteristics of Snowflake virtual warehouses in terms of the use of Snowpark?
  8. Question 58: Database XYZ has the data_retention_time_in_days parameter set to 7 days and table XYZ.public.ABC has the data_retention_time_in_days set to 10 days. A Develop…
  9. Question 59: A Data Engineer is building a set of reporting tables to analyze consumer requests by region for each of the Data Exchange offerings annually, as well as click…
  10. Question 61: A secure function returns data coming through an inbound share. What will happen if a Data Engineer tries to assign USAGE privileges on this function to an out…