An application requires PostgreSQL-specific supported extensions and the team wants managed backups and patching. What should the architect recommend?

Choose the single best answer.

A.Azure SQL Database because SQL syntax guarantees PostgreSQL extension compatibility
B.SQL Server on an Azure VM because guest access supplies PostgreSQL extensions to SQL Server
C.Azure Database for PostgreSQL flexible server after checking versions and extension support
D.Cosmos DB for NoSQL because JSON support guarantees relational compatibility

Show the answer and explanation

✓ Correct answer

Azure Database for PostgreSQL flexible server after checking versions and extension support

Flexible server preserves PostgreSQL with supported extensions and managed operations. SQL syntax does not make Azure SQL or SQL Server PostgreSQL-compatible. Cosmos JSON support does not supply the required engine. Source guide: PDF page 23.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.