Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

In a Microsoft Fabric notebook, you ingest a CSV file into a PySpark DataFrame named df by running a Python cell. In the next cell you switch the language to SQL by adding %%sql at the top and enter

SELECT * FROM df;

When the notebook runs in a pipeline, the SQL cell fails with the message "AnalysisException: Table or view not found: df". You need to correct the notebook so that the SQL cell can access the data without rewriting the query in Python. What should you do?

  • Change the language of the failing cell from %%sql to %%pyspark so the query runs in Python instead of SQL.

  • Add a PySpark cell before the SQL cell that executes df.createOrReplaceTempView("df"), then rerun the notebook.

  • Restart the notebook session to ensure the spark variable is re-initialized and rerun all cells.

  • Increase the spark.sql.shuffle.partitions setting to improve query parallelism before rerunning the pipeline.

Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize an analytics solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot