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.
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
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.
High availability configuration is useless if it is another part of the world... DR is choice in this case ... and hence A is the safest and correct answer
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.
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.
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.
This section is not available anymore. Please use the main Exam Page.DP-900 Exam Questions
Log in to ExamTopics
Sign in:
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.
ExamPwnr
Highly Voted 4 years, 8 months agoSQLHell
3 years, 4 months agolearner301
Highly Voted 4 years, 8 months agofdlsys
4 years, 3 months agojimakana
4 years, 2 months agoRoy34
Most Recent 3 weeks, 4 days agoAGTraining
1 year, 2 months agoItzFede
1 year, 10 months agochiiiweiii
2 years, 2 months agomilan92stankovic
2 years, 2 months agoStuurwiel1
2 years, 3 months agoKing_Lam
2 years, 3 months agothakurvi
2 years, 3 months agoFaize
2 years, 4 months agotizona
2 years, 4 months agoWWDITDA
2 years, 10 months agocmohl2013
2 years, 11 months agoDEMOLKID
2 years, 11 months agobfan95
3 years agoRichMelbourne
3 years ago