Câu 37: Databricks Certified Associate Developer for Apache Spark

The code block shown below contains an error. The code block is intended to use SQL to return a new DataFrame containing column storeId and column managerName from a table created from DataFrame storesDF. Identify the error. Code block:storesDF.createOrReplaceTempView("stores")storesDF.sql("SELECT storeId, managerName FROM stores")

1. A. The createOrReplaceTempView() operation does not make a Dataframe accessible via SQL.
2. B. The sql() operation should be accessed via the spark variable rather than DataFrame storesDF. — đáp án hiện tại
3. C. There is the sql() operation in DataFrame storesDF. The operation query() should be used instead.
4. D. This cannot be accomplished using SQL – the DataFrame API should be used instead.
5. E. The createOrReplaceTempView() operation should be accessed via the spark variable rather than DataFrame storesDF.