Monthly Archives: May 2020

Azure Resource Manager(ARM) is the deployment and management service on Azure that helps users to create, update and delete resources. When ARM receives a request from any of the azure tools, it forwards the request to the appropriate service after authenticating the request. Let’s have a look at some of the terms related to ARM:Continue reading “Azure Resource Manager”

Azure Portal is a GUI that lets users manage their Azure subscription. In order to login to Azure Portal, the only requirement is a valid Microsoft account i.e. username and password which can be created for free. Azure Portal Menu Azure Portal Menu provides an easy way to navigate the various features of Azure. ItContinue reading “Azure Portal Overview”

What is the main difference between Azure Data Lake Storage Gen2 (ADLS Gen2) and Synapse Analytics? ADLS Gen2 is optimized for data analytics on non-structured data while Synapse Analytics is optimized for business reporting on structured data ADLS Gen2 is built to integrate with Hadoop while Synapse Analytics is built on SQL Server ADLS Gen2Continue reading “ADE Q01: Azure Fundamentals Quiz”

Azure offers various storage tiers for storing data. The available tiers are: Premium: The premium tier provides the fastest access to stored data and is optimized for low latency use cases. The data is stored in high performance solid-state drives. Premium storage tier is only available for Azure Blob storage, while the other tiers areContinue reading “Azure Storage Tiers”

To ensure high levels of data availability, Azure always keeps multiple copies of data. Depending on the criticality and time required to enable access to the replica, there are a few data redundancy options available to customers in Azure: Locally Redundant Storage (LRS): Data is replicated across different racks in the same data center. ThisContinue reading “Azure Data Redundancy Options”

Cosmos DB provides various APIs with regards to data access from various platforms. Lets have a look at the APIs available: Source: https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/2-identify-the-technology-options Core(SQL) API: SQL API is the default API for Cosmos DB. It provides a similar functionality as a standard NoSQL data store. The main advantage of this API is that data canContinue reading “Azure Cosmos DB APIs”

Consistency models, also known as consistency levels, provide a way for developers to choose between high availability and better performance. Usually the choice is between two extremes but Cosmos DB provides a granular scale of consistency levels that can be configured to suit specific business requirement. Image source: https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels Let’s have a look at eachContinue reading “Azure Cosmos DB Consistency Models”

In the previous post, we discussed about the main features of Cosmos DB. In this post, we look at the data storage models supported by Cosmos DB in a bit more detail. Key-value: As the name suggests, data is stored as a tuple(pair), with a unique attribute(key) mapped to its corresponding content (value). Most KeyContinue reading “Azure Cosmos DB Database Models”

Cosmos DB (formerly, Document DB) is Microsoft’s premier NoSQL service offering on Azure. It is the first globally distributed, multi model database offered on cloud by any vendor. Image Source: https://docs.microsoft.com/en-us/azure/cosmos-db/introduction Lets have a look at the main features of Cosmos DB: Globally Distributed:  It is extremely easy to distribute data globally by using multipleContinue reading “Azure Cosmos DB”

Besides standard SQL Database, Azure provides a lot of specialized databases and data stores that offer unique features for specialized usage scenarios. We have already looked at some of these services in previous posts. For the sake of better understanding, I will include those services here as well. Azure Database for MySQL: This is aContinue reading “Specialized Databases and data stores on Azure”