How should you structure the output of the Stream Analytics job?

HOTSPOT 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...

January 29, 2023 No Comments READ MORE +

What should you do to improve high availability of the real-time data processing solution?

What should you do to improve high availability of the real-time data processing solution?A . Deploy identical Azure Stream Analytics jobs to paired regions in Azure. B. Deploy a High Concurrency Databricks cluster. C. Deploy an Azure Stream Analytics job and use an Azure Automation runbook to check the status...

January 28, 2023 No Comments READ MORE +

How should you configure the solution?

CORRECT TEXT You have an Azure Storage account that generates 200.000 new files daily. The file names have a format of (YYY)/(MM)/(DD)/|HH])/(CustornerID).csv. You need to design an Azure Data Factory solution that will toad new data from the storage account to an Azure Data lake once hourly. The solution must...

January 28, 2023 No Comments READ MORE +

What should you include in the solution?

You have an Azure Synapse Analystics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone. You need to ensure that users in a specific role only see the last four digits of a phone number when querying the Phone column. What should you include...

January 28, 2023 No Comments READ MORE +

How should you manage the data?

HOTSPOT You have an Azure Data Lake Storage Gen2 container. Data is ingested into the container, and then transformed by a data integration application. The data is NOT modified after that. Users can read files in the container but cannot modify the files. You need to design a data archiving...

January 28, 2023 No Comments READ MORE +

The following code segment is used to create an Azure Databricks cluster

HOTSPOT The following code segment is used to create an Azure Databricks cluster. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Graphical user interface, text, application Description automatically generated Box 1:...

January 28, 2023 No Comments READ MORE +

Which type of file should you use?

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...

January 28, 2023 No Comments READ MORE +

How should you configure the new cluster?

HOTSPOT You need to implement an Azure Databricks cluster that automatically connects to Azure Data Lake Storage Gen2 by using Azure Active Directory (Azure AD) integration. How should you configure the new cluster? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one...

January 28, 2023 No Comments READ MORE +

How should you complete the query?

HOTSPOT You are processing streaming data from vehicles that pass through a toll booth. You need to use Azure Stream Analytics to return the license plate, vehicle make, and hour the last vehicle passed during each 10-minute window. How should you complete the query? To answer, select the appropriate options...

January 28, 2023 No Comments READ MORE +

Which file format should you use for each type of output?

HOTSPOT You need to output files from Azure Data Factory. Which file format should you use for each type of output? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Parquet Parquet stores data in columns,...

January 27, 2023 No Comments READ MORE +