HOTSPOT You design data engineering solutions for a company. You must integrate on-premises SQL Server data into an Azure solution that performs Extract-Transform-Load (ETL) operations have the following requirements: Develop a pipeline that can integrate data and run notebooks. Develop…

HOTSPOT You are designing a solution for a company. You plan to use Azure Databricks. You need to recommend workloads and tiers to meet the following requirements: Provide managed clusters for running production jobs. Provide persistent clusters that support auto-scaling…

DRAG DROP You are designing a Spark job that performs batch processing of daily web log traffic. When you deploy the job in the production environment, it must meet the following requirements: Run once a day. Display status information on…

HOTSPOT A company stores large datasets in Azure, including sales transactions and customer account information. You must design a solution to analyze the data. You plan to create the following HDInsight clusters: You need to ensure that the clusters support…

You design data engineering solutions for a company. A project requires analytics and visualization of large set of data. The project has the following requirements: Notebook scheduling Cluster automation Power BI Visualization You need to recommend the appropriate Azure service.…

You plan to migrate data to Azure SQL Database. The database must remain synchronized with updates to Microsoft Azure and SQL Server. You need to set up the database as a subscriber. What should you recommend? A. Azure Data Factory…

You are designing a real-time stream solution based on Azure Functions. The solution will process data uploaded to Azure Blob Storage. The solution requirements are as follows: New blobs must be processed with a little delay as possible. Scaling must…

You have a Windows-based solution that analyzes scientific data. You are designing a cloud-based solution that performs real-time analysis of the data. You need to design the logical flow for the solution. Which two actions should you recommend? Each correct…

A company installs IoT devices to monitor its fleet of delivery vehicles. Data from devices is collected from Azure Event Hub. The data must be transmitted to Power BI for real-time data visualizations. You need to recommend a solution. What…

You are designing an Azure Data Factory pipeline for processing data. The pipeline will process data that is stored in general-purpose standard Azure storage. You need to ensure that the compute environment is created on-demand and removed when the process…