DP-300 Exam Question 46

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.
You plan to migrate DB1 to an Azure SQL Database managed instance.
What should you use to minimize downtime and data loss during the migration?
  • DP-300 Exam Question 47

    You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.
    You need to create a surrogate key for the table. The solution must provide the fastest query performance.
    What should you use for the surrogate key?
  • DP-300 Exam Question 48

    You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by using an Azure Marketplace SQL Server 2019 Enterprise image.
    You need to change the Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must ensure licensing compliance.
    What should you do first?
  • DP-300 Exam Question 49

    You have an Azure SQL logical server.
    You run the following script.

    DP-300 Exam Question 50

    You have an Azure Data Factory that contains 10 pipelines.
    You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.
    What should you add to each pipeline?