BestSeller
Best Seller!
$27.49
$24.99
DP-300: Administering Microsoft Azure SQL Solutions

DP-300: Administering Microsoft Azure SQL Solutions Certification Video Training Course

DP-300: Administering Microsoft Azure SQL Solutions Certification Video Training Course includes 130 Lectures which proven in-depth knowledge on all key concepts of the exam. Pass your exam easily and learn everything you need with our DP-300: Administering Microsoft Azure SQL Solutions Certification Training Video Course.

129 Students Enrolled
130 Lectures
14:06:00 hr
$27.49
$24.99

Curriculum for Microsoft Azure Database DP-300 Certification Video Training Course

DP-300: Administering Microsoft Azure SQL Solutions Certification Video Training Course Info:

The Complete Course from ExamCollection industry leading experts to help you prepare and provides the full 360 solution for self prep including DP-300: Administering Microsoft Azure SQL Solutions Certification Video Training Course, Practice Test Questions and Answers, Study Guide & Exam Dumps.

Plan and Implement Data Platform Resources

1. 1. deploy database offerings on selected platforms

Hello. And in this section, we're going to have a look at planning and implementing data platform resources. And we're going to start by using manual methods. So we've already got our first SQL database. So what happened? I went to Azure SQL, and I can go to Create. So here we can create single databases, elasticpools, managed instances, and SQL Virtual Machines. So we could have SQL Server sitting on a Windows server. So if I was to go to any of these, then I would just click Create. So if we have a look at these two, which we've not had a look at yet, So for SQL Managed Instances, you need your subscription and your resource group. You need a managed instance name. A managed instance is like having a full version of SQL Server on the cloud with an SQL Server that you can actually manipulate, though you can't actually manipulate the Windows machine behind it. So you need to put in your managed instancename, a region, and an admin login and password, and you'd also be able to put in the appropriate amount of compute and storage. Much later in this course, we'll look at actually creating an SQL Database-managed instance. Now we can also get SQL Virtual Machines, and you can see lots of different images. So with an SQL Virtual Machine, you will be paying for the operating system as well as for the SQL Server. You no longer have to pay for developer, but you also cannot use it for commercial purposes. You can only use it, for instance, for testing BEDO while learning how to actually use SQL Server. So it's likely you'll be using both Windows Server and a full SQL Server. There is also a "Bring Your License" version as well. Now, this isn't the only place where you can deploy it from.If I return home and look for the marketplace, this is another place where I can find a lot of images. So if I go to the left, you can see all of these different images that I can use. I can just type in SQL Server here and have a big search for what's available. So here you can see SQL Server on Windows or SQL Server on Linux, for instance, and there is this Create button at the bottom. So if I were to go back to Azure SQL and create a new virtual machine, then you'll see there are a lot more things that are needed. A virtual machine name; a region; availability options; availability sets; availability zones; skill sets; that sort of thing. We'll be looking at some of them later on. We'll be looking at what a "spot license" is, a discounted rate that may have infrastructure loss because they can recall it when they actually need it. You'll also need it to have virtual networks in place, so IP addresses So there are a lot more options that are needed here. You can choose the discs that you've got for networking. So don't forget, this is actually a full-blown computer. It's just one that's not on your machine. It's a virtual environment on a really big server that you've got access to. So these are some ways of deploying database offerings using the portal. You could also use SQLDatabase or SQL-managed instances or virtual machines to deploy them from. In the next video, we'll look at ways in which you can deploy them, but not through the portal itself.

2. 2, 80. configure customized deployment templates

