Schema Design and Data Types Quiz

Quiz covering Azure PostgreSQL for AI

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   Which extension must be enabled in Azure Database for PostgreSQL to support vector similarity search for AI applications?

2. 2

   When designing a schema for storing high-dimensional embeddings, which data type should be used for the vector column?

3. 3

   You are building a RAG (Retrieval-Augmented Generation) application. Why is it recommended to use an HNSW index on your vector column?

4. 4

   When storing metadata associated with AI embeddings, why is 'jsonb' often preferred over a strictly relational schema?

5. 5

   You have a table with 10 million vectors. You notice that queries using the '<=>' operator are performing full table scans. What is the most likely cause?