DP-900 · Question #304
What is the responsibility of a database administrator?
The correct answer is D. storing backup copies of data. A database administrator (DBA) is responsible for the availability, security, and recoverability of databases, with backup and restore being a core DBA duty.
Question
Options
- Aapplying data cleaning routines
- Bcreating data visualizations
- Cmanaging data integration processes
- Dstoring backup copies of data
How the community answered
(20 responses)- A5% (1)
- D95% (19)
Why each option
A database administrator (DBA) is responsible for the availability, security, and recoverability of databases, with backup and restore being a core DBA duty.
Applying data cleaning routines is the responsibility of a data engineer or data analyst who prepares data for analysis, not a core DBA function.
Creating data visualizations is the role of a data analyst or BI developer using tools such as Power BI or Tableau.
Managing data integration processes (ETL/ELT pipelines) is the responsibility of a data engineer, not a database administrator.
Storing and managing backup copies of data is a fundamental DBA responsibility; DBAs implement backup schedules, verify backup integrity, and perform restores to ensure data can be recovered after failure or corruption.
Concept tested: Database administrator role and responsibilities
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases
Topics
Community Discussion
No community discussion yet for this question.