Summary: Dp-201 Designing An Azure Data Solution

Read the summary and the most important questions on DP-201 Designing An azure data solution

• 1 Introduction

  This is a preview. There are 2 more flashcards available for chapter 1
  Show more cards here

• What Azure relational datastore services is this about?

  Azure SQL database
  Azure Synapse Analytics

• What azure non-relational datastore services is this about?

  Cosmos DB
  Data lake storage gen2
  BLOB storage

• What kind of solutions should you be able to design for relational and non-relational datastore services?

  Data distribution and partition
  High scalability, taking into account multiple regions, latency and throughput
  Disaster recovery
  High availability

• What types of data processing solutions exists?

  Batch processing
  Stream processing

• One of the data processing solutions you need to know about is stream processing. You need to know which two tools you can use to design solutions?

  Stream analytics
  Azure Databricks

• 2 Azure storage

• 2.1 Azure storage

  This is a preview. There are 3 more flashcards available for chapter 2.1
  Show more cards here

• If you don't need a full-blown database, than azure storage is the way to go. Why?

  It is durable
  Highly available
  stores redundantly
  It is secure (encrypted, fine grain access)
  Scalable without provisioning hardware for it.

• Eventhough data is stored redundantly, there are 4 redundancy options available. Which are there (from cheapest to most expensive)?

  Locally redundant (LRS)
  Zone-Redundant (ZRS)
  Geo-Redundant (GRS)
  Read-access Geo-Redundant (RA-GRS)

• What methods are there to copy data to and from Azure storage (4)?

  AzCopy Utility
  Azure Powershell
  Azure Storage SDK (for programming languages)
  StorSimple

• Blob-storage is cheaper than File storage. There are also options to make it even cheaper. Which three options are there?

  Premium storage
  Hot. Data is accessed frequently.
  Cool. Not accessed frequently.
  Archive. Almost never accessed.

• 2.3.1 Azure SQL database

  This is a preview. There are 2 more flashcards available for chapter 2.3.1
  Show more cards here

• name all the database deployment models for the Azure SQL database

  1. Single database (Fully managed single database)
     
  2. Elastic pool (collection of single SQL Servers sharing resources)
  3. Managed instance (SQL Server as a Service)
  4. SQL server on a Server VM.