Exam 70-764 topic 1 question 303 discussion

HOTSPOT -
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
You maintain a Microsoft SQL Server instance that contains the following databases SalesDb1, SalesDb2, and SalesDb3. Each database has tabled named
Products and Sales. The following table shows the configuration of each database.

The backup strategies for each database are described in the following table.

Each full or differential backup operation writes into a new file and uses a different sequence number. You observe the following database corruption issues.

SalesDb3 reports a number of database corruption issues related to error 823 and 824 when reading data pages. You must display the following information about the corrupted pages:
✑ database name
✑ impacted file id
✑ impacted file physical name
✑ impacted page id
✑ event type that identifies the error type
✑ error count
Users report performance issues when they run queries against SalesDb2. You plan to monitor query statistics and execution plans for SalesDb2 by using Query
Store. The monitoring strategy must meet the following requirements:
✑ Perform automatic data cleanup when query store disk usage reaches 500 megabyte (MB).
✑ Capture queries based on resource consumption.
✑ Use a stale query threshold value of 60 days.
The query optimizer generates suboptimal execution plans for a number of queries on the Sales table in SalesDb2. You will create a maintenance plan that updates statistics for the table. The plan should only update statistics that were automatically created and have not been updated for 30 days. The update should be based on all data in the table.
Both SalesDb1 and SalesDb2 experience blocking and deadlock issues. You create an Extended Events session to monitor the databases. (Click the Exhibit button.)
You need to create and configure the Extended Events session.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

Hot Area:

Suggested Answer:
Lock escalation is the process of converting many fine-grain locks into fewer coarse-grain locks, reducing system overhead while increasing the probability of concurrency contention.
References:
https://technet.microsoft.com/en-us/library/ms184286(v=sql.105).aspx https://blobeater.blog/2017/02/06/using-extended-events-in-azure/