In this video, we're going to look at some alternative ways of deploying resources. So let's go back into our SQL database. So here it is. Now, on the left side, we have a plethora of different options. And going nearly to the bottom, we've got a default template. Now, this is what's called an ARM template. Azure Resource Manager arm It's also written in code, as you can see. This code is called JSON-JSON, and it's fairly readable if you're used to something like XML. Well, it's a relative, let's say a cousin, but you can see it uses these pair values. So we've got the name and then we've got the value over here; it uses parameters as well. And if I go to the top, you can see that we've got a parameter called the server, and the initial value of the parameter is null. And here, we can see I've given it a name. Now, how was this generated? What is generated when you actually create an Azure database? In fact, any resource. So if I go and create a resource, here we have my SQL database section, and I will click Create, and here's my database. So I'm just putting in default values and going to review and create. You can see that we've got at the bottom a section where you can download a template for automation. So when I do that, you'll see this Arm template again. and I've got the same things that I can do. I can download; I can also deploy. What does deploy mean? Well, if I make any changes in here and click Deploy, then hopefully, by the end of this particular instance, my SQL database will reflect the changes that I've made here. So all I'm doing when I'm creating all of these SQL databases here is basically building up an Arm template. It all gets encoded. And then when I click Create, then it will take a look at the template to make sure it actually works and then create a document based on that. So if I have an existing GetDatabase or anything, I can download it. Now, I can download this one database. Now you can see there are some items that are not exportable yet. And so if I was to do what I'm about to do and actually try and deploy it, it wouldn't work because not everything is there. But I can download it, make an adjustment, and then deploy it separately to this. But I'm not going to do that. Instead, what I'm going to do is go to the resource groups here, and I will go to this resource group, SQL Database. And again, I'll go down to the bottom export template, and you can see we've got 41 resources. I think we had 16 in the previous one. So I can download this. So what is included in this SQL database resource? Well, we've got the server as well. So I can download all of this or click Download. You can see it here. So I will open up Internet File Explorer and go into my download. Here it is. So I'll unzip it so I can send it in a compressed zip folder. If I were zipping it the other way, I'd use something like Wind zip and unzip to a specific folder. There we go. And then I can edit these. So I can edit these on notepads. You probably don't have this option—you probably have to choose another app. So what you could do is just open up Notepad and open it here. And then I can change anything I want—any of the parameters. for instance, and I've got this other file here. So I have downloaded it, and I've made the changes. And what I can do now is deploy it. So deploy a custom template. So I will build my own template in the editor. I will upload files, so I'll go to where those files are located. So there you have it, I'll click Save, and the parameters will be created as well. "Okay, give me a resource group to review and create," I'd say if everything was working properly. But this wouldn't work because, as you saw, not everything is downloadable at the moment for the SQL database. It would work with other resources. Now. I could also use Azure PowerShell. So, Azure PowerShell is this thing here. So if I click on it, you'll see we get a new window, and I can choose with this cloud shell to use PowerShell Bash, also known as the CLI command-line interface. So if I were to click on one, and I'm going to create a little bit of storage that's needed, which will incur a small monthly cost, then I could type commands in this new window. Now to show you the sort of commands that I'll be using. It would be like writing new Hyphenaz" as your resource group to create a new resource group, "new Hyphena SQL Server" to create a new server, and then firewall rules and lots more things. Now, we do not have to get intoall of the my nutrition, thankfully, of howto learn to use as your cloud shell. That would take an entire course by itself. Here's the commandline interface as well. And you can see it uses a different syntax, the AZ space group, space-creating everything in lowercase. So I could put all of these commands down here and have them run. So this is another way of doing it. Now, if I was using something called an Azure Pipeline, then I could also use something called a Dacpak DACPAC. That's a Data Tier Application portable artifact. So this would be added to something called the Azure Hyphen Pipelines. Dot YML YML is an abbreviation for yet another Markup language. Believe it or not, I can also deploy databases, perhaps using SQL scripts together with PowerShell. So there are lots of different ways. Now, why would I be using any of these ways? Well, if I use Azure Portal, then I've got to go click, click, click—lots of clicks. Suppose I had to create a hundred databases—plenty of room to make errors. So, if I choose an automated method, such as deploying a custom template or using PowerShell or the CLI command line interface, I will be able to automate this and reduce the number of errors that I will make. You can always start with QuickStart templates and then modify them. So here are various automated deployment methods for resources. You can use PowerShell, you can use the CLI, you can use DACPAC if you are using Azure Pipeline, which we're not going to be using in this, or if you have an existing template. So let's go to our resource group. We can always export the template, make whatever adjustments we want to do, and then deploy it later to create a new database.

3. 4, 5. evaluate requirements and functional benefits/impact for the deployment

