Perhaps this is your first step toward the certification, or perhaps you are coming back for another round. We hope that you feel this exam challenges you, teaches you, and prepares you to pass the 70-461. If this is your first study guide, take a moment to relax. This could be the first step to a new high-paying job and an amazing career.

The 70-461 or as it’s also known, the MCSA Querying Microsoft SQL Server 2012-2014, like all tests, there is a bit of freedom on Microsoft's part to exam an array of subjects. That means knowing the majority of 70-461 content is required because they test randomly on the many subjects available. Be aware too that experience requirements often exist because they’ve observed the average person and what is required. You can always push past that to succeed with the 70-461 but it may take some extra work.

• Create database objects (20-25%)

• Work with data(25-30%)

• Modify data(20-25%)

• Troubleshoot and optimize(25-30%)