Question 11

You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.
Clustered columnstore indexes
Automatic tuning
Change tracking
PolyBase
You plan to migrate DB1 to an Azure SQL database.
What feature should be removed or replaced before DB1 can be migrated?
  • Question 12

    You are designing an anomaly detection solution for streaming data from an Azure IoT hub. The solution must meet the following requirements:
    Send the output to an Azure Synapse.
    Identify spikes and dips in time series data.
    Minimize development and configuration effort.
    Which should you include in the solution?
  • Question 13

    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?
  • Question 14

    You receive numerous alerts from Azure Monitor for an Azure SQL database.
    You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • Question 15

    HOTSPOT
    You have SQL Server on an Azure virtual machine.
    You review the query plan shown in the following exhibit.

    For each of the following statements, select yes if the statement is true. Otherwise, select no.
    NOTE: Each correct selection is worth one point.
    Hot Area: