Which role is accountable for keeping a company's production SQL Server instances available, including patching, access security, backup and restore testing, and performance tuning?
Show answer and explanation
Answer: A
A database administrator is responsible for operating database platforms. That covers installation and configuration, patching, securing access, backup and restore testing, and tuning performance so the systems stay available. The other roles focus elsewhere: machine learning engineers build and deploy models, visualization specialists design reports, and network architects design connectivity rather than database internals.
Why the other options are wrong
- B. Machine learning engineers package and deploy predictive models. They rarely own the uptime, patching, or backup routines of production SQL Server instances.
- C. Visualization specialists design charts and reports for consumers of data. They do not manage the security, backups, or tuning of the database engine itself.
- D. Network architects plan connectivity, routing, and segmentation. Those duties affect how clients reach the server but not the database's internal backup and tuning tasks.