DP-203 Exam Question 46

You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server named Server1.
You need to determine the size of the transaction log file for each distribution of DW1.
What should you do?
  • DP-203 Exam Question 47

    You have an Azure SQL database named Database1 and two Azure event hubs named HubA and HubB. The data consumed from each source is shown in the following table.

    You need to implement Azure Stream Analytics to calculate the average fare per mile by driver.
    How should you configure the Stream Analytics input for each source? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-203 Exam Question 48

    You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.
    You plan to create a database named D61 in Pool1.
    You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pod.
    Which format should you use for the tables in DB1?
  • DP-203 Exam Question 49

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

    You are batch loading a table in an Azure Synapse Analytics dedicated SQL pool.
    You need to load data from a staging table to the target table. The solution must ensure that if an error occurs while loading the data to the target table, all the inserts in that batch are undone.
    How should you complete the Transact-SQL code? 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.