dp-300-database-admin-assoc video for scenario: Peter Parker is working at the Daily Bugle. The Daily Bugle is a provider for services and content delivery
Scenario: Peter Parker is working at the Daily Bugle. The Daily Bugle is a provider for services and content delivery across the globe. It has requested Peter’s assistance in building a system that can handle thousands of writes per second to what is essentially an operational data mart. The Daily Bugle also needs the ability to perform real-time analytics on the data, to determine trends and identify anomalies. It's currently doing that with common language runtime (CLR) applications. They are not looking for a data warehouse and to utilize large portions of the SQL surface area, but it needs to be able to scale where users live. The Daily Bugle is also trying to determine which authentication methods to use in its hybrid environment. Although the main solution and application will live in Azure, the customer also needs to accommodate the following: An application on a non-Azure machine that is domain-joined. An older application that won't allow the change of the driver or connection string on a non-Azure machine. Multiple users that run reports from SQL admin tools (SQL Server Management Studio, Azure Data Studio, PowerShell) on non-Azure machines that are not domain-joined. Wherever possible, the Daily Bugle wants to eliminate hard-coding passwords or secrets in the connection strings and app configuration files. It also wants to eliminate using passwords in SQL tools or find a way to enhance that authentication. Which authentication method would Peter recommend for the application on a non-Azure machine that is domain-joined?