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:

Dividend Policy

A company's strategy or policy in determining the size and frequency of dividend payments to shareholders.

Ex-Dividend Date

The date on which a stock begins trading without the entitlement to the declared dividend, typically set two business days before the record date.

Future Dividends

Future Dividends refer to dividend payments that a company is expected to issue to its shareholders in the future, based on its earnings and dividend policy.

Residual Dividend Policy

A residual dividend policy involves a company paying out dividends from the leftover net income after all operational and project financing needs are met.