Question 61

You are designing an Azure Databricks interactive cluster. The cluster will be used infrequently and will be configured for auto-termination.
You need to ensure that the cluster configuration is retained indefinitely after the cluster is terminated. The solution must minimize costs.
What should you do?
  • Question 62

    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?
  • Question 63

    You have an Azure Stream Analytics job that receives clickstream data from an Azure event hub.
    You need to define a query in the Stream Analytics job. The query must meet the following requirements:
    * Count the number of clicks within each 10-second window based on the country of a visitor.
    * Ensure that each click is NOT counted more than once.
    How should you define the Query?
  • Question 64

    You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool.
    How should you complete the Transact-SQL statement? 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.

    Question 65

    You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.
    Which Azure Storage functionality should you include in the solution?