3 - Design Data Storage (15-20%).md

AZ-304: Design Data Storage (15-20%)

Design a solution for databases

• Select an appropriate data platform based on requirements
  • What is Azure SQL Database?
  • What is Azure SQL?
  • Understand data store models
• Recommend database service tier sizing
  • Azure SQL Database and Azure SQL Managed Instance service tiers
  • General Purpose service tier - Azure SQL Database and Azure SQL Managed Instance
• Recommend a solution for database scalability
• Recommend a solution for:
  • Azure Data Encryption at rest
  • Encryption of data in transit
  • Data in use
    • Transparent data encryption for SQL Database, SQL Managed Instance, and Azure Synapse Analytics

Design data integration

• Recommend a data flow to meet business requirements
  • Create Azure Data Factory Data Flow
  • Source transformation in mapping data flow
• Recommend a solution for data integration, including:
  • Azure Data Factory
  • Azure Databricks
  • Azure Data Lake
    • Introduction to Azure Data Lake Storage Gen2
  • Azure Synapse Analytics
    • What is dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics?

Select an appropriate storage account

• Choose between storage tiers
  • Access tiers for Azure Blob Storage - hot, cool, and archive
• Recommend a storage access solution
  • Introduction to the core Azure Storage services
  • Authorize access to blobs and queues using Azure Active Directory
  • Manage storage account access keys
• Recommend storage management tools
  • Microsoft client tools for working with Azure Storage
  • Get started with AzCopy

Return to Table of Contents