A multi-tenant SaaS application uses Azure Database for PostgreSQL. Each tenant has its own data, and the application frequently queries data by tenant_id and a date range. The team is debating between a single shared table with a tenant_id column versus a separate schema per tenant. Which design decision best balances performance, manageability, and data isolation?

Use a JSONB column to store tenant-specific data and query it with GIN indexes.

Use a separate schema per tenant and create identical tables in each schema.

Use a single shared table with a composite index on (tenant_id, date_column) and enforce tenant_id in every query.

Use a single table without any index on tenant_id and rely on application-level filtering.

Which technique helps reduce connection overhead and improve throughput when an application makes many short-lived database calls to Azure Database for PostgreSQL?

Increasing the number of concurrent connections

Using a single connection for all queries

Microsoft Certified:Azure AI Cloud Developer Associate

Domain 2Objective 2

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

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 21–25

21expert · hard
A multi-tenant SaaS application uses Azure Database for PostgreSQL. Each tenant has its own data, and the application frequently queries data by tenant_id and a date range. The team is debating between a single shared table with a tenant_id column versus a separate schema per tenant. Which design decision best balances performance, manageability, and data isolation?
Select an answer first
22foundation · easy
Which Azure Database for PostgreSQL setting directly controls the amount of CPU and memory available to the database server?
Select an answer first
23foundation · easy
Which PostgreSQL data type is used to store an embedding vector in a table when using pgvector?
Select an answer first
24foundation · easy
Which pgvector index type is designed to reduce compute overhead during approximate nearest neighbor (ANN) searches?
Select an answer first
25foundation · easy
Which technique helps reduce connection overhead and improve throughput when an application makes many short-lived database calls to Azure Database for PostgreSQL?
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 5)

Questions 21–25

Which Azure Database for PostgreSQL setting directly controls the amount of CPU and memory available to the database server?

Which PostgreSQL data type is used to store an embedding vector in a table when using pgvector?

Which pgvector index type is designed to reduce compute overhead during approximate nearest neighbor (ANN) searches?

Which technique helps reduce connection overhead and improve throughput when an application makes many short-lived database calls to Azure Database for PostgreSQL?

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