Which components should you use for each Elastic pool job services task?

Posted by: Pdfprep Category: DP-200 Tags: , ,

DRAG DROP

Your company uses Microsoft Azure SQL Database configure with Elastic pool. You use Elastic Database jobs to run queries across all databases in the pod.

You need to analyze, troubleshoot, and report on components responsible for running Elastic Database jobs.

You need to determine the component responsible for running job service tasks.

Which components should you use for each Elastic pool job services task? To answer, drag the appropriate component to the correct task. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Execution results and diagnostics: Azure Storage

Job launcher and tracker: Job Service

Job metadata and state: Control database

The Job database is used for defining jobs and tracking the status and history of job executions. The Job database is also used to store agent metadata, logs, results, job definitions, and also contains many useful stored procedures, and other database objects, for creating, running, and managing jobs using T-SQL.

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-job-automation-overview

Leave a Reply

Your email address will not be published.