Which line of code loads all rows from the Product table into a DataFrame using Spark SQL?

Which line of code loads all rows from the Product table into a DataFrame using Spark SQL?

• A. df = spark.read.table("Product")
• B. df = spark.read.csv("Product.csv")
• C. df = spark.sql("SELECT * FROM Product")
• D. df = spark.sql("SELECT TOP 100 * FROM Product")

Answer: (C)

Running a SQL query through SparkSession.sql is how you use Spark SQL to load data into a DataFrame. The line spark.sql("SELECT * FROM Product") asks Spark to query the Product table and return every row as a DataFrame. It leverages the Spark SQL engine to read from the catalog and materialize the full result set when you trigger an action. The other options either use the DataFrameReader API directly (not Spark SQL), load from a file rather than a registered table, or apply a limit (TOP 100) that would exclude some rows.

Running a SQL query through SparkSession.sql is how you use Spark SQL to load data into a DataFrame. The line spark.sql("SELECT * FROM Product") asks Spark to query the Product table and return every row as a DataFrame. It leverages the Spark SQL engine to read from the catalog and materialize the full result set when you trigger an action.

The other options either use the DataFrameReader API directly (not Spark SQL), load from a file rather than a registered table, or apply a limit (TOP 100) that would exclude some rows.