So we saw in a previous video that we were able to have an Azure SQL Database, but we're also able to have SQL managed instances and SQL Virtual Machines. So what's the difference between them? Now is probably a good time to have a look at these and compare and contrast them while looking at the similarities between Azure SQL Database and Azure SQL Manager instances; they are both PAS platform as a service), as opposed to SQL Server, which is AaHA. So the infrastructure is a service, the infrastructure is the Azure Virtual Machine, and SQL Server sits on top of that just like a normal program. Azure manages the database in SQL Server for these two, SQL Database and SQL managed instance. On a virtual machine, you need to manage your virtual machine, your Windows machine, and your Linux machine, and that gives you control of the database. Now, resources are always running for the SQL database unless they are dropped. Now, this is not quite true for serverless databases, so ones where you say, "Actually, I want to pause my database when it's not in use now for managed instances," they're always running on the dropoff for the virtual machine. You can shut down your virtual machine, and that means you won't be using any compute power, but you'll still be using other stuff like storage. And there will be a cost to your virtual machine even when it is shut down. Pass is best when you don't want to use Windows and don't want to deal with the overhead of doing so. Managed instances are probably best for most migrations to the cloud because, while your SQL requirements may require some changes because of the managed instances, they require fewer changes than SQL databases. However, if you just want to lift and shift your SQL Server database, then it's much easier to do it on a virtual machine because it's just like moving from an on-premises server to another on-premises server. It's just that this is a server that is in the cloud. Unfortunately, you do pay for this higher cost. You have to pay for the Windows license, you have to pay for the SQL Server license, and you also have to manage it as well. So when would you use these? Well, SQL Database is best for modern cloud applications, and when you need a quick solution, you need a quick way to market the managed instance that's best for new applications and existing on-premises applications for use in the cloud because you can use more features in the traditional SQL Server, the managed instance, that you can do in the database. We're going to have a look later, for instance, at how you can use agents on managed instances. SQL agents can't be used in databases. There are some other things you can do when you use an SQL Server virtual machine. Well, it's best when you don't want any database changes at all. when the list of compatible items has to be 100% complete or when you acquire operating service level access. Apart from SQL Database Serverless, you can now use all of these as hybrid benefits. So this reduces the cost if you currently have an existing SQL Server licence with software assurance and for VMs only. If you have a Windows Server license, you can also have reserved capacity. So you can say, for instance, I want to have an SQL database for a year, for three years, and that can reduce the cost as well. So in terms of compatibility, I've already had a brief look at this. You have all on-premises compatibilities for virtual machines; you have a high degree of compatibility with managed instances; you have morphed compatibles but not highly compatibles. You can use a lot of SQL Server features, but not some of the more advanced ones. So here you can see some of the syntax that isn't available in SQL Server. Whether you need it or not in your particular application, only you know. So trace flags are not supported in SQL databases. If you've ever used a trace flag, why is that? Well, trace flags are things when you startup in Server, there's no server to startup, you don't have any control of itmanaging instance, there are some trace flags supported. All trace flags are supported in virtual machines. As you can see, the more we talk to the right side, the more options we have. However, you still have to manage on the right side. So you have to manage your backups. You have to manage your patches. There are ways to assist with this in Azure, which means you have less to manage for SQL Database. For a SQL managed instance, then there are built-in backups, built-in patching, and built-in recovery. You can now have up to four terabytes of database space with SQL Database. More importantly, if you use something called the Hyperscale, you can go up to around 100 terabytes, or maybe even above that. With managed instances, you can get up to eight terabytes. And on a virtual machine, well, it just depends on SQL Server at the moment. SQL Server allows up to 256 terabytes, so the databases can be up to the maximum size. So you move your SQL Server from an on-premises environment to a virtual machine. With SQL databases, you have the choice of serverless compute. So why do you not actually have access to a specific server? Not that you have much access to it, but also because it can just be automatically decommissioned when it's not being used. And that, of course, can save on cost. One significant difference between SQL Database and managed instance is that you cannot use CLR (Net Framework common language run time) in a SQL Database, but you can in a managed instance. Now, which version of SQL Server are you using? Well, if using a virtual machine You can use any version starting with 2008 R2, which means you can use any additional developer, Express, Webs, Standard Enterprise, or any operating system. So suppose you needed SQL Server 2016 service pack 2 on a Windows 2016 server. Well, that is a virtual machine. Anything else? The SQL Database Ssql managed instance, youhave whatever the latest Stable Enterprise Editionis, or rather a version of that. As I said, not everything is compatible with those, but it's based on the latest Stable Enterprise Edition. So you don't have a choice as to which particular version you've got. You've got the latest. And as I said before, for managed instances, you can use SQL Agent Jobs. You can do that on the virtual machines. This is the standard way of automating various jobs. There is a different way. an SQL database. the Elastic Job Agent Service. So these are some of the requirements for your deployment, and these are some of the functional benefits and impact of the possible database offerings.

4. 6, 8. evaluate scalability and security aspects

In this video, we're going to start by looking at the scalability of these various database offerings. So first of all, as for your SQL database, it really depends on what version you go for. So it starts off at around the 1 TB level. So we've got 1 TB here for this generation five underscore two; we've got half a terabyte here for this earlier version. And then once you progress through all of the various models, you get up to around four terabytes. If you want to go higher, you can use the Hyperscale model, which we'll go over briefly in later videos. For an Azure SQL managed instance, if you're looking at the general purpose, you can have up to eight terabytes, and for the business critical, you can have between one and four terabytes. Again, it depends on what you're provisioning. Now you can have up to 100 databases. So the managed instance itself supports all these different databases. SQL Server on Azure Virtual Machines Well, it entirely depends how much you can get on a particular machine. So you can go up to 256 terabytes and have up to 50 instances per server. Now, the size of your virtual machine can be changed whenever you need, as can the compute power. Now, with Azure SQL Database, the size of a single database or the elastic pool can be changed as needed. as is the case with the managed instance. With the size that you've got within a managed instance, you don't actually have elastic pools because there's no need. Everything, basically, is in the pool. It is a single instance containing lots of databases. You can use resource governance to affect what resources are being used. Now you can also add more compute power. That's called vertically scaling. You can also charge your data into multiple database nodes using SQL Database. This is called horizontal scaling. You can do it if you have managed instances. It's not as easy. Now, with SQL databases, you can change the service tiers from Standard and General Purpose, which use premium disks, to Premium and Business Critical, which use SSDs (solid state disks). For the managed instance, you've only got Premium and Business Critical. SQL Database Basic and Hyper Scale now have two additional service tiers. You can actually change from "Basic" to any of these. It's probably not usual to change all the way from Basic all the way to Business Critical. You can do if you wished. However, you can't change into or out of Hyperscale. So if you start at Hyperscale, that's where you stay. If you want to change it, you have to decommission it. So these are some of the considerations to be made when looking at the scalability of possible database offerings. I also want to talk about the security aspects of these database offerings. So, you've got auditing available. It works at the server level for Managed Instant and Azure Virtual Machines. But the database level for an Azure SQL database? Now, these log files for the auditing are stored in Azure Blob Storage, apart from SQL Server for Azure Virtual Machines, where they are generally stored in the file system or in Windows event logs. Azure Defender is now available for all of these. In fact, I've got a free trial of Azure Defender on my existing Azure SQL database. So you can see, my free trial expires in 26 days. So it includes vulnerability assessment and threat detection. And it costs about two cents per instance, per hour. So that's about fifty cents per day, per instance. You've got data encryption built into a standard using transport layer security, so that is securing data on the move; transparent data encryption TDs, so that's encrypting data that's there on the actual database. And additionally, you can have something called Always Encrypted. Of course, there's also the issue of firewalls. You can use SQL authentication such as username and password on any of these, but obviously you can't use Windows authentication on anything other than an Azure Virtual Machine because that has Windows if you so choose, but you can use Azure Active Directory on any of them, though I think it's more common on the SQL database and the SQL managed instance. So these are some of the security aspects of these database offerings.

