A gaming company runs a leaderboard service on Azure Database for PostgreSQL. The service experiences high latency during peak hours due to connection churn from thousands of short-lived client connections. Which change will most effectively reduce latency?

Use a read replica to offload read queries.

Increase the database server's max_connections setting to allow more concurrent connections.

Set the client's connection timeout to a lower value.

Deploy a connection pooler like PgBouncer in front of the database and configure clients to use it.

Microsoft Certified:Azure AI Cloud Developer Associate

Domain 2Objective 2

Develop AI Solutions by Using Azure Database for PostgreSQL AI-200 Practice Questions (Page 10)

Part of the Develop AI solutions by using Azure data management services domain, which accounts for 25–30% of the AI-200 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~13–24 in this domain), expect 4–8 from this objective — we provide 48 practice questions to prepare you well beyond it. (estimate)

48questions here

10free pages

13concepts

25–30%of the exam

Questions 46–48

46foundation · easy
Which PostgreSQL data type should be used to store a fixed-length string like a country code (e.g., 'US')?
Select an answer first
47foundation · easy
Which SDK would a developer use to connect a Python application to Azure Database for PostgreSQL?
Select an answer first
48application · medium
A gaming company runs a leaderboard service on Azure Database for PostgreSQL. The service experiences high latency during peak hours due to connection churn from thousands of short-lived client connections. Which change will most effectively reduce latency?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to AI-200

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “AI-200” is a trademark of its owner, used for identification only.

Develop AI Solutions by Using Azure Database for PostgreSQL AI-200 Practice Questions (Page 10)

Questions 46–48

Which PostgreSQL data type should be used to store a fixed-length string like a country code (e.g., 'US')?

Which SDK would a developer use to connect a Python application to Azure Database for PostgreSQL?

A gaming company runs a leaderboard service on Azure Database for PostgreSQL. The service experiences high latency during peak hours due to connection churn from thousands of short-lived client connections. Which change will most effectively reduce latency?

Keep studying — Develop AI solutions by using Azure data management services