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

Questions 6–10

1. 6foundation · easy

   In a Python application using psycopg2, which method is used to execute a SQL query against Azure Database for PostgreSQL?

   • Aclient.run()
   • Bconnection.query()
   • Ccursor.execute()
   • Dcommand.execute()
   Reveal Solution Discussion Select an answer first
2. 7expert · hard

   A reporting application queries a large fact table in Azure Database for PostgreSQL. The query filters on a date column and aggregates by a category column. The table is append-only and new data is inserted daily. The query plan shows a bitmap index scan, but the query is still slow. Which optimization should the developer implement?

   • ACreate a composite B-tree index on (date, category) and use it for both filtering and aggregation.
   • BCreate a BRIN index on the date column and a regular B-tree index on the category column.
   • CUse a GIN index on the category column to speed up the aggregation.
   • DPartition the table by category and create indexes on each partition.
   Reveal Solution Discussion Select an answer first
4. 8expert · medium

   A company is building a semantic search system that must handle both exact keyword matches and semantic similarity. The system uses Azure Database for PostgreSQL. Users expect fast results even with complex queries. Which approach should the team take?

   • AUse only full-text search for all queries.
   • BUse a separate search engine like Elasticsearch for all queries.
   • CUse only vector similarity search for all queries.
   • DUse a hybrid search that combines full-text search with vector similarity using a weighted score.
   Reveal Solution Discussion Select an answer first
5. 9expert · hard

   A healthcare chatbot uses RAG with Azure Database for PostgreSQL. The knowledge base contains medical articles with metadata for specialty and language. The chatbot must retrieve relevant articles for a patient query, but the query may be in multiple languages. The team wants to ensure that the retrieved articles are in the same language as the query and are relevant to the medical specialty. Which query strategy should they use?

   • AGenerate a single multilingual embedding for the query and search across all languages, then filter by specialty in the application.
   • BStore separate embeddings for each language and use a UNION query to search each language separately.
   • CGenerate a language-specific embedding for the query and use a WHERE clause to filter by language and specialty before the vector search.
   • DUse full-text search with language-specific dictionaries and then filter by specialty.
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A financial services company runs a high-throughput transaction processing application on Azure Database for PostgreSQL. The application uses a connection pooler, but during peak load, the database CPU reaches 100% and transaction latency spikes. The team suspects that the connection pooler is not the bottleneck. Which additional measure should they take to reduce latency?

   • AIncrease the connection pooler's max client connections to allow more concurrent transactions.
   • BScale up the database to a higher compute tier to provide more CPU capacity.
   • CUse a read replica to offload write transactions.
   • DSet the transaction isolation level to READ UNCOMMITTED to reduce locking overhead.
   Reveal Solution Discussion Select an answer first