You have an Azure Synapse Analytics dedicated SQL pool that contains a table named DimSalesPerson. DimSalesPerson contains the following columns:•RepSourceID•SalesRepID•FirstName•LastName•StartDate•EndDate•RegionYou are developing an Azure Synapse Analytics pipeline that includes a mapping data flow named Dataflow1. Dataflow1 will read sales team data from an external source and use a Type 2 slowly changing dimension (SCD) when loading the data into DimSalesPerson.You need to update the last name of a salesperson in DimSalesPerson.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer(s): C,D
HOTSPOT (Drag and Drop is not supported)You plan to use an Azure Data Lake Storage Gen2 account to implement a Data Lake development environment that meets the following requirements:•Read and write access to data must be maintained if an availability zone becomes unavailable.•Data that was last modified more than two years ago must be deleted automatically.•Costs must be minimized.What should you configure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.
Answer(s): A
HOTSPOT (Drag and Drop is not supported)You are designing an Azure Data Lake Storage Gen2 container to store data for the human resources (HR) department and the operations department at your company.You have the following data access requirements:•After initial processing, the HR department data will be retained for seven years and rarely accessed.•The operations department data will be accessed frequently for the first six months, and then accessed once per month.You need to design a data retention solution to meet the access requirements. The solution must minimize storage costs.What should you include in the storage policy for each department? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.
HOTSPOT (Drag and Drop is not supported)You are developing an Azure Synapse Analytics pipeline that will include a mapping data flow named Dataflow1. Dataflow1 will read customer data from an external source and use a Type 1 slowly changing dimension (SCD) when loading the data into a table named DimCustomer in an Azure Synapse Analytics dedicated SQL pool.You need to ensure that Dataflow1 can perform the following tasks:•Detect whether the data of a given customer has changed in the DimCustomer table.•Perform an upsert to the DimCustomer table.Which type of transformation should you use for each task? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.
DRAG DROP (Drag and Drop is not supported)You have an Azure Synapse Analytics serverless SQL pool.You have an Azure Data Lake Storage account named adls1 that contains a public container named container1. The container1 container contains a folder named folder1.You need to query the top 100 rows of all the CSV files in folder1.How should you complete the query? 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
Post your Comments and Discuss Microsoft DP-203 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the DP-203 content, but please register or login to continue.