DP-203 Exam Question 11

You are designing an Azure Data Lake Storage Gen2 structure for telemetry data from 25 million devices distributed across seven key geographical regions. Each minute, the devices will send a JSON payload of metrics to Azure Event Hubs.
You need to recommend a folder structure for the dat
a. The solution must meet the following requirements:
Data engineers from each region must be able to build their own pipelines for the data of their respective region only.
The data must be processed at least once every 15 minutes for inclusion in Azure Synapse Analytics serverless SQL pools.
How should you recommend completing the structure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

DP-203 Exam Question 12

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 13

    You have an Azure Synapse Analytics dedicated SQL pool.
    You need to Create a fact table named Table1 that will store sales data from the last three years. The solution must be optimized for the following query operations:
    Show order counts by week.
    * Calculate sales totals by region.
    * Calculate sales totals by product.
    * Find all the orders from a given month.
    Which data should you use to partition Table1?
  • DP-203 Exam Question 14

    You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated SQL pool. The table contains purchases from suppliers for a retail store. FactPurchase will contain the following columns.

    FactPurchase will have 1 million rows of data added daily and will contain three years of dat a.
    Transact-SQL queries similar to the following query will be executed daily.
    SELECT
    SupplierKey, StockItemKey, COUNT(*)
    FROM FactPurchase
    WHERE DateKey >= 20210101
    AND DateKey <= 20210131
    GROUP By SupplierKey, StockItemKey
    Which table distribution will minimize query times?
  • DP-203 Exam Question 15

    What should you recommend using to secure sensitive customer contact information?