PrepAway - Latest Free Exam Questions & Answers

Category: DP-300

Exam DP-300: Administering Relational Databases on Microsoft Azure

What should you do first?

You have an Azure virtual machine based on a custom image named VM1. VM1 hosts an instance of Microsoft SQL Server 2019 Standard. You need to automate the maintenance of VM1 to meet the following requirements: • Automate the patching of SQL Server and Windows Server. • Automate full database backups and transaction log backups […]

Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct

You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: […]

How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.

You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service. How should you configure the backup of DB1? To answer, select the appropriate options in the […]

Which type of compression provides the greatest space reduction for the database?

You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table. FactSales has 6 billion rows and is loaded nightly by using a batch process. Which type of compression provides the greatest space reduction for the database? A. page compression B. row compression C. columnstore […]