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 11–15 (page: 4)

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

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 = '"'

Answer(s): D



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 M
  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.

Answer(s): D



What is a characteristic of the operations of streams in Snowflake?

  1. Whenever a stream is queried, the offset is automatically advanced.
  2. When a stream is used to update a target table, the offset is advanced to the current time.
  3. Querying a stream returns all change records and table rows from the current offset to the current time.
  4. Each committed and uncommitted transaction on the source table automatically puts a change record in the stream.

Answer(s): B



At what isolation level are Snowflake streams?

  1. Snapshot
  2. Repeatable read
  3. Read committed
  4. Read uncommitted

Answer(s): B



A CSV file, around 1 TB in size, is generated daily on an on-premise server. A corresponding table, internal stage, and file format have already been created in Snowflake to facilitate the data loading process.

How can the process of bringing the CSV file into Snowflake be automated using the LEAST amount of operational overhead?

  1. Create a task in Snowflake that executes once a day and runs a COPY INTO statement that references the internal stage. The internal stage will read the files directly from the on-premise server and copy the newest file into the table from the on-premise server to the Snowflake table.
  2. On the on-premise server, schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage. Create a task that executes once a day in Snowflake and runs a COPY INTO statement that references the internal stage. Schedule the task to start after the file lands in the internal stage.
  3. On the on-premise server, schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage. Create a pipe that runs a COPY INTO statement that references the internal stage. Snowpipe auto-ingest will automatically load the file from the internal stage when the new file lands in the internal stage.
  4. On the on-premise server, schedule a Python file that uses the Snowpark Python library. The Python script will read the CSV data into a DataFrame and generate an INSERT INTO statement that will directly load into the table. The script will bypass the need to move a file into an internal stage.

Answer(s): B



  PDF
Viewing page 4 of 24
Viewing questions 16 - 20 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!