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
What is a characteristic of the use of external tokenization?
Options
A External tokenization allows (he preservation of analytical values after de-identification
B External tokenization cannot be used with database replication
C Pre-loading of unmasked data is supported with external tokenization
D Secure data sharing can be used with external tokenization
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
A Data Engineer ran a stored procedure containing various transactions During the execution, the session abruptly disconnected preventing one transaction from committing or rolling hark. The transaction was left in a detached state and created a lock on resources ...must the Engineer take to immediately run a new transaction?
Options
A Call the system function SYSTEM$ABORT_TRANSACTION.
B Set the transaction abort on error to true in the stored procedure.
C Call the system function SYSTEM$CANCEL_TRANSACTION.
D Set the LOCK_TIMEOUT to FALSE in the stored procedure
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
Which methods will trigger an action that will evaluate a DataFrame? (Select TWO)
Select 2
Options
A DataFrame.col ( )
B DataFrame.show ()
C DataFrame.collect ()
D DateFrame.select ()
E DataFrame.random_split ( )
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
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!

5
Question
A Data Engineer is building a pipeline to transform a 1 TD tab e by joining it with supplemental tables The Engineer is applying filters and several aggregations leveraging Common Table Expressions (CTEs) using a size Medium virtual warehouse in a single query in Snowflake. After checking the Query Profile, what is the recommended approach to MAXIMIZE performance of this query if the Profile shows data spillage?
Options
A Switch to a multi-cluster virtual warehouse
B Increase the warehouse size
C Rewrite the query to remove the CTEs.
D Enable clustering on the table
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.