DP-300 Exam Question 166

You have an Azure SQL database named db1.
You need to retrieve the resource usage of db1 from the last week.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 167

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service.
You need to create a backup of DB1 that is accessible to the Azure Database Migration Service.
What should you run for the backup and where should you store the backup? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 168

You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the following columns.

You plan to enable Always Encrypted for Table1.
Which two columns support encryption? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
  • DP-300 Exam Question 169

    You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements.
    Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    DP-300 Exam Question 170

    Which windowing function should you use to perform the streaming aggregation of the sales data?