DP-203 Exam Question 76

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 77

    You use Azure Data Factory to prepare data to be queried by Azure Synapse Analytics serverless SQL pools.
    Files are initially ingested into an Azure Data Lake Storage Gen2 account as 10 small JSON files. Each file contains the same data attributes and data from a subsidiary of your company.
    You need to move the files to a different folder and transform the data to meet the following requirements:
    Provide the fastest possible query times.
    Automatically infer the schema from the underlying files.
    How should you configure the Data Factory copy activity? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-203 Exam Question 78

    You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Sales.Orders. Sales.Orders contains a column named SalesRep.
    You plan to implement row-level security (RLS) for Sales.Orders.
    You need to create the security policy that will be used to implement RLS. The solution must ensure that sales representatives only see rows for which the value of the SalesRep column matches their username.
    How should you complete the code? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-203 Exam Question 79

    You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage account named storage1. Storage1 requires secure transfers.
    You need to create an external data source in Pool1 that will be used to read .orc files in storage1.
    How should you complete the code? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-203 Exam Question 80

    You are designing a statistical analysis solution that will use custom proprietary1 Python functions on near real-time data from Azure Event Hubs.
    You need to recommend which Azure service to use to perform the statistical analysis. The solution must minimize latency.
    What should you recommend?