According to the news of Microsoft Official website, Microsoft 70-457 exam will be retired on July 31, 2016. 70-457 exam topics are valuable in your preparation. 

Create database objects

Work with data

Modify data

Troubleshoot and optimize queries

Install and configure SQL Server

Maintain instances and databases

Optimize and troubleshoot SQL Server