Knowledge check


You have customers running applications that access your PostgreSQL database. The operations these applications perform are typically queries that generate reports. These customers are located in Australia, Europe, and the United States. Your corporate headquarters is in the United States, this is where you insert, update, and delete most of the data. How can you minimize query latency for your customers?


You want to use the pgAdmin utility to monitor your database running in Azure Database for PostgreSQL. You're attempting to connect from your desktop computer. You're using the correct server name, protocol (SSL), username, and password, but you receive an error. What might the problem be?


You want to perform an online migration of an on-premises PostgreSQL database to Azure Database for PostgreSQL. Which tools should you use?


You need to configure applications so they connect to your databases in Azure Database for PostgreSQL. Where can you find this database connection information?