SnowPro Advanced: Data Engineer — Question 23

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

Answer options

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

Correct answer: B, E

Explanation

The methods DataFrame.collect() and DataFrame.show() both cause the DataFrame to be evaluated by triggering actions that retrieve data from the DataFrame. In contrast, DataFrame.random_split(), DataFrame.select(), and DataFrame.col() are transformations that do not execute until an action is called.