Courseiva

DP-600 · topic practice

Troubleshooting practice questions

Practise Microsoft Fabric Analytics Engineer Associate Troubleshooting practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Editorial oversight:Johnson Ajibi· MSc IT Security, IEEE Senior Member
6 questionsDomain: Troubleshooting

What the exam tests

What to know about Troubleshooting

Troubleshooting questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Troubleshooting exam traps

  • ▸Answering from memory before reading the full scenario.
  • ▸Missing a constraint such as cost, availability, security, scope or command context.
  • ▸Choosing a broad answer when the question asks for the most specific fix.
  • ▸Ignoring why the wrong options are tempting.

Practice set

Troubleshooting questions

6 questions · select your answer, then reveal the explanation

You are troubleshooting a Microsoft Fabric Lakehouse that is experiencing slow query performance when using SQL endpoints. You notice that many small Parquet files are being generated by frequent data ingestion jobs. What should you do to improve query performance?

Question 2mediummultiple choice
Read the full Troubleshooting explanation →

You are troubleshooting a scheduled refresh failure for a Dataflow Gen2 in Microsoft Fabric. The error log indicates that the destination lakehouse is inaccessible. What is the most likely cause?

You are troubleshooting a slow-running Spark job in a Fabric notebook. Which TWO metrics should you analyze to identify potential bottlenecks in your data processing job?

Refer to the exhibit. You are troubleshooting a failed automated deployment in a Microsoft Fabric environment. The deployment pipeline is triggered by a Service Principal via the REST API. Based on the error log, which maintenance action is required to resolve this issue?

Exhibit

{
  "error": {
    "code": "PowerBINotAuthorizedException",
    "message": "Service principal is not allowed to access the requested resource.",
    "details": [
      {
        "message": "The service principal does not have 'Member' or 'Admin' permissions on the workspace."
      }
    ]
  }
}

You are troubleshooting a failure in a Microsoft Fabric Data Factory pipeline. The error log indicates a 'Timeout' occurred during a 'Copy Data' activity from an on-premises SQL Server. Which maintenance action is most likely to resolve the issue?

Question 6mediummultiple choice
Read the full Troubleshooting explanation →

You are a Fabric analytics engineer. Your team uses a deployment pipeline to promote content from a development workspace to a test workspace. After a recent deployment, users in the test workspace report that they cannot see the latest changes to a report. You need to troubleshoot the deployment pipeline. Which action should you take first?

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Focused Troubleshooting sessions

Start a Troubleshooting only practice session

Every question in these sessions is drawn from the Troubleshooting domain — nothing else.

Related practice questions

Related DP-600 topic practice pages

Move into related areas when this topic feels solid.

Frequently asked questions

What does the DP-600 exam test about Troubleshooting?
Troubleshooting questions test whether you can apply the concept in context, not just recognise a definition.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Troubleshooting questions in a focused session?
Yes — the session launcher on this page draws every question from the Troubleshooting domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other DP-600 topics?
Use the topic links above to move to related areas, or go back to the DP-600 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the DP-600 exam covers. They are not copied from any real exam or dump site.