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

Question 74: Data is loaded into a staging table every day. From there, several departments perform transformations on the data and load it into different production tables…
Question 76: How should a Data Engineer build a pipeline that executes a stored procedure to parse and load unstructured data files as the files arrive in a stage?
Question 77: A Data Engineer needs to configure a task in Snowflake to automatically send error notifications in case of a data loading failure. The Engineer wants to use a…
Question 78: Which of the following grants are required for the role kafka_load_role_1 running the Snowflake Connector for Kafka, with the intent of loading data to Snowfla…
Question 79: A Data Engineer creates a pipe called mypipe. What command needs to be run to verify that the pipe is configured correctly and is running?
Question 80: When using a stored procedure in Snowflake, how many threads can the Snowflake API run concurrently?
Question 81: The following FLATTEN command is run: select * from table(flatten(input => parse_json('{"first_name":"joe", "last_name": "smith" "location": {"state":"co", }}'…
Question 82: This query was executed: SELECT SYSTEM$EXPLAIN_PLAN_JSON( 'SELECT Z1.ID, Z2.ID FROM Z1, Z2 WHERE Z2.ID = Z1.ID' ) AS explain_plan; What information will be pro…
Question 83: A Data Engineer needs to create a SQL script that will load and transform data in batch mode into Snowflake. The script should be run with SnowSQL, and should…
Question 84: A Data Engineer runs the following sequence: use role ACCOUNTADMIN; create role ROLE1; grant role ROLE1 to role ACCOUNTADMIN; grant create database on account…