Question 131

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 from the last five minutes every minute.
Which windowing function should you use?
  • Question 132

    You have an Azure event hub named retailhub that has 16 partitions. Transactions are posted to retailhub.
    Each transaction includes the transaction ID, the individual line items, and the payment details. The transaction ID is used as the partition key.
    You are designing an Azure Stream Analytics job to identify potentially fraudulent transactions at a retail store. The job will use retailhub as the input. The job will output the transaction ID, the individual line items, the payment details, a fraud score, and a fraud indicator.
    You plan to send the output to an Azure event hub named fraudhub.
    You need to ensure that the fraud detection solution is highly scalable and processes transactions as quickly as possible.
    How should you structure the output of the Stream Analytics job? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 133

    You have an on-premises data warehouse that includes the following fact tables. Both tables have the following columns: DateKey, ProductKey, RegionKey. There are 120 unique product keys and 65 unique region keys.

    Queries that use the data warehouse take a long time to complete.
    You plan to migrate the solution to use Azure Synapse Analytics. You need to ensure that the Azure-based solution optimizes query performance and minimizes processing skew.
    What should you recommend? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point

    Question 134

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB.
    You plan to copy the data from the storage account to an Azure SQL data warehouse.
    You need to prepare the files to ensure that the data copies quickly.
    Solution: You modify the files to ensure that each row is less than 1 MB.
    Does this meet the goal?