DP-300 Exam Question 41

You plan to perform batch processing in Azure Databricks once daily.
Which type of Databricks cluster should you use?
  • DP-300 Exam Question 42

    Based on the PaaS prototype, which Azure SQL Database compute tier should you use?
  • DP-300 Exam Question 43

    You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:\DB1.bak.
    You plan to deploy an Always On availability group that will have the following configurations:
    VM1 will host the primary replica of DB1.
    VM2 will host a secondary replica of DB1.
    You need to prepare the secondary database on VM2 for the availability group.
    How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

    DP-300 Exam Question 44

    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: Each correct selection is worth one point.
  • DP-300 Exam Question 45

    You are provisioning an Azure SQL database in the Azure portal as shown in the following exhibit.

    Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
    NOTE: Each correct selection is worth one point.