DP-300 Exam Question 26

You have an Azure SQL database named db1 on a server named server1.
You need to modify the MAXDOP settings for db1.
What should you do?
  • DP-300 Exam Question 27

    You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.
    You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead.
    What should you do?
  • DP-300 Exam Question 28

    You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure. Which service should you use?
  • DP-300 Exam Question 29

    You have an Azure SQL database named DBI that contains a nonclustered index named index1.
    End users report slow queries when they use index1.
    You need to identify the operations that are being performed on the index.
    Which dynamic management view should you use?
  • DP-300 Exam Question 30

    You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime.
    What should you do?