70-473: Designing and Implementing Cloud Data Platform Solutions Exam

Curriculum For This Course

Introduction

3Lectures

Time 00:10:39

Hybrid SQL Server Options

6Lectures

Time 00:23:52

SQL Server in a Virtual Machine (VM)

7Lectures

Time 00:29:35

Design Azure SQL Database

9Lectures

Time 00:39:12

Implement Azure SQL Database

5Lectures

Time 00:20:29

Azure SQL Database for MySQL and PostgreSQL

8Lectures

Time 00:23:28

SQL Server Security

11Lectures

Time 00:31:45

SQL Database Security

3Lectures

Time 00:07:57

High Availability

4Lectures

Time 00:24:16

Scalability

4Lectures

Time 00:16:28

Disaster Recovery

4Lectures

Time 00:06:32

Monitor SQL Server

4Lectures

Time 00:19:52

Congratulations!

1Lectures

Time 00:01:23

Introduction
	1. Introduction	02:38
	2. Exam 70-473 Requirements	03:58
	3. What You Should Already Know	03:17

Hybrid SQL Server Options
	1. Introduction to Hybrid Databases	06:22
	2. Hybrid Disaster Recovery	06:16
	3. Hybrid Data Storage	02:52
	4. Hybrid Security	02:30
	5. Hybrid Data Load	04:05
	6. Hybrid Data Sync	01:09

SQL Server in a Virtual Machine (VM)
	1. SQL Server in a Virtual Machine (VM)	03:33
	2. Creating a VM with SQL Server in Azure	08:54
	3. Connecting to the SQL Server VM	04:08
	4. Configuring Firewall Settings	05:28
	5. SQL Server Storage	02:41
	6. SQL Server Migration	02:41
	7. SQL Server VM Sizes	01:34

Design Azure SQL Database
	1. Introduction to Azure SQL Database	03:36
	2. Design a Solution Architecture	06:04
	3. Design Geo/DR Topology	01:24
	4. Design Security Architecture	06:06
	5. Design Data Load Strategy	03:48
	6. Choose an Appropriate Service Tier	08:25
	7. Deployment Scenarios	02:15
	8. IaaS vs PaaS	03:51
	9. Determine Application Access	02:21

Implement Azure SQL Database
	1. Provision Azure SQL Database	04:43
	2. Configure Firewall Rules	02:45
	3. Configure Geo-Replication	03:12
	4. Migrate On-Premises SQL to SQL Database	02:41
	5. Configure Scaling and Performance	06:37

Azure SQL Database for MySQL and PostgreSQL
	1. Design and Implement MySQL and PostgreSQL	02:47
	2. MySQL and PostgreSQL Security	01:37
	3. MySQL and PostgreSQL Data Load	02:44
	4. MySQL and PostgreSQL Service Tiers	01:45
	5. MySQL and PostgreSQL Provisioning	06:59
	6. MySQL and PostgreSQL Firewalls	01:53
	7. MySQL and PostgreSQL Migration	02:43
	8. MySQL and PostgreSQL Scaling	01:59

SQL Server Security
	1. Overview of Security	02:59
	2. Firewalls	04:59
	3. Connecting to SQL Server	04:32
	4. Logins, Users and Roles	02:58
	5. Assign Permissions	03:03
	6. Auditing	01:54
	7. Transparent Data Encryption (TDE)	01:16
	8. Row Level Security	01:07
	9. Data Encryption	02:07
	10. Data Masking	02:13
	11. Always Encrypted	03:09

SQL Database Security
	1. Differences Between SQL Server and Azure Database Security	01:49
	2. Firewalls	02:18
	3. Threat Detection	03:21

High Availability
	1. Overview of High Availability	04:55
	2. Design an HA Topology	07:22
	3. Design an HA Solution on SQL Server for VM	04:49
	4. Implement AlwaysOn Availability Groups	06:46

Scalability
	1. Overview of Scalability	03:22
	2. Design a Scale-Out Solution	05:15
	3. Multi-Master Scenarios	04:32
	4. Elastic Scale for Azure SQL Database	02:17

Disaster Recovery
	1. Introduction to Disaster Recovery	01:35
	2. Azure SQL Database Data Recovery	01:36
	3. Copy and Export	01:47
	4. Long Term Backups	01:05

Monitor SQL Server
	1. Monitoring SQL Server	01:26
	2. Monitor Database Activity	05:39
	3. DMVs and DMFs	05:18
	4. Monitor Performance	06:54

Congratulations!
	1. Thank you!	01:17

About This Course

Microsoft offers the Designing and Implementing Cloud Data Platform Solutions (70-473) exam. After passing this test, you will acquire the MCSE: Cloud Platform and Infrastructure or the MCSE: Data Management and Analytics certifications. These are high-level Microsoft credentials that can prove you have the abilities required to manage data center, work with cloud technologies, networking, identity management, systems management, and much more. The relevant course will help you prepare for the exam and become a Microsoft certified specialist.

Description

The MCSE: Cloud Platform and Infrastructure certificate approves the abilities in enterprise-scale data solutions and SQL administration. Before gaining MCSE, one should achieve the MCSA certification. The MCSE credentials are legitimate for a long time. As indicated by Microsoft, recertification exams cover the material from similar tests taken initially. With the new elective exam structure, the students have the chance to take the test based on their personal preference every year to "re-procure" the certificate.
The Microsoft training course is designed to understand how to design and implement solutions for data in Microsoft Azure, become a certified specialist, and remain updated with the latest news regarding the platform.

