A team is running a high-throughput application that performs many short queries against Azure Database for PostgreSQL. They notice high latency due to frequent connection establishment. Which configuration should the team implement to improve throughput and reduce latency?

Disable SSL to reduce connection setup time.

Increase the max_connections parameter to allow more concurrent connections.

Use a connection pooler and set a reasonable idle timeout for pooled connections.

Set a low connection timeout to fail fast and retry quickly.

A logistics company stores shipment tracking data in Azure Database for PostgreSQL. A C# application needs to retrieve all shipments that departed after a given timestamp and are destined for a specific city. The query will be executed frequently with different timestamps and cities. Which SDK approach should the developer use?

Use Npgsql with string concatenation to build the SQL query dynamically for each request.

Use Npgsql to run a query that selects all shipments and then use LINQ to filter by timestamp and city.

Use Npgsql with parameterized SQL: SELECT * FROM shipments WHERE departure_time > @ts AND destination_city = @city.

Use Npgsql to execute a stored procedure that returns all shipments, then filter the results in C#.

Which technique is commonly used to implement semantic retrieval in Azure Database for PostgreSQL?

Using full-text search with tsvector

Storing embeddings and using vector similarity search

Creating a B-tree index on text columns

Microsoft Certified:Azure AI Cloud Developer Associate

Domain 2Objective 2

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

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 16–20

16foundation · easy
Which Azure Database for PostgreSQL feature can help manage a large number of client connections by acting as a proxy?
Select an answer first
17application · medium
A team is running a high-throughput application that performs many short queries against Azure Database for PostgreSQL. They notice high latency due to frequent connection establishment. Which configuration should the team implement to improve throughput and reduce latency?
Select an answer first
18application · medium
A logistics company stores shipment tracking data in Azure Database for PostgreSQL. A C# application needs to retrieve all shipments that departed after a given timestamp and are destined for a specific city. The query will be executed frequently with different timestamps and cities. Which SDK approach should the developer use?
Select an answer first
19foundation · easy
Which technique is commonly used to implement semantic retrieval in Azure Database for PostgreSQL?
Select an answer first
20foundation · easy
Which PostgreSQL data type is most appropriate for storing a large binary file, such as an image, in a table?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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 4)

Questions 16–20

Which Azure Database for PostgreSQL feature can help manage a large number of client connections by acting as a proxy?

A team is running a high-throughput application that performs many short queries against Azure Database for PostgreSQL. They notice high latency due to frequent connection establishment. Which configuration should the team implement to improve throughput and reduce latency?

Which technique is commonly used to implement semantic retrieval in Azure Database for PostgreSQL?

Which PostgreSQL data type is most appropriate for storing a large binary file, such as an image, in a table?

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