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

Questions 41–45

1. 41foundation · easy

   A OneLake shortcut in Microsoft Fabric fails with an 'Access denied' error. Which of the following is the most appropriate solution?

   • ADelete the shortcut and create a new one
   • BChange the shortcut type to a different source
   • CGrant the appropriate permissions on the target location to the user or service principal
   • DRecreate the shortcut with a different name
   Reveal Solution Discussion Select an answer first
2. 42foundation · easy

   A T-SQL query in Microsoft Fabric fails with a 'Divide by zero error'. Which of the following is the most effective way to resolve this?

   • AIncrease the precision of the numeric data type
   • BChange the query to use FLOAT data type
   • CUse NULLIF to prevent division by zero
   • DRemove the division operation from the query
   Reveal Solution Discussion Select an answer first
4. 43application · medium

   A T-SQL query in a Fabric Warehouse fails with error 8115, 'Arithmetic overflow error converting expression to data type int.' The query sums a column that previously worked. Which action should you take?

   • AAdd a WHERE clause to filter out NULL values.
   • BChange the query to use the AVG function instead of SUM.
   • CCast the column to a larger data type, such as BIGINT, before performing the sum.
   • DIncrease the query's memory grant in the warehouse settings.
   Reveal Solution Discussion Select an answer first
5. 44application · medium

   A Fabric notebook fails with 'java.lang.OutOfMemoryError: Java heap space' when processing a large DataFrame. The notebook is attached to a Spark pool with a small node size. The data volume has doubled since the notebook was created. What should you do to resolve the error?

   • AIncrease the Spark pool's node size or add more executors
   • BChange the notebook's language from PySpark to Spark Scala
   • CUse a smaller file format like CSV instead of Parquet
   • DDisable the notebook's automatic checkpointing
   Reveal Solution Discussion Select an answer first
6. 45foundation · easy

   A notebook in Microsoft Fabric fails with a 'Py4JJavaError' when running a PySpark cell. What does this error typically indicate?

   • AAn exception occurred in the JVM while executing Spark code
   • BThe notebook is not attached to a Spark pool
   • CThe notebook has exceeded its execution time limit
   • DThe notebook has a syntax error in the Python code
   Reveal Solution Discussion Select an answer first