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.
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.
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.
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 3 years, 6 months agoSQLHell
2 years, 3 months agolearner301
Highly Voted 3 years, 6 months agofdlsys
3 years, 2 months agojimakana
3 years, 1 month agoAGTraining
Most Recent 4 weeks agoItzFede
9 months, 1 week agochiiiweiii
1 year agomilan92stankovic
1 year, 1 month agoStuurwiel1
1 year, 2 months agoKing_Lam
1 year, 2 months agothakurvi
1 year, 2 months agoFaize
1 year, 3 months agotizona
1 year, 3 months agoWWDITDA
1 year, 9 months agocmohl2013
1 year, 10 months agoDEMOLKID
1 year, 10 months agobfan95
1 year, 11 months agoRichMelbourne
1 year, 11 months agomedinacau
1 year, 11 months ago