Question 41

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

    You have an Azure Databricks resource.
    You need to log actions that relate to changes in compute for the Databricks resource.
    Which Databricks services should you log?
  • Question 43

    You have an Azure subscription that contains an Azure Blob Storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool named Pool1.
    You need to store data in storage1. The data will be read by Pool1. The solution must meet the following requirements:
    Enable Pool1 to skip columns and rows that are unnecessary in a query.
    Automatically create column statistics.
    Minimize the size of files.
    Which type of file should you use?
  • Question 44

    You develop data engineering solutions for a company.
    A project requires the deployment of data to Azure Data Lake Storage.
    You need to implement role-based access control (RBAC) so that project members can manage the Azure Data Lake Storage resources.
    Which three actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • Question 45

    You plan to create an Azure Data Factory pipeline that will include a mapping data flow.
    You have JSON data containing objects that have nested arrays.
    You need to transform the JSON-formatted data into a tabular dataset. The dataset must have one tow for each item in the arrays.
    Which transformation method should you use in the mapping data flow?