Data Engineering on Microsoft Azure Free Practice Exam Questions

62 real Data Engineering on Microsoft Azure exam questions with answers and AI explanations. Microsoft certification prep — page 2 of 7.

Question 24: You build a data warehouse in an Azure Synapse Analytics dedicated SQL pool. Analysts write a complex SELECT query that contains multiple JOIN and CASE stateme…
Question 25: You are planning a solution to aggregate streaming data that originates in Apache Kafka and is output to Azure Data Lake Storage Gen2. The developers who will…
Question 26: You plan to implement an Azure Data Lake Storage Gen2 container that will contain CSV files. The size of the files will vary based on the number of events that…
Question 28: You are implementing a batch dataset in the Parquet format. Data files will be produced be using Azure Data Factory and stored in Azure Data Lake Storage Gen2.…
Question 32: You are designing a dimension table for a data warehouse. The table will track the value of the dimension attributes over time and preserve the history of the…
Question 35: You have a SQL pool in Azure Synapse. A user reports that queries against the pool take longer than expected to complete. You determine that the issue relates…
Question 38: You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables i…
Question 39: You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1. You need to re…
Question 42: You have an Azure Stream Analytics job. You need to ensure that the job has enough streaming units provisioned. You configure monitoring of the SU % Utilizatio…
Question 43: You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named SQLPool1. SQLPool1 is currently paused. You need to restore th…