Microsoft Azure Architect Design (2020, legacy) — Question 1

You need to design a solution that will execute custom C# code in response to an event routed to Azure Event Grid. The solution must meet the following requirements:
✑ The executed code must be able to access the private IP address of a Microsoft SQL Server instance that runs on an Azure virtual machine.
✑ Costs must be minimized.
What should you include in the solution?

Answer options

• A. Azure Logic Apps in the integrated service environment
• B. Azure Functions in the Dedicated plan and the Basic Azure App Service plan
• C. Azure Logic Apps in the Consumption plan
• D. Azure Functions in the Consumption plan

Correct answer: D

Explanation

The correct answer is D, Azure Functions in the Consumption plan, as it allows for executing C# code in a cost-effective manner. Options A and B are not ideal due to higher costs associated with their respective plans, while option C does not provide the necessary capability to run custom C# code effectively.