Schema Design and Data Types Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Azure PostgreSQL for AI

What you'll be asked

  1. Which extension must be enabled in Azure Database for PostgreSQL to support vector similarity search for AI applications?
  2. When designing a schema for storing high-dimensional embeddings, which data type should be used for the vector column?
  3. You are building a RAG (Retrieval-Augmented Generation) application. Why is it recommended to use an HNSW index on your vector column?
  4. When storing metadata associated with AI embeddings, why is 'jsonb' often preferred over a strictly relational schema?
  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?

Answers and explanations come after you submit.