You are designing an Azure Database for PostgreSQL Flexible Server solution. The application experiences heavy read traffic from reporting dashboards, which is impacting the performance of transactional writes. You need to improve the performance of the transactional workload. What should you recommend?

Answer options:

Enable High Availability (Zone Redundant).

Deploy a read replica and route reporting traffic to it.

Scale up the compute tier of the primary server.

Enable connection pooling using PgBouncer.

How to approach this question

Identify the feature used to offload read-heavy workloads in PostgreSQL.

Full Answer

B.Deploy a read replica and route reporting traffic to it.✓ Correct

Deploy a read replica and route reporting traffic to it.

Read replicas allow you to scale out read-intensive workloads. You can replicate data from the primary server to up to five replicas, offloading reporting queries and freeing up the primary for transactions.

Common mistakes

Confusing High Availability (standby) with Read Replicas (active for reads).

Question 18 All questions Question 20

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 6

55 questions · hints · full answers · grading

More questions from this exam

Q01Contoso Ltd is a global manufacturing company with 50,000 employees. They operate a mix of on-pre...Medium Q02A financial institution has 500 Windows Server VMs on-premises and 200 VMs in Azure. They need to...Hard Q03An enterprise uses Azure Sentinel and Log Analytics. They ingest 500 GB of logs daily. The IT bud...Hard Q04You are designing a monitoring strategy for a new Azure deployment consisting of App Service, Azu...Easy Q05A healthcare company uses Microsoft Entra ID (Azure AD). They need to implement a security policy...Medium

View all 55 questions →