Certified Data Engineer Associate Exam

Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam

Question 101

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.

Which command could the data engineering team use to access sales in PySpark?

SELECT * FROM sales

spark.table("sales")

spark.sql("sales")

spark.delta.table("sales")

Correct Answer: B

To access the Delta table named 'sales' in PySpark, the command 'spark.table('sales')' is used. This command allows the data engineering team to access the table using Python, which is necessary for implementing their tests. The other options either employ SQL directly or use incorrect syntax for the context of PySpark.

Discussion

MDWPartnersOption: B

Repeated, correct.