Introduction to Azure SQL Services 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 applications that require full compatibility with SQL Server features and the ability to manage the underlying operating system?
  2. You are deploying an Azure SQL Database and need to ensure that the database automatically scales compute resources based on workload demand, pausing during periods of inactivity to save costs. Which purchasing model should you choose?
  3. When configuring an Azure SQL Database, what is the primary purpose of an 'Elastic Pool'?
  4. A company requires a database solution that supports cross-database queries and SQL Agent jobs, but they want to minimize administrative overhead. Which service should they select?
  5. You are architecting a solution where you must maintain specific SQL Server instance-level configurations and registry settings while offloading the management of the underlying hardware and OS patching to Azure. Which deployment model provides the highest level of control while still being a managed service?

Answers and explanations come after you submit.