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

  1. Question 1: A new CUSTOMER table is created by a data pipeline in a Snowflake schema where MANAGED ACCESS is enabled. Which roles can grant access to the CUSTOMER table? (…
  2. Question 2: Given the table SALES which has a clustering key of column CLOSED_DATE, which table function will return the average clustering depth for the SALES_REPRESENTAT…
  3. Question 4: A Data Engineer is working on a Snowflake deployment in AWS eu-west-1 (Ireland). The Engineer is planning to load data from staged files into target tables usi…
  4. Question 5: A Data Engineer wants to create a new development database (DEV) as a clone of the permanent production database (PROD). There is a requirement to disable Fail…
  5. Question 7: A stream called TRANSACTIONS_STM is created on top of a TRANSACTIONS table in a continuous pipeline running in Snowflake. After a couple of months, the TRANSAC…
  6. Question 9: A Data Engineer has developed a dashboard that will issue the same SQL select clause to Snowflake every 12 hours. How long will Snowflake use the persisted que…
  7. Question 10: Which Snowflake objects does the Snowflake Kafka connector use? (Choose three.)
  8. Question 12: A Data Engineer needs to load JSON output from some software into Snowflake using Snowpipe. Which recommendations apply to this scenario? (Choose three.)
  9. Question 13: Which methods can be used to create a DataFrame object in Snowpark? (Choose three.)
  10. Question 14: What is the purpose of the BUILD_STAGE_FILE_URL function in Snowflake?