SKILL BENCHMARK

AZ-305: Design Data Storage Solutions Proficiency

  • 25m
  • 25 questions
The AZ-305: Design Data Storage Solutions Proficiency benchmark measures your ability to recommend database service tier sizing, recommend a solution for database scalability, and encrypt data. You will be assessed on your ability to design solutions for data integration and data analysis, and recommend a solution for storing relational, semi-structured, and non-relational data. You will also be evaluated on your ability to design a data solution for protection and durability, and recommend access control solutions to data storage. A learner who scores high on this benchmark demonstrates that they have the skills to design and recommend a data storage solution for relational and non-relational data.

Topics covered

  • allow storage account access from specific networks
  • automate storage account blob lifecycle activities
  • configure database sizing and scalability settings
  • create a managed disk and attach it to a VM
  • create an Azure key vault using the portal
  • create a SAS for a storage account
  • demonstrate how to enable high availability for Azure SQL
  • demonstrate how to manage Azure SQL configuration settings
  • demonstrate how to upload blobs using PowerShell
  • demonstrate how to upload blobs using the Azure portal
  • determine when Azure HDInsight should be used
  • determine when Azure Synapse Analytics should be used
  • enable managed Transparent Data Encryption (TDE) for Azure databases
  • encrypt an Azure storage account with a customer-managed key
  • manage key vault items using PowerShell
  • manage storage account data archiving
  • manage the blob soft delete feature
  • map a mount point to an Azure Files share
  • set a legal hold policy on a blob container
  • use Azure Storage Explorer to manage blobs
  • use the Azure portal to deploy Azure SQL
  • use the Azure portal to manage an Azure Files share
  • use the CLI to manage an Azure Files share
  • use the portal to manage storage account keys
  • use the storage explorer GUI tool to manage storage account contents