The backup strategies for each database are described

This preview shows page 9 - 14 out of 51 pages.

The backup strategies for each database are described in the following table. Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 9 / 51
Image of page 9
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download 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 Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 10 / 51
Image of page 10
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download 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. You need to monitor query statistics and execution plans for SalesDb2. Which options should you set for the Query Store configuration? To answer, select the appropriate options in the answer area. Hot Area: Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 11 / 51
Image of page 11
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download Correct Answer: Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 12 / 51
Image of page 12
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download Operation Mode: Read-Write Query Store Capture Mode: Auto Size Based Cleanup Mode: AUTO Operation Mode: Read-Write It is strongly recommended to activate size-based cleanup to makes sure that Query Store always runs in read-write mode and collects the latest data. Query Store Capture Mode: Auto Auto – Infrequent queries and queries with insignificant compile and execution duration are ignored. Thresholds for execution count, compile and runtime duration are internally determined. Size Based Cleanup Mode: AUTO It is strongly recommended to activate size-based cleanup to makes sure that Query Store always runs in read-write mode and collects the latest data.
Image of page 13
Image of page 14

You've reached the end of your free preview.

Want to read all 51 pages?

  • Fall '19
  • Microsoft SQL Server

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors