Configuring relational data services Flashcards

1
Q

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

A

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.)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

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.)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What can you configure for read-replicas?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How are read-replicas updated?

A

Asynchronously with the master server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What would you use read-replicas for?

A

Read-intensive workloads like BI and analytics.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What wouldn’t you use read-replicas for?

A

Write-intensive workloads.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly