Azure SQL

Azure SQL

Last updated on July 3, 2023

Azure SQL Cheat Sheet

  • A fully managed database built upon the SQL Server engine.
  • SLA durability up to 99.995%.
  • SQL Databases Resource type:
    • Single Database – offers serverless and hyperscale storage (up to 100TB).
    • Elastic Pool – a collection of databases with a shared set of resources.
    • Database Server – manage groups of single databases and elastic pools.
  • SQL Managed Instances are for migrations “lift-and-shift” to the cloud.
    • The features of both SQL Server database engine and Azure SQL are available in SQL Managed Instance. 
      • PaaS benefits – Azure will handle all infrastructure management.
      • Business continuity – the data are protected with automated backups.
      • Security and compliance – supports native VNet implementation and it is exposed only through a private IP address.
      • Management operations –  automatically deploy new instances, update instance properties, and delete instances that are no longer needed.
    • Automate the migration of existing SQL Server instance to SQL Managed Instance with Azure Data Migration Service
    • Azure Hybrid Benefit for SQL Server allows you to exchange existing licenses to get discounted rates on SQL Managed Instance.
  • SQL Virtual Machines are used for applications requiring OS-level access.
  • Endpoint: <server_name>.database.windows.net
  • vCore-based service tiers:
    • General Purpose is for common workloads.
    • Hyperscale is appropriate for online transaction processing (OLTP) and hybrid transactional analytical workloads (HTAP).
    • Business Critical is best for OLTP applications with high transaction rates and low IO latency.
  • Tutorials dojo strip
  • Azure Hybrid Benefit for SQL Server enables you to use your SQL Server licenses to pay a reduced rate on Azure SQL.
  • Azure Data Studio is a modern cross-platform database tool with customizable code snippets, lightning-fast IntelliSense, useful peek definitions, and an integrated terminal to run other SQL tools.

Monitoring

  • You can use Intelligent Insights to continuously monitor your Azure SQL usage and detect disruptive events that may lead to poor database performance.
  • Azure SQL Analytics can be used to monitor your databases across multiple subscriptions. It can collect and visualize key performance metrics of your databases and enables you to create custom monitoring rules and alerts.
  • Automatic tuning in Azure SQL continuously monitors queries executed on your database, and automatically improves the performance using artificial intelligence. 

Networking

  • Private endpoint connections provide access to all databases in the server.
  • Allow communications from all resources inside the Azure boundary with firewall rules.

Azure SQL Security

  • You can use Advanced Data Security (ADS) for data classification, vulnerability assessment, and advanced threat protection.

Azure SQL Pricing

  • The resources are billed hourly at a fixed rate based on the service tier and compute size you choose.
  • You are billed for outgoing Internet traffic.

Validate Your Knowledge

Question 1

Question Type: Single choice

Note: This item is part of a series of questions with the exact same scenario but with a different proposed answer. Each one in the series has a unique solution that may, or may not, comply with the requirements specified in the scenario.

A company is migrating all its applications and data to Microsoft Azure. There is a strict requirement that the Azure environment must only be comprised of platform-as-a-service (PaaS) solutions to minimize the amount of administrative effort in managing the underlying resources.

Solution: Deploy the applications using the Azure App Service and migrate the data to Azure SQL databases.

Does this solution comply with the requirement?

  1. Yes
  2. No

Correct Answer: 1

Platform as a service (PaaS) is a complete development and deployment environment in the cloud, with resources that enable you to deliver everything from simple cloud-based apps to sophisticated, cloud-enabled enterprise applications. You purchase the resources you need from a cloud service provider on a pay-as-you-go basis and access them over a secure Internet connection.

Like IaaS, PaaS includes infrastructure – servers, storage, and networking – but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application life cycle: building, testing, deploying, managing, and updating.

PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure, and middleware, container orchestrators such as Kubernetes or the development tools, and other resources. You manage the applications and services that you develop, and the cloud service provider typically manages everything else.

In this scenario, the Azure App Service and Azure SQL Databases are both Platform as a Service (PaaS) solutions that allow the customers to deploy and run their custom applications quickly while minimizing the administrative effort in managing the underlying server resources. You can indeed deploy the applications using the Azure App Service and migrate the data to Azure SQL databases.

