Azure SQL

  • 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.
  • 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. 
  • IT Certification Category (English)728x90

Networking

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

Security

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

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: Multiple-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. 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.

Tutorials Dojo Study Guide and Cheatsheet

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

Sources:
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/

NEW Course – Google Certified Associate Cloud Engineer Practice Exams

Google Certified Associate Cloud Engineer Practice Exams

NEW Course – AWS Certified Machine Learning Specialty Practice Exams 2021

AWS Certified Machine Learning Specialty Practice Exams

Pass your AWS and Azure Certifications with the Tutorials Dojo Portal

Tutorials Dojo portal

Our Bestselling AWS Certified Solutions Architect Associate Practice Exams

AWS Certified Solutions Architect Associate Practice Exams

Enroll Now – Our AWS Practice Exams with 95% Passing Rate

AWS Practice Exams Tutorials Dojo

Enroll Now – Our Azure Certification Exam Reviewers

azure reviewers tutorials dojo

Enroll Now – Our Google Cloud Certification Exam Reviewers

Tutorials Dojo Study Guide and Cheat Sheets eBooks

Tutorials Dojo Study Guide and Cheat Sheets-2

FREE Intro to Cloud Computing for Beginners

FREE AWS Practice Test Samplers

Browse Other Courses

Generic Category (English)300x250

Recent Posts

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?

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, 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
error: Content is protected !!