A Database Specialist Is Performing a Proof of Concept with Amazon

question 128

Multiple Choice

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.

---

Definitions:

Megacities

Urban areas that exceed populations of ten million people, often facing unique challenges related to infrastructure, population density, and environmental impact.

Urban Populations

The segment of a population residing in cities and towns, as opposed to rural areas.

Resources Consumption

The act of using natural resources to satisfy human needs and wants, often resulting in depletion of those resources.

Sustainable Living

Practices that reduce one’s environmental impact by living in a way that can be maintained over the long term without depleting resources or causing harm.