5. 7. HA/DR of the possible database offerings

In this video, we're going to have a look at the HADR (high availability and disaster recovery) of the possible database offerings. So first of all, Microsoft has an availability guarantee. Now, it doesn't have any guarantee that your databases will be that accessible. However, if they're not available at that level, then you'll get a partial credit. So you can see SQL Server and virtual machines. The minimum SLA that's a service level agreementis 95% and that means it will beup 19 times out of 20, basically. Now, depending on what you do, you can increase your chances and increase them quite a lot, all the way up to 99.99% of the time. With an Azure SQL managed instance, it has 99.99% availability. With Azure SQL Database, it's 99.95% availability, which is twice as good. In other words, half the amount of downtime. However, it does depend on how you are configuring it. So somewhere between 99.99%, which is called "four nines," and 95%, which is called "four and a half nines," Now, this is apart from the hyperscale version, which is 99.9% to 99 95%.So from three to three and a half and nine s. Now, with SQL Server on an Azure virtual machine, you can configure the availability of replicas using a domain controller virtual machine. So what all of this means is that if one particular instance goes down, then you can switch over to another replica. As a result, this is a component of SQL Database high availability and disaster recovery. Then you have locally redundant availability at the basic, standard, and general purpose levels. And you'll notice that those three are frequently grouped together, whereas in the premium business-critical or elastic pools, a three- to four-node cluster with either local or zone redundant availability is automatically included. And you can also add read-only replicas, which are versions that you can read. Now you might be going, "Okay, what's this local and zone and all the rest?" Well, let's just have a look at a particular region. So obviously these computers have to be stored somewhere. So they are stored in geographic regions likefor instance West US or South United Kingdom. Now, each of these is housed in, let's call it, a building. It might be several buildings. And they have their own servers, maybe lots of servers, and they have their own electricity, their own networking, and their own cooling. Now, if it's locally replicated, then you'll find that you may have one version here and another version here. So if this one fails, this one can take over. However. a zone version. So this could be an availability zone willhave at least three buildings, each of whichwill have their own generation, each of whichwill have their own networking and their cooling. So you may have a version here, a version here, and a version here. So let's say there was an earthquake in this particular area, which knocked the entire building offline. Well, if you had locally replicated them, then all three versions might be off. But if you had zones replicated, then you would have them in different geographical areas geographically.So the failure of one building would not necessarily affect the other two because they have their own infrastructure. Now, you could have availability sets, by the way; that's also within one particular building. The advantage of this is that you would have up to five updated domains. So in other words, five sets of computers And what happens? Let's say this computer needs to be updated. It will update this computer; it will finish updating that computer's operating system; but it won't go onto the next computer or the next set of computers until this first set is finished. So that allows you some certainty that not all of your virtual machines will be shutdown at the same time for updates. So in addition to locally redundant and zone redundant, you can also have georedundant data, which means data from more than one region. So you might have it in the west or the east us.So, when it comes to database deployment, we have locally redundant, zone redundant, and geo redundant options. So you've got your pick of your redundancies. So you can see when we use local or zone-wide redundant availability. If one of the nodes gets knocked out, then the other nodes can say we're still here. Zone redundant configuration is also possible at the general-purpose level for Azure SQL Database. And no doubt Azure will be adding bit by bitwhat you can do with all of the various things. Now with SQL Server and Azure virtual machines, you can configure backups, but you have to do that yourself. We can use a plugin to help automate them, but essentially, if you're in charge of a SQL Database and managed instance, you can have automated backups; in fact, you have to have them because they're included in the price and include full differential and transaction log backups for seven to 35 days. I think you could go all the way down to one, but seven is the default and generally you would expand it rather than collapse it. You can also have full database backups for longterm backup retention, also called LTR. And this is configurable in the Azure SQL Database and can be done on demand, essentially copying the backups for longer-term backup retention. Now, with the appropriate backups, you can do point-in-time restores. What does that mean? Well, let's say it is now quarter past two and I want to restore the database as it was at five minutes past two because something has gone badly wrong—somebody's deleted a table. You can do that. You can do it at 20, 5, and 7 seconds. You will need full differential and transaction logs, which are of course automatically included in the Azure SQL Database and Azure SQL managed instance. You have to configure it in the virtual machine version. So, if you have those, you can do point in Time Restores. On the virtual machine, you can configure geo-replication storage. In other words, I have my files on one disk, and they are on another disc in a different region, country, or continent; even this occurs asynchronously, that is, it does not occur at the same time. It might be that I finish doing something on one computer, write a file, and then a few seconds later, a few minutes later, it's on another file, and it takes time to get there. Active geo-replication can be configured with SQL Database. So this means that your database just gets duplicated onto up to four readable secondary databases, and then finally you can use failover. So what does failover mean? Well, let's say I've got several databases replicated. Something goes wrong with one particular database, the infrastructure fails, and it will failover to one of the backups. So the primary fails and fails over to a secondary. The secondary calls, "Okay, I am now the primary." You can do something similar with SQL Server and Azure Virtual Machines using something called shared storage. So these are the features and requirements for high availability and disaster recovery.

