Amazon DBS-C01 Exam Dumps

A company hosts a 2 TB Oracle database in its on-premises data center. A database specialist is migrating the database from on premises to an Amazon Aurora PostgreSQL database on AWS.

The database specialist identifies a problem that relates to compatibility Oracle stores metadata in its data dictionary in uppercase, but PostgreSQL stores the metadata in lowercase. The database specialist must resolve this problem to

complete the migration.

What is the MOST operationally efficient solution that meets these requirements?

A. Override the default uppercase format of Oracle schema by encasing object names in quotation marks during creation.

B. Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convert-lowercase.

C. Use the AWS Schema Conversion Tool conversion agent to convert the metadata from uppercase to lowercase.

D. Use an AWS Glue job that is attached to an AWS Database Migration Service (AWS DMS) replication task to convert the metadata from uppercase to lowercase.

The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real- time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.

Which approach will meet these requirements?

A. Use pg_audit to generate audit logs and send the logs to the Security team.

B. Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.

C. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.

D. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.

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 global secondary index on Invoice ID to the existing table.

B. Add a local secondary index on Invoice ID to the existing table.

C. Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.

D. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.