What is the cause of this error and what should the Database Specialist do to resolve this issue?

A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:

ERROR: cloud not write block 7507718 of temporary file: No space left on device

What is the cause of this error and what should the Database Specialist do to resolve this issue?
A . The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to modify the workload to load the data slowly.
B . The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to enable Aurora storage scaling.
C . The local storage used to store temporary tables is full. The Database Specialist needs to scale up the instance.
D . The local storage used to store temporary tables is full. The Database Specialist needs to enable local storage scaling.

View Answer

Answer: C

Explanation:

Reference: https://serverfault.com/