Exam Ref DP-300: Administering Microsoft Azure SQL Solutions
Оглавление⌄
Title Page....2 Copyright Page....3 Contents at a glance....6 Contents....7 About the author....14 Introduction....15 Organization of this book....15 Preparing for the exam....16 Microsoft certifications....16 Access the Exam Updates chapter and online references....17 Errata, updates, & book support....17 Stay in touch....18 Chapter 1. Plan and implement data platform resources....19 Skill 1.1: Plan and deploy Azure SQL solutions....19 Skill 1.2: Configure resources for scale and performance....64 Skill 1.3: Plan and implement a migration strategy....81 Chapter summary....114 Thought experiment....116 Thought experiment answers....117 Chapter 2. Implement a secure environment....118 Skill 2.1: Configure database authentication and authorization....118 Skill 2.2: Implement security for data at rest and data in transit....144 Skill 2.3: Implement compliance controls for sensitive data....161 Chapter summary....187 Thought experiment....188 Thought experiment answers....188 Chapter 3. Monitor, configure, and optimize database resources....190 Skill 3.1: Monitor resource activity and performance....190 Skill 3.2: Monitor and optimize query performance....211 Skill 3.3: Configure database solutions for optimal performance....238 Chapter summary....257 Thought experiment....258 Thought experiment answers....259 Chapter 4. Configure and manage automation of tasks....261 Skill 4.1: Create and manage SQL Server Agent jobs....261 Skill 4.2: Automate deployment of database resources....279 Skill 4.3: Create and manage database tasks in Azure....290 Chapter summary....306 Thought experiment....307 Thought experiment answers....307 Chapter 5. Plan and configure a high availability and disaster recovery (HA/DR) environment....309 Skill 5.1: Recommend an HA/DR strategy for database solutions....309 Skill 5.2: Plan and perform backup and restore of a database....316 Skill 5.3: Configure HA/DR for database solutions....332 Chapter summary....350 Thought experiment....352 Thought experiment answers....353 Chapter 6. DP-300 Administering Microsoft Azure SQL Solutions exam updates....354 The purpose of this chapter....354 Exam objective updates....356 Updated technical content....356 Objective mapping....356 Index....364 Code Snippets....398
Описание
В этом материале разберём тему: database.
Designed for database administrators, solution architects, data scientists, and other data professionals, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the Microsoft Certified: Azure Database Administrator Associate level. Prepare for Microsoft Exam DP-300 and demonstrate your real-world foundational knowledge of Azure database administration using a variety of methods and tools to perform and automate day-to-day operations, including use of Transact-SQL (T-SQL) and other tools for administrative management purposes. Focus on the expertise measured by these objectives:
Plan and implement data platform resourcesImplement a secure environmentMonitor, configure, and optimize database resourcesConfigure and manage automation of tasksPlan and configure a high availability and disaster recovery (HA/DR) environmentThis Microsoft Exam Ref:Organizes its coverage by the Skills Measured list published for the examFeatures strategic, what-if scenarios to challenge youAssumes you have subject matter expertise in building database solutions that are designed to support multiple workloads built with SQL Server on-premises and Azure SQLAbout the ExamExam PD-300 focuses on core knowledge for implementing and managing the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services, using a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes. About Microsoft Certification
Passing this exam fulfills your requirements for the Microsoft Certified: Azure Database Administrator Associate certification, demonstrating your ability to administer a SQL Server database infrastructure for cloud, on-premises, and hybrid relational databases using the Microsoft PaaS relational database offerings.
Файл доступен для загрузки ниже.
Поделиться
Частые вопросы
Можно ли скачать «Exam Ref DP-300: Administering Microsoft Azure SQL Solutions» бесплатно?
Да, «Exam Ref DP-300: Administering Microsoft Azure SQL Solutions» доступна для бесплатного скачивания на нашем сайте в формате PDF. Ссылка на файл находится на этой странице.
В каком формате и какого размера файл?
Книга предоставляется в формате PDF, размер файла 6,7 МБ.
Кто автор и когда вышла книга?
автор — Zacker Craig, издательство Pearson Education Limited, год выпуска 2026, 410 страниц.
О чём книга «Exam Ref DP-300: Administering Microsoft Azure SQL Solutions»?
Prepare for Microsoft Exam DP-300 and demonstrate your real-world foundational knowledge of Azure database administration using a variety of methods and tools to perform and automate day-to-day operations, including use of Transact-SQL (T-S
Похожие материалы
Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers. 2 Ed
Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
SQL for Data Science: Data Cleaning, Wrangling and Analytics with Relational Databases
SQL Interview Questions: A complete question bank to crack your ANN SQL interview with real-time examples
T-SQL Fundamentals. 4Ed
GETTING STARTED WITH SQL. Exercises with PhpMyAdmin and MySQL
A Comprehensive Study of SQL: Practice and Implementation