mediumMultiple ChoiceObjective-mapped

PL-900 Practice Question: Refer to the exhibit

Exhibit

Refer to the exhibit.

```
EXEC sp_who2
```

Output:
```
SPID  Status   Login    HostName  BlkBy  DBName   Command   CPUTime DiskIO  LastBatch
54    sleeping sa       SERVER1   .      SalesDB  AWAITING COMMAND  0       0       2023-03-15 10:00:00.000
55    runnable  user1    CLIENT1   54     SalesDB  SELECT    5000    1200    2023-03-15 10:05:00.000
```

Refer to the exhibit. A Power BI report connecting to the SalesDB database is slow. The exhibit shows a SQL Server activity snapshot. What is the most likely cause of the performance issue?

⚠ Common exam trap

The trap here is that candidates see SPID 54 as 'sleeping' and assume it is idle and harmless, missing that it still holds locks that block other queries, which is the root cause of the performance issue.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

SPID 55 is blocked by SPID 54, causing delays

The exhibit shows SPID 55 (a SELECT query) in a 'suspended' state with a non-zero 'blocked_by' column value of 54, indicating it is waiting for a lock held by SPID 54. SPID 54 is in a 'sleeping' state but still holds locks, which blocks SPID 55 from proceeding. This blocking chain directly causes the report's slow performance, as the Power BI query cannot complete until the blocking session releases its locks.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The database server has insufficient memory
Why it's wrong here
No memory-related indicators in the output.
✓
SPID 55 is blocked by SPID 54, causing delays
Why this is correct
BlkBy column shows SPID 55 is blocked by SPID 54.
✗
The SELECT query (SPID 55) is performing a table scan
Why it's wrong here
No evidence of table scan; the issue is blocking.
✗
The sleeping session (SPID 54) is using too much CPU
Why it's wrong here
Sleeping session has 0 CPU time.

Go deeper

PL-900 Practice Question: Refer to the exhibit

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question