Are you looking for exciting news from Microsoft? Let’s take a closer look at the new Microsoft certification exam 70-764 – Administering SQL Database Infrastructure. It is currently in development. We have access to information about the topics and technology used in the exam, as well as the exam description.
First, it is important to mention that Microsoft’s certification exam uses SQL Server as a foundation technology. This exam is for database professionals who perform maintenance, installation, and configuration tasks. It covers many topics and is quite complex. These topics are:
Configuring data access (20-25%)
Backup and restore of databases (20-25%)
Monitoring and managing SQL Server instances (35-40%)
Management of high availability and disaster recovery (20-25%)
A successful candidate will be an expert at configuring encryption, data access, permissions, and auditing. He can create backup strategies, restore databases, manage database integrity, and more. You will need to be able monitor database activity, monitor queries and monitor SQL server instances if you want to become Microsoft certified. It will also be a big plus to know how to implement log shipping and AlwaysOn Availability groups, as well as failover cluster instances.
This exam tests your ability to perform the technical tasks previously mentioned. Other responsibilities include setting up database systems and making sure they work efficiently. Also, securing data from unauthorised access by regularly backing up and storing it.
