DP-300 Exam Question 76

You have an Azure subscription.
You create a logical SQL server that hosts four databases Each database will be used by a separate customer.
You need to ensure that each customer can access only its own database. The solution must minimize administrative effort Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
  • DP-300 Exam Question 77

    You have an Azure SQL database named DB 1 in the General Purpose service tier.
    You need to monitor DB 1 by using SQL Insights.
    What should you include in the solution? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 78

    You have an Azure subscription that contains an Azure SQL database. The database contains a table named table1 that uses partitioned columnstores. You need to configure table1 to meet the following requirements:
    * Each partition must be compressed
    * The compression ratio must be maximized.
    * You must be able to index the compressed data.
    What should you use?
  • DP-300 Exam Question 79

    You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements.
    What should you include in the recommendation?
  • DP-300 Exam Question 80

    You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1.
    You need to ensure that User! can create a scheduled task to perform a full backup of DB1. The solution must use the principle of least privilege.
    Which built-in database role should you assign to User1?