Virtual Lab DP-300: Administering Relational Databases on Microsoft Azure

Name: Virtual Lab DP-300: Administering Relational Databases on Microsoft Azure
Price: 44.96 USD
Availability: InStock

Only %1 left

Skillable has launched a dedicated collection of Challenge 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 challenge 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 25 challenges and contains over 20 hours of hands-on practice and supports the Microsoft Exam DP-300: Administering Relational Databases on Microsoft Azure competencies.

IMPORTANT!!! 90 day use of license and 2 uses per challenge. Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.

For more detailed information, please read the objectives, features, and view the video demo, for an in-depth explanation of the Virtual Lab.

Regular Price $49.95 As low as $44.96

Skip to the end of the images gallery

Skip to the beginning of the images gallery

Details

IMPORTANT!!

Before you or your students begin, please ensure you have set aside enough time to complete Challenge Labs as you will not be able to pause, save, or return to your progress.

Guided Challenge - approximately 30 minutes to complete
Advanced Challenge - approximately 45 minutes to complete
Expert Challenge - approximately 60 minutes to complete

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

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

Challenge Name	Challenge ID
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%)

Challenge Name	Challenge ID
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%)

Challenge Name	Challenge ID
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%)

Challenge Name	Challenge ID
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%)

Challenge Name	Challenge ID
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%)

Challenge Name	Challenge ID
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%)

Challenge Name	Challenge ID
Perform a Database Consistency Check by Using DBCC [Guided]	ARDB-011

Please note that in order to guarantee that our products are up to date, the actual number of challenges may vary.

