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

Questions 16–20

1. 16application · medium

   An Eventhouse table shows a 'Partial ingestion failure' for a batch of data. The error details indicate that some records have a timestamp in an invalid format. Which action should you take?

   • ADrop the table and recreate it with a different schema.
   • BChange the Eventstream to output data in CSV format instead of JSON.
   • CUpdate the table's ingestion mapping to use a datetime parser that matches the source format.
   • DIncrease the Eventhouse's streaming ingestion rate.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   A Dataflow Gen2 in Fabric fails with an error stating 'The key didn't match any rows in the table'. Which of the following is the most likely cause?

   • AA lookup or merge operation could not find a matching key in the referenced table
   • BThe dataflow is trying to write to a read-only destination
   • CThe source file is empty
   • DThe dataflow has a circular dependency
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A T-SQL query in a Fabric Warehouse fails with 'String or binary data would be truncated.' The query inserts rows from a staging table into a dimension table. The staging table was recently modified to include a longer product description. What should you do to resolve the error?

   • AAdd a SET ANSI_WARNINGS OFF statement before the INSERT
   • BIncrease the length of the destination column or truncate the source data explicitly
   • CChange the staging table's collation to match the destination table
   • DUse a LEFT JOIN instead of an INNER JOIN in the INSERT statement
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   A data pipeline in Fabric fails because the source data schema has changed, adding a new column. Which of the following is the most effective way to resolve this error?

   • AChange the source to a different table
   • BIgnore the error and run the pipeline again
   • CUpdate the pipeline dataset and mapping to include the new column
   • DDelete the pipeline and recreate it from scratch
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   An Eventstream ingests data from a custom application that sends events in Avro format. The Eventstream is configured to output to an Eventhouse. The Eventstream shows a 'Schema validation error' for some events. The application team says the schema is correct. Which action should you take?

   • AChange the Eventstream's output format to JSON.
   • BCheck if the Eventstream's schema registry is synchronized with the application's schema version.
   • CIncrease the Eventstream's throughput to handle more events.
   • DAsk the application team to send events in a different format.
   Reveal Solution Discussion Select an answer first