Read More

Download Free Microsoft Azure Database DP-300 Practice Test Questions, Microsoft Azure Database DP-300 Exam Dumps

File Votes Size Last Comment
Microsoft.realtests.DP-300.v2024-01-24.by.zhangyong.114q.vce 1 3.12 MB  
Microsoft.examquestions.DP-300.v2021-10-26.by.imogen.102q.vce 1 3.36 MB  
Microsoft.realtests.DP-300.v2021-08-05.by.lucas.89q.vce 1 2.55 MB  
Microsoft.practicetest.DP-300.v2021-07-08.by.louis.68q.vce 1 1.55 MB  
Microsoft.train4sure.DP-300.v2021-04-28.by.ellis.45q.vce 1 1.2 MB  
Microsoft.testking.DP-300.v2020-08-16.by.emily.24q.vce 3 517.94 KB  
Votes
3
Size
517.94 KB
Last Comment
 
Comments
* The most recent comment are at the top

Add Comments

Feel Free to Post Your Comments About EamCollection's Microsoft Azure Database DP-300 Certification Video Training Course which Include Microsoft DP-300 Exam Dumps, Practice Test Questions & Answers.

Similar Microsoft Video Courses

Administering a SQL Database Infrastructure
113
4.4
9 hrs
70-764 - Administering a SQL Database Infrastructure
Administering Microsoft System Center Configuration Manager and Cloud Services Integration
132
4.5
4 hrs
70-703 - Administering Microsoft System Center Configuration Manager and Cloud Services Integration
Administering Windows Server 2012
451
4.5
8 hrs
70-411 - Administering Windows Server 2012
Administering Windows Server Hybrid Core Infrastructure
119
5.0
18 hrs
$24.99
AZ-800 - Administering Windows Server Hybrid Core Infrastructure
Analyzing and Visualizing Data with Microsoft Excel
135
4.6
5 hrs
70-779 - Analyzing and Visualizing Data with Microsoft Excel
Analyzing and Visualizing Data with Microsoft Power BI
102
4.3
11 hrs
70-778 - Analyzing and Visualizing Data with Microsoft Power BI
Analyzing Data with Microsoft Power BI
137
5.0
1 hr
$24.99
DA-100 - Analyzing Data with Microsoft Power BI
Architecting Microsoft Azure Solutions
129
4.5
1 hr
70-535 - Architecting Microsoft Azure Solutions
Architecting Microsoft Azure Solutions (70-534)
516
4.6
1 hr
70-534 - Architecting Microsoft Azure Solutions (70-534)
Cloud Fundamentals
124
4.6
1 hr
98-369 - Cloud Fundamentals
Configuring Advanced Windows Server 2012 Services
198
4.6
8 hrs
70-412 - Configuring Advanced Windows Server 2012 Services
Configuring and Operating Microsoft Azure Virtual Desktop
102
5.0
6 hrs
$24.99
AZ-140 - Configuring and Operating Microsoft Azure Virtual Desktop
Configuring Windows Devices
285
4.6
16 hrs
70-697 - Configuring Windows Devices
Configuring Windows Server Hybrid Advanced Services
136
5.0
19 hrs
$24.99
AZ-801 - Configuring Windows Server Hybrid Advanced Services
Core Solutions of Microsoft Exchange Server 2013
102
4.6
1 hr
70-341 - Core Solutions of Microsoft Exchange Server 2013
Core Solutions of Microsoft SharePoint Server 2013
97
4.5
1 hr
70-331 - Core Solutions of Microsoft SharePoint Server 2013
Data Engineering on Microsoft Azure
115
5.0
10 hrs
$24.99
DP-203 - Data Engineering on Microsoft Azure
Database Fundamentals
94
4.5
3 hrs
$24.99
98-364 - Database Fundamentals
Deploying Microsoft 365 Teamwork
126
4.6
1 hr
MS-300 - Deploying Microsoft 365 Teamwork
Deploying SharePoint Server Hybrid
93
4.5
1 hr
MS-301 - Deploying SharePoint Server Hybrid
Designing an Azure Data Solution
87
4.5
5 hrs
DP-201 - Designing an Azure Data Solution
Designing and Deploying Microsoft Exchange Server 2016
144
4.4
2 hrs
70-345 - Designing and Deploying Microsoft Exchange Server 2016
Designing and Implementing a Data Science Solution on Azure
132
4.6
9 hrs
$24.99
DP-100 - Designing and Implementing a Data Science Solution on Azure
Designing and Implementing a Microsoft Azure AI Solution
113
5.0
5 hrs
$24.99
AI-102 - Designing and Implementing a Microsoft Azure AI Solution
Designing and Implementing an Azure AI Solution
125
4.5
2 hrs
AI-100 - Designing and Implementing an Azure AI Solution
Designing and Implementing Cloud Data Platform Solutions
104
4.5
1 hr
70-473 - Designing and Implementing Cloud Data Platform Solutions
Designing and Implementing Microsoft Azure Networking Solutions
87
5.0
5 hrs
$24.99
AZ-700 - Designing and Implementing Microsoft Azure Networking Solutions
Designing and Implementing Microsoft DevOps Solutions
135
4.5
2 hrs
$24.99
AZ-400 - Designing and Implementing Microsoft DevOps Solutions
Designing Business Intelligence Solutions with Microsoft SQL Server 2012
131
4.5
4 hrs
70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012
Designing Database Solutions for Microsoft SQL Server 2012
130
4.5
6 hrs
70-465 - Designing Database Solutions for Microsoft SQL Server 2012
Designing Microsoft Azure Infrastructure Solutions
94
5.0
8 hrs
$24.99
AZ-305 - Designing Microsoft Azure Infrastructure Solutions
Developing Microsoft Azure Solutions
367
4.6
1 hr
70-532 - Developing Microsoft Azure Solutions
Developing Microsoft SharePoint Server 2013 Core Solutions
100
4.5
1 hr
70-488 - Developing Microsoft SharePoint Server 2013 Core Solutions
Developing Microsoft SQL Server 2012/2014 Databases
128
4.6
4 hrs
70-464 - Developing Microsoft SQL Server 2012/2014 Databases
Developing Solutions for Microsoft Azure
130
4.5
1 hr
AZ-203 - Developing Solutions for Microsoft Azure
Developing Solutions for Microsoft Azure
98
4.6
14 hrs
$24.99
AZ-204 - Developing Solutions for Microsoft Azure
Developing SQL Data Models
100
4.5
7 hrs
70-768 - Developing SQL Data Models
Developing SQL Databases
141
4.5
8 hrs
70-762 - Developing SQL Databases
Enabling Office 365 Services
484
4.5
1 hr
70-347 - Enabling Office 365 Services
Endpoint Administrator
138
5.0
13 hrs
$24.99
MD-102 - Endpoint Administrator
Excel 2013
126
4.6
11 hrs
$24.99
77-420 - Excel 2013
Excel 2016: Core Data Analysis, Manipulation, and Presentation
90
4.5
6 hrs
$24.99
77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
Identity with Windows Server 2016
98
4.5
20 hrs
70-742 - Identity with Windows Server 2016
Implementing a Hybrid and Secure Messaging Platform
112
4.5
4 hrs
MS-201 - Implementing a Hybrid and Secure Messaging Platform
Implementing a SQL Data Warehouse
140
4.3
6 hrs
70-767 - Implementing a SQL Data Warehouse
Implementing an Azure Data Solution
137
4.5
5 hrs
DP-200 - Implementing an Azure Data Solution
Implementing Data Models and Reports with Microsoft SQL Server 2012
124
4.5
5 hrs
70-466 - Implementing Data Models and Reports with Microsoft SQL Server 2012
Implementing Microsoft Azure Infrastructure Solutions
296
4.5
1 hr
70-533 - Implementing Microsoft Azure Infrastructure Solutions
Installation, Storage, and Compute with Windows Server 2016
439
4.5
8 hrs
70-740 - Installation, Storage, and Compute with Windows Server 2016
Installing and Configuring Windows Server 2012
315
4.4
10 hrs
70-410 - Installing and Configuring Windows Server 2012
Introduction to Programming Using Python
101
4.6
7 hrs
$24.99
98-381 - Introduction to Programming Using Python
Managing Microsoft SharePoint Server 2016
123
4.5
1 hr
70-339 - Managing Microsoft SharePoint Server 2016
Managing Microsoft Teams
135
4.5
9 hrs
$24.99
MS-700 - Managing Microsoft Teams
Managing Modern Desktops
141
4.5
7 hrs
$24.99
MD-101 - Managing Modern Desktops
Managing Office 365 Identities and Requirements
112
4.6
1 hr
70-346 - Managing Office 365 Identities and Requirements
Managing Projects with Microsoft Project 2013
85
4.6
1 hr
74-343 - Managing Projects with Microsoft Project 2013
MCSA Administering Microsoft SQL Server 2012/2014 Databases
477
4.6
11 hrs
70-462 - MCSA Administering Microsoft SQL Server 2012/2014 Databases
MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
100
4.5
6 hrs
70-463 - MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
MCSA Networking with Windows Server 2016
142
4.6
5 hrs
70-741 - MCSA Networking with Windows Server 2016
MCSA Querying Microsoft SQL Server 2012/2014
546
4.5
12 hrs
70-461 - MCSA Querying Microsoft SQL Server 2012/2014
MCSD Developing ASP.NET MVC Web Applications
131
4.6
18 hrs
70-486 - MCSD Developing ASP.NET MVC Web Applications
MCSD Developing Windows Azure and Web Services
102
4.6
13 hrs
70-487 - MCSD Developing Windows Azure and Web Services
MCSD Programming in C#
370
4.5
8 hrs
70-483 - MCSD Programming in C#
MCSD Programming in HTML5 with JavaScript and CSS3
156
4.6
7 hrs
70-480 - MCSD Programming in HTML5 with JavaScript and CSS3
MCSE Designing and Implementing a Server Infrastructure
683
4.5
9 hrs
70-413 - MCSE Designing and Implementing a Server Infrastructure
MCSE Implementing an Advanced Server Infrastructure
220
4.4
8 hrs
70-414 - MCSE Implementing an Advanced Server Infrastructure
Microsoft 365 Administrator
134
5.0
5 hrs
$24.99
MS-102 - Microsoft 365 Administrator
Microsoft 365 Fundamentals
86
4.5
2 hrs
$24.99
MS-900 - Microsoft 365 Fundamentals
Microsoft 365 Identity and Services
94
4.5
3 hrs
$24.99
MS-100 - Microsoft 365 Identity and Services
Microsoft 365 Messaging
132
4.4
11 hrs
$24.99
MS-203 - Microsoft 365 Messaging
Microsoft 365 Mobility and Security
135
4.5
5 hrs
$24.99
MS-101 - Microsoft 365 Mobility and Security
Microsoft 365 Security Administration
117
4.5
7 hrs
$24.99
MS-500 - Microsoft 365 Security Administration
Microsoft Access Expert Exam
141
5.0
8 hrs
$24.99
MO-500 - Microsoft Access Expert Exam
Microsoft Azure Administrator
134
4.5
10 hrs
$24.99
AZ-104 - Microsoft Azure Administrator
Microsoft Azure Administrator
121
4.6
7 hrs
AZ-103 - Microsoft Azure Administrator
Microsoft Azure AI Fundamentals
126
5.0
5 hrs
$24.99
AI-900 - Microsoft Azure AI Fundamentals
Microsoft Azure Architect Design
115
4.5
9 hrs
AZ-301 - Microsoft Azure Architect Design
Microsoft Azure Architect Design
100
4.5
12 hrs
$24.99
AZ-304 - Microsoft Azure Architect Design
Microsoft Azure Architect Technologies
114
4.6
10 hrs
$24.99
AZ-303 - Microsoft Azure Architect Technologies
Microsoft Azure Architect Technologies
113
4.6
9 hrs
AZ-300 - Microsoft Azure Architect Technologies
Microsoft Azure Data Fundamentals
118
4.4
2 hrs
$24.99
DP-900 - Microsoft Azure Data Fundamentals
Microsoft Azure Fundamentals
121
4.7
3 hrs
$24.99
AZ-900 - Microsoft Azure Fundamentals
Microsoft Azure Security Technologies
112
4.5
7 hrs
$24.99
AZ-500 - Microsoft Azure Security Technologies
Microsoft Cybersecurity Architect
122
5.0
12 hrs
$24.99
SC-100 - Microsoft Cybersecurity Architect
Microsoft Dynamics 365 Business Central Functional Consultant
105
5.0
1 hr
$24.99
MB-800 - Microsoft Dynamics 365 Business Central Functional Consultant
Microsoft Dynamics 365 customer engagement Online Deployment
126
4.6
1 hr
MB2-715 - Microsoft Dynamics 365 customer engagement Online Deployment
Microsoft Dynamics 365 Customer Service Functional Consultant
116
4.5
2 hrs
$24.99
MB-230 - Microsoft Dynamics 365 Customer Service Functional Consultant
Microsoft Dynamics 365 Customization and Configuration
111
4.5
12 hrs
MB2-716 - Microsoft Dynamics 365 Customization and Configuration
Microsoft Dynamics 365 Finance Functional Consultant
95
5.0
8 hrs
$24.99
MB-310 - Microsoft Dynamics 365 Finance Functional Consultant
Microsoft Dynamics 365 for Field Service
98
4.5
1 hr
$24.99
MB-240 - Microsoft Dynamics 365 for Field Service
Microsoft Dynamics 365 for Sales
86
4.6
1 hr
MB2-717 - Microsoft Dynamics 365 for Sales
Microsoft Dynamics 365 for Sales
145
5.0
9 hrs
$24.99
MB-210 - Microsoft Dynamics 365 for Sales
Microsoft Dynamics 365 Fundamentals
143
5.0
3 hrs
MB-901 - Microsoft Dynamics 365 Fundamentals
Microsoft Dynamics 365: Core Finance and Operations
94
5.0
3 hrs
$24.99
MB-300 - Microsoft Dynamics 365: Core Finance and Operations
Microsoft Dynamics CRM 2016 Customization and Configuration
117
4.5
3 hrs
$24.99
MB2-712 - Microsoft Dynamics CRM 2016 Customization and Configuration
Microsoft Dynamics CRM 2016 Sales
125
4.4
1 hr
MB2-713 - Microsoft Dynamics CRM 2016 Sales
Microsoft Excel (Excel and Excel 2019)
142
4.5
11 hrs
$24.99
MO-200 - Microsoft Excel (Excel and Excel 2019)
Microsoft Excel Expert (Excel and Excel 2019)
107
5.0
8 hrs
$24.99
MO-201 - Microsoft Excel Expert (Excel and Excel 2019)
Microsoft Identity and Access Administrator
128
5.0
3 hrs
$24.99
SC-300 - Microsoft Identity and Access Administrator
Microsoft Information Protection Administrator
142
5.0
6 hrs
$24.99
SC-400 - Microsoft Information Protection Administrator
Microsoft Power BI Data Analyst
104
5.0
3 hrs
$24.99
PL-300 - Microsoft Power BI Data Analyst
Microsoft Power Platform + Dynamics 365 Core
135
5.0
10 hrs
MB-200 - Microsoft Power Platform + Dynamics 365 Core
Microsoft Power Platform App Maker
103
5.0
15 hrs
$24.99
PL-100 - Microsoft Power Platform App Maker
Microsoft Power Platform Developer
119
5.0
11 hrs
$24.99
PL-400 - Microsoft Power Platform Developer
Microsoft Power Platform Functional Consultant
124
5.0
7 hrs
$24.99
PL-200 - Microsoft Power Platform Functional Consultant
Microsoft Power Platform Fundamentals
135
5.0
6 hrs
$24.99
PL-900 - Microsoft Power Platform Fundamentals
Microsoft Security Operations Analyst
126
5.0
12 hrs
$24.99
SC-200 - Microsoft Security Operations Analyst
Microsoft Security, Compliance, and Identity Fundamentals
137
5.0
7 hrs
$24.99
SC-900 - Microsoft Security, Compliance, and Identity Fundamentals
Microsoft Word (Word and Word 2019)
111
5.0
5 hrs
$24.99
MO-100 - Microsoft Word (Word and Word 2019)
Networking Fundamentals
122
4.5
4 hrs
$24.99
98-366 - Networking Fundamentals
Perform Cloud Data Science with Azure Machine Learning
100
4.5
1 hr
70-774 - Perform Cloud Data Science with Azure Machine Learning
Planning and Administering Microsoft Azure for SAP Workloads
97
5.0
5 hrs
$24.99
AZ-120 - Planning and Administering Microsoft Azure for SAP Workloads
Planning and Configuring a Messaging Platform
135
4.5
4 hrs
MS-200 - Planning and Configuring a Messaging Platform
Provisioning SQL Databases
141
4.6
8 hrs
70-765 - Provisioning SQL Databases
Querying Data with Transact-SQL
120
4.6
6 hrs
70-761 - Querying Data with Transact-SQL
Securing Windows Server 2016
90
4.5
13 hrs
70-744 - Securing Windows Server 2016
Security Fundamentals
110
4.6
6 hrs
$24.99
98-367 - Security Fundamentals
SharePoint 2010
97
4.4
2 hrs
$24.99
77-886 - SharePoint 2010
Software Development Fundamentals
112
4.5
5 hrs
$24.99
98-361 - Software Development Fundamentals
Technology Literacy for Educators
143
5.0
1 hr
$24.99
62-193 - Technology Literacy for Educators
Upgrading Your Skills to MCSA Windows Server 2012
124
4.5
5 hrs
70-417 - Upgrading Your Skills to MCSA Windows Server 2012
Upgrading Your Skills to MCSA: Windows Server 2016
140
4.5
2 hrs
70-743 - Upgrading Your Skills to MCSA: Windows Server 2016
Windows 10
97
4.5
6 hrs
$24.99
MD-100 - Windows 10
Windows Operating System Fundamentals
144
4.4
3 hrs
$24.99
98-349 - Windows Operating System Fundamentals
Windows Server Administration Fundamentals
124
4.6
6 hrs
$24.99
98-365 - Windows Server Administration Fundamentals
Cloud Fundamentals
Cloud Fundamentals
124
4.6
1 hr
Excel 2013
$24.99
Excel 2013
126
4.6
11 hrs
Windows 10
$24.99
Windows 10
97
4.5
6 hrs

