Download SnowPro Advanced Data Engineer.SnowPro-Advanced-Data-Engineer.ExamTopics.2026-08-09.139q.vcex

Vendor: Snowflake
Exam Code: SnowPro-Advanced-Data-Engineer
Exam Name: SnowPro Advanced Data Engineer
Date: Aug 09, 2026
File Size: 5 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
A Data Engineer is working on a continuous data pipeline which receives data from Amazon Kinesis Firehose and loads the data into a staging table which will later be used in the data transformation process. The average file size is 300-500 MB.
The Engineer needs to ensure that Snowpipe is performant while minimizing costs.
How can this be achieved?
  1. Increase the size of the virtual warehouse used by Snowpipe.
  2. Split the files before loading them and set the SIZE_LIMIT option to 250 MB.
  3. Change the file compression size and increase the frequency of the Snowpipe loads.
  4. Decrease the buffer size to trigger delivery of files sized between 100 to 250 MB in Kinesis Firehose.
Correct answer: D
Question 2
A Data Engineer is trying to load the following rows from a CSV file into a table in Snowflake with the following structure:
The engineer is using the following COPY INTO statement:
However, the following error is received:
Number of columns in file (6) does not match that of the corresponding table (3), use file format option error_on_column_count_mismatch=false to ignore this error File 'address.csv.gz', line 3, character 1 Row 1 starts at line 2, column "STGCUSTOMER"[6] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option.
Which file format option should be used to resolve the error and successfully load all the data into the table?
  1. ESCAPE_UNENCLOSED FIELD = '\\'
  2. ERROR_ON_COLUMN_COUNT_MISMATCH = FALSE
  3. FIELD_DELIMITER = ','
  4. FIELD_OPTIONALLY_ENCLOSED_BY = '"'
Correct answer: D
Question 3
Company A and Company B both have Snowflake accounts. Company A's account is hosted on a different cloud provider and region than Company B's account. Companies A and B are not in the same Snowflake organization.
How can Company A share data with Company B? (Choose two.)
  1. Create a share within Company A's account and add Company B's account as a recipient of that share.
  2. Create a share within Company A's account, and create a reader account that is a recipient of the share. Grant Company B access to the reader account.
  3. Use database replication to replicate Company A's data into Company B's account. Create a share within Company B's account and grant users within Company B's account access to the share.
  4. Create a new account within Company A's organization in the same cloud provider and region as Company B's account. Use database replication to replicate Company A's data to the new account. Create a share within the new account, and add Company B's account as a recipient of that share.
  5. Create a separate database within Company A's account to contain only those data sets they wish to share with Company B. Create a share within Company A's account and add all the objects within this separate database to the share. Add Company B's account as a recipient of the share.
Correct answer: A, B
Question 4
A Data Engineer wants to check the status of a pipe named my_pipe. The pipe is inside a database named test and a schema named Extract (case-sensitive).
Which query will provide the status of the pipe?
  1. SELECT SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");
  2. SELECT SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
  3. SELECT * FROM SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
  4. SELECT * FROM SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");
Correct answer: B
Question 5
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
Correct answer: C
Question 6
Which functions will compute a 'fingerprint' over an entire table, query result, or window to quickly detect changes to table contents or query results? (Choose two.)
  1. HASH(*)
  2. HASH_AGG(*)
  3. HASH_AGG(<expr>, <expr>)
  4. HASH_AGG_COMPARE(*)
  5. HASH_COMPARE(*)
Correct answer: B, C
Question 7
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
Correct answer: A, C, D
Question 8
What is a characteristic of the use of external tokenization?
  1. Secure data sharing can be used with external tokenization.
  2. External tokenization cannot be used with database replication.
  3. Pre-loading of unmasked data is supported with external tokenization.
  4. External tokenization allows the preservation of analytical values after de-identification.
Correct answer: D
Question 9
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.
Correct answer: B
Question 10
A Data Engineer has created table t1 with one column c1 with datatype VARIANT: create or replace table t1 (c1 variant);
The Engineer has loaded the following JSON data set, which has information about 4 laptop models, into the table.
The Engineer now wants to query that data set so that results are shown as normal structured data. The result should be 4 rows and 4 columns, without the double quotes surrounding the data elements in the JSON data.
The result should be similar to the use case where the data was selected from a normal relational table t2, where t2 has string data type columns model_id, model, manufacturer, and model_name, and is queried with the SQL clause select * from t2;
Which select command will produce the correct results?
Correct answer: B
Question 11
Which methods will trigger an action that will evaluate a DataFrame? (Choose two.)
  1. DataFrame.random_split()
  2. DataFrame.collect()
  3. DataFrame.select()
  4. DataFrame.col()
  5. DataFrame.show()
Correct answer: B, E
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!