DP-203 Exam Question 106

You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit.

You create an external table named ExtTable that has LOCATION='/topfolder/'.
When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned?
  • DP-203 Exam Question 107

    You have an Azure SQL database named DB1 and an Azure Data Factory data pipeline named pipeline.
    From Data Factory, you configure a linked service to DB1.
    In DB1, you create a stored procedure named SP1. SP1 returns a single row of data that has four columns.
    You need to add an activity to pipeline to execute SP1. The solution must ensure that the values in the columns are stored as pipeline variables.
    Which two types of activities can you use to execute SP1? (Refer to Data Engineering on Microsoft Azure documents or guide for Answers/Explanation available at Microsoft.com)
  • DP-203 Exam Question 108

    You store files in an Azure Data Lake Storage Gen2 container. The container has the storage policy shown in the following exhibit.

    Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
    NOTE: Each correct selection Is worth one point.

    DP-203 Exam Question 109

    You have two Azure SQL databases named DB1 and DB2.
    DB1 contains a table named Table 1. Table1 contains a timestamp column named LastModifiedOn. LastModifiedOn contains the timestamp of the most recent update for each individual row.
    DB2 contains a table named Watermark. Watermark contains a single timestamp column named WatermarkValue.
    You plan to create an Azure Data Factory pipeline that will incrementally upload into Azure Blob Storage all the rows in Table1 for which the LastModifiedOn column contains a timestamp newer than the most recent value of the WatermarkValue column in Watermark.
    You need to identify which activities to include in the pipeline. The solution must meet the following requirements:
    * Minimize the effort to author the pipeline.
    * Ensure that the number of data integration units allocated to the upload operation can be controlled.
    What should you identify? To answer, select the appropriate options in the answer area.

    DP-203 Exam Question 110

    You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named SQLPool1.
    SQLPool1 is currently paused.
    You need to restore the current state of SQLPool1 to a new SQL pool.
    What should you do first?