Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
In a Python notebook cell, which statement correctly reads a notebook widget and passes the Python variable to a SQL statement?
A
order_date = dbutils.widgets.get('widget_order_date')spark.sql('SELECT * FROM sales WHERE orderDate = order_date')
B
order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = '{order_date}'')
C
order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = '${order_date}'')
D
order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = 'f{order_date}'')
E
order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = 'order_date'')
