This blog post will go through some quick tips including Q/A and related blog posts on the topics that we covered in the Azure Database Administrator Day 1 Live Session which will help you gain a better understanding and make it easier for you to learn the Azure Database Administrator Training Program clear the [DP-300] Certification & get a better-paid job.
On our Day 1 Live Session of the [DP-300] Microsoft Database Administrator Training Program, we covered the concepts of The Role of Azure database administrator and learned and Learn how to use Azure portal and SQL Server Management Studio.
Role Of The Azure Database Administrator
A Modern database administrator is responsible for the design, implementation, maintenance, and performance of database systems. They work with on-premises and cloud-based data platform solutions built on Azure Data Services and SQL Server. The main goal is to ensure the availability and consistent performance of various applications running on the database server.
Q.1) What is Azure SQL?
Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.
Q.2) What is Azure SQL Database?
SQL Database is a PaaS deployment option of Azure SQL that abstracts both the OS and the SQL Server instance away from users. Support modern cloud applications on an intelligent, managed database service, that includes serverless compute.
SQL Database has the industry’s highest availability SLA. It provides other intelligent capabilities related to monitoring and performance, partly because Microsoft manages instances.
You can check out our related blog here: Azure SQL Deployment Options
Q.3) What is Azure SQL Managed Instance?
Modernize your existing SQL Server applications at scale with an intelligent fully managed instance as a service, with almost 100% feature parity with the SQL Server database engine. Best for most migrations to the cloud.
Q.4) What is SQL Server on Azure VMs?
Lift-and-shift your SQL Server workloads with ease and maintain 100% SQL Server compatibility and operating system-level access.
>Azure SQL deployment options
Here are some different Azure SQL deployment options
- Azure SQL on Virtual Machines
- Azure SQL Managed Instance
- Azure SQL Database
Also Read: Our blog post on Azure Data Studio.
IaaS vs. PaaS
SQL Server on a virtual machine is considered IaaS. The other deployment options in the Azure SQL platform, Azure SQL Managed Instance, and Azure SQL Database are platform as a service (PaaS) deployments. These PaaS Azure SQL deployment options contain a fully managed database engine that automates most of the database management functions, like upgrading, patching, backups, and monitoring.
Q.5) List the features of SQL Managed Instance and SQL Database?
- Business continuity enables your business to continue operating in the face of disruption.
- High availability guarantees your databases are up and running 99.99% of the time. No need to worry about maintenance or downtime.
- Automated backups are created and use Azure read-access geo-redundant storage (RA-GRS) to provide geo-redundancy.
- Long-term backup retention enables you to store specific full databases for up to 10 years.
- Geo-replication creates readable replicas of your database in the same datacenter (region) or a different one.
- Scalability You can easily add more resources (CPU, memory, storage) without long provisioning.
- Network security features protect your data over the network. These features include firewalls to restrict connectivity, Azure Private Link to ensure your data isn’t exposed to the internet, and integration with virtual networks for connectivity to on-premises environments.
- Advanced security detects threats and vulnerabilities in your databases and enables you to secure your data.
- Automatic tuning analyzes your workload. It provides recommendations that can optimize the performance of your applications by adding indexes, removing unused indexes, and automatically fixing query plan problems.
- Built-in monitoring capabilities enable you to get insights into the performance of your databases and workload and troubleshoot performance problems.
- Built-in intelligence automatically identifies potential problems in your workload and provides recommendations that can help you to fix those problems.
Q.6) What is Azure Storage?
The Azure storage platform provides a number of storage services, for files and object storage, message queues, and VM disks. SQL Server uses two types of storage.
- Managed Disks
- Blob Storage
Q.7) Name the open-source database on the Azure platform?
- Azure Database for MariaDB
- Azure Database for MySQL
- Azure Database for Postgre SQL
>Lab: Provision A SQL Server On An Azure Virtual Machine
The first lab of the Database Administration on Microsoft Azure course is to deploy a SQL Virtual Machine (Free SQL Server License: SQL 2019 Developer on Windows Server 2019) in the Azure portal. To get started with this lab you will need an Azure Subscription where you will first create a resource group in which all your resources will be created, then you will be provisioning the SQL server on Azure VM with the specified configurations.
> Connect To SQL Server And Restore A Backup
In this lab, you’ll create a Remote Desktop Protocol (RDP) connection to the SQL Virtual Machine created in the previous lab, download the database backup file, restore the database in SQL Server using SQL Server Management Studio (SSMS) and then perform some SQL queries to confirm the availability of the AdventureWorks database.
Feedback Received…
Here is some positive feedback from our trainees who attended the session:
Read more about the DP-300 Certification and whether it is the right certification for you, from our blog on Exam DP-300: Database Administrator on Microsoft Azure
Quiz Time (Sample Exam Questions)!
With our Azure Database Administrator Training Program, we cover 200+ sample exam questions to help you prepare for the DP-300 Certification.
Ques. What type of storage offers the lowest latency in Azure?
a. Ultra SSD
b. Premium SSD
c. Standerd SSD
Comment with your answer & we will tell you if you are correct or not!
Next Task For You
Begin your journey toward Mastering Azure Cloud and landing high-paying jobs. Just click on the register now button on the below image to register for a Free Class on Mastering Azure Cloud: How to Build In-Demand Skills and Land High-Paying Jobs. This class will help you understand better, so you can choose the right career path and get a higher paying job.
Leave a Reply