DB1 という名前の Microsoft SQL Server 2019 データベースと、SQLMI1 という名前の Azure SQL マネージド インスタンスがあります。SQL Server エージェント ジョブを DB1 から SQLMI1 に移動する必要があります。SQLMI1 でサポートされていないジョブ属性はどれですか?
正解:D
Basic Concept: This question tests task automation for database administration, including which Azure or SQL mechanism can run repeatable maintenance and configuration work.
Why D is Correct: output files matches the expected DP-300 administration action. output files can participate in administration workflows, but automation questions require the mechanism that can execute repeatable tasks with the correct scope and schedule. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: You need to move a SQL Server Agent job from DB1 to SQLMI1.
Why A is Wrong: log to table can participate in administration workflows, but automation questions require the mechanism that can execute repeatable tasks with the correct scope and schedule. It would leave too much manual work or would operate at the wrong scope for the requested automation.
Why B is Wrong: email notifications can participate in administration workflows, but automation questions require the mechanism that can execute repeatable tasks with the correct scope and schedule. It does not provide the required repeatable execution, scheduling, or deployment automation requirement, so it would not complete the administrative workflow reliably.
Why C is Wrong: schedules can participate in administration workflows, but automation questions require the mechanism that can execute repeatable tasks with the correct scope and schedule. It belongs to a different step of operations; this question needs the mechanism that can run or deploy the task repeatedly.