AWS Certified Database – Specialty — Question 145

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?

Answer options

• 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.

Correct answer: C

Explanation

The error indicates that the temporary storage is insufficient to handle the current operations, which is why the correct answer is C. Options A and B relate to Aurora storage scaling, which is not the issue here. Option D suggests enabling local storage scaling, but the only solution that addresses the full storage problem is to scale up the instance itself.