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

Questions 21–25

1. 21foundation · easy

   An Eventhouse in Microsoft Fabric fails to query data with an error stating 'Query execution timed out'. Which of the following is the most likely cause?

   • AThe user does not have permission to run queries
   • BThe query is too complex or the data volume is too large
   • CThe data source is offline
   • DThe Eventhouse is not configured with a database
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A Dataflow Gen2 uses a 'Remove rows' step to filter out blank values. The dataflow succeeds but the output table has fewer rows than expected. Which action should you take?

   • AChange the output table's schema to allow more rows.
   • BIncrease the dataflow's timeout setting.
   • CChange the 'Remove rows' step to 'Remove errors' to handle invalid values.
   • DReview the 'Remove rows' step to ensure the filter condition is correct.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A OneLake shortcut to an external S3 bucket shows a 'Permission denied' error when a user tries to read files. The shortcut was created with a set of access keys. Which action should you take?

   • AChange the shortcut to use a different S3 bucket.
   • BVerify that the access keys stored in the shortcut are still valid and have read permissions on the S3 bucket.
   • CAsk the user to clear their browser cache.
   • DRecreate the shortcut with a different shortcut name.
   Reveal Solution Discussion Select an answer first
5. 24expert · hard

   An Eventstream is configured to send data to both an Eventhouse and a Lakehouse. The Eventhouse destination works, but the Lakehouse destination fails with 'Authentication failed'. The Eventstream uses a system-assigned managed identity. The Lakehouse's workspace has a firewall enabled. What should you do?

   • AChange the Eventstream's managed identity to a user-assigned managed identity
   • BDisable the Lakehouse workspace's firewall
   • CAdd the Eventstream's managed identity to the Lakehouse workspace's firewall allowlist
   • DUse a shared access signature instead of the managed identity
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   A data pipeline in Fabric fails intermittently due to transient network issues. Which of the following is the most appropriate technique to resolve this?

   • AIncrease the timeout of the pipeline run
   • BDisable the pipeline schedule to avoid failures
   • CChange the data source to a different location
   • DImplement retry policies on the pipeline activities
   Reveal Solution Discussion Select an answer first