Question 146

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 147

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 section, 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 Synapse Analytics dedicated SQL pool that contains a table named Table1.
You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.
You plan to insert data from the files in container1 into Table1 and transform the dat a. Each row of data in the files will produce one row in the serving layer of Table1.
You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.
Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external table that has an additional DateTime column.
Does this meet the goal?
  • Question 148

    You have the following Azure Stream Analytics query.

    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE: Each correct selection is worth one point.

    Question 149

    You are monitoring an Azure Stream Analytics job by using metrics in Azure.
    You discover that during the last 12 hours, the average watermark delay is consistently greater than the configured late arrival tolerance.
    What is a possible cause of this behavior?
  • Question 150

    You build an Azure Data Factory pipeline to move data from an Azure Data Lake Storage Gen2 container to a database in an Azure Synapse Analytics dedicated SQL pool.
    Data in the container is stored in the following folder structure.
    /in/{YYYY}/{MM}/{DD}/{HH}/{mm}
    The earliest folder is /in/2021/01/01/00/00. The latest folder is /in/2021/01/15/01/45.
    You need to configure a pipeline trigger to meet the following requirements:
    Existing data must be loaded.
    Data must be loaded every 30 minutes.
    Late-arriving data of up to two minutes must he included in the load for the time at which the data should have arrived.
    How should you configure the pipeline trigger? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.