Requirements

Plan a half breed SQL Server arrangement
Screen and investigate databases on Azure
Execute SQL Server on VMs (Azure Virtual Machines)
Structure a database arrangement on Azure SQL database
Structure and actualize Database security
Structure and actualize adaptable arrangements
Structure and actualize high accessibility arrangements
Structure and actualize Azure SQL Database information recuperation
Structure and actualize MySQL and PostgreSQL database arrangements in Azure

Exam details

The exam comes with approximately 40-60 questions.
The questions can be multiple choice, drag and drop, hot areas, case study, etc.
The candidates are given two hours to answer the questions.
The students need to score 700 points out of 1000 to pass the exam.

Exam topics

Designing and implementing database solutions for Cloud Data Platform Solutions
Designing and implementing security
Designing for high disaster recovery, scalability, and availability
Monitoring and managing database implementations for Azure

Target audience

The IT professionals who have the competences, knowledge, and credentials to show their abilities in administering, managing, and designing cloud and infrastructure. It is possible to say that MCSE: Cloud Platform and Infrastructure prepares its holders for the positions, such as a network administrator, a systems engineer, a network engineer, an IT manager, a system administrator, an IT support specialist, and etc. The MCSE: Data Management and Analytics certification is essential for a database designer and a database analyst.

Conclusion

The MCSE: Cloud Platform and Infrastructure and MCSE: Data Management and Analytics credentials show that you have got the abilities for an advancing IT industry. These MCSE certifications will open up professional perspectives and give you the chance to go further in your career. The aptitudes will enhance with the help of this Microsoft training course, and your learning will undoubtedly bring outstanding results.

Career path:

IT Directors
IT Managers
Sr. Systems Engineers
Systems Administrators

The certification provides the holder with an opportunity to earn from around $47,428 to $146,157 on an annual basis.

Free 70-473 Exam Questions & Microsoft 70-473 Dumps
Microsoft.selftesttraining.70-473.v2019-05-13.by.kayole.90q.ete	Views: 368 Downloads: 99	Size: 695.31 KB Votes: 3
Microsoft.testking.70-473.v2019-04-03.by.lydia.83q.ete	Views: 394 Downloads: 92	Size: 497.21 KB Votes: 2
Microsoft.test-king.70-473.v2019-01-21.by.lauren.75q.ete	Views: 518 Downloads: 176	Size: 482.57 KB Votes: 2
Microsoft.prep4sure.70-473.v2018-10-17.by.lastborn223.57q.ete	Views: 742 Downloads: 213	Size: 342.61 KB Votes: 2
Microsoft.Passcertification.70-473.v2017-12-11.by.ksenia.28qs.ete	Views: 1446 Downloads: 703	Size: 867.17 KB Votes: 6

Student Feedback

4.5

Good

52%

48 %

Comments * The most recent comment are at the top

Stella

South Africa

Jan 22, 2019

Great and compact correspondence. I an extremely happy that the instructor was effective and clear to understand explanations. You do not need to continue perusing like a news speaker. However, the result is quite good anyway! In addition to these, the dialect utilized by the educator is very informative and easy to catch. So, it’s worth choosing. Much appreciated.

devonta freeman

Egypt

Jan 20, 2019

A great substance with clarification about Azure SQL and Provisional SQL database and administration levels and scaling the database. Everyone should attempt it at least once.

alex

India

Jan 11, 2019

This course was useful in getting comfortable with the broadness of themes to enable you to comprehend the extent of 70-473. I do feel like it could utilize somewhat more points of interest on the arrangement as I feel a greater part of the test concentrated on PowerShell directions to do the organizations as opposed to the Azure entryway. Be that as it may, this course joined with a Measure Up training exam was an extraordinary combo to pass the exam. Thanks.

marcus

United States

Jan 09, 2019

It improved the Cloud technology as a concept. The slides are not bad but difficult to pursue, with accentuation on the exam’s targets. I can add that the straightforward yet compelling dialect tone makes me understand the ideas effortlessly. A debt of gratitude is for supporting functional tests, which made the preparation and passing much simpler. So, it was great to run with.

julian edelman

Qatar

Jan 04, 2019

I have experienced your impressive course for IaaS and PaaS, which was great. However, this course is just useful not with precedent and less demo. This makes focus on taking in the themes well. A debt of gratitude is for this astounding chance.

calais campbell

Australia

Dec 27, 2018

I appreciated the material. It was immediate to the point, and the dialect utilized, alongside the pacing, was impeccable. I can undoubtedly return to the video on the off chance that I require more explicit insights about a specific point without chasing for it. The material ought to be refreshed a bit, especially in light of the fact that since the video was made, Azure has been refreshed somewhat, and a few things may require a re-contact. To add, I might suspect this is impeccable. I would prepare with this teacher once again.

kyle

Nigeria

Dec 11, 2018

This course is very clear and can be learnt with ease. The addresses are very much developed to enable the students to get each idea effortlessly. Very much illustrated.

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Limited Time Discount Offer
40% Off - Ends in 02:00:00

70-473: Designing and Implementing Cloud Data Platform Solutions

Curriculum For This Course