Exam Certified Data Engineer Associate topic 1 question 63 discussion

Actual exam question from Databricks's Certified Data Engineer Associate

Question #: 63
Topic #: 1

[All Certified Data Engineer Associate Questions]

A data engineer has a Python variable table_name that they would like to use in a SQL query. They want to construct a Python code block that will run the query using table_name.

They have the following incomplete code block:

____(f"SELECT customer_id, spend FROM {table_name}")

Which of the following can be used to fill in the blank to successfully complete the task?

A. spark.delta.sql
B. spark.delta.table
C. spark.table
D. dbutils.sql
E. spark.sql

Show Suggested Answer

Suggested Answer: E 🗳️

by meow_akk at Oct. 22, 2023, 4:57 a.m.

Comments

Submit Cancel

sandbar_dorados_09

2 months, 1 week ago

Selected Answer: E

spark.sql() is a PySpark function allowing the caller to execute a SQL query from Python

upvoted 1 times

...

benni_ale

6 months ago

Selected Answer: E

E is correct

upvoted 2 times

...

azure_bimonster

9 months, 2 weeks ago

Selected Answer: E

E is correct

upvoted 2 times

...

meow_akk

1 year ago

E is correct you use spark.sql to execute python comamands

upvoted 4 times

...

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 63 discussion

Comments

sandbar_dorados_09

benni_ale

azure_bimonster

meow_akk

SY0-701