Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Palo Alto Networks
Salesforce
SAP
All Vendors
  1. Home
  2. Snowflake
  3. SnowPro Advanced Data Engineer

Snowflake SnowPro Advanced Data Engineer Exam (page: 1)
Snowflake SnowPro Advanced Data Engineer
Updated on: 11-Aug-2025

Viewing Page 1 of 16
SnowPro Advanced Data Engineer PDF 143 Questions

A Data Engineer needs to load JSON output from some software into Snowflake using Snowpipe.

Which recommendations apply to this scenario? (Choose three.)

  1. Load large files (1 GB or larger).
  2. Ensure that data files are 100-250 MB (or larger) in size, compressed.
  3. Load a single huge array containing multiple records into a single table row.
  4. Verify each value of each unique element stores a single native data type (string or number).
  5. Extract semi-structured data elements containing null values into relational columns before loading.
  6. Create data files that are less than 100 MB and stage them in cloud storage at a sequence greater than once each minute.

Answer(s): B,D,E



A Data Engineer is working on a Snowflake deployment in AWS eu-west-1 (Ireland). The Engineer is planning to load data from staged files into target tables using the COPY INTO command.

Which sources are valid? (Choose three.)

  1. Internal stage on GCP us-central1 (Iowa)
  2. Internal stage on AWS eu-central-1 (Frankfurt)
  3. External stage on GCP us-central1 (Iowa)
  4. External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)
  5. External stage in an Amazon S3 bucket on AWS eu-central-1 (Frankfurt)
  6. SSD attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)

Answer(s): B,D,E



What is the purpose of the BUILD_STAGE_FILE_URL function in Snowflake?

  1. It generates an encrypted URL for accessing a file in a stage.
  2. It generates a staged URL for accessing a file in a stage.
  3. It generates a permanent URL for accessing files in a stage.
  4. It generates a temporary URL for accessing a file in a stage.

Answer(s): C



A Data Engineer needs to ingest invoice data in PDF format into Snowflake so that the data can be queried and used in a forecasting solution.

What is the recommended way to ingest this data?

  1. Use Snowpipe to ingest the files that land in an external stage into a Snowflake table.
  2. Use a COPY INTO command to ingest the PDF files in an external stage into a Snowflake table with a VARIANT column.
  3. Create an external table on the PDF files that are stored in a stage and parse the data into structured data.
  4. Create a Java User-Defined Function (UDF) that leverages Java-based PDF parser libraries to parse PDF data into structured data.

Answer(s): D



A table is loaded using Snowpipe and truncated afterwards. Later, a Data Engineer finds that the table needs to be reloaded, but the metadata of the pipe will not allow the same files to be loaded again.

How can this issue be solved using the LEAST amount of operational overhead?

  1. Wait until the metadata expires and then reload the file using Snowpipe.
  2. Modify the file by adding a blank row to the bottom and re-stage the file.
  3. Set the FORCE=TRUE option in the Snowpipe COPY INTO command.
  4. Recreate the pipe by using the CREATE OR REPLACE PIPE command.

Answer(s): C



Which Snowflake objects does the Snowflake Kafka connector use? (Choose three.)

  1. Pipe
  2. Serverless task
  3. Internal user stage
  4. Internal table stage
  5. Internal named stage
  6. Storage integration

Answer(s): A,D,E



A Data Engineer is implementing a near real-time ingestion pipeline to load data into Snowflake using the Snowflake Kafka connector. There will be three Kafka topics created.

Which Snowflake objects are created automatically when the Kafka connector starts? (Choose three.)

  1. Tables
  2. Tasks
  3. Pipes
  4. Internal stages
  5. External stages
  6. Materialized views

Answer(s): A,C,D



Which stages support external tables?

  1. Internal stages only; within a single Snowflake account
  2. Internal stages only; from any Snowflake account in the organization
  3. External stages only; from any region, and any cloud provider
  4. External stages only; only on the same region and cloud provider as the Snowflake account

Answer(s): C



Viewing Page 1 of 16



Share your comments for Snowflake SnowPro Advanced Data Engineer exam with other users:

Priscila 7/22/2022 9:59:00 AM

i find the xengine test engine simulator to be more fun than reading from pdf.
GERMANY


suresh 12/16/2023 10:54:00 PM

nice document
Anonymous


Wali 6/4/2023 10:07:00 PM

thank you for making the questions and answers intractive and selectable.
UNITED STATES


Nawaz 7/18/2023 1:10:00 AM

answers are correct?
UNITED STATES


das 6/23/2023 7:57:00 AM

can i belive this dump
INDIA


Sanjay 10/15/2023 1:34:00 PM

great site to practice for sitecore exam
INDIA


jaya 12/17/2023 8:36:00 AM

good for students
UNITED STATES


Bsmaind 8/20/2023 9:23:00 AM

nice practice dumps
Anonymous


kumar 11/15/2023 11:24:00 AM

nokia 4a0-114 dumps
Anonymous


Vetri 10/3/2023 12:59:00 AM

great content and wonderful to have the answers with explanation
UNITED STATES


Ranjith 8/21/2023 3:39:00 PM

for question #118, the answer is option c. the screen shot is showing the drop down, but the answer is marked incorrectly please update . thanks for sharing such nice questions.
Anonymous


Eduardo Ramírez 12/11/2023 9:55:00 PM

the correct answer for the question 29 is d.
Anonymous


Dass 11/2/2023 7:43:00 AM

question no 22: correct answers: bc, 1 per session 1 per page 1 per component always
UNITED STATES


Reddy 12/14/2023 2:42:00 AM

these are pretty useful
Anonymous


Daisy Delgado 1/9/2023 1:05:00 PM

awesome
UNITED STATES


Atif 6/13/2023 4:09:00 AM

yes please upload
UNITED STATES


Xunil 6/12/2023 3:04:00 PM

great job whoever put this together, for the greater good! thanks!
Anonymous


Lakshmi 10/2/2023 5:26:00 AM

just started to view all questions for the exam
NETHERLANDS


rani 1/19/2024 11:52:00 AM

helpful material
Anonymous


Greg 11/16/2023 6:59:00 AM

hope for the best
UNITED STATES


hi 10/5/2023 4:00:00 AM

will post exam has finished
UNITED STATES


Vmotu 8/24/2023 11:14:00 AM

really correct and good analyze!
AZERBAIJAN


hicham 5/30/2023 8:57:00 AM

excellent thanks a lot
FRANCE


Suman C 7/7/2023 8:13:00 AM

will post once pass the cka exam
INDIA


Ram 11/3/2023 5:10:00 AM

good content
Anonymous


Nagendra Pedipina 7/13/2023 2:12:00 AM

q:32 answer has to be option c
INDIA


Tamer Barakat 12/7/2023 5:17:00 PM

nice questions
Anonymous


Daryl 8/1/2022 11:33:00 PM

i really like the support team in this website. they are fast in communication and very helpful.
UNITED KINGDOM


Curtis Nakawaki 6/29/2023 9:13:00 PM

a good contemporary exam review
UNITED STATES


x-men 5/23/2023 1:02:00 AM

q23, its an array, isnt it? starts with [ and end with ]. its an array of objects, not object.
UNITED STATES


abuti 7/21/2023 6:24:00 PM

cool very helpfull
Anonymous


Krishneel 3/17/2023 10:34:00 AM

i just passed. this exam dumps is the same one from prepaway and examcollection. it has all the real test questions.
INDIA


Regor 12/4/2023 2:01:00 PM

is this a valid prince2 practitioner dumps?
UNITED KINGDOM


asl 9/14/2023 3:59:00 PM

all are relatable questions
CANADA