Table Of ContentMC
Microsoft Certified
Azure Data Fundamentals
Study Guide
MC
Microsoft Certified
Azure Data Fundamentals
Study Guide
EXAM DP- 900
Jake Switzer
Copyright © 2022 by John Wiley & Sons, Inc. All rights reserved.
Published by John Wiley & Sons, Inc., Hoboken, New Jersey.
Published simultaneously in Canada and the United Kingdom.
978- 1- 119- 85583- 5
978- 1- 119- 85585- 9 (ebk.)
978- 1- 119- 85584- 2 (ebk.)
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by
any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under
Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the
Publisher, or authorization through payment of the appropriate per- copy fee to the Copyright Clearance Center,
Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750- 8400, fax (978) 750- 4470, or on the web at
www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department,
John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748- 6011, fax (201) 748- 6008, or online at
www.wiley.com/go/permission.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with
respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including
without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or
promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work
is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional
services. If professional assistance is required, the services of a competent professional person should be sought.
Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or
Website is referred to in this work as a citation and/or a potential source of further information does not mean that
the author or the publisher endorses the information the organization or Website may provide or recommendations
it may make. Further, readers should be aware the Internet Websites listed in this work may have changed or
disappeared between when this work was written and when it is read.
For general information on our other products and services or for technical support, please contact our Customer
Care Department within the United States at (800) 762- 2974, outside the United States at (317) 572- 3993 or fax
(317) 572- 4002.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be
available in electronic formats. For more information about Wiley products, visit our web site at www.wiley.com.
Library of Congress Control Number: 2021950194
Trademarks: WILEY, the Wiley logo, and the Sybex logo are trademarks or registered trademarks of John Wiley
& Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without written
permission. Microsoft and Azure are registered trademarks of Microsoft Corporation. All other trademarks are the
property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned
in this book. MC Microsoft Certified Azure Data Fundamentals Study Guide is an independent publication and is
neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.
Cover image: ©Jeremy Woodhouse/Getty Images
Cover design: Wiley
Acknowledgments
While I have been able to work on several exciting opportunities in my professional career
at Microsoft, including delivering live presentations and working with some of the biggest
brand name organizations the world, this was my first time tackling a technical book. This
project was both intense and incredibly rewarding, as it allowed me to share what I believe
are the fundamental skills anyone will need to start a successful career with the Microsoft
data stack. However, this would not have been possible without the support from the follow-
ing people.
First and foremost, I would like to thank my wife, Kaiya, for her love and support during
the writing of this book. It is from her that I gather inspiration to be my best self every day.
Thanks to my mom and dad for their unrelenting support and helping me make the most of
every opportunity.
I would also like to thank my colleague Susanne Tedrick, author of WOMEN OF
COLOR IN TECH: A Blueprint for Inspiring and Mentoring the Next Generation of Tech-
nology Innovators, (Wiley, 2020) for reaching out to me when this opportunity became
available and to Kenyon Brown, the acquisitions editor, for helping me get it off the ground.
Many thanks to Ayman El-G hazali, the technical editor for this book and a mentor of mine
throughout my time at Microsoft. Special thanks to Jon Flynn and Tash Tahir, two of my
colleagues at Microsoft, for taking the time out of their busy schedule to review the content.
Finally, thank you to the entire team who made this book come together, including
David Clark (project editor), Pete Gaughan (managing editor), Judy Flynn (copyeditor), and
Barath Kumar Rajasekaran, who polished the rough content and made sure the project kept
moving. Thanks also to all of the people who work behind the scenes with the production of
this book.
About the Author
Jake Switzer has been using technology to build data- oriented solutions since his time as
a student at the University of Alabama. He has held delivery and advisory roles at Micro-
soft for over nine years, including as a consultant and cloud solution architect. Jake has
designed and developed data platform and advanced analytics solutions for an assortment
of Microsoft enterprise customers to ensure that their specific business needs were met. Over
the last few years, he has focused on advising Microsoft’s sports customers how to design
and build modern data solutions in Azure. His responsibilities in this role include providing
architecture guidance, building proof of concepts, aiding in production deployments, and
troubleshooting support issues. He is well- versed in a variety of data engineering technol-
ogies and frameworks such as SQL Server, Apache Spark, Azure Data Factory, Azure Data-
bricks, Azure Synapse Analytics, and Power BI. In his free time, he enjoys spending time
outdoors hiking and can be found most weekends cooking and sharing a scotch with
his wife.
