Microsoft Provisioning SQL Databases | 70-765 Exam
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3 students enrolled

Microsoft Provisioning SQL Databases | 70-765 Exam

Pass Microsoft 70-765 Exam on the first attempt. 2 practice tests with 160+ unique questions with explanation.
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3 students enrolled
Created by IT HELP
Last updated 2/2020
English
Microsoft Provisioning SQL Databases | 70-765 Exam
Current price: $12.99 Original price: $19.99 Discount: 35% off
7 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
Requirements
  • Experience in SQL Server Database
Included in This Course
+ Practice Tests
2 Tests 160 questions
Microsoft Provisioning SQL Databases | 70-765 Exam
80 questions
Microsoft Provisioning SQL Databases | 70-765 Exam
80 questions
Description

Course in Pre-Launch Mode,Total number of question will be around 160+.

Microsoft Provisioning SQL Databases | 70-765 Test series

It cover 100% of Microsoft 70-765 certification syllabus.

Exam Topics:

Implement SQL in Azure (40–45%)

  • 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 databases and instances (30-35%)

  • 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 (30–35%)

  • 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

Who this course is for:
  • IT Professionals
  • DBAs