Question

You manage 40 Azure SQL databases on a single logical server. New databases are provisioned weekly, and you need an Elastic Job that runs a maintenance T-SQL script against every database on the server, automatically including databases added in the future. You are configuring the target group. Which target group member configuration meets this requirement with the least ongoing maintenance?

Accepted Answer

Add the logical server as a target group member (server target) so all current and future databases are included dynamically.

Answer

Add each database individually as a target group member and update the group each week.

Answer

Add an elastic pool as the target group member so future databases are automatically covered.

Answer

Add the master database as a target group member so it fans out to all user databases.