Exam SnowPro Advanced Data Engineer topic 1 question 26 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer

Question #: 26
Topic #: 1

[All SnowPro Advanced Data Engineer Questions]

Which methods will trigger an action that will evaluate a DataFrame? (Choose two.)

A. DataFrame.random_split()
B. DataFrame.collect()
C. DataFrame.select()
D. DataFrame.col()
E. DataFrame.show()

Show Suggested Answer

Suggested Answer: BE 🗳️

by stopthisnow at Oct. 30, 2023, 8:52 p.m.

Comments

Submit Cancel

Snow_P

6 months, 4 weeks ago

Selected Answer: BE

collect and show are actions, for the rest Spark is just writing down what it needs to do when an action occurs

upvoted 1 times

...

stopthisnow

7 months, 2 weeks ago

Selected Answer: BE

https://docs.snowflake.com/en/developer-guide/snowpark/python/working-with-dataframes#performing-an-action-to-evaluate-a-dataframe As mentioned earlier, the DataFrame is lazily evaluated, which means the SQL statement isn’t sent to the server for execution until you perform an action. An action causes the DataFrame to be evaluated and sends the corresponding SQL statement to the server for execution.

upvoted 3 times

...