How should you monitor SALESDB to meet the technical requirements? A. Query the sys.resource_stats dynamic management view. B. Review the Query Performance Insights for SALESDB. C. Query the sys.dm_os_wait_stats dynamic management view. D. Review the auditing information of SALESDB.
Case study Overview ADatum Corporation is a retailer that sells products through two sales channels: retail stores and a website. Existing Environment ADatum has one database server that has Microsoft SQL Server 2016 installed. The server hosts three mission-critical databases…
Which two metrics should you use to identify the appropriate RU/s for the telemetry data? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Number of requests B. Number of requests exceeded…
What should you implement to optimize SQL Database for Race Central to meet the technical requirements? A. the sp_update stored procedure B. automatic tuning C. Query Store D. the dbcc checkdb command
You are monitoring the Data Factory pipeline that runs from Cosmos DB to SQL Database for Race Central. You discover that the job takes 45 minutes to run. What should you do to improve the performance of the job? A.…
Case Study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam.…
Note: This question-is part of a series of questions that present the same scenario. Each question-in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others…
Note: This question-is part of a series of questions that present the same scenario. Each question-in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others…
Overview Current environment Contoso relies on an extensive partner network for marketing, sales, and distribution. Contoso uses external companies that manufacture everything from the actual pharmaceutical to the packaging. The majority of the company’s data reside in Microsoft SQL Server…
HOTSPOT You need to ensure phone-based polling data upload reliability requirements are met. How should you configure monitoring? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: