Database maintenance the company has defined a

This preview shows page 22 - 25 out of 51 pages.

Database Maintenance The company has defined a maintenance window every month when the server can be unavailable. Any maintenance functions that require exclusive access should be accomplished during that window. Project milestones completed Revoked all existing read and write access to the database, leaving the schema ownership in place. Configured an Azure storage container secured with the storage account name MyStorageAccount with the primary access key StorageAccountKey on the cloud file server. SQL Server 2014 has been configured on the satellite server and is ready for use. On each database server, the fast storage has been assigned to drive letter F:, and the slow storage has been assigned to drive letter D:. You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort. Which code should you use? Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 22 / 51
Image of page 22
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download A. Option A B. Option B C. Option C Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 23 / 51
Image of page 23
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download D. Option D Correct Answer: A -Scenario: -During your investigation, you discover that the sales force reports are causing significant contention. - Sales force data access Sales people at both the headquarters office and the satellite office must generate reports that read from the Product and SalesOrderDetail tables. No updates or inserts are ever made by sales people. These reports are run at random times and there can be no reporting downtime to refresh the data set except during the monthly maintenance window. The reports that run from the satellite office are process intensive queries with large data sets. Regardless of which office runs a sales force report, the SalesOrderDetail table should only return valid, committed order data; any orders not yet committed should be ignored. QUESTION 19 You maintain three datacenters in different geographical regions. You have a four-node failover cluster that hosts a Microsoft SQL Server Failover Cluster Instance (FCI) in Datacenter1. You must extend FCI to add four nodes in Datacenter2. You need to configure a node majority quorum mode for the cluster. What are the two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Use a cloud quorum witness that is hosted in Microsoft Azure B. Use no witness C. Use a disk witness that is hosted in Datacenter2 D. Use a disk witness that is hosted in Datacenter1 E. Use a file share witness that is hosted in Datacenter3 Correct Answer: AE A: Cloud Witness is a type of Failover Cluster quorum witness that uses Microsoft Azure to provide a vote on cluster quorum.
Image of page 24
Image of page 25

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