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
The following code is executed in a Snowflake environment with the default settings:

Exhibit

What will be the result of the select statement?
Options
A 1
B 1John
C John CUSTOMER' does not exist or is not authorized.
D SQL compilation error object
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
A Data Engineer is implementing a near real-time ingestion pipeline to toad data into Snowflake using the Snowflake Kafka connector. There will be three Kafka topics created. ……snowflake objects are created automatically when the Kafka connector starts? (Select THREE)
Select 3
Options
A internal stages
B External stages
C Materialized views
D Tasks
E Pipes
F Tables
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

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

4
Question
A stream called TRANSACTIONS_STM is created on top of a transactions table in a continuous pipeline running in Snowflake. After a couple of months, the TRANSACTIONS table is renamed transactiok3_raw to comply with new naming standards

What will happen to the TRANSACTIONS _STM object?
Options
A Reading from the traksactioks_3T>: stream will succeed for some time after the expected STALE_TIME.
B TRANSACTIONS _STM will be stale and will need to be re-created
C TRANSACTIONS _STM will be automatically renamed TRANSACTIONS _RAW_STM.
D TRANSACTIONS _STM will keep working as expected
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Which methods can be used to create a DataFrame object in Snowpark? (Select THREE)
Select 3
Options
A DataFraas.writeO
B session.builder()
C session.sql()
D session.read.json{)
E session,table()
F session.jdbc_connection()
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.