exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 4 question 13 discussion

Actual exam question from Microsoft's DP-200
Question #: 13
Topic #: 4
[All DP-200 Questions]

DRAG DROP -
Your company uses Microsoft Azure SQL Database configured with Elastic pools. You use Elastic Database jobs to run queries across all databases in the pool.
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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
kempstonjoystick
Highly Voted 5 years, 2 months ago
I think the first and third boxes on this one should both be Control Database as per the documentation https://docs.microsoft.com/en-us/azure/sql-database/sql-database-job-automation-overview#job-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.
upvoted 49 times
111222333
4 years ago
Agree that both first and third box should be Control Database. - First box: "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." - Third box: "Job output The outcome of a job's steps on each target database are recorded in detail, and script output can be captured to a specified table. You can specify a database to save any data returned from a job." Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/job-automation-overview#job-database
upvoted 1 times
...
...
suhas16c
Highly Voted 4 years, 10 months ago
How can the result after execution be stored in the control database? It should be Azure storage. Hence the answers given are correct
upvoted 7 times
...
syu31svc
Most Recent 4 years, 6 months ago
I would say: Azure storage for execution Control database for the jobs
upvoted 2 times
dev2dev
4 years, 4 months ago
you are wrong on execution. how you execute on azure storage?
upvoted 2 times
...
...
hart232
4 years, 8 months ago
A should be Azure storage as Control database can have logs but to do diagnostics the log need to be stored somewhere so that they can be diagnosed.
upvoted 1 times
...
SiddharthB
4 years, 8 months ago
Should the answer be like below if referred the below documentation? https://docs.microsoft.com/en-us/azure/sql-database/sql-database-job-automation-overview#job-database 1)Job database 2)Job agent 3)Job database
upvoted 4 times
...
krisspark
4 years, 11 months ago
true.. no storage required.. 1st one is control database
upvoted 3 times
...
Divs123
5 years ago
Both first and third boxes should have Control Date base
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...