A Company Is Using Amazon Aurora PostgreSQL for the Backend

question 109

Multiple Choice

A company is using Amazon Aurora PostgreSQL for the backend of its application. The system users are complaining that the responses are slow. A database specialist has determined that the queries to Aurora take longer during peak times. With the Amazon RDS Performance Insights dashboard, the load in the chart for average active sessions is often above the line that denotes maximum CPU usage and the wait state shows that most wait events are IO:XactSync. What should the company do to resolve these performance issues?

• A) Add an Aurora Replica to scale the read traffic.
• B) Scale up the DB instance class.
• C) Modify applications to commit transactions in batches.
• D) Modify applications to avoid conflicts by taking locks.

Calculate total vehicle life cycle cost for fleet management.

Identify applications and non-applications of sustainability in business practices.

Recognize the components of the ISO14000 environmental management standards.

Understand the 4 R's of environmental sustainability (Reduce, Reuse, Recycle, Reputation).

---

Definitions:

Painted Pottery

Ceramic vessels that are decorated with painted designs, common in various ancient and historical cultures around the world.

Stele of Hammurabi

An ancient Babylonian monument bearing the law code of King Hammurabi, one of the earliest and most complete written legal codes.

Divinity

A quality of being divine or godlike, often associated with gods, deities, or the sacred.

Ishtar Gate

The elaborate entrance gate to the ancient city of Babylon, constructed in about 575 BCE by order of King Nebuchadnezzar II, dedicated to the goddess Ishtar and known for its blue glazed tiles and depictions of dragons and bulls.