This DP-300 practice question tests your understanding of monitor, configure, and optimize database resources. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. A key principle to apply: storage autogrow. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
Network Topology
Refer to the exhibit. You review the configuration of an Azure SQL Database. Which statement about this database is true?
Network Topology
A
The database can automatically increase storage.
Option A is correct because the storage profile shows autogrow enabled, allowing the database to automatically increase storage when needed.
B
Geo-redundant backup storage is enabled.
Why wrong: Option B is wrong because geo-redundant backup storage is not enabled; it is configured as locally redundant.
C
The database uses zone-redundant high availability.
Why wrong: Option C is incorrect because the high availability configuration is not zone-redundant; it is configured as locally redundant.
D
The database is using the Hyperscale service tier.
Why wrong: Option D is wrong because the service tier shown is General Purpose, not Hyperscale.
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The database can automatically increase storage.
Option A is correct because the storage profile shows autogrow enabled, allowing the database to automatically increase storage when needed. Option B is wrong because geo-redundant backup storage is not enabled; it is configured as locally redundant. Option C is wrong because the high availability configuration is not zone-redundant; it uses locally redundant storage. Option D is wrong because the service tier shown is General Purpose, not Hyperscale.
Key principle: Storage autogrow
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 can automatically increase storage.
Why this is correct
Option A is correct because the storage profile shows autogrow enabled, allowing the database to automatically increase storage when needed.
Related concept
Storage autogrow
✗
Geo-redundant backup storage is enabled.
Why it's wrong here
Option B is wrong because geo-redundant backup storage is not enabled; it is configured as locally redundant.
✗
The database uses zone-redundant high availability.
Why it's wrong here
Option C is incorrect because the high availability configuration is not zone-redundant; it is configured as locally redundant.
✗
The database is using the Hyperscale service tier.
Why it's wrong here
Option D is wrong because the service tier shown is General Purpose, not Hyperscale.
Common exam traps
Common exam trap: answer the scenario, not the keyword
Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.
Trap categories for this question
Command / output trap
Option D is wrong because the service tier shown is General Purpose, not Hyperscale.
Detailed technical explanation
How to think about this question
Treat this as a scenario question. Identify the problem, the constraint, and the best action. Then compare each option against those facts.
KKey Concepts to Remember
Storage autogrow
Geo-redundant backup storage
Zone-redundant high availability
General Purpose service tier
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Storage autogrow
Real-world example
How this comes up in practice
A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this DP-300 question in full detail.
Monitor, configure, and optimize database resources — This question tests Monitor, configure, and optimize database resources — Storage autogrow.
What is the correct answer to this question?
The correct answer is: The database can automatically increase storage. — Option A is correct because the storage profile shows autogrow enabled, allowing the database to automatically increase storage when needed. Option B is wrong because geo-redundant backup storage is not enabled; it is configured as locally redundant. Option C is wrong because the high availability configuration is not zone-redundant; it uses locally redundant storage. Option D is wrong because the service tier shown is General Purpose, not Hyperscale.
What should I do if I get this DP-300 question wrong?
Review storage autogrow, then practise related DP-300 questions on the same topic to reinforce the concept.
What is the key concept behind this question?
Storage autogrow
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.