After you answer a question in this section you will

This preview shows page 8 - 12 out of 19 pages.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. Your company has several Microsoft SQL Server instances. Each instance hosts many databases. You observe I/O corruption on some of the instances. You need to perform the following actions: Identify databases where the PAGE VERIFY option is not set. Configure full page protection for the identified databases. Solution: You run the following Transact-SQL statement: For each database that you identify, you run the following Transact-SQL statement: Does the solution meet the goal? A. Yes B. No Correct Answer: B We should check for CHECKSUM not TORN_PAGE_DETECTION References: - database-option-to-checksum?view=sql-server-2017 Latest 70-764 Dumps | 70-764 Study Guide | 70-764 Braindumps 8 / 19
Image of page 8
2019 Latest pass4itsure 70-764 PDF and VCE dumps Download QUESTION 8 You have a SQL Server 2012 database named DB1. You have a backup device named Device1. You discover that the log file for the database is full. You need to ensure that DB1 can complete transactions. The solution must not affect the chain of log sequence numbers (LSNs). Which code segment should you execute? A. BACKUP LCG DB1 TO Device1 WITH COPY_ONLY B. BACKUP LOG DB1 TO Device1 C. BACKUP LOG DB1 TO Device1 WITH NCRECCVERY D. BACKUP LOG D31 TO Device1 WITH TRUNCATE ONLY Correct Answer: B QUESTION 9 You use SQL Server 2014 Enterprise Edition. Your database contains a partitioned table named AuditData. AuditData is partitioned by year. Partition 1 contains data from the year 2010 and prior. Management has decided to archive all AUDITDATA records from 2010 and prior. Management wants the records to be removed from the database entirely and provided to the backup team as a zipped text file. The data must no longer reside in the database. There is very little tolerance for performance degradation in your environment. You need to remove all 2010 and prior data from the AuditData table by using the least amount of system resources possible. Develop the solution by selecting and arranging the required SQL actions in the correct order. You may not need all of the actions. Select and Place: Latest 70-764 Dumps | 70-764 Study Guide | 70-764 Braindumps 9 / 19
Image of page 9
2019 Latest pass4itsure 70-764 PDF and VCE dumps Download Correct Answer: Latest 70-764 Dumps | 70-764 Study Guide | 70-764 Braindumps 10 / 19
Image of page 10
2019 Latest pass4itsure 70-764 PDF and VCE dumps Download Note: - Create a new partitioned table with the partition function you want, and then insert the data from the old table into the new table by using an INSERT INTO...SELECT FROM statement.
Image of page 11
Image of page 12

You've reached the end of your free preview.

Want to read all 19 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