Pass Microsoft Azure DP-203 Exam in First Attempt Easily
Latest Microsoft Azure DP-203 Practice Test Questions, Azure Exam Dumps
Accurate & Verified Answers As Experienced in the Actual Test!
Check our Last Week Results!
- Premium File 379 Questions & Answers
Last Update: Oct 3, 2024 - Training Course 262 Lectures
- Study Guide 1325 Pages
Download Free Microsoft Azure DP-203 Exam Dumps, Azure Practice Test
File Name | Size | Downloads | |
---|---|---|---|
microsoft |
2.5 MB | 1217 | Download |
microsoft |
2.6 MB | 1220 | Download |
microsoft |
2.5 MB | 1161 | Download |
microsoft |
1.7 MB | 1268 | Download |
microsoft |
1.3 MB | 1544 | Download |
Free VCE files for Microsoft Azure DP-203 certification practice test questions and answers, exam dumps are uploaded by real users who have taken the exam recently. Download the latest DP-203 Data Engineering on Microsoft Azure certification exam practice test questions and answers and sign up for free on Exam-Labs.
Microsoft Azure DP-203 Practice Test Questions, Microsoft Azure DP-203 Exam dumps
Introduction
1. IMPORTANT - How we are going to approach the exam objectives
Now, before we proceed ahead with this course, I want to tell students how I've gone ahead and structured the contents of this course. So here I am on the official documentation page when it comes to the exam. For example, DP, if I go ahead and scroll down and if I click on "Download Exam Skills Outline" here, you will see all of the different sections that are part of this particular exam. And you also have different objectives. Now, the way that I am structuring this course, I'm not going step by step as per the objectives given over here. Instead, I've decided to go service by service and see what the important services are when it comes to exams. The first is Azure Data Lake Generation. There are two storage accounts. Then we have Azure Synapse, and then we have Azure Databricks, and we have other services such as stream analytics. So instead of actually going objective by objective, I have decided to go service by service. This will actually make the flow of understanding much easier for the student because, see, each objective pertains to a different service. And I do want students to actually get confused when it comes to what service is being mapped to what objective. Instead, I'll ensure that I cover all the objectives based on the service they are being targeted for. That's the main purpose. That's why in this course we'll first go through as your Data Lake Gen 2 storage account, then we'll go through as your synapses, and then we'll go on to data processing, wherein we will look at as your data factory, stream address, etc. So that's how I've actually decided to structure this course. See, in all of my courses, I want to keep in mind what's best for the student—how will the student learn? What's the best way for them to actually capture the knowledge I am trying to give them in the course itself? And all of this is always aligned with the objectives of the exam and also with the type of questions. What are the questions you'll actually get in the exam itself? So I don't want students to actually get confused as to why I'm not going objective by objective, because this may not always be the best case when trying to teach you when it comes to being prepared for the exam. That's why I am going through service by service so that you understand everything that the service has to offer, right? So, with that in mind, I want to let students know so that you have an upfront understanding when it comes to how I've structured this particular course.
2. OPTIONAL - Overview of Azure
Right, just for those students who are not familiar with Azure. So Asia is a cloud platform where you can develop and build a wide range of applications and services before deploying them to the cloud. If you are new to Azure, I suggest you go ahead and create something known as an Asia Free Account. So this is something that is actually available in Azure. You can actually go ahead and create a free account. That free account actually gives you $200 worth of credit to play with for the first month. And there are some services that come for free on the homepage. If you scroll down, you can see the different categories of the services that are offered as part of Azure. For example, one service here is Azure Synapse Addicts. And this is something that we're going to see in detail as part of this particular course. One important thing to remember is that this is the implementation of products and services that are already available. The only difference is that you are working with these products and services on the Azure cloud. Yes, Azure also has its own brand of services that help you achieve more on the cloud. So there is a lot that you can do with the cloud platform on Azure in this course. Once you complete this course, you can see all that we can do from a data engineering perspective.
3. OPTIONAL - Concepts in Azure
Now in this chapter, I just want to go through some core concepts when it comes to Azure. This is just for those students who are not that familiar with working on Azure. So when you go ahead and start working on Azure, the first thing you need to do is go ahead and create an Azure account. Now, Azure has the facilities to go ahead and create a free account wherein you get $200 worth of credit for free for the first month. And you also get a very small subset of services for free. In order to create an account, you need either a Microsoft account or a GitHub account. If you have a Gmail account, you can rest assured that you have a Microsoft account and then create an Azure account. Once you have the Azure account in place, you'll actually log in with either your Microsoft account or your GitHub account, and then you'll basically come onto the Azure Portal. Now this is a web interface that allows you to work with the different services that Azure has to offer. So for example, if you want to work with the Azure Data Lake Gen 2 service, you can use that. Or if you want to build a SQL data warehouse in Azure, you use it as your Synapse service. So there are different Azure services that you can actually work with when you create your account. When you work with a particular service, you'll actually create a resource based on that service. So for example, if you want to work with a Data Lake Storage account, you create a resource based on that particular service. On the Azure Deal Storage Account service, each resource that you create in Azure needs to be part of a subscription. Now a subscription is used for billing purposes. So it depends on how much you consume, right? So that will come as part of your subscription billing. And at the end of the billing month, whatever you have consumed, you have to pay for it now as part of your account, if you are trying that out, so you do get some credits for free. You get $200 worth of credit for free. So whatever you consume will actually go against that credit amount. Following that, you'll use a pay-as-you-go subscription. That's what I use. So I pay based on how much I consume, and at the end of my billing month, I then pay for how much I consume. Each resource also needs to be part of something known as a resource group. The resource group is used for a logical grouping of resources. So as a simple example, let's say you had an application that needed to use a set of resources based on services in a CRM. You can place all of those resources as part of the resource group, so you know that that resource group only has resources for that application. Then in Asia, as part of your account, you get something known as the Azure Ad-Free Directory. Azure Active Directory is an identity provider in Azure. So here you can go ahead and create users, you can create groups, you can create something known as applications, and then you can give access to these users to the resources that you actually create in Azure. There's a lot that actually goes into working with Azure. But at this point in time, I want to give some very important basic concepts that the students should know when it comes to initially working with the Azure platform.
4. Azure Free Account
Hi and welcome back. Now in this chapter, I want to talk about the Azhaw Free Account. So if you are new to Azure and you want to try out their services, you can actually create an account for free account. So there are some services that you get for free as part of this account. if you actually scroll down. So you can see what you get with the Azure Free account here. One of the other important things that you actually get with the Azure free account is $200 worth of credit for 30 days. So for example, if you are exploring a service that is not free as part of your account, whatever the cost of that service is will actually be taken from this $200 worth of credit. So you get credit to actually explore Asana for 30 days if you scroll down. So, here are the products that are free for the next twelve months. You should keep a note when it comes to the type of product that you get for free. For example, if you look at Windows virtual machines, there is only one particular tier that actually comes for free. if you want to spin up another virtual machine that is based on another tier. So this tier basically determines how much virtual CPU and how much RAM are actually allocated to the virtual machine. So if you want a virtual machine with more CPU and more RAM, you have to choose a different tier that will not come as part of the account. That's something that you need to pay for. But remember, with $200 worth of free credit, I said that if you use any service that is not free, it will be taken from the $200 worth of free credit. So you can experiment with services during the first month of your Azure Free account. If you scroll down, you can see the entire list of products that are free for twelve months. And here, you can see all of the products that are always free. So with each service, there will be something that comes for free. It's not like the entire service is free. There's just a part of it that comes for free so that you can actually explore that service. If you scroll down here in Azure, you'll find a FAQ section about the Azure Free account. So please also go through this because I get a lot of questions when it comes to the SEO Free account. So for example, I get a question from students saying that after the 30 days are over, then what do we do? So once your 30 days are over, if you still want to get those free services that you saw on the first page, then you have to change your subscription to something known as "pay as you go" pricing there. Then you start paying for the services as you use them. So I normally use the "pay as you go" pricing. I only pay for how much I consume. If I am not using a service, I am not going to pay for it. It's as simple as that. Another question that I do get from students is: What do I need to sign up for a free account? So you need a phone number, a credit card or debit card number, a Microsoft account, or a GitHub account. This is required, right? So in this chapter, I want to introduce you to that concept wherein you can actually go ahead and create an account. So if you've not done that before, you can actually try it out. Please note that you can only create an Asia-free account the first time. You can't keep creating multiple Azure free accounts.
5. Creating an Azure Free Account
So in this chapter, let's try to create your free account. So here I'll click on "Start Free." So we first need to sign in with a Microsoft-based account. Now if you don't have a Microsoft account, you can create one. So I'll hit on "create one." You can enter your email address here. So for example, if you have a Gmail ID, you can create an account here based on a Gmail ID. So here I'm giving my Gmail ID details, and I'm going on to the next step. Now here, I need to create a password for my Microsoft account. I'll proceed to the next one. Yeah, it will ask me to verify the code. So it will send a code to my Gmail account. So in my Gmail account, I can see this is the code. So let me copy it. I'll paste it here, and I'll go on to Next. So it's asking me to solve a puzzle so that it verifies that we are not a robot. So I'll move on to the next one. So here, it asked me to tap on the arrows to rotate the image. I'll click on Done. So now we can start creating your free account. So it's asking us to specify our region to give all of these details. So I am going to enter all of these details. So I'm entering all of the details. I've actually entered my first name and my last name. I've also entered my phone number. Now here, I'll click on "text me." So here I need to enter the verification code, which will be sent to my mobile device. So I've got the verification code. I'll verify the code. So this is also done. So here I have agreed to the customer agreement. Now here, when it comes to the identity verification by the card, it's saying it's going to make a temporary authorization on this card, but you won't be charged unless you upgrade. So currently, we're not upgrading. It is creating an account for you. So I'll need to enter my credit card information here. I've entered my card details. Now I've entered my address, my city, and my state. Please note, I'm not showing it over here for privacy reasons. Then I'll click on "Sign Up." It's now setting up our account. Now it's redirecting me, telling me that we can now start working with you. So now I can click on the portal icon here. And here we are in the Azure Portal. In this chapter, I want to show you the process of creating an Azure free account. Please note that when it comes to this course, I'll be using my other account, which is the pay as you go subscription account. Now, please note that when it comes to the Azure Free account, there can be some restrictions in place. For example, you might not be able to create a resource based on a service in a region of your choice. This is a free account, and Microsoft wants to ensure that no one abuses the services that come with this free Azure account. That's why there are some restrictions in place. So I use my own account as yours because I don't have that many restrictions in place with our account, where I'm using a pay-as-you-go subscription where I am paying based on how much I use. Now, for me, my primary goal is to ensure that I give you the best training possible when it comes to learning about Azure, keeping in mind the objectives for the exam. So by using my other account, I can ensure that I can deliver you the best content when it comes to learning about us.
6. OPTIONAL - Quick tour of the Azure Portal
Now that you've created your as your account and logged in with your as your account, So here I am, logged in with my Microsoft account. So this is a Gmail account converted into a Microsoft account. And now this particular user ID has full and measured privileges over the account itself. Now, when you log in, you get a dashboard. What I get is a dashboard where I can see all of the resources, a snapshot of the resources that I have in my account in yours. Now here, I have a menu. So in this menu on the left, you can create a resource based on a service. In Azure, you have your dashboard. You have the home screen. So sometimes you might get this screen. This is the home screen, offering your services. If you go on to All Services, you will see the different categories. And for each category, what are the different services that are available? If you navigate to all resources, you will find an ever-expanding list of Azure services. So here you can see all of the resources that are created as part of your account. If I just minimize this just for this point in time, each resource that you have in a zoom, as I said, is based on a service. So this is a SQL database that is based on the Azure SQL Database Service. I mentioned that every resource needs to be part of a resource group. I said this was for the logical grouping of resources. Next, when you create a resource, you have to define a location for the resource. So there are regions across the world in which you can define your resource. So, despite the fact that this is a cloud platform, it's abstract for you; you're working with the cloud. But in the end, your resource needs to be hosted on some sort of physical infrastructure. That physical infrastructure needs to be in a particular location. There are a lot of factors that define the location that you choose. For example, if you have users who are accessing a web application that you are defining in Azure, and let's say those users are located in the North Europe location, then you should create that resource in that location itself, so that the latency or the users get a better response time because they and the resource are in the same location. There are a few resources that are available at the global level where you don't have to mention the location, but for most of the services, you do have to mention a location. In the end, the price of a service also depends from region to region. That is just a minor difference. Next is the subscription. So I mentioned that each resource needs to be part of a subscription. This is used for billing purposes. So now I have a subscription in place. if you want to create a new resource. There are many ways you can do that. You can find this Create a resource in all resources by clicking on it. You can hit on "Create" over here. You can also go on to a particular service. So these are the commonly used services, and you can create a resource right there itself. If you hit on "Create Over Here," Let me go ahead and just hide this. Here you have the marketplace. So the marketplace is where you can see all of the services that Azure has to offer. So, for example, if you want to create a database, you can go on to the category for databases. And here, let's say you want to create a SQL database. So you can click on the SQL database option. Then you get a wizard. The wizard will help you to create that SQL database. Here there are different categories that you have to enter in order to ensure that you fulfil the requirements for creating the SQL database. So you can see that for every resource—every resource that you create in Azure—you have to mention the subscription and the resource group. And then you mentioned other details about the SQL database. So you go through all of the screens, you complete all of the checkpoints over here, and on the final screen you will be able to review and create. Currently it's giving me an error because I have not filled in the basic screen, I have not given the database name, et cetera. So I'm just giving an example of how you create a resource, right? So in this chapter, I just want to give that basic overview when it comes to working with your portal.
Design and implement data storage – Basics
1. Section Introduction
Hi, and welcome to the section. Now in this section, we are going to start a little bit light. I'm going to discuss storage accounts and talk about the Azure Data Lake storage account. I'll also show you an example of a very simple application that actually connects to an Azure SQL database and to an Asia storage account. Now, there are multiple reasons as to why I'm starting this way. The first step in this course is to establish a foundation for your knowledge of data and some of the existing data stores that you can use in Azure. Even though Azure SQL database is not in the scope of the exam and I'm not going over Azure SQL database in great detail, I want to start with how an application can actually make use of data to set the tone for this particular course on how do you handle data. At the same time, it also gives us a way to start working with services in a CRM. And this is important for those students who are not well versed on how to work with Azure. So there are multiple reasons as to why I'm starting this way. And then we build from there onward, because I have a lot of content when it comes to building an Azure SQL Data Warehouse, when it comes to using spark pools in Azure Synapse, when it comes to Azure Schematics, when it comes to Azure Data Bricks, and a whole lot more. So I just want to start saying, "First, right, set the base," and then from there we'll take it forward.
2. Understanding data
Now, the first thing I want to do is talk about data itself. So you probably heard the saying "data is the new oil," and really, there's been an explosion when it comes to the availability of data itself. so much so that there are rules that actually govern how data should be used and controlled. And then we also came to the issue of big data. Because we have so much data at our disposal, companies want to go ahead and make use of the data to build intelligent insights and get information based on the data itself. Now, when it comes to working with big data, you have to ensure that you are able to work with large data sets and that you can work with data as it arrives, so it arrives in large volumes and also arrives at a very fast rate. Next, when it comes to the data itself, consider aspects such as data storage. So what is the underlying store that you'll actually use for storing data, how will you process the data, and finally, how will you visualise your data? Now, I just want to give some quick views on the classification of data. First, you have structured data. This is a tablet format that is represented by rows and columns in a database. As a result, many of you will be familiar with the concept of having a database. when you store the information in tables in a database itself. Over here, you will have columns that represent the type of data that's going to be stored. And then you have rows in the table itself. When it comes to the underlying database engine, it is responsible for the storage of data. Also, when you query for the data, it is responsible for giving you the results. When it comes to Azure, you have the ability to install a database engine on a virtual machine. So you could go out and install Oracle, Microsoft, SQL Server, MySQL, etc. Or you could also use the platform as a service that is available, namely your SQL database service. And this is something that we will just look at briefly in subsequent chapters. Now, apart from structured data, your app has semi-structured data as well. Your data could reside in other formats and not in a database. So this could be in a normal file. A common example is JSON. This is JavaScript object notation over here, giving an example of a JSON object. In this course, we will be looking at how to work with JSON-based data. Next, we have key-value data stores. Here, you get the value based on the key that is being stored. If you have, let's say, a customer ID for the key, we'll have various values that are available for each key name. As a result, the key value data store can also be stored as tables. But over here, you don't have any sort of relationship between the tables as you would in a sequel-based database system. So I said here that the data does not have any specific structure or relationship. And then finally, we have unstructured data. So this is data like having audio files, video files, images, et cetera. All of these are considered to be binary objects. So, before we get started, I thought it would be a good idea to go over some of the key concepts in data classification.
3. Example of data storage
Now, in the next set of chapters, I want to show an example of a very simple Net Core-based application. This application will fetch data from an underlying TV table that will be stored in an Azure SQL database. Also, it will fetch images from something known as an Azure Storage account. The main reason why I want to show this example to students is for several purposes. Firstly, I want to introduce Azure Storage accounts for those students who are not familiar. Next, I want to show how you can create an instance of an Azure SQL Database. This is the platform as a service that is available for the Microsoft SQL Server Engine. And then it also gives students an idea of how an application can actually interact with data that is stored in a MySQL database and in an Asia Storage account. Please note that from an exam perspective, you need to know about other services such as Azure Data and LakeGen2 Storage Accounts. But those types of accounts are actually based on Azure Storage accounts themselves. So if you have a good idea of Azure Storage accounts, then you have a good idea of how Daily Gen 2 storage accounts actually work. And when it comes to SQL, we have to learn about hosting a SQL Data Warehouse, and that will be done via the Azure Synapse Service. However, for the purpose of understanding how to host a sequel-based service on Azure, using the Azure SQL Database service will provide students with a good understanding of how to use a platform as a service. So let's go ahead.
4. Lab - Azure Storage accounts
So the first thing we are going to do is to create an Azure Storage account. Now an Azure Storage account is used for the storage of data in the cloud. We are going to be creating something known as a general-purpose V2 storage Two Storage Account. Now, when you create such a storage account, you get various services that can be used as part of that storage account. When it comes to creating an Azure Data Lake Storage account, which is also based on the Block Service, you get something known as the Block Service, which you can use for the storage of objects or blocks such as your video files, audio files, or other files. So this is an important service.
As part of Azure Storage accounts, we are not going to be using or focusing on the other services because they are not part of the exam. But, just to give you an idea of your storage accounts, I'm talking about general-purpose V Two Storage Accounts also have the Table Service, which allows you to store structured NoSQL data. Here's an example of a table that you can store. Using the Table Service, you can use the File Service, which is used for hosting file shares. These file shares can be accessed by multiple users or mapped to virtual machines. And finally you have a queue service, which is used for sending and receiving messages. So let's go on to Azure and create an instance of an Azure Storage account. So here I am in Azure. So I'll go ahead and create an Azure Storage account. So for all resources, I'll go ahead and hit Create. In the marketplace, I can search for storage accounts. I'll hit on "Create." Here, I need to choose a subscription.
This is used for billing purposes. Next, I need to choose a resource group. The resource group is used for a logical grouping of resources. For the purpose of this entire course, I'll create a new resource group. I'll give the resource group a name. I'll hiton Okay, in the instance details, I have to give a unique name for the storage account. So if I give a simple name like "data store," it will say the name has already been taken. So I have to give it a unique name. North Europe is the region that I will choose. You can choose the region of your choice. In terms of the performance, I'll leave it as it is. In terms of redundancy, I'll choose locally redundant storage. So this is a low-cost option when it comes to replication. And don't worry, I have another chapter. When it comes to redundancy for your storage accounts, I'll go on in advance. I'll leave everything as it is.
There are a lot of options when it comes to Azure Storage accounts. I'll go on to networking, leave everything as it is, and go on to data protection. Leave everything as it is. I'll go on with tags. I'll go on to review and create, and I'll click on create. So now we are deploying an Asia Storage Account. This will just take a couple of minutes. Let's come back once we have the storage account in place. Once the resource deployment is complete, I'll get a notification. So all the notifications of the actions that you perform in Azure will actually appear on this notification screen. I can then go on to the resource. And on the left-hand side, I have my storage account.
When it comes to the storage account, you have data storage. You can go ahead and create your containers, which is the use of the Blob service. You have the file shares, which is the purpose of the file service. You have queues, which is the use of the queue service, and you have tables, which is the use of the table service. Let's mark an end to this chapter wherein we have gone ahead and created an Azure storage account. Please note that in a subsequent chapter, when we will look at an application that will actually connect to this storage account, we will actually upload some objects onto this storage account.
5. Lab - Azure SQL databases
So in the prior chapter, we looked at creating an Azure storage account. In this chapter, let's look at how to create a resource based on Azure for your SQL Database Service. So, firstly, I'll go on to all the resources. I can go ahead and hide this. I can create a new resource. Now, please note that over here I only have a number of resources in place. So in order to prepare myself for delivering these videos, I had gone ahead and provisioned these resources early and worked with them. If you want to filter the resources that we are creating now, as part of this course, remember that we created them based on a particular resource group name.
Currently, all of these resources are part of a resource group known as New GRP. But we have created a resource group known as Data GRP. So in the All Resources screen, I can go on to resource grouping. And here I can choose my data GRP and hit "Apply." so that now we'll only see the resources that we are creating as part of our course, right? So let's now create a resource based on the Azure SQL Database Service. I'll hit on "Create." Here I can choose the SQL database option. So in a similar case, you have to choose your subscription and our resource group. I'll choose my data-GRP resource Resource Group. We have to now give the database a name. I'll give a name of app DB. And here I need to create something known as a "new server." So before we go with the creation of the SQL database, again, just for those students who are not aware of this option of a platform as a service feature that is available in Azure, we have the Azure SQL Database Service.
So let's say you want to host a SQL database in Azure. One option that you have is to create an Azure virtual machine. So over here, you're creating a machine on the cloud. Then you can install the database software of your choice. It could be Oracle. It could be Microsoft. SQL Server. It could be my SQL. So you'll first create the VM, or virtual machine. You will install the database software. Then you'll create your database, create your tables, and start storing your data. Now, when it comes to hosting your entire infrastructure on your virtual machine, one of the biggest advantages is that the underlying physical service that is hosting your virtual machine is completely managed by Azure. You don't have to worry about the physical infrastructure.
But when it comes to your virtual machine and when it comes to your database itself, you have to consider different administrative tasks, such as having a backup in place for your database. In large organizations, this is very important. What happens if your data gets corrupted? What happens if the database engine goes down? What happens if the virtual machine hosting the database server goes down? So you also have to look at options with high availability. So Azure has a service known as the Azure SQL Database service. This is a platform as a service here, and in addition to the physical infrastructure, even the virtual machine, the underlying compute that is hosting your database is also completely managed by Azure.
One of the biggest advantages is that this service can take backups automatically. So you won't have to write any complicated scripts or configure anything. Everything is available out of the box when it comes to the Azure SQL Database service. It is also built automatically for high availability. And there are a lot of features when it comes to the Azure SQL Database service. So if you want to host a SQL database that is based on the Microsoft SQL Server Engine, one option is to use the Azure SQL Database service, right? So let's go back to our screen for creating the Azure SQL Database. So we have mentioned our database name. Now we just need to mention the server details that will be hosting our database. Remember, I said the entire server infrastructure would be managed by Azure. Over here, you are just specifying the details about the server. That's it. I'll hit on "create new." I need to give the server's name. I need to give the administrator a login and password. We will be using this server name and this admin login and password to log into our database server so that we can create our tables and start hosting our data. I'm doing all of this so that students will then have a good idea when we start creating a resource based on Azure Synapse. Azure Synapse is a service that is used for hosting a SQL data warehouse. And even during that time, you will see that your Synapse, in the end, again manages the underlying infrastructure for you. You can just go ahead and start creating your SQL data warehouse for the exam. You don't need to know about the Azure SQL Database Service.
But as an instructor, I feel that students should have some idea about hosting a SQL database in Azure. And some students might not be familiar with this concept. That's why I want to ensure that students are aware of such a service. I'll give a server name. This again needs to be unique. So the server names So just give the server name so it is available. I need to grant a server administrator login. When it comes to the password that you mentioned, there are some constraints. So you have to ensure that you create a password that adheres to these constraints. The password that I will create will be very simple. It will be "Azure Eight," one to three with a capital "Azure." In terms of the location, I'll choose North Europe. So I'll host all my services and all my resources. In the North Europe location, I'll hit on Okay, next, I'll configure my database.
Now, these are the pricing options that are available for the underlying database engine. Based on the pricing model that you use, it will allocate the required amount of CPU, the amount of memory, the amount of IOPS—everything—for your database instance. Since this is just a very simple demo, I'll choose the basic standard and premium Tube models. This is based on something known as database transaction units. This unit is a combined measure of CPU memory, IOPS, et cetera. All of this is then given as a bundle unit and you'll be charged based on the number of units that you consume here. In terms of the data size, just choose a very limited data size because I don't need that much size for my database. If I scroll down and go on to the right, you can see the estimated cost per month.
So it's just 15 USD for hosting a SQL Database on the cloud per month. In terms of our lab, if you're following along, if you have a pay as you go subscription, remember to delete all of your resources after you've finished working with them, even if you have your free account and will be getting that credit back for the first 30 days. To save on that credit, remember: once you are done with the resource, go ahead and delete it so that you don't bear a cost. I'll hit "Apply" next. I'll leave everything as it is. I'll go on to networking. Here in the connectivity method, I'll choose a public endpoint. So by default, there is actually a firewall in place to kind of limit the traffic that enters the SQL database because it's a public service. So in the firewall rules for adding the current client IP address, I'll mark it as yes. That means I'll be able to access this SQL Database instance from the workstation I'm using. I'll also allow other Azure services and resources to access this server.
So when we look at later chapters as, let's say, your data factory, this is your service. So we can easily allow that service to access your SQL database. If we check this box, I'll move on to Security. I'll leave everything as it is. I'll go on to additional settings. I won't change anything. I'll go on tags I'll go on to Review and Create, and I'll hit Create. Now this implementation is going to create two resources. It will create an Azure SQL database server. And it will also create an Azure SQL database. Now, in order to connect to and work with your SQL Server as your SQL database, you can download and install the SQL Server Management Studio on your workstation—on your machine itself. This is a client tool. It is a free tool. You can download and install it. I've already got it installed on my machine. It's a very simple download and installation. We can then use this tool to connect to your SQL database, and I'll be using it again in the following chapters when we look at working with the SQL Data Warehouse. So ensure that you download and install the tool. I said it's a very simple download and installation, so I'll come back after a couple of minutes once we have our SQL database in place. Once we have the resource in place, I'll go ahead and do it. So now we have our SQL database in place. If I go to All Resources, if I filter based on my Data GRP group, and if I hit on Apply Here, we can see that we have our SQL database in place and also the database server that is hosting our database.
So again, I'll go on to the SQL database. Now, on my machine, I have already installed SQL Server Management Studio. So let me go ahead and launch SQL Server Management Studio. So we get the "Connect to Server" screen. Yeah, we need to give the server's name. So if you go onto your SQL database, you can copy the server name onto the clipboard, and we can do a Control V and paste it over here. In terms of authentication, we'll use SQL Server authentication for the login and enter the information that was provided when you created your SQL Database. So the login was Sequel user, and the password was your other 8123.
I'll hit on Connect, and now we should be connected to our Azure SQL Database server. So now, within a matter of minutes, we have a database hosted in Azure. You can begin creating tables in your database and hosting data right away. If you didn't have the cloud, remember, you would need to first have a machine in place to install the database software. It would take hours just to get the setup in place, but here, within a couple of minutes, we have a cloud version of our database. So let's mark an end to this chapter. And in the next chapter, we'll now see a very simple Net application that would connect to both your storage account and our SQL database.
Microsoft Azure DP-203 Exam Dumps, Microsoft Azure DP-203 Practice Test Questions and Answers
Do you have questions about our DP-203 Data Engineering on Microsoft Azure practice test questions and answers or any of our products? If you are not clear about our Microsoft Azure DP-203 exam practice test questions, you can read the FAQ below.
Purchase Microsoft Azure DP-203 Exam Training Products Individually