DP-300 Exam Question 71

You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.
What should you create?
  • DP-300 Exam Question 72

    You have an Azure subscription that contains an Azure SQL database named SQL1.
    SQL1 is in an Azure region that does not support availability zones.
    You need to ensure that you have a secondary replica of SQLI in the same region.
    What should you use?
  • DP-300 Exam Question 73

    You have an Azure Databricks resource.
    You need to log actions that relate to changes in compute for the Databricks resource.
    Which Databricks services should you log?
  • DP-300 Exam Question 74

    You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements:
    The web app must be hosted on an Azure virtual network.
    The Azure SQL database must be assigned a private IP address.
    The Azure SQL database must allow connections only from the virtual network.
    You need to recommend a solution that meets the requirements.
    What should you include in the recommendation?
  • DP-300 Exam Question 75

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.
    You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
    Solution: You run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2.
    Does this meet the goal?