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.
- The features of both SQL Server database engine and Azure SQL are available in 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.
- 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?
- Yes
- 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?
- Yes
- 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:
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/
Get 20% Off – Christmas Big Sale on All Practice Exams, Video Courses, and eBooks!
Learn AWS with our PlayCloud Hands-On Labs
Tutorials Dojo Exam Study Guide eBooks
FREE AWS Exam Readiness Digital Courses
FREE AWS, Azure, GCP Practice Test Samplers
Subscribe to our YouTube Channel
Follow Us On Linkedin
Written by: Jon Bonso
