DP-300 Exam Question 61

You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server! that runs Windows Server. SQLVM1 and Serverl are joined to an Active Directory Domain Services (AD DS) domain. Serverl hosts a file share named Sharel.
You need to ensure that a SQL Server Agent job step on SQLVM1 can access the files in Share1. The solution must use the principle of least privilege.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

DP-300 Exam Question 62

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 of the databases on VM1.
Minimize administrative effort.
What should you do first?
  • DP-300 Exam Question 63

    You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.
    Data to be loaded is identified by a column named LastUpdatedDate in the source table.
    You plan to execute the pipeline every four hours.
    You need to ensure that the pipeline execution meets the following requirements:
    Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits.
    Supports backfilling existing data in the table.
    Which type of trigger should you use?
  • DP-300 Exam Question 64

    You have an Azure subscription.
    You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI).
    Which three parameters are required?
  • DP-300 Exam Question 65

    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 answer area.
    NOTE: Each correct selection is worth one point.