Physical Locations All of the corporate executives, product managers, and support staff are stationed at the headquarters office. Half of thesales force works at this location. There is also a satellite sales office. The other half of the sales force works at the satellite office in order to have sales people closer to clients in that area. Only sales people work at the satellitelocation. Problem Statement To be successful, Fabrikam needs a website that is fast and has a high degree of system uptime. The current systemoperates on a single server and the company is not happy with the single point of failure this presents. The currentnightly backups have been failing due to insufficient space on the available drives and manual drive cleanup often needing tohappen to get past the errors. Additional space will not be made available for backups on the HQ or satellite servers. During your investigation, you discover that the sales force reports are causing significant contention. Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test19 / 51
2020 Latest pass4itsure 70-764 PDF and VCE dumps DownloadConfiguration Windows Logins The network administrators have set up Windows groups to make it easier to manage security. Users may belong tomore than one group depending on their role. The groups have been set up as shown in the following table: Server Configuration The IT department has configured two physical servers with Microsoft Windows Server 2012 R2and SQL Server 2014 Enterprise Edition and one Windows Azure Server. There are two tiers of storage available foruse by database files only a fast tier and a slower tier. Currently the data and log files are stored on the fast tier ofstorage only. If a possible use case exists, management would like to utilize the slower tier storage for data files. Theservers are configured as shown in the following table: Database Currently all information is stored in a single database called ProdDB, created with the following script: The Product table is in the Production schema owned by the ProductionStaff Windows group. It is the main table in thesystem so access to information in the Product table should be as fast as possible. The columns in the Product table aredefined as shown in the following table: Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test20 / 51
2020 Latest pass4itsure 70-764 PDF and VCE dumps DownloadThe SalesOrderDetail table holds the details about each sale. It is in the Sales schema owned by the SalesStaffWindows group. This table is constantly being updated, inserted into, and read. The columns in the SalesOrderDetailtable are defined as shown in the following table: Database Issues The current database does not perform well. Additionally, a recent disk problem caused the system to go down,resulting in lost sales revenue. In reviewing the current system, you found that there are no automated maintenanceprocedures.
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.
Temple University Fox School of Business ‘17, Course Hero Intern
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.
University of Pennsylvania ‘17, Course Hero Intern
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.
Tulane University ‘16, Course Hero Intern
Stuck? We have tutors online 24/7 who can help you get unstuck.
Ask Expert Tutors
You can ask
You can ask
You can ask
(will expire )