🧠 Quiz Library

Multimodal models, vector index types, cosine vs Euclidean distance, VECTOR_NORMALIZE, RAG patterns, and prompt engineering in SQL!

Execution plans, statistics, deadlocks, parameter sniffing, SQL Database Projects, and deployment pipelines!

SQL auditing, object permissions, TDE, TLS, Managed Identity, EXECUTE AS, and securing API endpoints!

REGEXP functions, window functions (RANK, LAG, LEAD), PIVOT, STRING_AGG, recursive CTEs, and MERGE!

PRIMARY KEY, FOREIGN KEY, CHECK, filtered indexes, included columns, and JSON_OBJECT / JSON_ARRAY functions!

Embeddings, vector indexes, hybrid search, reciprocal rank fusion, and retrieval-augmented generation in SQL!

SQL Database Projects, DAB, CDC, Change Tracking, REST/GraphQL, and Azure service integration!

Always Encrypted, RLS, Dynamic Data Masking, Query Store, DMVs, and GitHub Copilot in SQL!

CTEs, window functions, fuzzy matching, stored procedures, triggers, and error handling!

Tables, indexes, JSON columns, constraints, partitioning, temporal, ledger, and graph tables!

Model size trade-offs, embedding dimension costs, ANN recall vs latency, RAG failure modes, RRF scoring, and prompt engineering with sp_invoke_external_rest_endpoint!

DAB config file structure, pagination, CDC latency trade-offs, dacpac vs publish profiles, secrets management, and deployment controls!