70-764 Administering a SQL Database Infrastructure




70-764 Administering a SQL Database Infrastructure

Update Alert —

26 Nov 2020 —

  • Added new 33 question in Practice Test -5.

  • Corrected Type and grammar Mistakes. 

  • Adding new Practice Test 6 in December 2020


19 Nov 2020 —

  • Added new 12 question in Practice Test -5. 

  • Adding 50+ new question in December 2020


Microsoft MCSA  70-764 for SQL server Practice Test 

MCSA 70-764 practice test

This course contain 5 Practice test for Microsoft Certification  exam 70-764 for SQL server 2016.

It covers 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 

• Configure data access and auditing

  • Configure encryption

    • Implement cell-level encryption, implement Always Encrypted, implement backup encryption, configure transparent data encryption, configure encryption for connections, troubleshoot encryption errors

  • Configure data access and permissions

    • Manage database object permissions, create and maintain users, create and maintain custom roles, configure user options for Azure SQL Database, configure row-level security, configure dynamic data masking

  • Configure auditing

    • Configure an audit on SQL Server, query the SQL Server audit log, manage a SQL Server audit, configure an Azure SQL Database audit, analyze audit logs and reports from Azure SQL Database


• Manage backup and restore of databases

  • Develop a backup strategy

    • Back up very large databases, configure alerting for failed backups, back up databases to Azure, manage transaction log backups, configure database recovery models, configure backup automation

  • Restore databases

    • Perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restores

  • Manage database integrity

    • Implement database consistency checks, identify database corruption, recover from database corruption


• Manage and monitor SQL Server instances

  • Monitor database activity

    • Monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collector

  • Monitor queries

    • Manage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using Extended Events

  • Manage indexes

    • Identify and repair index fragmentation, identify and create missing indexes, identify and drop underutilized indexes, manage existing columnstore indexes

  • Manage statistics

    • Identify and correct outdated statistics, implement Auto Update Statistics, implement statistics for large tables

  • Monitor SQL Server instances

    • Create and manage operators, create and manage SQL Agent alerts, define custom alert actions, define failure actions, configure database mail, configure Policy-Based Management, identify available space on data volumes, identify the cause of performance degradation


• Manage high availability and disaster recovery

  • Implement log shipping

    • Configure log shipping, monitor log shipping

  • Implement AlwaysOn Availability Groups

    • Configure Windows clustering, create an availability group, configure read-only routing, manage failover, create distributed availability groups

  • Implement failover cluster instances

    • Manage shared disks, configure cluster shared volumes



Crack Microsoft Certification for SQL server 2016, Exam 70-764 in very first attempt

Url: View Details

What you will learn
  • Able to understand exam patternss
  • able to solve certification exam questions.

Rating: 4.45

Level: Expert Level

Duration: 225 questions

Instructor: Gulab Chand Tejwani


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.


© 2021 hugecourses.com. All rights reserved.
View Sitemap