DP-203 Exam Question 26

You need to implement a Type 3 slowly changing dimension (SCD) for product category data in an Azure Synapse Analytics dedicated SQL pool.
You have a table that was created by using the following Transact-SQL statement.

Which two columns should you add to the table? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
  • DP-203 Exam Question 27

    You need to schedule an Azure Data Factory pipeline to execute when a new file arrives in an Azure Data Lake Storage Gen2 container.
    Which type of trigger should you use?
  • DP-203 Exam Question 28

    You have an Azure Synapse Analytics SQL pool named Pool1 on a logical Microsoft SQL server named Server1.
    You need to implement Transparent Data Encryption (TDE) on Pool1 by using a custom key named key1.
    Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    DP-203 Exam Question 29

    You are designing a highly available Azure Data Lake Storage solution that will include geo-zone-redundant storage (GZRS).
    You need to monitor for replication delays that can affect the recovery point objective (RPO).
    What should you include in the monitoring solution?
  • DP-203 Exam Question 30

    You are planning a solution to aggregate streaming data that originates in Apache Kafka and is output to Azure Data Lake Storage Gen2. The developers who will implement the stream processing solution use Java, Which service should you recommend using to process the streaming data?