Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
Okta
Palo Alto Networks
Salesforce
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: 25-Dec-2025

Viewing Page 1 of 16
SnowPro Advanced Data Engineer PDF 162 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:

Stephen 10/3/2023 6:24:00 PM

yes, iam looking this
AUSTRALIA


Stephen 8/4/2023 9:08:00 PM

please upload cima e2 managing performance dumps
Anonymous


hp 6/16/2023 12:44:00 AM

wonderful questions
Anonymous


Priyo 11/14/2023 2:23:00 AM

i used this site since 2000, still great to support my career
INDONESIA


Jude 8/29/2023 1:56:00 PM

why is the answer to "which of the following is required by scrum?" all of the following stated below since most of them are not mandatory? sprint retrospective. members must be stand up at the daily scrum. sprint burndown chart. release planning.
UNITED STATES


Marc blue 9/15/2023 4:11:00 AM

great job. hope this helps out.
UNITED STATES


Anne 9/13/2023 2:33:00 AM

upload please. many thanks!
Anonymous


pepe el toro 9/12/2023 7:55:00 PM

this is so interesting
Anonymous


Antony 11/28/2023 12:13:00 AM

great material thanks
AUSTRALIA


Thembelani 5/30/2023 2:22:00 AM

anyone who wrote this exam recently
Anonymous


P 9/16/2023 1:27:00 AM

ok they re good
Anonymous


Jorn 7/13/2023 5:05:00 AM

relevant questions
UNITED KINGDOM


AM 6/20/2023 7:54:00 PM

please post
UNITED STATES


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

q:42 there has to be a image in the question to choose what does it mean from the options
INDIA


BrainDumpee 11/18/2023 1:36:00 PM

looking for cphq dumps, where can i find these for free? please and thank you.
UNITED STATES


sheik 10/14/2023 11:37:00 AM

@aarun , thanks for the information. it would be great help if you share your email
Anonymous


Random user 12/11/2023 1:34:00 AM

1z0-1078-23 need this dumps
Anonymous


labuschanka 11/16/2023 6:06:00 PM

i gave the microsoft azure az-500 tests and prepared from this site as it has latest mock tests available which helped me evaluate my performance and score 919/1000
Anonymous


Marianne 10/22/2023 11:57:00 PM

i cannot see the button to go to the questions
Anonymous


sushant 6/28/2023 4:52:00 AM

good questions
EUROPEAN UNION


A\MAM 6/27/2023 5:17:00 PM

q-6 ans-b correct. https://docs.paloaltonetworks.com/pan-os/9-1/pan-os-cli-quick-start/use-the-cli/commit-configuration-changes
UNITED STATES


unanimous 12/15/2023 6:38:00 AM

very nice very nice
Anonymous


akminocha 9/28/2023 10:36:00 AM

please help us with 1z0-1107-2 dumps
INDIA


Jefi 9/4/2023 8:15:00 AM

please upload the practice questions
Anonymous


Thembelani 5/30/2023 2:45:00 AM

need this dumps
Anonymous


Abduraimov 4/19/2023 12:43:00 AM

preparing for this exam is overwhelming. you cannot pass without the help of these exam dumps.
UNITED KINGDOM


Puneeth 10/5/2023 2:06:00 AM

new to this site but i feel it is good
EUROPEAN UNION


Ashok Kumar 1/2/2024 6:53:00 AM

the correct answer to q8 is b. explanation since the mule app has a dependency, it is necessary to include project modules and dependencies to make sure the app will run successfully on the runtime on any other machine. source code of the component that the mule app is dependent of does not need to be included in the exported jar file, because the source code is not being used while executing an app. compiled code is being used instead.
Anonymous


Merry 7/30/2023 6:57:00 AM

good questions
Anonymous


VoiceofMidnight 12/17/2023 4:07:00 PM

Delayed the exam until December 29th.
UNITED STATES


Umar Ali 8/29/2023 2:59:00 PM

A and D are True
Anonymous


vel 8/28/2023 9:17:09 AM

good one with explanation
Anonymous


Gurdeep 1/18/2024 4:00:15 PM

This is one of the most useful study guides I have ever used.
CANADA