Apache Cassandra– Gaining the Azure Data Engineer Associate Certification
If you have an on‐premises NoSQL Cassandra database and want to migrate to the Azure platform, choose this service. When you migrate to Azure, you no longer need to manage nodes, clusters, or the OS. All of that is outsourced to Azure. Data is queried using the Cassandra Query Language (CQL), and you can use the client drivers you are already familiar with for accessing via code.
Table API
The Azure Cosmos DB Table API is the same concept as an Azure Table, where it stores keys and their values. You can store a massive number of these pairs, and querying them is also very fast. There is a guarantee of <10 ms latency for reads and writes, 10 million operations per second, and the global distribution you would expect from an Azure Cosmos DB API. None of those mentioned features is available using the standard Azure Table feature found in the Azure Storage account. If you want those features, then it is easy to migrate between an Azure Table and an Azure Cosmos DB Table API.
Gremlin (Graph)
Gremlin is a graph database service useful for storing data as it appears in the real world. Using the Gremlin query language, based on Apache TinkerPop project, you can access and manipulate data. The Gremlin API on Azure Cosmos DB is recommended for new workloads you want to run on the Azure platform. A graph database represents data at the storage layer instead of at a table layer. For example, if you had a relational database and wanted to store information about people, the accounts they have, and their location, you would probably create three tables and link them together with primary and foreign keys. With a graph database, each of those three would be represented by a node, and the relationship is bound between nodes and not between the data that exists within them.
Azure SQL Server Products
Microsoft SQL Server has been around for some time. It is a RDBMS created by Microsoft and uses SQL queries to manage the data stored within it. All the common concepts that go along with an RDBMS apply, like primary/foreign keys, triggers, indexes, and stored procedures. There are a lot of customers who run very large workloads on this RDBMS on Azure and in private datacenters. Numerous SQL Server offerings are available on Azure. Azure SQL is a group of products that use the SQL Server database engine in the cloud. Each of the products is described in more detail next.
SQL Server on Virtual Machines
Running this product is identical to running a full version of Microsoft SQL Server in your private datacenter. When you migrate that to Azure, though, you no longer need to manage the hardware and networking aspects. Since an Azure VM is an IaaS cloud service, you are still required to manage updates to the operating system (both Windows and Linux are supported) and SQL Server version and patches. It is still a very cost‐effective solution and a vast variety of VM sizes and locations are available to run your data service on.
If you have an on‐premises NoSQL Cassandra database and want to migrate to the Azure platform, choose this service. When you migrate to Azure, you no longer need to manage nodes, clusters, or the OS. All of that is outsourced to Azure. Data is queried using the Cassandra Query Language (CQL), and you can use…
