Top Cosmos DB Interview Questions
  • What Is Azure Cosmos DB? …
  • Features of Cosmos DB. …
  • Explain the differences between NoSQL and relational databases. …
  • What is Databricks accessing in Cosmos DB? …
  • How Does Azure Cosmos DB Support Various Data Models Such As Key/value, Columnar, Document And Graph? …
  • What Is A Master Key?

Azure Cosmos DB is a fully managed NoSQL database for modern app development. Single-digit millisecond response times, and automatic and instant scalability, guarantee the speed at any scale.

Azure Cosmos DB takes database administration off your hands with automatic management, updates, and patching as a fully managed service. It also handles capacity management with cost-effective serverless and automatic scaling options that respond to application needs to match capacity with demand.Table of Contents

TOP 20 Azure Cosmos DB Interview Questions and Answers 2019 | WisdomJobs

Cosmos DB Interview Questions and Answers

All questions are targeted for Azure Cosmos DB. We have a separate document for NoSQL DataBase Interview Questions. You must know have knowledge of these questions will help you to clear Azure Cosmos DB interview.

1. 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.
  • 2. What is Cosmos DB?

    Azure Cosmos DB is a multi model database service by Microsoft, that is globally distributed. It provides the capability of scale the throughput and storage across any number of azure regions with a single button click. You can manage and access the data using your favorite API including (MongoDB, SQL, Cassandra, Tables, Gremlin). Cosmos DB provides some SLA (service level agreements) for consistency guarantee, throughput, availability and latency.

    3. Explain the common use cases for Azure Cosmos DB.

    Azure Cosmos DB is a good choice for any Mobile, Web, Gaming or IOT applications that needs:

  • low and fast order of millisecond response times.
  • predictable performance
  • to automatic scale rapidly and globally
  • ability to query over schema-free data.
  • 4. How does Azure Cosmos DB provide predictable performance?

    5. What do you think about HIPAA compliances for Azure Cosmos DB ?

    HIPAA establishes the standards to use, safeguarding and disclose the identifiable health information of any individual. Azure Cosmos DB fully supports HIPAA Compliance or its HIPAA compliant. For more about HIPAA compliance visit What is HIPAA.

    6. Is there any storage limit of Cosmos DB?

    There is no storage limit for a Cosmos container. It can store any amount of data.

    7. Can I use multiple APIs to access the data in Cosmos DB?

    8. How does Cosmos DB provide support for various data models like key/value, columnar, document and graph?

    9. How does Cosmos DB cost is calculated?

    11. Describe the throughput limits of Azure Cosmos DB.

    12. Does Azure Cosmos DB provide free account?

    13. Explain the connection mode. Are Direct and Gateway connection modes encrypted?

    For more you can refer Connection Mode

    14. Explain the indexing in Cosmos DB.

    For more you can refer Indexing in Azure Cosmos DB

    15. Describe the Indexing policies in Cosmos DB.

    For more you can refer Indexing policies in Azure Cosmos DB

    16. What Indexing modes Azure Cosmos DB supports?

    17. Describe the change feed in Azure Cosmos DB.

    18. Describe the Partitioning in Azure Cosmos DB.

    19. How Azure Cosmos DB is globally distributed database?

    For more you can refer Global distribution in Cosmos DB

    20. How will you implement Azure Cosmos DB security?

    For more you can refer Security in Azure Cosmos DB

    21. Explain the ACID in Cosmos DB.

    For more you can refer ACID in Cosmos DB

    22. Explain common clauses (Select, From, Where, Order By, Group By, Offset Limit) in Azure Cosmos DB.

    23. Explain the SQL subquery and its types.

    A subquery is a query which is nested within another query. A query or statement that contains sub query is called as outer query. Sometimes subquery is known as inner query. There are two types of subqueries. Azure Cosmos DB supports only Correlated subqueries.

  • Correlated – This type of subquery is evaluated once for each row processed by outer query and this subquery reference values from outer query.
  • Non-correlated – This type of subquery does not depend on outer query. It can be run on its own without referencing values from outer query.
  • Subqueries can be further classified into three categories based on the number of rows and columns returned by the subquery as below.

  • Table – returns multiple rows and multiple columns.
  • Multi-value – returns multiple rows and single column.
  • Scalar – returns single row and single column.
  • For more you can refer

    25. How Azure Cosmos DB SQL query execution works?

    26. What APIs Azure Cosmos DB offers?

    27. What are the benefits of using server-side programming in Azure Cosmos DB?

    For more you can refer server-side programming in Cosmos DB

    28. What is Container in Cosmos DB?

    29. What is _etag in Azure Cosmos DB?

    What is Cosmos DB?Azure Cosmos DB is commonly used within web and mobile applications, and is well suited for modeling social interactions, integrating with third-party services, and for building rich personalized experiences. The Cosmos DB SDKs can be used build rich iOS and Android applications using the popular Xamarin framework. 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.

  • low and fast order of millisecond response times.
  • predictable performance
  • to automatic scale rapidly and globally
  • ability to query over schema-free data
  • To interact with a resource, you must include the authorization header with the authorization string in all REST operations, whether you’re using a master key token or a resource token. The following are the parts included in brackets: The type of token is indicated by typeoftoken: master or resource. Tokenversion refers to the token’s current version, which is 1.0. The hashed token signature is denoted by the term hassignature. To ensure that the authorisation string does not contain any erroneous characters, it should be encoded before being added to the REST request.

    Yes. The Azure Cosmos DB Emulator simulates the Cosmos DB provider with high fidelity. It has the same capabilities as Azure Cosmos DB, including instructions for building and querying JSON documents, deploying and scaling collections, and running saved tactics and triggers. You can use the Azure Cosmos DB Emulator to develop and test programmes, and then deploy them to Azure on a global scale by sending a single setup request to the Azure Cosmos DB connection endpoint.

    A primary key is a security token that allows an account to access all of its resources. Individuals who have the key have read and write access to the database account’s resources. When distributing primary keys, be cautious. On the Keys blade of the Azure portal, you can find the primary primary key and secondary primary key. See View, copy, and regenerate access keys for additional information about keys.

    You’ll need to create accounts, databases, containers, and things in Azure before you can start using Azure Cosmos DB. Accounts. Accounts are the most basic units of distribution and have a high level of availability. In Azure Cosmos DB SQL API, you can configure the region[s] for your data at the account level. The globally unique DNS name used for API queries is likewise stored in accounts. You can also specify the account’s default consistency level for requests. The Azure portal, Azure Resource Manager templates, the Azure CLI, and Azure PowerShell can all be used to manage or create accounts.

    Azure Cosmos DB is a fully machine with SLAs that guarantees latency, throughput, availability, and consistency. Because it’s a provisioned device, it has resources set aside to meet these requirements. The rapid rate of table creation is noticed and slowed. We recommend that you examine the rate at which tables appear and reduce it to less than five per minute. The Table API is a provided device, so keep that in mind. You’ll start paying for it as soon as you provide it.

    Cosmos DB Interview Questions

    Here is a list of essential Cosmos DB Interview Questions and Answers for Freshers and mid-level Experienced Professionals. All answers to these Cosmos DB questions are explained in a simple and easiest way. These basic, advanced and latest Cosmos DB questions will help you to clear your next Job interview.

    FAQ

    Is Cosmos DB NoSQL or SQL?

    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.

    Which API is best for Cosmos DB?

    Azure Cosmos DB is a fully managed, serverless NoSQL database for high-performance applications of any size or scale.

    Is Cosmos DB SAAS or PaaS?

    Core(SQL) API is native to Azure Cosmos DB. API for MongoDB, Cassandra, Gremlin, and Table implement the wire protocol of open-source database engines. These APIs are best suited if the following conditions are true: If you have existing MongoDB, Cassandra, or Gremlin applications.

    Related Posts

    Leave a Reply

    Your email address will not be published. Required fields are marked *