DP-300 Exam Question 11

Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a
10-Mbps internet connection.
You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database.
What should you use?
  • DP-300 Exam Question 12

    You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1.
    You plan to access the files in Account1 by using an external table.
    You need to create a data source in Pool1 that you can reference when you create the external table.
    How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 13

    You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.
    You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
    You need to recommend a database service for the deployment. The solution must minimize administrative effort.
    What should you include in the recommendation?
  • DP-300 Exam Question 14

    You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2 . SQLM2 contains a database named DB1 and a user named User1.
    User1 drops DB1.
    You need to perform a point-in-time restore of DB1 to SQLMI2.
  • DP-300 Exam Question 15

    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?