Microsoft 70-764: Administering a SQL Database Infrastructure is designed for the professional database administrators and database developers who function in job roles dealing with security, monitory, high availability solutions, and backups. The certification test is focused on Azure SQL and SQL Server 2016. Microsoft 70-764 is definitely a new exam but with some topics that are similar to Microsoft 70-462. Those specialists who have already taken the 70-462 test will surely find there some topics that they have come across. It is essential to mention that this new exam consists of more related topics on Azure SQL and less questions about installation, replication, import/export data, and maintenance.

The Microsoft 70-764 exam contains around 50 questions, and passing it requires that the candidates score at least 700 points on a scale of 1000. Earning 700 points is not the same as 70% because the points associated with each question vary. This means 700 points might be more or less than 70% of the total exam scores. The 70-764 test is available only in English. The technology focus of the exam is SQL Server. Passing the test leads towards the award of the MCP or MCSA certificates.

The Microsoft 70-764 exam is not as extensive as the older version of the test, which means that with an adequate preparation, one can pass it easily. There are some major areas that are covered under this certification exam that the students are required to study in detail. Note that these topics also have several sub-topics that are equally important. They include managing high availability and disaster recovery, configuration of data access and auditing, managing backups and restoration of databases, and monitoring and managing SQL Server instances. Each of these topics has specific percentage that shows the weight of exam questions that are associated to them. The 70-764 certification test is aimed at the database professionals who are saddled with the responsibility of installing, maintaining, and configuring tasks. Some other job roles include ensuring efficient systems operations, setting up databases systems, backing up, securing data from unapproved access and storage.

To enroll for the exam, the candidates are required to pay $165 as the exam fee. Depending on the country of residence, Microsoft 70-764 can be taken as an online proctored delivery or a computer based test. It is essential that the test takers go through the certification page to check if the online proctored delivery is available in their country.