Practice Questions
Question 1
Which task is a primary responsibility of a database administrator (DBA)?
A. Creating machine learning models
B. Designing data visualizations
C. Managing database security and access
D. Writing business reports
✅ Answer: C
Explanation:
DBAs are responsible for security, access control, and permissions within databases.
Question 2
Which activity is most closely associated with database performance tuning?
A. Creating dashboards
B. Optimizing queries and indexes
C. Cleaning raw data files
D. Training AI models
✅ Answer: B
Explanation:
DBAs improve performance by analyzing queries and managing indexes.
Question 3
Who is primarily responsible for configuring database backups and ensuring data can be restored?
A. Data Analyst
B. Data Scientist
C. Database Administrator
D. Business User
✅ Answer: C
Explanation:
DBAs handle backup and recovery strategies to protect data.
Question 4
Which responsibility ensures that a database remains available during system failures?
A. Data transformation
B. High availability and disaster recovery planning
C. Data visualization
D. Schema design for analytics
✅ Answer: B
Explanation:
DBAs configure failover, replication, and disaster recovery solutions.
Question 5
A DBA creates user roles and assigns permissions to control access to data.
What area of responsibility does this represent?
A. Performance optimization
B. Data modeling
C. Security management
D. Data ingestion
✅ Answer: C
Explanation:
Managing roles and permissions is part of database security.
Question 6
Which task is typically handled by a DBA in an Azure environment?
A. Maintaining physical server hardware
B. Configuring database access and monitoring performance
C. Building dashboards in Power BI
D. Writing ETL pipelines
✅ Answer: B
Explanation:
In Azure, Microsoft manages infrastructure, while DBAs focus on configuration, performance, and access control.
Question 7
Which of the following is part of ensuring data integrity?
A. Creating visual reports
B. Defining primary and foreign keys
C. Running batch analytics queries
D. Exporting data to CSV files
✅ Answer: B
Explanation:
DBAs enforce data integrity using constraints like primary and foreign keys.
Question 8
Which task is LEAST likely to be performed by a DBA?
A. Monitoring database performance
B. Configuring backups
C. Building machine learning models
D. Managing user permissions
✅ Answer: C
Explanation:
Machine learning is typically handled by data scientists, not DBAs.
Question 9
A database experiences slow query performance. What is the DBA’s most appropriate action?
A. Create a dashboard
B. Increase data volume
C. Analyze and optimize queries or indexes
D. Delete historical data
✅ Answer: C
Explanation:
DBAs troubleshoot performance issues by optimizing queries and indexes.
Question 10
Which concept describes the division of responsibilities between Azure and the DBA?
A. Data normalization
B. Shared responsibility model
C. Data pipeline architecture
D. Schema-on-read
✅ Answer: B
Explanation:
In Azure, Microsoft manages infrastructure, while DBAs manage data, access, and performance — this is the shared responsibility model.
✅ Quick Exam Takeaways
For DP-900, remember DBAs are responsible for:
✔ Security (users, roles, permissions)
✔ Performance (query tuning, indexing)
✔ Backup & recovery
✔ High availability & disaster recovery
✔ Monitoring & troubleshooting
✔ Data integrity
And in Azure:
✔ Microsoft manages infrastructure
✔ DBAs manage configuration, access, and optimization
Go to the DP-900 Exam Prep Hub main page.
The Data Community 