Logo ExamsQA
Exit
Official Bank 0/65

SnowPro Advanced Data Engineer Certification (DEA-C01) - Snowflake Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
65 Total Questions
1
Question
A company built a sales reporting system with Python, connecting to Snowflake using the Python Connector. Based on the user's selections, the system generates the SQL queries needed to fetch the data for the report First it gets the customers that meet the given query parameters (on average 1000 customer records for each report run) and then it loops the customer records sequentially Inside that loop it runs the generated SQL clause for the current customer to get the detailed data for that customer number from the sales data table

When the Data Engineer tested the individual SQL clauses they were fast enough (1 second to get the customers 0 5 second to get the sales data for one customer) but the total runtime of the report is too long

How can this situation be improved?
Options
A Increase the number of maximum clusters of the virtual warehouse
B Rewrite the report to eliminate the use of the loop construct
C Define a clustering key for the sales data table
D Increase the size of the virtual warehouse
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
How can the following relational data be transformed into semi-structured data using the LEAST amount of operational overhead?

Exhibit
Options
A Use the OBJECT_CONSTRUCT function to return a Snowflake object
B Use the TO_VARIANT function to convert each of the relational columns to VARIANT.
C Use the PAESE_JSON function to produce a variant value
D Use the to_json function
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
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. ..... recommended way to ingest this data?
Options
A Use Snowpipe to ingest the files that land in an external stage into a Snowflake table
B Use a COPY INTO command to ingest the PDF files in an external stage into a Snowflake table with a VARIANT column.
C Create an external table on the PDF files that are stored in a stage and parse the data nto structured data
D Create a Java User-Defined Function (UDF) that leverages Java-based PDF parser libraries to parse PDF data into structured data
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
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?
Options
A Decrease the buffer size to trigger delivery of files sized between 100 to 250 MB in Kinesis Firehose
B Split the files before loading them and set the SIZE_LIMIT option to 250 MB.
C Change the file compression size and increase the frequency of the Snowpipe loads
D Increase the size of the virtual warehouse used by Snowpipe.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
A Data Engineer executes a complex query and wants to make use of Snowflake s query results caching capabilities to reuse the results.

Which conditions must be met? (Select THREE).
Select 3
Options
A The query must be executed using the same virtual warehouse.
B The new query must have the same syntax as the previously executed query.
C The micro-partitions cannot have changed due to changes to other data in the table
D The table structure contributing to the query result cannot have changed
E The USED_CACHED_RESULT parameter must be included in the query.
F The results must be reused within 72 hours.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.