Only Registered Members Can Download VCE Files or View Training Courses

Please fill out your email address below in order to Download VCE files or view Training Courses. Registration is Free and Easy - you simply need to provide an email address.

  • Trusted By 1.2M IT Certification Candidates Every Month
  • VCE Files Simulate Real Exam Environment
  • Instant Download After Registration.
Please provide a correct e-mail address
A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Log into your ExamCollection Account

Please Log In to download VCE file or view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

Only registered Examcollection.com members can download vce files or view training courses.

Registration is free and easy - just provide your E-mail address. Click Here to Register

SPECIAL OFFER: GET 10% OFF

ExamCollection Premium

ExamCollection Premium Files

Pass your Exam with ExamCollection's PREMIUM files!

  • ExamCollection Certified Safe Files
  • Guaranteed to have ACTUAL Exam Questions
  • Up-to-Date Exam Study Material - Verified by Experts
  • Instant Downloads
Enter Your Email Address to Receive Your 10% Off Discount Code
A Confirmation Link will be sent to this email address to verify your login
We value your privacy. We will not rent or sell your email address

SPECIAL OFFER: GET 10% OFF

Use Discount Code:

MIN10OFF

A confirmation link was sent to your e-mail.
Please check your mailbox for a message from support@examcollection.com and follow the directions.

Next

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.