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 2 of 11.

  1. Question 16: A company has an extensive script in Scala that transforms data by leveraging DataFrames. A Data Engineer needs to move these transformations to Snowpark. What…
  2. Question 18: A company is building a dashboard for thousands of Analysts. The dashboard presents the results of a few summary queries on tables that are regularly updated.…
  3. Question 19: A Data Engineer ran a stored procedure containing various transactions. During the execution, the session abruptly disconnected, preventing one transaction fro…
  4. Question 20: Which output is provided by both the SYSTEM$CLUSTERING_DEPTH function and the SYSTEM$CLUSTERING_INFORMATION function?
  5. Question 21: A table is loaded using Snowpipe and truncated afterwards. Later, a Data Engineer finds that the table needs to be reloaded, but the metadata of the pipe will…
  6. Question 23: Which methods will trigger an action that will evaluate a DataFrame? (Choose two.)
  7. Question 26: What is a characteristic of the use of external tokenization?
  8. Question 27: A Data Engineer is implementing a near real-time ingestion pipeline to load data into Snowflake using the Snowflake Kafka connector. There will be three Kafka…
  9. Question 28: Which functions will compute a 'fingerprint' over an entire table, query result, or window to quickly detect changes to table contents or query results? (Choos…
  10. Question 29: Which stages support external tables?