70-765 Provisioning SQL Databases

Exam Preparation Microsoft Certification for SQL server 2016, Exam 70-765

3.55 (46 reviews)
Udemy
platform
English
language
IT Certification
category
70-765 Provisioning SQL Databases
407
students
200 questions
content
Nov 2020
last update
$19.99
regular price

What you will learn

Able to understand exam patterns

able to solve certification exam questions.

Description

Update Alert

1 Dec 2020

  • Re-Written Practice test- 2,3 and 4 with improved English.

  • Added new Practice Test -5 with 20 new questions.


30 Nov 2020

  • Re-Written Practice test- 1 with improved English.


Microsoft MCSA  70-765 for SQL server Practice Test 

MCSA 70-765 practice test

This course contain 3 Practice test for Microsoft Certification  exam 70-765 for SQL server 2016.

It cover 100% of Microsoft certification syllabus. 

You can find questions more on practical side,they will help you to solve your real time problems.

Course Detail 

Deploy a Microsoft Azure SQL Database

  • Deploy a Microsoft Azure SQL Database

    • Choose a service tier, create servers and databases, create a sysadmin account, configure elastic pools

  • Plan for SQL Server installation

    • Plan for an IaaS or on-premises deployment, select the appropriate size for a virtual machine, plan storage pools based on performance requirements, evaluate best practices for installation, design a storage layout for a SQL Server virtual machine

  • Deploy SQL Server instances

    • Deploy a SQL Server instance in IaaS and on-premises, manually install SQL Server on an Azure Virtual Machine, provision an Azure Virtual Machine to host a SQL Server instance, automate the deployment of SQL Server databases, deploy SQL Server by using templates

  • Deploy SQL Server databases to Azure virtual machines

    • Migrate an on-premises SQL Server database to an Azure virtual machine, generate benchmark data for performance needs, perform performance tuning on Azure IaaS, support availability sets in Azure

Manage Database and instances 

  • Configure secure access to Microsoft Azure SQL Databases

    • Configure firewall rules, configure Always Encrypted for Azure SQL Database, configure cell-level encryption, configure dynamic data masking, configure transparent data encryption (TDE)

  • Configure SQL Server performance settings

    • Configure database performance settings, configure max server memory, configure the database scope, configure operators and alerts

  • Manage SQL Server instances

    • Create databases, manage files and file groups, manage system database files, configure tempdb

Manage Storage

  • Manage SQL Storage

    • Manage SMB file shares, manage stretch databases, configure Azure storage, change service tiers, review wait statistics, manage storage pools, recover from failed storage

  • Perform database maintenance

    • Monitor DMVs, maintain indexes, automate maintenance tasks, update statistics, verify database integrity, recover from database corruption




Reviews

Regina
December 10, 2020
These tests were not worded well (not good use of English), some answers were incorrect and there were not enough explanations to assist with understanding.
Vassilis
March 11, 2020
This course helped me pass 70 765 exam. Covers all the topics and many questions where exactly the same. some typos need to be reviewed
Sarah
May 24, 2018
Good Sample Questions, I hope you will add more because the question is too basic not enough to pass the real world MS Exam.

Charts

Price

70-765 Provisioning SQL Databases - Price chart

Rating

70-765 Provisioning SQL Databases - Ratings chart

Enrollment distribution

70-765 Provisioning SQL Databases - Distribution chart
1534202
udemy ID
1/31/2018
course created date
11/22/2019
course indexed date
Bot
course submited by