DP-203 Exam Question 11

You plan to implement an Azure Data Lake Gen2 storage account.
You need to ensure that the data lake will remain available if a data center fails in the primary Azure region.
The solution must minimize costs.
Which type of replication should you use for the storage account?
  • DP-203 Exam Question 12

    You are designing a star schema for a dataset that contains records of online orders. Each record includes an order date, an order due date, and an order ship date.
    You need to ensure that the design provides the fastest query times of the records when querying for arbitrary date ranges and aggregating by fiscal calendar attributes.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • DP-203 Exam Question 13

    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 Azure Synapse.
    * Identify spikes and dips in time series data.
    * Minimize development and configuration effort.
    Which should you include in the solution?
  • DP-203 Exam Question 14

    You have an Azure Data Factory instance that contains two pipelines named Pipeline1 and Pipeline2.
    Pipeline1 has the activities shown in the following exhibit.

    Pipeline2 has the activities shown in the following exhibit.

    You execute Pipeline2, and Stored procedure1 in Pipeline1 fails.
    What is the status of the pipeline runs?
  • DP-203 Exam Question 15

    You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1.
    You need to identify the extent of the data skew in Table1.
    What should you do in Synapse Studio?