Microsoft Azure Data Fundamentals DP-900 Practice Question
An organization uses the PostGIS extension in its on-premises PostgreSQL 14 database. It plans to migrate to Azure but does not want to manage operating-system patches or database engine upgrades. Which Azure service should you recommend to host the workload while retaining full PostgreSQL compatibility and support for PostGIS?
The workload requires a managed PostgreSQL service that keeps the community engine and its extensions, including PostGIS, while eliminating the need for customers to maintain the underlying virtual machines or apply engine updates. Azure Database for PostgreSQL Flexible Server is Microsoft's fully managed PostgreSQL offering; it runs the open-source PostgreSQL engine, supports popular extensions such as PostGIS, and handles patching, backups, and high availability.
Azure SQL Managed Instance is a managed SQL Server service and is not compatible with PostgreSQL. Azure Database for MySQL Flexible Server uses the MySQL engine, not PostgreSQL. Azure Cosmos DB Core (SQL) API is a NoSQL document database service that does not run PostgreSQL or support PostGIS. Therefore, Azure Database for PostgreSQL Flexible Server is the only option that meets all stated requirements.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the benefit of using Azure Database for PostgreSQL Flexible Server for PostGIS workloads?
Open an interactive chat with Bash
What is the key difference between Azure Database for PostgreSQL Flexible Server and Azure SQL Managed Instance?
Open an interactive chat with Bash
What is PostGIS and why is it important for PostgreSQL databases?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .