DP-200

HOTSPOT You have an Azure SQL database named Database1 and two Azure event hubs named HubA and HubB. The data consumed from each source is shown in the following table. You need to implement Azure Stream Analytics to calculate the average fare per mile by driver. How should you configure...

DRAG DROP Your company plans to create an event processing engine to handle streaming data from Twitter. The data engineering team uses Azure Event Hubs to ingest the streaming data. You need to implement a solution that uses Azure Databricks to receive the streaming data from the Azure Event Hubs....

DRAG DROP You have an Azure SQL database named DB1 in the Each US 2 region. You need to build a secondary geo-replicated copy of DB1 in the West US region on a new server. Which three actions should you perform in sequence? To answer, move the appropriate actions from...

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region. To complete this task, sign...

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to generate an email notification to [email protected] if the available storage in an Azure Cosmos DB database named cosmos10277521 is less...

You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval. The output will be sent to a Delta Lake table. Which output mode should you use?A . completeB . updateC ....

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region. To complete this task, sign...

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to generate an email notification to [email protected] if the available storage in an Azure Cosmos DB database named cosmos10277521 is less...

You are creating a new notebook in Azure Databricks that will support R as the primary language but will also support Scola and SQL. Which switch should you use to switch between languages?A . %<language>B . \[<language>]C . \(<language>)D . @<Language>View AnswerAnswer: A Explanation: You can override the primary language...

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You plan to query db3 to retrieve a list of sales customers. The query will retrieve several columns that include the email address...