dp-300-database-admin-assoc video for scenario: Happy Hogan was hired at Hammer Advanced Systems to build a mission-critical cloud application that requires
Scenario: Happy Hogan was hired at Hammer Advanced Systems to build a mission-critical cloud application that requires 99.995 percent availability because downtime might be life threatening. High performance is required, because any delay in response carries high risk and can be life-threatening. Given the sensitivity of the collected personal information, data sovereignty must be guaranteed. His main mission is to ensure that the app is designed and deployed with the appropriate data redundancy and fault resilience to meet the availability and data sovereignty goals. The emergency dispatch system coordinators are concerned about protecting sensitive data (PII) while allowing database analysts (DBAs) to perform their jobs. DBAs must not be able to see sensitive data stored in specific columns, and all access to tables that contain sensitive data must be monitored. At the same time, DBAs need to be able to troubleshoot performance by using the Azure portal, SQL Server Management Studio, and Azure Data Studio. They also need the ability to create new contained database users who must be mapped to Microsoft Entra ID principals. What role does colocation play in your solution?