DP-900 Question #304: Real Exam Question with Answer & Explanation

Question

What is the responsibility of a database administrator?

Options

• Aapplying data cleaning routines
• Bcreating data visualizations
• Cmanaging data integration processes
• Dstoring backup copies of data

Explanation

A database administrator (DBA) is responsible for the availability, security, and recoverability of databases, with backup and restore being a core DBA duty.

Common mistakes.

• A. Applying data cleaning routines is the responsibility of a data engineer or data analyst who prepares data for analysis, not a core DBA function.
• B. Creating data visualizations is the role of a data analyst or BI developer using tools such as Power BI or Tableau.
• C. Managing data integration processes (ETL/ELT pipelines) is the responsibility of a data engineer, not a database administrator.

Concept tested. Database administrator role and responsibilities

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases

No community discussion yet for this question.