Top Cosmos DB Interview Questions

In this post we will look at Cosmos DB Interview questions. Examples are provided with explanation.

What Is Azure Cosmos DB?

Azure Cosmos DB is a fully managed NoSQL database for modern app development. Single-digit millisecond response times, and automatic and instant scalability, guarantee speed at any scale. Business continuity is assured with SLA-backed availability and enterprise-grade security.Azure Cosmos DB takes database administration off your hands with automatic management, updates and patching. It also handles capacity management with cost-effective serverless and automatic scaling options that respond to application needs to match capacity with demand.
Azure Cosmos DB is a global distributed, multi-model database that is used in a wide range of applications and use cases. It is a good choice for any serverless application that needs low order-of-millisecond response times, and needs to scale rapidly and globally.

Features of Cosmos DB.

Complete service and ready to use: It gives you a complete product that is powered by Azure and can be automatically replicated in data centers worldwide.
Multi-API: Because data is indexed automatically, users can access it using any API of their choice. They can see their data using SQL, Gremlin, JavaScript, Azure Table Storage, and MongoDB.
Multi-API and Multi-Language Support.
Multi-Consistency Support.
Indexes Data Automatically.
High Availability.
A number of consistency levels: It uses five different consistency levels: bounded staleness, strong, session, eventual, and consistent-prefix.
Latency: Very low latency is practically guaranteed at less than 10 milliseconds when reading data and less than 15 milliseconds when writing data.
Globally Distributed.
Linearly Scalable.
Schema-Agnostic Indexing.
Multi-Model.

Explain the differences between NoSQL and relational databases.

There are two types of database systems are implemented Relational and NoSQL. There are lot of differences in these systems.

Relational Database provide store of related tables while NoSQL stores the unstructured or semi-structured data in the form of key/value or JSON documents.
Relational DB has fixed schema while NoSQL DB has dynamic schema.
Relational DB use SQL (Structured Query Language) to manage the data, NoSQL DB have many models for managing and accessing the data.
Relational Tables provide ACID guarantees but NoSQL does not provide ACID guarantees beyond the scope of single DB partition.
Relational DBs are mature, proven and widely used where as NoSQL is high performance database with ease-of-use, resilience, scalability and availability characteristics.

What is Databricks accessing in Cosmos DB?

Azure Cosmos DB is Microsoft's globally distributed, multi-model database. Azure Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure's geographic regions. It offers throughput, latency, availability, and consistency guarantees with comprehensive service level agreements (SLAs).

How Does Azure Cosmos DB Support Various Data Models Such As Key/value, Columnar, Document And Graph?

Azure Cosmos DB has a schema agnostic indexing engine capable of automatically indexing all the data it ingests without requiring any schema or secondary indexes from the developer. The engine relies on a set of logical index layouts (inverted, columnar, tree) which decouple the storage layout from the index and query processing subsystems. Cosmos DB also has the ability to support a set of wire protocols and APIs in an extensible manner and translate them efficiently to the core data model (1) and the logical index layouts (2) making it uniquely capable of supporting multiple data models natively.

What Is A Master Key?

A master key is a security token to access all resources for an account. Individuals with the key have read and write access to all resources in the database account. Use caution when you distribute master keys. The primary master key and secondary master key are available on the Keys blade of the Azure portal.

How Do I Start Developing Against The DocumentDB Api?

Microsoft DocumentDB API is available in the Azure portal. First you must sign up for an Azure subscription. Once you sign up for an Azure subscription, you can add DocumentDB API container to your Azure subscription. For instructions on adding an Azure Cosmos DB account, see Create an Azure Cosmos DB database account. If you had a DocumentDB account in the past, you now have an Azure Cosmos DB account. SDKs are available for .NET, Python, Node.js, JavaScript, and Java. Developers can also use the RESTful HTTP APIs to interact with Azure Cosmos DB resources from various platforms and languages.

What is a primary key?

A primary key is a security token to access all resources for an account. Individuals with the key have read and write access to all resources in the database account. Use caution when you distribute primary keys. The primary primary key and secondary primary key are available on the Keys blade of the Azure portal. For more information about keys, see View, copy, and regenerate access keys.

Explain the indexing in Cosmos DB.

Azure Cosmos DB is a schema-agnostic database that allows you to iterate on your application without having to deal with schema or index management. By default, Azure Cosmos DB automatically indexes every property for all items in your container without having to define any schema or configure secondary indexes. The goal of this article is to explain how Azure Cosmos DB indexes data and how it uses indexes to improve query performance. It is recommended to go through this section before exploring how to customize indexing policies.

Search Tutorials