The Database Administration Team Has Asked You to Help Them

question 23

Multiple Choice

The database administration team has asked you to help them improve the performance of their new database server running on Google Compute Engine. The database is for importing and normalizing their performance statistics and is built with MySQL running on Debian Linux. They have an n1-standard-8 virtual machine with 80 GB of SSD persistent disk. What should they change to get better performance from this system?

• A) Increase the virtual machine's memory to 64 GB
• B) Create a new virtual machine running PostgreSQL
• C) Dynamically resize the SSD persistent disk to 500 GB
• D) Migrate their performance metrics warehouse to BigQuery
• E) Modify all of their batch jobs to use bulk inserts into the database

---

Definitions:

Manager

An individual responsible for directing and overseeing the work of a group of people in an organization, making decisions, planning, and implementing strategies to achieve goals.

Severity Error

A bias in performance appraisal where the evaluator tends to judge all employees as performing at the same level, usually at an extreme of performance.

Daily Sales Targets

Specific sales performance goals set for a sales team or individual salesperson to achieve within a single day.

Subordinates

Employees who are lower in rank or position and report to supervisors or managers within an organizational hierarchy.