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

  1. Question 63: A Data Engineer is building a data pipeline to ingest incremental data from a data source using streams and tasks in Snowflake. A stream is created on a CUSTOM…
  2. Question 64: A Data Engineer has created a scalar User-Defined Function (UDF) that contains a SELECT statement based on a projection constraint column. The Engineer notices…
  3. Question 65: A Data Engineer needs to be able to create new databases and objects as required for a Proof of Concept (POC). The sandbox Snowflake account where the POC is t…
  4. Question 66: 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…
  5. Question 67: Which command will retrieve results for all objects of a row access policy db1.policies.objectslist at the database level?
  6. Question 68: A Data Engineer is querying a large table (+100 million rows) with the following SQL: select name , address , datediff(year, birthdate, current_date()) from cu…
  7. Question 70: The following stored procedure has been created to load orders for a single date into a target table: create or replace procedure uspLoadOrdersByDate () return…
  8. Question 71: A Data Engineer has created table T1 with DATA_RETENTION_TIME_IN_DAYS set to 7. There is a default stream S1 on table T1. The parameter MAX_DATA_EXTENSION_TIME…
  9. Question 72: A Data Engineer made modifications to staged files and re-staged them. A pipe is running but the changed data is not appearing in the table. What step should t…
  10. Question 73: What considerations should a Data Engineer make when leveraging the table function TASK_HISTORY? (Choose two.)