Identify and Resolve Errors DP-700 Practice Questions (Page 6)

Questions 26–30

1. 26foundation · easy

   A T-SQL query in Microsoft Fabric fails because it references a column that does not exist. Which of the following is the most appropriate corrective action?

   • AAdd the column to the table using ALTER TABLE
   • BCorrect the column name in the query to match the table schema
   • CRemove the column from the SELECT list
   • DChange the query to use SELECT *
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A Fabric notebook runs a PySpark script that reads from a Lakehouse and writes to a delta table. The notebook fails with a 'Py4JJavaError' that mentions 'AnalysisException: Path does not exist'. The Lakehouse path was working yesterday. Which action should you first take?

   • ARestart the notebook session to clear the Py4J cache.
   • BIncrease the notebook's executor memory to handle larger files.
   • CChange the notebook to use a relative path instead of an absolute path.
   • DCheck if the Lakehouse file or folder was renamed or moved.
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   A T-SQL query in Microsoft Fabric fails with a 'Conversion failed' error. Which of the following is the most likely cause?

   • AThe query has a syntax error
   • BThe query exceeds the maximum number of joins
   • CThe query attempts to convert a value to a data type that is incompatible
   • DThe query references a non-existent table
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   A OneLake shortcut in Microsoft Fabric fails to access data with an error stating 'Access denied'. What does this error typically indicate?

   • AThe shortcut is not configured
   • BThe shortcut path is incorrect
   • CThe target data is corrupted
   • DThe user or service principal does not have permission to the shortcut's target
   Reveal Solution Discussion Select an answer first
6. 30expert · hard

   An Eventhouse receives high-volume telemetry from an Eventstream. The Eventhouse's ingestion rate is lower than the Eventstream's output rate, and the Eventstream shows a backlog. The Eventhouse has a single database with a default ingestion policy. You need to reduce the backlog without losing data. What should you do?

   • AChange the Eventstream's output to use a Lakehouse instead of the Eventhouse
   • BReduce the Eventstream's batching interval to send smaller batches more frequently
   • CIncrease the Eventhouse's ingestion capacity by scaling up the Eventhouse SKU
   • DDisable the Eventhouse's streaming ingestion policy
   Reveal Solution Discussion Select an answer first