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

Questions 31–35

1. 31foundation · easy

   A Dataflow Gen2 in Fabric fails with an error indicating 'DataFormat.Error: Invalid cell value'. What does this error typically indicate?

   • AThe dataflow has exceeded the maximum number of steps
   • BA cell contains a value that does not match the expected data type
   • CThe destination table does not exist
   • DThe source file is too large to be loaded
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   An Eventstream in Microsoft Fabric fails to deserialize incoming JSON events because the schema has changed. Which of the following is the most appropriate solution?

   • AIncrease the throughput of the eventstream
   • BChange the source to a different event hub
   • CUpdate the event schema in the eventstream to match the new JSON structure
   • DDisable the eventstream and re-enable it
   Reveal Solution Discussion Select an answer first
4. 33foundation · easy

   A Dataflow Gen2 in Fabric fails because a column contains values that cannot be converted to a number. Which of the following is the most appropriate solution?

   • AChange the data type of the column to text
   • BRemove the column from the dataflow
   • CIgnore the error and refresh the dataflow
   • DUse the 'Replace errors' transformation to replace error values with a default
   Reveal Solution Discussion Select an answer first
5. 34application · medium

   A Fabric data pipeline copies data from an Azure SQL Database to a Lakehouse table. The pipeline ran successfully for weeks, but last night it failed at the 'Copy data' activity with an error indicating a 'OneLake shortcut' path is invalid. The source and destination were unchanged. Which action should you take first?

   • ARecreate the OneLake shortcut to the source database.
   • BVerify that the shortcut referenced in the destination path still exists and points to the correct location.
   • CCheck the source database firewall rules for the pipeline's IP address.
   • DChange the pipeline to use the Lakehouse's default file path instead of a shortcut.
   Reveal Solution Discussion Select an answer first
6. 35expert · hard

   A T-SQL stored procedure in a Fabric Warehouse fails with error 2627, 'Violation of PRIMARY KEY constraint.' The procedure inserts new records into a table. The table was recently recreated with a new primary key column. Which action should you take?

   • AIncrease the stored procedure's execution timeout.
   • BCheck the source data for duplicate values in the new primary key column.
   • CChange the stored procedure to use a different table.
   • DDisable the primary key constraint temporarily.
   Reveal Solution Discussion Select an answer first