Equivalent to the audit add login to server role

This preview shows page 39 - 41 out of 51 pages.

Equivalent to the Audit Add Login to Server Role Event Class. References: QUESTION 30 You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction processing sales system. The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups. These backups are stored on a backup server in the company\\'s data center. Every week, the company places the full backup on a tape and sends it to a third-party backup storage system. The company is worried that a disaster might occur that could destroy their computer center and cause them to lose orders. You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations. What should you do? More than one answer choice may achieve the goal. Select the BEST answer. A. Set up SQL Server Always On with a SQL Azure database as a replica. B. Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine. C. Put the differential backup on tape and send it to the third-party backup storage system. D. Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location. Correct Answer: D SQL Server 2012 was the first version to provide the ability to back up databases to the Cloud, and SQL Server 2014 improves on the process. Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud. QUESTION 31 Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 39 / 51
Image of page 39
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download Which feature should you enable and configure so session requests addressed to a specific instance can be allocated different processor resources based on session request properties? A. Resource Governor B. Windows System Resource Manager C. Processor affinity D. I/O affinity Correct Answer: A Resource Governor enables you to allocate session requests to different resources based on the characteristics of the session request properties. References: - governor/resource-governor QUESTION 32 You have a Microsoft SQL Server instance that hosts a database named DB1 that contains 800 gigabyte (GB) of data. The database is used 24 hours each day. You implement indexes and set the value of the Auto Update Statistics option set to True. Users report that queries take a long time to complete. You need to identify tables that meet the following requirements: More than 1,000 rows have changed.
Image of page 40
Image of page 41

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