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

Questions 26–30

1. 26foundation · easy

   Which indexing technique is most effective for reducing latency on queries that filter by a column used in a WHERE clause?

   • ACreating a B-tree index on that column
   • BUsing a BRIN index on that column
   • CCreating a GIN index on that column
   • DAvoiding indexes to reduce overhead
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A team is using pgvector in Azure Database for PostgreSQL to perform similarity searches on a large dataset. They notice that queries consume high CPU and memory, affecting overall performance. Which approach should the team take to minimize compute overhead?

   • ADisable the index and rely on sequential scans for better performance.
   • BUse an IVFFlat index with a large number of lists to improve accuracy.
   • CIncrease the maintenance_work_mem parameter to speed up index creation.
   • DUse an HNSW index with a small value for the m parameter to reduce memory usage.
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   Which connection string parameter is commonly required to securely connect to Azure Database for PostgreSQL using an SDK?

   • Aprotocol=tcp
   • BuseSSL=false
   • Cencrypt=true
   • Dsslmode=require
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   Which PostgreSQL index type is specifically designed to accelerate full-text search queries?

   • AB-tree index
   • BBRIN index
   • CSP-GiST index
   • DGIN index
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A healthcare startup is designing a schema in Azure Database for PostgreSQL for a patient portal. Each patient can have multiple appointments, and each appointment references a doctor. The application frequently queries appointments by patient ID and by doctor ID. Which schema design best supports these queries while maintaining data integrity?

   • ACreate a single table with all patient, doctor, and appointment columns, and index only the primary key.
   • BCreate separate tables for patients and doctors, and store appointment details in a log table without foreign keys.
   • CStore appointments as a JSONB array inside the patients table to avoid joins.
   • DCreate a patients table, a doctors table, and an appointments table with foreign keys to both patients and doctors, plus indexes on patient_id and doctor_id.
   Reveal Solution Discussion Select an answer first