← Back to exam page

DP-203 – Data Engineering on Microsoft Azure

Loading demo links...

Showing 13–15 of 20 questions

Question 13 (New Update)

You are designing an anomaly detection solution for streaming data from an Azure IoT hub. The solution must meet the following requirements:

Which should you include in the solution?

Select an option, then click Submit answer.

  • ○

    Azure Databricks
  • ○

    Azure Stream Analytics
  • ○

    Azure SQL Database
Question 14 (New Update)

You are designing an Azure Synapse solution that will provide a query interface for the data stored in an Azure Storage account. The storage account is only accessible from a virtual network.

You need to recommend an authentication mechanism to ensure that the solution can access the source data.

What should you recommend?

Select an option, then click Submit answer.

  • ○

    a managed identity
  • ○

    anonymous public read access
  • ○

    a shared key
Question 15 (Mixed Questions)

You need to design an Azure Synapse Analytics dedicated SQL pool that meets the following requirements:

Can return an employee record from a given point in time.

Maintains the latest employee information. Minimizes query complexity.

How should you model the employee data?

Select an option, then click Submit answer.

  • ○

    as a temporal table

  • ○

    as a SQL graph table

  • ○

    as a degenerate dimension table
  • ○

    as a Type 2 slowly changing dimension (SCD) table