ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 151 - AZ-204 discussion

Report
Export

You are developing an Azure function that connects to an Azure SQL Database instance. The function is triggered by an Azure Storage queue.

You receive reports of numerous System.InvalidOperationExceptions with the following message:

"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

You need to prevent the exception.

What should you do?

A.
In the host.json file, decrease the value of the batchSize option
Answers
A.
In the host.json file, decrease the value of the batchSize option
B.
Convert the trigger to Azure Event Hub
Answers
B.
Convert the trigger to Azure Event Hub
C.
Convert the Azure Function to the Premium plan
Answers
C.
Convert the Azure Function to the Premium plan
D.
In the function.json file, change the value of the type option to queueScaling
Answers
D.
In the function.json file, change the value of the type option to queueScaling
Suggested answer: A

Explanation:

With the Premium plan the max outbound connections per instance is unbounded compared to the 600 active (1200 total) in a Consumption plan.

Note: The number of available connections is limited partly because a function app runs in a sandbox environment. One of the restrictions that the sandbox imposes on your code is a limit on the number of outbound connections, which is currently 600 active (1,200 total) connections per instance. When you reach this limit, the functions runtime writes the following message to the logs: Host thresholds exceeded: Connections.

Reference:

https://docs.microsoft.com/en-us/azure/azure-functions/manage-connections

https://docs.microsoft.com/en-us/azure/azure-functions/functions-scale#service-limits

asked 02/10/2024
Alexey Bokov
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first