AI-200 Data Management Services And Vector Search Practice Question
You are designing an AI architecture that stores vector embeddings in Azure Cosmos DB for NoSQL. You need to implement role-based access control (RBAC) so that specific application microservices can only execute read-only queries against the database without having permission to write or delete documents. How should you configure this?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a custom SQL role definition with read-only data actions and assign it to the microservice's managed identity
Azure Cosmos DB supports custom SQL role definitions with specific data actions (such as read vs write) assigned via role assignments to managed identities or service principals.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Configure Azure Blob Storage RBAC permissions on the Cosmos DB container
Why it's wrong here
Blob storage roles do not apply to Azure Cosmos DB containers.
- ✗
Share the primary master master-key with all microservices
Why it's wrong here
Sharing master keys grants full read/write/delete access, violating security best practices.
- ✓
Create a custom SQL role definition with read-only data actions and assign it to the microservice's managed identity
Why this is correct
Custom Cosmos DB SQL roles with specific data actions enforce least-privilege read-only access.
- ✗
Disable authentication on the Cosmos DB account during query execution
Why it's wrong here
Disabling authentication exposes the database publicly without any access control.
Quick reference
Access Control Model Comparison
| Model | Acronym | Who Controls Access? | Best For |
|---|---|---|---|
| Discretionary Access Control | DAC | Resource owner | Small teams, file shares |
| Mandatory Access Control | MAC | System / security labels | Classified govt / military |
| Role-Based Access Control | RBAC | Administrator (via roles) | Enterprise environments |
| Attribute-Based Access Control | ABAC | Policy engine (user + resource attributes) | Fine-grained, dynamic policies |
| Rule-Based Access Control | RuBAC | System rules / ACLs | Firewall rules, network ACLs |
About these practice questions
One of 507 original AI-200 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Microsoft exam blueprint
This AI-200 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AI-200 exam.