DP-203 Exam Question 96

You need to implement an Azure Synapse Analytics database object for storing the sales transactions dat a. The solution must meet the sales transaction dataset requirements.
What solution must meet the sales transaction dataset requirements.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-203 Exam Question 97

You have an Azure Data Factory pipeline shown the following exhibit.

The execution log for the first pipeline run is shown in the following exhibit.

The execution log for the second pipeline run is shown in the following exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

DP-203 Exam Question 98

You have an Azure Data Lake Storage account that has a virtual network service endpoint configured.
You plan to use Azure Data Factory to extract data from the Data Lake Storage account. The data will then be loaded to a data warehouse in Azure Synapse Analytics by using PolyBase.
Which authentication method should you use to access Data Lake Storage?
  • DP-203 Exam Question 99

    You have an Azure Data Lake Storage account that contains a staging zone.
    You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.
    Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data Flow, and then inserts the data info the data warehouse.
    Does this meet the goal?
  • DP-203 Exam Question 100

    You are responsible for providing access to an Azure Data Lake Storage Gen2 account.
    Your user account has contributor access to the storage account, and you have the application ID and access key.
    You plan to use PolyBase to load data into an enterprise data warehouse in Azure Synapse Analytics.
    You need to configure PolyBase to connect the data warehouse to storage account.
    Which three components should you create in sequence? To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.