MC Microsoft Certified Azure Data Fundamentals Study Guide
Home > Mathematics and Science Textbooks > Mathematics > MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900
MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900

MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900


     0     
5
4
3
2
1



International Edition


X
About the Book

The most authoritative and complete study guide for people beginning to work with data in the Azure cloud In MC Azure Data Fundamentals Study Guide: Exam DP-900, expert Cloud Solution Architect Jake Switzer delivers a hands-on blueprint to acing the DP-900 Azure data certification. The book prepares you for the test – and for a new career in Azure data analytics, architecture, science, and more – with a laser-focus on the job roles and responsibilities of Azure data professionals. You’ll receive a foundational knowledge of core data concepts, like relational and non-relational data and transactional and analytical data workloads, while diving deep into every competency covered on the DP-900 exam. You’ll also get: Access to complimentary online study tools, including hundreds of practice exam questions, electronic flashcards, and a searchable glossary Additional prep assistance with access to Sybex’s superior interactive online learning environment and test bank Walkthroughs of skills and knowledge that are absolutely necessary for current and aspiring Azure data pros in introductory roles Perfect for anyone just beginning to work with data in the cloud, MC Azure Data Fundamentals Study Guide: Exam DP-900 is a can’t-miss resource for anyone prepping for the DP-900 exam or considering a new career working with Azure data.

Table of Contents:
Introduction xxvi Assessment Test xvii Answers to the Assessment Test xxxix Chapter 1 Core Data Concepts 1 Describe Types of Core Data Workloads 2 Data Value 3 Data Volume 10 Data Variety 11 Data Velocity 14 Describe Data Analytics Core Concepts 21 Data Processing Techniques 21 Describe Analytics Techniques 32 Describe Data Visualization Techniques 34 Summary 40 Exam Essentials 41 Review Questions 44 Chapter 2 Relational Databases in Azure 49 Relational Database Features 51 Relational Database Design Considerations 51 Relational Database Offerings in Azure 61 Azure SQL 63 Azure Synapse Analytics Dedicated SQL Pools 90 Open- Source Databases in Azure 92 Management Tasks for Relational Databases in Azure 96 Deployment Scripting and Automation 96 Migrating to Azure SQL 105 Database Security 106 Common Connectivity Issues 113 Management Tools 115 Query Techniques for SQL 119 DDL vs. DML Commands 120 Query Relational Data in Azure SQL, MySQL, MariaDB, and PostgreSQL 125 Summary 129 Exam Essentials 130 Review Questions 132 Chapter 3 Nonrelational Databases in Azure 139 Nonrelational Database Features 140 Key- Value Store 141 Document Database 142 Columnar Database 143 Graph Database 144 Azure Cosmos DB 145 High Availability 146 Request Units 148 Azure Cosmos DB APIs 150 Management Tasks for Azure Cosmos DB 154 Deployment Options 154 Azure Cosmos DB Security 165 Azure Cosmos DB Common Connectivity Issues 167 Management Tools 169 Summary 170 Exam Essentials 171 Review Questions 174 Chapter 4 File, Object, and Data Lake Storage 177 File and Object Storage Features 178 Azure Storage 179 Performance Tiers 180 Data Redundancy 181 Deploying through the Azure Portal 182 Azure Storage Services 187 Management Tasks for Azure Storage 198 Deployment Scripting and Automation 198 Azure Storage Security 201 Azure Storage Common Connectivity Issues 212 Management Tools 213 Summary 217 Exam Essentials 218 Review Questions 221 Chapter 5 Modern Data Warehouses in Azure 225 Analytical Workload Features 226 Transactional vs. Analytical Workloads 226 Data Processing Techniques 229 Modern Data Warehouse Components 233 Data Modeling Best Practices for Data Warehouses 233 Azure Services for Modern Data Warehouses 234 End- to- End Analytics with Azure Synapse Analytics 268 Deploying an Azure Synapse Analytics Workspace 270 Contents xv Navigating the Synapse Studio UI 271 Dedicated SQL Pools 275 Serverless SQL Pools 287 Summary 292 Exam Essentials 293 Review Questions 295 Chapter 6 Reporting with Power BI 301 Power BI at a Glance 302 Working with Power BI 303 Summary 324 Exam Essentials 325 Review Questions 326 Appendix Answers to the Review Questions 329 Chapter 1: Core Data Concepts 330 Chapter 2: Relational Databases in Azure 331 Chapter 3: Nonrelational Databases in Azure 333 Chapter 4: File, Object, and Data Lake Storage 334 Chapter 5: Modern Data Warehouses in Azure 335 Chapter 6: Reporting with Power BI 337 Index 339

About the Author :
ABOUT THE AUTHOR JAKE SWITZER is a Cloud Solution Architect at Microsoft specializing in Big Data and Advanced Analytics. He has worked with major athletics customers like the NBA, NFL, MLB, and the USGA on architecting and proving out big data and advanced analytics solutions in Azure.


Best Sellers


Product Details
  • ISBN-13: 9781119855835
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: Sybex Inc.,U.S.
  • Height: 231 mm
  • No of Pages: 400
  • Returnable: N
  • Sub Title: Exam DP-900
  • Width: 183 mm
  • ISBN-10: 1119855837
  • Publisher Date: 09 May 2022
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Spine Width: 20 mm
  • Weight: 635 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900
John Wiley & Sons Inc -
MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!