Home > Microsoft > CertPREP Training Labs: Microsoft Exam DP-300 (90 day license)

CertPREP Training Labs: Microsoft Exam DP-300 (90 day license)

CertPREP Training Labs: Microsoft Exam DP-300 (90 day license)
🔍 Click to enlarge photo

Summary

WEB PRICE: $35.00
Member price: $35.00
Qty

Please select required options above

Description
Pearson CertPREP has launched a dedicated collection of Labs to support Azure Database Administrators who implement and manage the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services. Each lab within the Administering Relational Databases on Microsoft Azure Collection is short in duration, scenario based, hands-on activity that includes a means of assessment. This collection is comprised of over 35 labs and contains over 20 hours of hands-on practice and supports the Microsoft Exam DP-300: Administering Relational Databases on Microsoft Azure competencies.

A total of 3 attempts to complete each lab exercise

Multiple levels: Guided, Advanced & Expert

Access to the lab delivery platform starting upon your first lab launch:

  • Collection (Exam Level) – 90 days
  • Library (Technology Level) – 180 days
  • All Access (All labs) – 365 days

The listing below shows which lab(s) support the specified Microsoft Exam DP-300: Administering Relational Databases on Microsoft Azure competencies. *Note: A Lab may support more than one competency.

Plan and Implement Data Platform Resources (15-20%)

Configure an Azure SQL Database Elastic Pool [Guided] (ARDB-001)
Configure SQL Server in an Azure Virtual Machine [Guided] (ARDB-002)
Implement a Database Migration Strategy [Guided] (ARDB-003)
Can You implement a Database Migration Strategy? [Advanced] (ARDB-004)
Can You Migrate a Database and Monitor Query Performance? [Expert] (ARDB-013)
Can You Design an Encryption Solution by Using Azure SQL Database? [Advanced] (DADS-012)

Implement a Secure Environment (15-20%)

Getting Started with Administering Relational Databases on Azure (Series A) [Getting Started] (ARDA-000)
Configure Azure Disk Encryption for an Azure Virtual Machine That Hosts SQL Server [Guided] (ARDA-007)
Can You Implement End-To-End Encryption by Using Azure SQL Database? [Advanced] (ARDA-008)
Can You Implement End-To-End Security by Using Azure SQL Database? [Expert] (ARDA-013)
Enable Always Encrypted with Azure SQL Database [Guided] (DADS-011)
Implement Dynamic Data Masking by Using Azure SQL Database [Guided] (IADS-003)
Getting Started with Azure Secure Data and Applications [Getting Started] (SDA-000)

Monitor and Optimize Operational Resources (15-20%)

Configure Azure SQL Database Auditing [Guided] (ARDA-009)
Enable Automatic Tuning in Azure SQL Database [Guided] (ARDA-011)
Can You Optimize and Monitor Azure SQL Database? [Advanced] (ARDA-012)
Assess Database Performance by Using Query Performance Insight [Guided] (ARDB-005)
Configure Query Store to Collect Performance Data [Guided] (ARDB-006)
Can You Automate Database Maintenance Tasks? [Advanced] (ARDB-012)
Monitor Azure Storage [Guided] (AZ300.1-003

Optimize Query Performance (5-10%)

Improve Query Performance by Using an Index [Guided] (ARDB-007)
Can You Optimize Query Performance? [Advanced] (ARDB-008)
Automate Database Maintenance Tasks by Using SQL Server Agent [Guided] (ARDB-010)
Can You Design an Azure Synapse Analytics Solution? [Advanced] (DADS-004)

Perform Automation of Tasks (10-15%)

Monitor Azure Storage [Guided] (AZ300.1-003)
Manage Azure VM Diagnostics [Guided] (AZ300.1-012)

Plan and Implement a High Availability and Disaster Recovery (HADR) Environment (15-20%)

Getting Started with Administering Relational Databases on Azure (Series A) [Getting Started] (ARDA-000)
Enable High Availability of an Azure SQL Database [Guided] (ARDA-002)
Can You Implement a Highly Available and Secure Azure SQL Database? [Advanced] (ARDA-004)
Enable Azure Backup for a SQL Server Database [Guided] (ARDB-009)
Design an Azure SQL Database Design for Disaster Recovery [Guided] (DADS-002)
Enable Geo-Replication of an Azure SQL Database [Guided] (IADS-002)
Getting Started with Implement High Availability in Windows Server 2016 [Getting Started] (IHA-000)

Perform Administration by Using T-SQL (10-15%)

Perform a Database Consistency Check by Using DBCC [Guided] (ARDB-011)