support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. SnowPro Advanced Data Engineer

Free SnowPro Advanced Data Engineer Exam Braindumps
SnowPro Advanced Data Engineer Questions 31–35 (page: 8)

Updated On: 10-Feb-2026
Page 8 of 24
PDF with 162 Questions

A Data Engineer is developing a data pipeline to ingest data from an Amazon S3 bucket into a Snowflake table.

Files will be loaded into the S3 bucket randomly, with most files loaded during working hours. The files are in a compressed CSV format (*.csv.gz) and average 100 MB per file.

The data ingestion requirements are listed in order of priority:

1. MOST cost-effective method
2. LEAST amount of operational overhead
3. New data MUST be available within 10 minutes of the creation of a file

Which ingestion method will meet these requirements?

  1. Snowpipe
  2. Snowpipe Streaming
  3. Snowflake Kafka Connector
  4. The COPY INTO <location> command

Answer(s): A

Explanation:

Snowpipe provides serverless, event-driven file ingestion with minimal operational overhead and low per-file cost, delivering data well within the 10-minute requirement.



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?

  1. Create a Snowpipe with the parameter AUTO_INGEST = TRUE.
  2. Create a Snowpipe that includes the INTEGRATION = `<procedure name>' parameter.
  3. Create a stage with parameter ENCODING = `<procedure name>' to call the procedure when flies land in the stage.
  4. Create a stage with a directory table, a stream on the directory table, and a task referencing the stream.

Answer(s): D

Explanation:

Use a directory table on the stage to capture arriving files, create a stream on that table to detect new rows, and define a task that invokes the stored procedure whenever new files appear.



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 an existing task that inserts data into a table every 5 minutes. The Engineer set up a notification integration with Amazon Secure Notification Service (SNS) named my_notification_int.

How should the task be updated to automatically send error notifications if it fails?

  1. Add an ALERT clause in the task definition to link it to the notification service.
  2. Add the command: ALTER TASK MYTASK SET ERROR_INTEGRATION = `my_notification_int'; to the notification.
  3. Use the NOTIFICATION INTEGRATION = `my_notification_int' parameter in the task configuration.
  4. Add NOTIFICATION_PROVIDER = `my_notificacion_int' to the task schedule.

Answer(s): B

Explanation:

Use ALTER TASK ... SET ERROR_INTEGRATION = `my_notification_int' so that SNS will be notified whenever the task encounters a failure.



A Data Engineer is investigating a query that is taking a long time to return. The Query Profile shows the following:



What step should the Engineer take to increase the query performance?

  1. Add additional virtual warehouses.
  2. Increase the size of the virtual warehouse.
  3. Rewrite the query using Common Table Expressions (CTEs).
  4. Change the order of the joins and start with smaller tables first.

Answer(s): B



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 met? (Choose three.)

  1. The results must be reused within 72 hours.
  2. The query must be executed using the same virtual warehouse.
  3. The USED_CACHED_RESULT parameter must be included in the query.
  4. The table structure contributing to the query result cannot have changed.
  5. The new query must have the same syntax as the previously executed query.
  6. The micro-partitions cannot have changed due to changes to other data in the table.

Answer(s): D,E,F



  PDF
Viewing page 8 of 24
Viewing questions 36 - 40 out of 162 questions


Post your Comments and Discuss Snowflake SnowPro Advanced Data Engineer exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!