Configuring relational data services

Question 1

What three things can you configure for an Azure database for PostgreSQL? Give a summary of each.

Answer 1

Parameters. (Not all native parameters are supported or available)

Extensions. (Not all native Postgres extensions are supported)

Read replicas - you can configure up five read-replicas to improve performance and scale read-intensive workloads. (Each read replica incurs a cost for the provisioned compute.)

Question 2

What two things can you configure for an Azure database for MySQL? Give a summary of each.

Answer 2

Parameters. (Not all parameters can be adjusted)

Read replicas - you can configure up five read-replicas to improve performance and scale read-intensive workloads. (Each read replica incurs a cost for the provisioned compute.)

Question 3

What can you configure for read-replicas?

Answer 3

Where they’re replicated to (for non-basic servers).

Question 4

How are read-replicas updated?

Answer 4

Asynchronously with the master server.

Question 5

What would you use read-replicas for?

Answer 5

Read-intensive workloads like BI and analytics.

Question 6

What wouldn’t you use read-replicas for?

Answer 6

Write-intensive workloads.