Hence, the correct answer is: Yes as the proposed solution is valid and complies with the requirement.

References:
https://azure.microsoft.com/en-au/overview/what-is-paas/
https://docs.microsoft.com/en-us/learn/modules/principles-cloud-computing/5-types-of-cloud-services
https://docs.microsoft.com/en-us/azure/security/fundamentals/paas-deployments

Note: This question was extracted from our AZ-900 Microsoft Azure Fundamentals Practice Exams.

Question 2

Question Type: Multiple-choice

An organization is planning to migrate all of its servers and data to Azure.

You need to recommend a solution to only use Software-as-a-Service Azure products that will support the planned migration.

Solution: Deploy Azure virtual machines and Azure SQL Database.

Does this meet the goal?

  1. Yes
  2. AWS Exam Readiness Courses
  3. No

Correct Answer: 2

Infrastructure as a service (IaaS) is an instant computing infrastructure, provisioned, and managed over the Internet. It’s one of the types of cloud services, along with software as a service (SaaS), platform as a service (PaaS), and serverless.

IaaS quickly scales up and down with demand, letting you pay only for what you use. It helps you avoid the expense and complexity of buying and managing your own physical servers and other datacenter infrastructure. Each resource is offered as a separate service component, and you only need to rent a particular one for as long as you need it. 

Platform as a service (PaaS) is a complete development and deployment environment in the cloud, with resources that enable you to deliver everything from simple cloud-based apps to sophisticated, cloud-enabled enterprise applications. You purchase the resources you need from a cloud service provider on a pay-as-you-go basis and access them over a secure Internet connection.

Like IaaS, PaaS includes infrastructure—servers, storage, and networking—but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

Azure Virtual Machines (VM) is an infrastructure as a service (IaaS) service that gives you the flexibility of virtualization without having to buy and maintain the physical hardware that runs it. However, you still need to maintain the VM by performing tasks, such as configuring, patching, and installing the software that runs on it.

Therefore, the correct answer is: No.

Reference:
https://azure.microsoft.com/en-us/overview/what-is-paas/

Note: This question was extracted from our AZ-900 Microsoft Azure Fundamentals Practice Exams.

For more Azure practice exam questions with detailed explanations, check out the Tutorials Dojo Portal:

Microsoft Azure Practice Exams Tutorials Dojo

Azure SQL Cheat Sheet Resources:

https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview
https://azure.microsoft.com/en-us/services/sql-database/

Tutorials Dojo portal

Be Inspired and Mentored with Cloud Career Journeys!

Tutorials Dojo portal

Enroll Now – Our Azure Certification Exam Reviewers

azure reviewers tutorials dojo

Enroll Now – Our Google Cloud Certification Exam Reviewers

Tutorials Dojo Exam Study Guide eBooks

tutorials dojo study guide eBook

FREE AWS Exam Readiness Digital Courses

Subscribe to our YouTube Channel

Tutorials Dojo YouTube Channel

FREE Intro to Cloud Computing for Beginners

FREE AWS, Azure, GCP Practice Test Samplers

Recent Posts

Written by: Jon Bonso

Jon Bonso is the co-founder of Tutorials Dojo, an EdTech startup and an AWS Digital Training Partner that provides high-quality educational materials in the cloud computing space. He graduated from Mapúa Institute of Technology in 2007 with a bachelor's degree in Information Technology. Jon holds 10 AWS Certifications and is also an active AWS Community Builder since 2020.

AWS, Azure, and GCP Certifications are consistently among the top-paying IT certifications in the world, considering that most companies have now shifted to the cloud. Earn over $150,000 per year with an AWS, Azure, or GCP certification!

Follow us on LinkedIn, YouTube, Facebook, or join our Slack study group. More importantly, answer as many practice exams as you can to help increase your chances of passing your certification exams on your first try!

View Our AWS, Azure, and GCP Exam Reviewers Check out our FREE courses

Our Community

~98%
passing rate
Around 95-98% of our students pass the AWS Certification exams after training with our courses.
200k+
students
Over 200k enrollees choose Tutorials Dojo in preparing for their AWS Certification exams.
~4.8
ratings
Our courses are highly rated by our enrollees from all over the world.

What our students say about us?