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 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 68

    You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a table named table1.
    You load 5 TB of data intotable1.
    You need to ensure that columnstore compression is maximized for table1.
    Which statement should you execute?
  • DP-203 Exam Question 69

    You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1.
    Several users execute ad hoc queries to DW1 concurrently.
    You regularly perform automated data loads to DW1.
    You need to ensure that the automated data loads have enough memory available to complete quickly and successfully when the adhoc queries run.
    What should you do?
  • DP-203 Exam Question 70

    The storage account container view is shown in the Refdata exhibit. (Click the Refdata tab.) You need to configure the Stream Analytics job to pick up the new reference data. What should you configure? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.