---
tags: DP-300, Reference
---

# DP-300 Reference

## Contact
[[e-mail]](mailto:[e-mail])
LinkedIn: [@abc12207](https://www.linkedin.com/in/abc12207/)

> Date: 20220307
> Course ID: 37655

## Course Materials
[Course DP-300 English version](https://aka.ms/CourseDP-300)

[Course DP-300 简体中文版本](https://aka.ms/learn/dp300cn)

[Course DP-300 正體中文版本](https://aka.ms/learn/dp300tw)

## Infos
[ESI Support](https://aka.ms/esisupport)

## Lab
### LODS (VM)
[Lab On Demands](https://aka.ms/esilab)
> Date: 20220307
> Training key: C0AB3D2CCDE74D7D
> Valid for 6 months

Turtoial Video: https://media.yu.money/common/lods.html

### Azure Pass
[Azure Pass Redeem](https://aka.ms/azurepass)
> Valid for 100 USD or 1 month

Turtoial Video: https://media.yu.money/common/azurepass.html

### Instruction
[DP-300 Labs](https://aka.ms/dp300labs)
[DP-300 ZH Labs](https://aka.ms/dp300zhlabs)
[DP-300 Lab Files](http://aka.ms/dp300labfiles)

[DP-300 Labs Backup site](https://lab.yu.money/DP-300T00-Administering-Relational-Databases-on-Azure/)
[DP-300 ZH Labs Backup site](https://lab.yu.money/DP-300T00ZH-Administering-Relational-Databases-on-Azure/)
[DP-300 Lab Files Backup site](https://mctcontent.blob.core.windows.net/dp300/DP300LabFiles.zip?sv=2020-10-02&st=2022-01-24T06%3A48%3A02Z&se=2099-01-25T06%3A48%3A00Z&sr=b&sp=r&sig=JJu2uzr0v504xfx8l5llEAzyoiVpS646%2BQUWcmAaC%2B8%3D)
> Use backup site if GitHub is being block by Great firewall

## Course Info


## M01 - The role of the database administrator
[Azure SQL Database Hyperscale](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/service-tier-hyperscale)

[SQL Server compatibility level](https://docs.microsoft.com/zh-tw/sql/t-sql/statements/alter-database-transact-sql-compatibility-level#arguments)

[SQL Server on Azure VM FAQ](https://docs.microsoft.com/zh-cn/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-iaas-faq)

[Azure SQL Managed Instance](https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-managed-instance)

[Azure SQL Database](https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-technical-overview)

[SQL Server application compatibility certification](https://docs.microsoft.com/zh-cn/sql/database-engine/install-windows/compatibility-certification)

## M02 - Plan and implement data platform resources
[Region Pair](https://docs.microsoft.com/zh-tw/azure/best-practices-availability-paired-regions)

[Data Migration Assistant](https://docs.microsoft.com/zh-tw/sql/dma/dma-overview?view=sql-server-ver15)

[Azure SQL DTU overview](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/service-tiers-dtu)

[Azure SQL vCore overview](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/service-tiers-vcore)

[vCore vs DTU purchasing models](https://docs.microsoft.com/zh-cn/azure/azure-sql/database/purchasing-models)

[Azure Defender for SQL](https://docs.microsoft.com/zh-cn/azure/azure-sql/database/azure-defender-for-sql)

[Azure SQL Database vs Managed Instance](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/features-comparison)

[Azure SQL Database IP firewall rules](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/firewall-configure)

## M03 - Implement a secure environment
[Database-level Roles](https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver15)

[Server-Level Roles](https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-ver15)

[透明資料加密](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal)

[Always Encrypted](https://docs.microsoft.com/zh-tw/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver15)

[使用 Azure Key Vault 設定 Always Encrypted](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/always-encrypted-azure-key-vault-configure?tabs=azure-powershell)

[具有安全記憶體保護區的 Always Encrypted](https://docs.microsoft.com/zh-tw/sql/relational-databases/security/encryption/always-encrypted-enclaves?view=sql-server-ver15)

[動態資料遮罩](https://docs.microsoft.com/zh-tw/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15)

[SQL 資料探索與分類](https://docs.microsoft.com/zh-tw/sql/relational-databases/security/sql-data-discovery-and-classification?view=sql-server-ver15&tabs=t-sql)

## M04 - Monitor and optimize operational resources
[使用查詢存放區監視效能](https://docs.microsoft.com/zh-tw/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15)

[使用查詢存放區的最佳做法](https://docs.microsoft.com/zh-tw/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql-server-ver15)

[ISOLATION LEVEL](https://docs.microsoft.com/zh-cn/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver15)

[受控磁碟比較](https://docs.microsoft.com/zh-tw/azure/virtual-machines/disks-types#disk-comparison)

[磁碟等量分割](https://docs.microsoft.com/zh-tw/azure/virtual-machines/premium-storage-performance#disk-striping)

[tempdb 資料庫](https://docs.microsoft.com/zh-tw/sql/relational-databases/databases/tempdb-database?view=sql-server-ver15)

[SQL Server Resource Governor](https://docs.microsoft.com/zh-tw/sql/relational-databases/resource-governor/resource-governor?view=sql-server-ver15)

[智慧查詢處理](https://docs.microsoft.com/zh-tw/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15)

[Azure SQL Elastic Jobs](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/job-automation-overview)

## M05 - Optimize query performance
[執行計劃](https://docs.microsoft.com/zh-tw/sql/relational-databases/performance/execution-plans?view=sql-server-ver15)

[查詢分析基礎結構 (轻型查询分析)](https://docs.microsoft.com/zh-tw/sql/relational-databases/performance/query-profiling-infrastructure?view=sql-server-ver15)

[SARGable](https://docs.microsoft.com/zh-tw/learn/modules/describe-sql-server-query-plans/4-identify-problematic)

[資料庫正規化](https://docs.microsoft.com/zh-tw/office/troubleshoot/access/database-normalization-description)

[索引](https://docs.microsoft.com/zh-tw/sql/relational-databases/indexes/indexes?view=sql-server-ver15)

[查詢提示](https://docs.microsoft.com/zh-tw/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-ver15)

[Parameter Sniffing](https://docs.microsoft.com/zh-cn/sql/relational-databases/query-processing-architecture-guide?view=sql-server-ver15#parameter-sensitivity)

[資料類型優先順序](https://docs.microsoft.com/zh-tw/sql/t-sql/data-types/data-type-precedence-transact-sql?view=sql-server-ver15)

[Data compression](https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver15)

## M06 - Automation of tasks
[ARM Template overview](https://docs.microsoft.com/zh-tw/azure/azure-resource-manager/templates/overview)

[維護計畫](https://docs.microsoft.com/zh-tw/sql/relational-databases/maintenance-plans/maintenance-plans?view=sql-server-ver15)

[Quickstart: SQL backup and restore to Azure Blob Storage](https://docs.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-ver15&tabs=SSMS)

[SQL Server Agent 多伺服器環境](https://docs.microsoft.com/zh-tw/sql/ssms/agent/create-a-multiserver-environment?view=sql-server-ver15)

[SQL Server Extended Events overview](https://docs.microsoft.com/zh-tw/sql/relational-databases/extended-events/extended-events?view=sql-server-ver15)

[Azure SQL Database Extended Events](https://docs.microsoft.com/zh-tw/azure/azure-sql/database/xevent-db-diff-from-svr)

[Microsoft Service Trust Portal](https://servicetrust.microsoft.com/)

## M07 - Planning and implementing a High Availability and Disaster Recovery Environment
[SQL Server on Azure VM always on by Azure Portal](https://docs.microsoft.com/zh-tw/azure/azure-sql/virtual-machines/windows/availability-group-azure-portal-configure)

[Windows容錯移轉叢集概觀](https://docs.microsoft.com/zh-tw/azure/azure-sql/virtual-machines/windows/hadr-windows-server-failover-cluster-overview)

[在 Azure 虛擬機器上SQL Server容錯移轉的群集實例](https://docs.microsoft.com/zh-tw/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-overview)

[教學課程：在 Azure VM (SQL Server手動設定可用性)](https://docs.microsoft.com/zh-tw/azure/azure-sql/virtual-machines/windows/availability-group-manually-configure-tutorial-single-subnet)

[分散式可用性群組](https://docs.microsoft.com/zh-tw/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver15)

[設定 Always On 分散式可用性群組](https://docs.microsoft.com/zh-tw/sql/database-engine/availability-groups/windows/configure-distributed-availability-groups?view=sql-server-ver15&tabs=automatic)

[教學課程：新增 SQL Managed Instance 至容錯移轉群組](https://docs.microsoft.com/zh-tw/azure/azure-sql/managed-instance/failover-group-add-instance-tutorial?tabs=azure-portal)

## Whiteboard

SVG download: [Whiteboard](https://mctcontent.blob.core.windows.net/dp300/Whiteboard.svg?sv=2020-10-02&st=2022-01-27T07%3A11%3A34Z&se=2099-01-28T07%3A11%3A00Z&sr=b&sp=r&sig=AodKEN4sGWn5hMnHND6Z4FPThN77bSIcPshkwbZG3j0%3D)

## Exam
[DP-300](https://docs.microsoft.com/en-us/learn/certifications/exams/dp-300)
[Registration Demo Video](https://aka.ms/LxPExamDiscountVideo)
[Exam duration and question types](https://docs.microsoft.com/en-us/learn/certifications/exam-duration-question-types)


SVG: [exam.svg](https://mctcontent.blob.core.windows.net/common/exam.svg?sv=2020-04-08&st=2021-05-27T05%3A44%3A17Z&se=2099-05-28T05%3A44%3A00Z&sr=b&sp=r&sig=%2BXIR3HiVkMiiTTW4mcJH%2BPLaomLzJ3odOD4yaZC7bZI%3D)

## Summary - ZH







## Else
[Azure for GCP Professionals](https://docs.microsoft.com/en-us/azure/architecture/gcp-professional/)

[Azure for AWS Professionals](https://docs.microsoft.com/en-us/azure/architecture/aws-professional/)