<< Prev Question Next Question >>

Question 8/78

You are planning a streaming data solution that will use Azure Databricks. The solution will stream sales transaction data from an online store. The solution has the following specifications:
* The output data will contain items purchased, quantity, line total sales amount, and line total tax amount.
* Line total sales amount and line total tax amount will be aggregated in Databricks.
* Sales transactions will never be updated. Instead, new rows will be added to adjust a sale.
You need to recommend an output mode for the dataset that will be processed by using Structured Streaming. The solution must minimize duplicate data.
What should you recommend?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (78q)
Question 1: You need to output files from Azure Data Factory. Which file...
Question 2: You are developing a solution that will stream to Azure Stre...
Question 3: You have a self-hosted integration runtime in Azure Data Fac...
Question 4: You are developing a solution using a Lambda architecture on...
Question 5: You have two Azure Storage accounts named Storage1 and Stora...
Question 6: You need to create an Azure Data Factory pipeline to process...
Question 7: You plan to create an Azure Data Lake Storage Gen2 account Y...
Question 8: You are planning a streaming data solution that will use Azu...
Question 9: You have an Azure Stream Analytics job that receives clickst...
Question 10: You have several Azure Data Factory pipelines that contain a...
Question 11: You need to design a data ingestion and storage solution for...
Question 12: Note: This question is part of a series of questions that pr...
Question 13: You develop data engineering solutions for a company. A proj...
Question 14: What should you recommend using to secure sensitive customer...
Question 15: You are designing an Azure Data Lake Storage Gen2 container ...
Question 16: A company purchases IoT devices to monitor manufacturing mac...
Question 17: You have an Azure Data Lake Storage Gen2 container that cont...
Question 18: You have an Azure Data lake Storage account that contains a ...
Question 19: You are designing an Azure Synapse solution that will provid...
Question 20: You have an Azure Synapse Analytics dedicated SQL pool. You ...
Question 21: You have an enterprise data warehouse in Azure Synapse Analy...
Question 22: You are designing the folder structure for an Azure Data Lak...
Question 23: You have an Azure Data Lake Storage Gen2 account that contai...
Question 24: You use Azure Stream Analytics to receive Twitter data from ...
Question 25: You are planning the deployment of Azure Data Lake Storage G...
Question 26: You have an Azure Data Factory pipeline that performs an inc...
Question 27: You configure version control for an Azure Data Factory inst...
Question 28: You have an Azure Synapse Analystics dedicated SQL pool that...
Question 29: You are designing an inventory updates table in an Azure Syn...
Question 30: The storage account container view is shown in the Refdata e...
Question 31: You have an Azure Factory instance named DF1 that contains a...
Question 32: You have an Azure Synapse Analytics dedicated SQL Pool1. Poo...
Question 33: You have the following Azure Data Factory pipelines * ingest...
Question 34: Note: This question is part of a series of questions that pr...
Question 35: You are designing a star schema for a dataset that contains ...
Question 36: You are building an Azure Stream Analytics job to identify h...
Question 37: You build an Azure Data Factory pipeline to move data from a...
Question 38: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 39: You build a data warehouse in an Azure Synapse Analytics ded...
Question 40: You are designing a streaming data solution that will ingest...
Question 41: You use Azure Data Lake Storage Gen2 to store data that data...
Question 42: You need to design an analytical storage solution for the tr...
Question 43: You have a partitioned table in an Azure Synapse Analytics d...
Question 44: You have the following Azure Stream Analytics query. (Exhibi...
Question 45: You have an on-premises data warehouse that includes the fol...
Question 46: You have an Azure Data Lake Storage Gen2 account named accou...
Question 47: From a website analytics system, you receive data extracts a...
Question 48: You are building an Azure Analytics query that will receive ...
Question 49: You have an Azure Stream Analytics query. The query returns ...
Question 50: You have an Azure data solution that contains an enterprise ...
Question 51: You have an Azure Data Lake Storage account that contains a ...
Question 52: You need to collect application metrics, streaming query eve...
Question 53: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 54: You need to design a data retention solution for the Twitter...
Question 55: You are designing an Azure Synapse Analytics dedicated SQL p...
Question 56: You are designing the folder structure for an Azure Data Lak...
Question 57: You plan to create an Azure Data Factory pipeline that will ...
Question 58: You have files and folders in Azure Data Lake Storage Gen2 f...
Question 59: You plan to create an Azure Data Factory pipeline that will ...
Question 60: You have an Azure Synapse Analytics job that uses Scala. You...
Question 61: You plan to build a structured streaming solution in Azure D...
Question 62: Which Azure Data Factory components should you recommend usi...
Question 63: You need to implement the surrogate key for the retail store...
Question 64: You are creating a new notebook in Azure Databricks that wil...
Question 65: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 66: You are monitoring an Azure Stream Analytics job. The Backlo...
Question 67: You have an Azure Stream Analytics job that is a Stream Anal...
Question 68: You manage an enterprise data warehouse in Azure Synapse Ana...
Question 69: You have an Azure Data Factory that contains 10 pipelines. Y...
Question 70: You use Azure Data Factory to prepare data to be queried by ...
Question 71: You use Azure Stream Analytics to receive Twitter data from ...
Question 72: You plan to develop a dataset named Purchases by using Azure...
Question 73: You have an Azure Data Factory pipeline that is triggered ho...
Question 74: You are planning a solution to aggregate streaming data that...
Question 75: You have an Azure Synapse Analytics dedicated SQL pool. You ...
Question 76: You have a table in an Azure Synapse Analytics dedicated SQL...
Question 77: You have an Azure Storage account and a data warehouse in Az...
Question 78: You have a Microsoft SQL Server database that uses a third n...