DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ27

Monitor, configure, and optimize database resources

You have an Azure subscription.

You need to deploy an Azure SQL Managed Instance that meets these requirements:

  • Optimize latency.
  • Maximize the memory-to-vCore ratio.

Which service tier and hardware generation should you use?

Select
Service tier:
Hardware generation:
Explanation

The Business Critical service tier uses local SSD storage and is intended for workloads that need the lowest storage I/O latency. Premium-series - memory optimized hardware offers the greatest memory-to-vCore ratio for Azure SQL Managed Instance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!