DP-203 Exam Question 61

You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output the data to an Azure Blob storage account.
You need to output the count of tweets during the last five minutes every five minutes. Each tweet must only be counted once.
Which windowing function should you use?
  • DP-203 Exam Question 62

    You have an Azure Synapse Analytics dedicated SQL pool named pool1.
    You need to perform a monthly audit of SQL statements that affect sensitive data. The solution must minimize administrative effort.
    What should you include in the solution?
  • DP-203 Exam Question 63

    You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool.
    You need to design queries to maximize the benefits of partition elimination.
    What should you include in the Transact-SQL queries?
  • DP-203 Exam Question 64

    You have a self-hosted integration runtime in Azure Data Factory.
    The current status of the integration runtime has the following configurations:
    Status: Running
    Type: Self-Hosted
    Running / Registered Node(s): 1/1
    High Availability Enabled: False
    Linked Count: 0
    Queue Length: 0
    Average Queue Duration. 0.00s
    The integration runtime has the following node details:
    Name: X-M
    Status: Running
    Available Memory: 7697MB
    CPU Utilization: 6%
    Network (In/Out): 1.21KBps/0.83KBps
    Concurrent Jobs (Running/Limit): 2/14
    Role: Dispatcher/Worker
    Credential Status: In Sync
    Use the drop-down menus to select the answer choice that completes each statement based on the information presented.
    NOTE: Each correct selection is worth one point.

    DP-203 Exam Question 65

    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.
    * 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.