Azure DP-900 Short Notes:  Explore non-relational data offerings in Azure

Azure DP-900 Short Notes: Explore non-relational data offerings in Azure

👉When data is too varied and difficult to model and when there are no inherited relationships within data, use non-relational data repositories to store such data.

Azure Table Storage

👉NoSQL key-value model non-relational database.

👉Create within azure storage account.

👉In an Azure Table Storage table, items are referred to as rows, and fields are known as columns.

👉Each row has a key and columns can vary.

👉Data stored is de-normalized.

👉Splits a table into partitions for grouping related rows, based on a common property or partition key.

👉Partitions help to improve the searching speed of data.


Azure Blob Storage

👉Store massive amounts of unstructured data, or blobs, in the cloud.

👉Support three types of blob.

  • Block blobs = Store data such as images that do not change frequently.
  • Page blobs = As virtual disk storage for virtual machines.
  • Append blobs = For append operations such as writing log files.

👉Blobs are created within containers in the storage account.

👉Three access tiers

  • Hot tier
  • Cool tier
  • Archive tier

Azure File Storage

👉Create file shares in cloud and access from anywhere with an internet connection.

👉Create within azure storage account.

👉Uses Server Message Block 3.0 (SMB) protocol.

👉Applications running on-premise or in the cloud can access file storage.

👉Upload files to file storage through azure portal or AzCopy utility.

👉Data is replicated locally within a region, but can also be geo-replicated to a second region.

👉Azure File Storage offers two performance ties.

  • Standard tier - HD
  • Premium tier - SSD

Azure Cosmos DB

👉Multi-model NoSQL database management system.

👉Manages data as a partitioned set of documents.

👉A document is a collection of fields, identified by a key.

👉Multiple APIS to access documents.

  • SQL API
  • Table API
  • MongoDB API
  • Cassandra API.
  • Gremlin API

👉Documents in a Cosmos DB database are organized into containers.

👉The documents in a container are grouped together into partitions.

👉A partition holds a set of documents that share a common partition key.