Azure SQL Database Deployment Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Deploy Azure SQL Solutions

What you'll be asked

  1. Which Azure SQL deployment option is best suited for a single application that requires a dedicated set of resources and does not need to share capacity with other databases?
  2. You are migrating an on-premises SQL Server instance to Azure. The application requires cross-database queries and SQL Agent jobs. Which deployment option provides the highest level of compatibility with on-premises SQL Server?
  3. You have 50 small databases with unpredictable usage patterns. You want to minimize costs by sharing resources among these databases. What should you implement?
  4. When deploying an Azure SQL Database, which purchasing model allows you to scale compute and storage independently and provides the flexibility to use existing on-premises SQL Server licenses?
  5. You are configuring a new Azure SQL Managed Instance. You need to ensure the instance is isolated from the public internet and can communicate securely with your on-premises network via ExpressRoute. What must you configure during deployment?

Answers and explanations come after you submit.