DP-300 Plan and implement data platform resources Practice Question
Exhibit
Refer to the exhibit. Exhibit: ``` Event ID: 4140 Severity: 16 Message: Could not allocate space for object 'sys.sysrscols' in database 'mydb' because the 'PRIMARY' filegroup is full. ```
Refer to the exhibit. An Azure SQL Database administrator sees the error in the SQL Server error log. The database is in the General Purpose tier with 100 GB of storage. Which action should the DBA take to resolve the issue?
⚠ Common exam trap
Test-takers frequently confuse a full transaction log with a full database, leading them to choose 'Increase the log file size' (Option C) when the error is actually about the overall database storage limit.
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
✓
Increase the max size of the database
The error indicates the database has reached its maximum size limit of 100 GB. In Azure SQL Database General Purpose tier, the max size is set at the database level, not the log file level. Increasing the max size of the database (Option D) directly resolves the 'could not allocate space' error by allowing more data to be stored, without requiring a tier change or manual log file manipulation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Shrink the database
Why it's wrong here
Shrinking may not free space if there is no unused space.
- ✗
Scale up to a higher service objective (e.g., from GP to BC)
Why it's wrong here
Scaling up does not increase storage; it increases performance.
- ✗
Increase the log file size
Why it's wrong here
The error is about data files, not log files.
- ✓
Increase the max size of the database
Why this is correct
Increasing max size adds more space to the primary filegroup.
Visual reference
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
One of 906 original DP-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.