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

1. Question 118: A Data Engineer is cloning a production database for use as a development environment using these commands: USE ROLE CLONE_ADMIN; CREATE DATABASE DB_DEV CLONE…
2. Question 119: A Data Engineer needs to monitor the quality of hr.tables.employee_dim using a Data Metric Function (DMF). Which DMF will return the percent of NULL values for…
3. Question 120: A table was created under MY_SCHEMA: CREATE TABLE my_schema.orders ( order_id INT, order_item_nr INT ) DATA_RETENTION_TIME_IN_DAYS = 5; The DATA_RETENTION_TIME…
4. Question 125: When would a Data Engineer use TABLE with the FLATTEN function instead of the LATERAL FLATTEN combination?
5. Question 126: A Data Engineer executes a complex query and wants to make use of Snowflake’s query results caching capabilities to reuse the results. Which conditions must be…