https://www.measureup.com/virtual-lab-dp-300-administering-databases-microsoft-azure.html 8561 Virtual Lab DP-300: Administering Relational Databases on Microsoft Azure <p><i>IMPORTANT!!</i></p> <p><i>Before you or your students begin, please ensure you have set aside enough time to complete </i>Challenge Labs <i>as you will not be able to pause, save, or return to your progress.</i></p> <ul> <li>Guided Challenge - approximately 30 minutes to complete</li> <li>Advanced Challenge - approximately 45 minutes to complete</li> <li>Expert Challenge - approximately 60 minutes to complete</li> </ul><br> <p>The listing below shows which challenge(s) support the specified Microsoft Exam DP-300: Administering Relational Databases on Microsoft Azure competencies. <i>*Note: A Challenge Lab may support more than one competency.</i> </p><br> <h2>Plan and Implement Data Platform Resources (15-20%)</h2> <table> <tr> <td><b>Challenge Name</b></td> <td><b>Challenge ID</b></td> </tr> <tr> <td>Configure an Azure SQL Database Elastic Pool [Guided]</td> <td>ARDB-001</td> </tr> <tr> <td>Configure SQL Server in an Azure Virtual Machine [Guided]</td> <td>ARDB-002</td> </tr> <tr> <td>Implement a Database Migration Strategy [Guided]</td> <td>ARDB-003</td> </tr> <tr> <td>Can You implement a Database Migration Strategy? [Advanced]</td> <td>ARDB-004</td> </tr> <tr> <td>Can You Migrate a Database and Monitor Query Performance? [Expert]</td> <td>ARDB-013</td> </tr> <tr> <td>Can You Design an Encryption Solution by Using Azure SQL Database? [Advanced]</td> <td>DADS-012</td> </tr> </table><br> <h2>Implement a Secure Environment (15-20%)</h2> <table> <tr> <td><b>Challenge Name</b></td> <td><b>Challenge ID</b></td> </tr> <tr> <td>Getting Started with Administering Relational Databases on Azure (Series A) [Getting Started]</td> <td>ARDA-000</td> </tr> <tr> <td>Configure Azure Disk Encryption for an Azure Virtual Machine That Hosts SQL Server [Guided]</td> <td>ARDA-007</td> </tr> <tr> <td>Can You Implement End-To-End Encryption by Using Azure SQL Database? [Advanced]</td> <td>ARDA-008</td> </tr> <tr> <td>Can You Implement End-To-End Security by Using Azure SQL Database? [Expert]</td> <td>ARDA-013</td> </tr> <tr> <td>Enable Always Encrypted with Azure SQL Database [Guided]</td> <td>DADS-011</td> </tr> <tr> <td>Implement Dynamic Data Masking by Using Azure SQL Database [Guided]</td> <td>IADS-003</td> </tr> <tr> <td>Getting Started with Azure Secure Data and Applications [Getting Started]</td> <td>SDA-000</td> </tr> </table><br> <h2>Monitor and Optimize Operational Resources (15-20%)</h2> <table> <tr> <td><b>Challenge Name</b></td> <td><b>Challenge ID</b></td> </tr> <tr> <td>Configure Azure SQL Database Auditing [Guided]</td> <td>ARDA-009</td> </tr> <tr> <td>Enable Automatic Tuning in Azure SQL Database [Guided]</td> <td>ARDA-011</td> </tr> <tr> <td>Can You Optimize and Monitor Azure SQL Database? [Advanced]</td> <td>ARDA-012</td> </tr> <tr> <td>Assess Database Performance by Using Query Performance Insight [Guided]</td> <td>ARDB-005</td> </tr> <tr> <td>Configure Query Store to Collect Performance Data [Guided]</td> <td>ARDB-006</td> </tr> <tr> <td>Can You Automate Database Maintenance Tasks? [Advanced]</td> <td>ARDB-012</td> </tr> <tr> <td>Monitor Azure Storage [Guided]</td> <td>AZ300.1-003</td> </tr> </table><br> <h2>Optimize Query Performance (5-10%)</h2> <table> <tr> <td><b>Challenge Name</b></td> <td><b>Challenge ID</b></td> </tr> <tr> <td>Improve Query Performance by Using an Index [Guided]</td> <td>ARDB-007</td> </tr> <tr> <td>Can You Optimize Query Performance? [Advanced]</td> <td>ARDB-008</td> </tr> <tr> <td>Automate Database Maintenance Tasks by Using SQL Server Agent [Guided]</td> <td>ARDB-010</td> </tr> <tr> <td>Can You Design an Azure Synapse Analytics Solution? [Advanced]</td> <td>DADS-004</td> </tr> </table><br> <h2>Perform Automation of Tasks (10-15%)</h2> <table> <tr> <td><b>Challenge Name</b></td> <td><b>Challenge ID</b></td> </tr> <tr> <td>Monitor Azure Storage [Guided]</td> <td>AZ300.1-003</td> </tr> <tr> <td>Manage Azure VM Diagnostics [Guided] </td> <td>AZ300.1-012</td> </tr> </table><br> <h2>Plan and Implement a High Availability and Disaster Recovery (HADR) Environment (15-20%)</h2> <table> <tr> <td><b>Challenge Name</b></td> <td><b>Challenge ID</b></td> </tr> <tr> <td>Getting Started with Administering Relational Databases on Azure (Series A) [Getting Started]</td> <td>ARDA-000</td> </tr> <tr> <td>Enable High Availability of an Azure SQL Database [Guided]</td> <td>ARDA-002</td> </tr> <tr> <td>Can You Implement a Highly Available and Secure Azure SQL Database? [Advanced]</td> <td>ARDA-004</td> </tr> <tr> <td>Enable Azure Backup for a SQL Server Database [Guided]</td> <td>ARDB-009</td> </tr> <tr> <td>Design an Azure SQL Database Design for Disaster Recovery [Guided]</td> <td>DADS-002</td> </tr> <tr> <td>Enable Geo-Replication of an Azure SQL Database [Guided]</td> <td>IADS-002</td> </tr> <tr> <td>Getting Started with Implement High Availability in Windows Server 2016 [Getting Started]</td> <td>IHA-000</td> </tr> </table><br> <h2>Perform Administration by Using T-SQL (10-15%)</h2> <table> <tr> <td><b>Challenge Name</b></td> <td><b>Challenge ID</b></td> </tr> <tr> <td>Perform a Database Consistency Check by Using DBCC [Guided] </td> <td>ARDB-011</td> </tr> </table><br> <br><br><p style="color: red;"><b>Please note that in order to guarantee that our products are up to date, the actual number of challenges may vary.</b></p> https://www.measureup.com/media/catalog/product/m/i/microsoft_dp-300_vl.png 44.96 instock 0 44.96 Microsoft 0 0 0 https://www.measureup.com/media/catalog/product/m/i/microsoft_dp-300_vl.png 7606 7617 /measureup /measureup/Microsoft /measureup/Microsoft/Microsoft Technical /measureup/Microsoft/Microsoft Technical/Microsoft Virtual Labs 2023-01-19T06:11:17+0000