Course1-M3

Question 1

Some of the best practices for database optimization?

Ref

Answer 1

• Capacity planning
• Database design activities such as indexing, partitioning, and normalization

Database partitioning is a process whereby very large tables are divided into smaller, individual tables. Queries run faster because they’re accessing a smaller part of the data. Partitioning also improves data manageability.

Question 2

What’s capacity planning in database optimization?

Ref

Answer 2

Capacity planning includes the process of determining the optimal hardware and software resources required for performance, even as the load on the system continues to fluctuate on a day-to-day basis. Capacity planning also factors in future growth requirements.

Question 3

What’s the purpose of database indexing?

Ref

Answer 3

Database indexing helps to quickly locate data without searching each row in a database. It minimizes the number of times a disk needs to be accessed when a query is processed.

Question 4

What’s Database normalization?

Ref

Answer 4

Database normalization is a design technique to reduce inconsistencies arising out of data redundancy and anomalies arising out of update, delete, and insert operations on databases.
This impacts the efficiency and speed of querying, cleansing, and analyzing operations.