Question

You manage 40 Azure SQL databases spread across three logical servers that host tenant data for a SaaS application. You need to run the same index maintenance T-SQL script against all 40 databases every night using the Elastic Jobs feature. You have created an Elastic Job agent and a job. Which action correctly defines WHICH databases the job step executes against?

Accepted Answer

Create a target group and add the three logical servers as target members, allowing the agent to expand each server into its member databases at runtime.

Answer

Add each of the 40 databases individually as a linked server on the job agent's control database.

Answer

Enable the SQL Server Agent service on each logical server and register the databases as agent targets.

Answer

Configure a maintenance plan in the Azure portal and assign the 40 databases as subscribers.