Which API consistency level allows reads to be served from the local region only?
ABounded staleness
BSession
CStrong
DEventual
Explanation
Session consistency allows reads to return the latest updated data per session; the others don't restrict reads to the local region.
Q32
A company needs to ingest large amounts of geospatial data into Azure Cosmos DB. Which API would be most appropriate?
ASQL API
BGremlin API
CCassandra API
DTable API
Explanation
SQL API supports geospatial data natively; the other APIs lack this feature.
Q33
What happens when a stored procedure exceeds the 5 second execution limit in Azure Cosmos DB?
AIt automatically retries.
BIt returns a timeout error.
CIt continues execution indefinitely.
DIt deletes itself.
Explanation
Stored procedures return a timeout error if execution exceeds 5 seconds; the others do not accurately describe the behavior.
Q34
Which service is used to manage data consistency in Cosmos DB?
AConsistency levels
BDatabase indexing
CPartitioning strategies
DChange feed
Explanation
Consistency levels define how data is synchronized in Cosmos DB, while the other options focus on data retention or access techniques.
Q35
A company needs to prevent unauthorized access to their Cosmos DB account. Which security feature should they implement first?
AVirtual Network Service Endpoints
BThroughput scaling
CCosmos DB triggers
DChange feed
Explanation
Virtual Network Service Endpoints limit access to network traffic, while the other options do not focus on security measures directly.
Q36
You are configuring a multi-region Cosmos DB account. What happens if one region becomes unavailable?
AData is lost
BFailover occurs automatically
COperations are stopped
DReplica data is deleted
Explanation
Automatic failover ensures continuity during regional unavailability, whereas the other options imply data issues or service disruptions that are not accurate.
Q37
Which consistency level allows reads of stale data?
AEventual
BBounded Staleness
CStrong
DSession
Explanation
Eventual consistency permits stale reads, while others do not.
Q38
A company needs to enable multi-region write support in Azure Cosmos DB. Which configuration is required?
AUse Multi-master replication
BEnable Strong consistency
CSet Request Units to low
DLimit partition keys to single region
Explanation
Multi-master replication allows multi-region writes, while others do not support that feature.
Q39
What happens when you exceed provisioned throughput in Azure Cosmos DB?
ARequests are queued
BRequests fail with 429 error
CDatabase shuts down
DThroughput is automatically increased
Explanation
Exceeding throughput results in a 429 error, indicating too many requests.
Q40
Which consistency model offers the lowest latency in Azure Cosmos DB?
AEventual Consistency
BStrong Consistency
CBounded Staleness
DSession Consistency
Explanation
Eventual Consistency provides lower latency but is less guaranteed in data availability than Strong Consistency.