A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The company now want to downsize storage to save money. The solution must have the least impact on production and near-zero downtime.
Which solution would meet these requirements?

• A.Create a new read replica and make it the primary by terminating the existing primary
• B.Create a new RDS DB instance with the required storage and move the databases from the old instancesto the new instance using AWS DMS
• C.Create a snapshot of the old databases and restore the snapshot with the required storage
• D.Create a new database using native backup and restore

Comment: *

Name: *

Email: *

Verification: *

A company's ecommerce website uses Amazon DynamoDB for purchase orders. Each order is made up of a Customer ID and an Order ID. The DynamoDB table uses the Customer ID as the partition key and the Order ID as the sort key.
To meet a new requirement, the company also wants the ability to query the table by using a third attribute named Invoice ID. Queries using the Invoice ID must be strongly consistent. A database specialist must provide this capability with optimal performance and minimal overhead.
What should the database administrator do to meet these requirements?

• A.Add a local secondary index on Invoice ID to the existing table.
• B.Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.
• C.Add a global secondary index on Invoice ID to the existing table.
• D.Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.

Comment: *

Name: *

Email: *

Verification: *

The Development team recently executed a database script containing several data definition language (DDL) and data manipulation language (DML) statements on an Amazon Aurora MySQL DB cluster. The release accidentally deleted thousands of rows from an important table and broke some application functionality. This was discovered 4 hours after the release. Upon investigation, a Database Specialist tracked the issue to a DELETE command in the script with an incorrect WHERE clause filtering the wrong set of rows.
The Aurora DB cluster has Backtrack enabled with an 8-hour backtrack window. The Database Administrator also took a manual snapshot of the DB cluster before the release started. The database needs to be returned to the correct state as quickly as possible to resume full application functionality. Data loss must be minimal.
How can the Database Specialist accomplish this?

• A.Quickly rewind the DB cluster to a point in time before the release using Backtrack.
• B.Restore the DB cluster using the manual backup snapshot created before the release and change the application configuration settings to point to the new DB cluster.
• C.Perform a point-in-time recovery (PITR) of the DB cluster to a time before the release and copy the deleted rows from the restored database to the original database.
• D.Create a clone of the DB cluster with Backtrack enabled. Rewind the cloned cluster to a point in time before the release. Copy deleted rows from the clone to the original database.

Comment: *

Name: *

Email: *

Verification: *

A company uses the Amazon DynamoDB table contractDB in us-east-1 for its contract system with the following schema:
orderID (primary key) timestamp (sort key) contract (map) createdBy (string) customerEmail (string) After a problem in production, the operations team has asked a database specialist to provide an IAM policy to read items from the database to debug the application. In addition, the developer is not allowed to access the value of the customerEmail field to stay compliant.
Which IAM policy should the database specialist use to achieve these requirements?
A)

B)

C)

D)

• A.Option A
• B.Option C
• C.Option B
• D.Option C

Comment: *

Name: *

Email: *

Verification: *

A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.
Which solution meets these requirements?

• A.Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replicainstance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
• B.Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1Region. Use Amazon QuickSight for displaying dashboard results.
• C.Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the apnortheast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cacheapplication data from the replica to generate the dashboards.
• D.Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replicain the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.

Comment: *

Name: *

Email: *

Verification: *