Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam DP-900 topic 1 question 92 discussion

Actual exam question from Microsoft's DP-900
Question #: 92
Topic #: 1
[All DP-900 Questions]

You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?

  • A. You need to generate reports without affecting the transactional workload.
  • B. You need to audit the transactional application.
  • C. You need to implement high availability in the event of a regional outage.
  • D. You need to improve the recovery point objective (RPO).
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
Use read-only replicas to offload read-only query workloads.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
ExamPwnr
Highly Voted 3 years, 6 months ago
Why C? It is not High Availability if you cannot write to the database. If your primary database goes down, HA means that users would continue to work as normal, but they cannot commit changes in this case (Read-Only). Answer should be only: A.
upvoted 126 times
SQLHell
2 years, 3 months ago
All the other options are managed by Azure SQL database
upvoted 3 times
...
...
learner301
Highly Voted 3 years, 6 months ago
I would go for A, read only replica is created to offload part of transactions (backup, reporting...) in order to free up resources on DB. If you want to achieve High availability use Geo redundancy
upvoted 69 times
fdlsys
3 years, 2 months ago
Secondary instance in HA is read-only for users but write-able for DB sync. So, answer is "C" - that is the actual purpose of the secondary replica(s). Referenced URL merely suggests that replicas can and should be used to offload heavy read-only (reports) workload from the primary instance, but that does not define the original purpose.
upvoted 3 times
jimakana
3 years, 1 month ago
How does this make sense to the "in the event of a regional outage" part in the answer?
upvoted 2 times
...
...
...
AGTraining
Most Recent 4 weeks ago
option A
upvoted 1 times
...
ItzFede
9 months, 1 week ago
The correct answer is A. You should implement a read-only database replica when you need to generate reports without affecting the transactional workload. By creating a read-only replica of the transactional database, you can offload the reporting workload to the replica, ensuring that the performance of the transactional workload is not impacted. This allows you to generate reports and perform analytical queries on the replica without affecting the availability or responsiveness of the primary transactional database.
upvoted 3 times
...
chiiiweiii
1 year ago
Selected Answer: A
Correct Answer
upvoted 2 times
...
milan92stankovic
1 year, 1 month ago
Selected Answer: A
Clear as a tear - A!
upvoted 2 times
...
Stuurwiel1
1 year, 2 months ago
Selected Answer: A
You should implement a read-only database replica when you need to generate reports without affecting the transactional workload. A read-only replica is a copy of the database that can be used for reporting or other read-only workloads without affecting the performance of the transactional application. This allows you to offload reporting and other read-only workloads to the replica, which can improve the performance of the transactional application.
upvoted 5 times
...
King_Lam
1 year, 2 months ago
A is correct.
upvoted 2 times
...
thakurvi
1 year, 2 months ago
Selected Answer: A
Its A for sure . C is debatable if kept for active passive config as DR
upvoted 2 times
...
Faize
1 year, 3 months ago
The right Answer is A.
upvoted 2 times
...
tizona
1 year, 3 months ago
Selected Answer: A
right answer is A
upvoted 1 times
...
WWDITDA
1 year, 9 months ago
Selected Answer: A
Absolutely correct.
upvoted 3 times
...
cmohl2013
1 year, 10 months ago
Selected Answer: A
C ist not correct: operational DBs must provide write access to be fully functional, a read-only DB will not cover for that and availability for writes is not maintained.
upvoted 4 times
...
DEMOLKID
1 year, 10 months ago
conflicto de interes
upvoted 1 times
...
bfan95
1 year, 11 months ago
Selected Answer: A
Answer: A
upvoted 2 times
...
RichMelbourne
1 year, 11 months ago
Shown on test 15/04/2022
upvoted 3 times
...
medinacau
1 year, 11 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...