Purchase from these online retailers:
Prepare for Microsoft Exam 70-765—and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.
Focus on the expertise measured by these objectives:
- Implement SQL in Azure
- Manage databases and instances
- Manage storage
This Microsoft Exam Ref:
- Organizes its coverage by exam objectives
- Features strategic, what-if scenarios to challenge you
- Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills
This book contains three chapters to define and detail the objectives of the Microsoft 70-765 exam. The content contained in this publication covers what you should expect to see on the exam, but you should have a solid working knowledge of SQL Server and Azure skills. It is recommended to concentrate on one chapter at a time as you study the materials contained in this guide. At the end of each chapter you will find a thought experiment that you should complete. Complete the questions and review the answers for each experiment to test your knowledge of the subject material.
The exam reference series covers a high level of knowledge that you are expected to know in regards to the exam by covering why topics and “how to” processes with tasks allowing you to fully understand a topic and its use with the product in a working environment. The exam reference series makes the assumption you have some practical experience in the subject material through regular use of SQL Server, or possibly a previous version of the product. To be successful in taking the exam, you should be able to plan and architect Azure SQL Database, SQL Server in Azure IaaS, and SQL Server on-premises based solutions.
There are specific walkthroughs in different areas of the book, especially in new feature topic areas. There are numerous notes and links to external material so you can deep dive into additional subjects that will enable you to gain a more in depth understanding of features of SQL Server and allow you to obtain a better understanding of the subject material.
This book covers all of the objectives of the exam, however it may not cover every exam question. Only the Microsoft exam team knows the exam questions. Exam questions are regularly updated, so this book should be considered a supplement to real use experience of SQL Server, and not a complete comprehensive guide to every exam question. This edition of the book covers Azure and SQL Server as of mid-2017. As Azure SQL Database, SQL Server and Azure IaaS evolve, be sure to check the exam objectives to check for any changes or new version related information.
If you master the material in this book, coupled with the external links provided, and use the product to gain real world experience, you should have a recipe for success in your quest for Microsoft certification. Good luck on your goal!
Important: How to use this book to study for the exam
Certification exams validate your on-the-job experience and product knowledge. To gauge your readiness to take an exam, use this Exam Ref to help you check your understanding of the skills tested by the exam. Determine the topics you know well and the areas in which you need more experience. To help you refresh your skills in specific areas, we have also provided “Need more review?” pointers, which direct you to more in-depth information outside the book.
The Exam Ref is not a substitute for hands-on experience. This book is not designed to teach you new skills.
We recommend that you round out your exam preparation by using a combination of available study materials and courses. Learn more about available classroom training at https://www.microsoft.com/learning. Microsoft Official Practice Tests are available for many exams at https://aka.ms/practicetests. You can also find free online courses and live events from Microsoft Virtual Academy at https://www.microsoftvirtualacademy.com.
This book is organized by the “Skills measured” list published for the exam. The “Skills measured” list for each exam is available on the Microsoft Learning website: https://aka.ms/examlist.
Note that this Exam Ref is based on publicly available information and the author’s experience. To safeguard the integrity of the exam, authors do not have access to the exam questions.
About the authors
JOSEPH D'ANTONI is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry & Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He holds a BS in Computer Information Systems from Louisiana Tech University.
SCOTT KLEIN CTO of Cloud and Devices with nearly two decades of experience working with Microsoft SQL Server. Prior to becoming CTO, Scott spent six years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books, his latest focuses on using Microsoft’s IoT suite to process and analyze data. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.