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

Question 88: You are building a data flow in Azure Data Factory that upserts data into a table in an Azure Synapse Analytics dedicated SQL pool. You need to add a transform…
Question 89: You have an on-premises database named db1 and a set-hosted integration runtime. You have an Azure subscription that contains an Azure Data Lake Storage accoun…
Question 91: You have an Azure data factory named DF1. DF1 contains a single pipeline that is executed by using a schedule trigger. From Diagnostics settings, you configure…
Question 93: You have an on-premises Linux server that contains a database named DB1. You have an Azure subscription that contains an Azure data factory named ADF1 and an A…
Question 99: You have an Azure Data Factory pipeline named P1. You need to schedule P1 to run at 10:15 AM, 12:15 PM, 2:15 PM, and 4:15 PM every day. Which frequency and int…
Question 102: You have an Azure subscription that contains an Azure Cosmos DB database. Azure Synapse Link is implemented on the database. You configure a full fidelity sche…
Question 103: You are creating an Azure Data Factory pipeline. You need to add an activity to the pipeline. The activity must execute a Transact-SQL stored procedure that ha…
Question 105: You have an Azure subscription that contains a Microsoft Purview account. You need to search the Microsoft Purview Data Catalog to identify assets that have an…
Question 108: You have an Azure subscription that contains an Azure data factory named ADF1 and a Log Analytics workspace named Workspace1. You need to configure ADF1 to sen…
Question 114: You are developing a solution that will stream to Azure Stream Analytics. The solution will have both streaming data and reference data. Which input type shoul…