DP-300 Administering Microsoft Azure SQL Solutions

Recommend an appropriate database offering based on specific requirements

Concepts

If you are looking to administer Microsoft Azure SQL solutions for your exams, it’s important to choose the appropriate database offering based on your specific requirements. Microsoft offers a range of database services on Azure that are designed to cater to different workloads and scenarios. In this article, we will explore some of the options available and recommend the most suitable offering based on various considerations.

Azure SQL Database

Azure SQL Database is a fully managed relational database service that offers built-in intelligence and scalability. It is ideal for modern application development and deployment. With Azure SQL Database, you can take advantage of features such as automatic tuning, intelligent performance, and advanced security capabilities. If your exam involves working with traditional relational databases and you require a fully managed service with high scalability, Azure SQL Database is a strong contender.

Here’s an example code snippet:


Welcome to Azure SQL Database!
This is my sample SQL database.
Feel free to explore the data and perform queries.

  .database.windows.net,1433";

    $connectionOptions = array(

        "Database" => "",

        "Uid" => "",

        "PWD" => ""

    );

    $conn = sqlsrv_connect($serverName, $connectionOptions);
    if($conn === false) {

        die(print_r(sqlsrv_errors(), true));

    }
    $tsql = "SELECT * FROM ";

    $getResults = sqlsrv_query($conn, $tsql);

    if ($getResults == FALSE) {

        die(print_r(sqlsrv_errors(), true));

    }

    while ($row = sqlsrv_fetch_array($getResults, SQLSRV_FETCH_ASSOC)) {

        echo "
".$row['column1']." - ".$row['column2']."
";

    }

sqlsrv_free_stmt($getResults); ?>

Azure SQL Managed Instance

Azure SQL Managed Instance provides near 100% compatibility with the latest SQL Server on-premises database engine. It is a fully managed platform-as-a-service (PaaS) offering that offers easy migration of on-premises SQL Server databases. With Managed Instance, you get the benefits of a fully managed service while retaining the familiarity and feature set of SQL Server. If your exam focuses on migrating and managing SQL Server workloads in the cloud, Azure SQL Managed Instance is an excellent choice.

Here’s an example code snippet:

USE master; GO


CREATE LOGIN  WITH PASSWORD = '';

GO
CREATE USER  FROM LOGIN ;

ALTER ROLE db_owner ADD MEMBER ;

GO

USE ;

GO
CREATE TABLE dbo.MyTable

(

    ID INT IDENTITY(1,1) PRIMARY KEY,

    Name NVARCHAR(50) NOT NULL

);

GO
INSERT INTO dbo.MyTable (Name) VALUES ('John');

INSERT INTO dbo.MyTable (Name) VALUES ('Jane');

INSERT INTO dbo.MyTable (Name) VALUES ('Mark');

GO

SELECT * FROM dbo.MyTable;

Azure SQL Server on Azure Virtual Machines

If your exam requires you to configure and manage your own SQL Server instances on virtual machines, Azure SQL Server on Azure Virtual Machines is the right choice. With this offering, you have full control over the SQL Server environment, including OS-level customization and configuration. You can leverage existing SQL Server skills and tools to administer and maintain your databases. If your exam focuses on infrastructure-level administration and customization, Azure SQL Server on Azure Virtual Machines is a suitable option.

Here’s an example code snippet:

USE master; GO


CREATE LOGIN  WITH PASSWORD = '';

GO
CREATE USER  FROM LOGIN ;

ALTER SERVER ROLE sysadmin ADD MEMBER ;

GO

CREATE DATABASE ;

GO
USE ;

GO
CREATE TABLE dbo.MyTable

(

    ID INT IDENTITY(1,1) PRIMARY KEY,

    Name NVARCHAR(50) NOT NULL

);

GO

INSERT INTO dbo.MyTable (Name) VALUES ('John');

INSERT INTO dbo.MyTable (Name) VALUES ('Jane');

INSERT INTO dbo.MyTable (Name) VALUES ('Mark');

GO

SELECT * FROM dbo.MyTable;

In conclusion, the appropriate database offering for administering Microsoft Azure SQL solutions based on your specific exam requirements would depend on factors such as the need for fully managed services, compatibility with SQL Server, or infrastructure-level control. Azure SQL Database, Azure SQL Managed Instance, and Azure SQL Server on Azure Virtual Machines are all powerful options to consider, each catering to different scenarios. Assess your requirements and choose the offering that best aligns with your exam objectives.