nerdexam
SnowflakeSnowflake

DEA-C02 · Question #85

DEA-C02 Question #85: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #85. The question stem and answer options stay visible for context.

Snowflake Scripting and Tasks

Question

A Data Engineer is setting up a data processing pipeline in Snowflake. The pipeline needs to process PDF files that are uploaded to a stage with a directory table enabled. The data must be extracted from the files, and then the processed data will be loaded into a table. What should be done to ensure that the pipeline will automatically process any newly-added PDF files?

Options

  • AConfigure Snowpipe to automatically load the PDF data directly into the table without the need for
  • BImplement a custom Python script to continuously scan the stage and process any newly-created
  • CUse a materialized view to monitor the directory table for changes and trigger the processing task
  • DCreate a stream on the directory table to track changes and use the stream to trigger a task to

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Streams#Tasks#Directory Tables#Automated Pipelines
Full DEA-C02 PracticeBrowse All DEA-C02 Questions