Databricks Certified Data Engineer - Associate

Ultimate access to all questions.

In a Python notebook cell, which statement correctly reads a notebook widget and passes the Python variable to a SQL statement?

Real Exam

order_date = dbutils.widgets.get('widget_order_date')spark.sql('SELECT * FROM sales WHERE orderDate = order_date')

9.6%

order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = '{order_date}'')

47.3%

Loading comments...

order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = '${order_date}'')

16.7%

order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = 'f{order_date}'')

19.7%

order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = 'order_date'')

6.8%