DP-300 Exam Question 56

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements:
Support failovers that do not require client applications to change their connection strings.
Replicate the database to a secondary Azure region.
Support failover to the secondary region.
What should you include in the recommendation?
  • DP-300 Exam Question 57

    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 58

    Which windowing function should you use to perform the streaming aggregation of the sales data?
  • DP-300 Exam Question 59

    You have an Azure Synapse Analytics dedicated SQL pool.
    You run PDW_SHOWSPACEUSED('dbo.FactInternetSales'); and get the results shown in the following table.

    Which statement accurately describes the dbo.FactInternetSales table?
  • DP-300 Exam Question 60

    You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server.
    You need to ensure that each customer can only connect to and access their respective database.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.