1Z0-1151-25 Question 44
Single answerYou manage an Autonomous Transaction Processing (ATP) database on Oracle Cloud Infrastructure to support an e-commerce platform experiencing sudden peaks in demand during holiday promotions. The business requires minimal downtime and no major code changes when adjusting compute resources. Which action should you take to scale the ATP instance in this scenario?
- A
Use the OCI Console to increase the available OCPUs and apply the changes immediately.
- B
Shut down the Autonomous Database for at least 30 minutes before resizing and then restart it.
- C
Edit the database parameter file to increase CPU allocations and then perform a full system reboot.
- D
Migrate the ATP instance to a different region with a higher pre-configured shape.
Show answer and explanation
Correct answer: A
Explanation
In OCI Autonomous Databases, adjusting resources like OCPUs and storage is done directly in the OCI Console and takes effect with minimal downtime. Unlike traditional databases, there is no need for extensive manual intervention, such as shutting down the DB or editing parameter files. For more details, refer to Oracle Cloud Infrastructure documentation on Autonomous Database scaling best practices.
- A. Correct.
Correct. In Autonomous Transaction Processing, you can scale OCPUs (and storage) online from the OCI Console with minimal disruption. The system automatically adjusts the database and no major downtime is necessary.
- B. Incorrect.
Incorrect. Autonomous Database doesn�t require manual shutdown for scaling. This option reflects traditional database practices but is unnecessary for ATP, leading to unnecessary downtime.
- C. Incorrect.
Incorrect. Editing database parameter files is not the recommended or necessary approach in ATP, as scaling is handled automatically through the OCI Console without directly modifying parameter files.
- D. Incorrect.
Incorrect. Migrating to another region is time-consuming and not required. ATP allows you to scale resources within the same region quickly and transparently.