DP-203 Exam Question 66

You are designing a financial transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and will include the following columns:
TransactionType: 40 million rows per transaction type
CustomerSegment: 4 million per customer segment
TransactionMonth: 65 million rows per month
AccountType: 500 million per account type
You have the following query requirements:
Analysts will most commonly analyze transactions for a given month.
Transactions analysis will typically summarize transactions by transaction type, customer segment, and/or account type You need to recommend a partition strategy for the table to minimize query times.
On which column should you recommend partitioning the table?
  • DP-203 Exam Question 67

    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 68

    A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices.
    The company must be able to monitor the devices in real-time.
    You need to design the solution.
    What should you recommend?
  • DP-203 Exam Question 69

    You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1.
    You need to identify the extent of the data skew in Table1.
    What should you do in Synapse Studio?
  • DP-203 Exam Question 70

    You have an Azure Stream Analytics query. The query returns a result set that contains 10,000 distinct values for a column named clusterID.
    You monitor the Stream Analytics job and discover high latency.
    You need to reduce the latency.
    Which two actions should you perform? Each correct answer presents a complete solution.
    NOTE: Each correct selection is worth one point.