17.2k views
0 votes
Protecting data security, privacy, and integrity are important database functions. What activities are required in the DBA's managerial role of enforcing these functions

User ColeX
by
4.2k points

1 Answer

1 vote

Answer:

Coordinating, monitoring, and allocating database administration resources

Step-by-step explanation:

people and data. Defining goals and formulating strategic plans for the database administration function.

Separate database servers and web servers.

Use web application and database firewalls.

Secure database user access.

Regularly update your operating system and patches.

Audit and continuously monitor database activity.

Test your database security.

Encrypt data and backups.

The DBA are responsible to authorizing access the database, coordinate and monitor, and acquiring software/ hardware resources. The database designers are responsible to identify the data that to be stored in the database and choose suitable structures to store this data.

Software installation and Maintenance.

Data Extraction, Transformation, and Loading.

Specialized Data Handling.

Database Backup and Recovery.

Security.

Authentication.

Capacity Planning.

Performance Monitoring.

User ElenaT
by
4.4k points