Course : Database Administation (DBA) Learning Outcomes: LO2: Apply SQL Server features LO3: Apply strategies for perfor

[answerhappygod]

Course : Database Administation (DBA)
Learning Outcomes:
LO2: Apply SQL Server features
LO3: Apply strategies for performance tuning

Course Database Administation Dba Learning Outcomes Lo2 Apply Sql Server Features Lo3 Apply Strategies For Perfor 1 (59.36 KiB) Viewed 37 times

Course Database Administation Dba Learning Outcomes Lo2 Apply Sql Server Features Lo3 Apply Strategies For Perfor 2 (122.99 KiB) Viewed 37 times

Question :

Course Database Administation Dba Learning Outcomes Lo2 Apply Sql Server Features Lo3 Apply Strategies For Perfor 3 (15.86 KiB) Viewed 37 times

II. Case(40%) You are employed as a DBA in a manufacturing company. Currently, you manage two databases for two production systems in your company. There are many problems with the backup procedure, backup type and cluster between these two systems, you should propose a backup procedure, backup type and cluster solution between these two systems. The following about each system:
a. You manage a database in a data warehouse system. There is a huge amount of data in this database. The situation with this system: Only executives and managers could access this database This database is not critical in the business process in your company. It takes 4 days for a full backup of this database and 2 days for differential backup. It is not necessary to always back up this database. ● ● b. You manage a database for a machinery system. The situation with this system: ● This system is very critical and must always be available. This system does not store a huge amount of data. It is necessary to always take backup because this system is critical for your company. It takes 6 hours to fully backup and 1 hour for a differential backup.
[LO2, LO3, 20 points] Make an architecture diagram for clustering between 2 systems and explain it!