DP-203 Exam Question 131

You haw an Azure data factory named ADF1.
You currently publish all pipeline authoring changes directly to ADF1.
You need to implement version control for the changes made to pipeline artifacts. The solution must ensure that you can apply version control to the resources currently defined m the UX Authoring canvas for ADF1.
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 132

    You have an enterprise-wide Azure Data Lake Storage Gen2 account. The data lake is accessible only through an Azure virtual network named VNET1.
    You are building a SQL pool in Azure Synapse that will use data from the data lake.
    Your company has a sales team. All the members of the sales team are in an Azure Active Directory group named Sales. POSIX controls are used to assign the Sales group access to the files in the data lake.
    You plan to load data to the SQL pool every hour.
    You need to ensure that the SQL pool can load the sales data from the data lake.
    Which three actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each area selection is worth one point.
  • DP-203 Exam Question 133

    You need to design an analytical storage solution for the transactional dat a. The solution must meet the sales transaction dataset requirements.
    What should you include in the solution? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-203 Exam Question 134

    You build an Azure Data Factory pipeline to move data from an Azure Data Lake Storage Gen2 container to a database in an Azure Synapse Analytics dedicated SQL pool.
    Data in the container is stored in the following folder structure.
    /in/{YYYY}/{MM}/{DD}/{HH}/{mm}
    The earliest folder is /in/2021/01/01/00/00. The latest folder is /in/2021/01/15/01/45.
    You need to configure a pipeline trigger to meet the following requirements:
    Existing data must be loaded.
    Data must be loaded every 30 minutes.
    Late-arriving data of up to two minutes must he included in the load for the time at which the data should have arrived.
    How should you configure the pipeline trigger? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-203 Exam Question 135

    You develop a dataset named DBTBL1 by using Azure Databricks.
    DBTBL1 contains the following columns:
    SensorTypeID
    GeographyRegionID
    Year
    Month
    Day
    Hour
    Minute
    Temperature
    WindSpeed
    Other
    You need to store the data to support daily incremental load pipelines that vary for each GeographyRegionID. The solution must minimize storage costs.
    How should you complete the code? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.