A Database Specialist is constructing a new Amazon Neptune DB cluster and tries to load data from Amazon S3 using the Neptune bulk loader API. The Database Specialist is confronted with the following error message:
Unable to establish a connection to the s3 endpoint. The source URL is s3:/mybucket/graphdata/ and the region code is us-east-1. Kindly confirm your Configuration S3.
Which of the following activities should the Database Specialist take to resolve the issue? (Select two.)

• A.Check that Amazon S3 has an IAM role granting read access to Neptune
• B.Check that an Amazon S3 VPC endpoint exists
• C.Check that a Neptune VPC endpoint exists
• D.Check that Amazon EC2 has an IAM role granting read access to Amazon S3
• E.Check that Neptune has an IAM role granting read access to Amazon S3

Comment: *

Name: *

Email: *

Verification: *

Amazon Aurora MySQL is being used by an ecommerce business to migrate its main application database. The firm is now doing OLTP stress testing using concurrent database connections. A database professional detected sluggish performance for several particular write operations during the first round of testing.
Examining the Amazon CloudWatch stats for the Aurora DB cluster revealed a CPU usage of 90%.
Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively? (Select two.)

• A.Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.
• B.Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I/O.
• C.Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.
• D.Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.
• E.Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.

Comment: *

Name: *

Email: *

Verification: *

An ecommerce company is running Amazon RDS for Microsoft SQL Server. The company is planning to perform testing in a development environment with production data. The development environment and the production environment are in separate AWS accounts. Both environments use AWS Key Management Service (AWS KMS) encrypted databases with both manual and automated snapshots. A database specialist needs to share a KMS encrypted production RDS snapshot with the development account.
Which combination of steps should the database specialist take to meet these requirements? (Select THREE.)

• A.Create an automated snapshot. Share the snapshot from the production account to the development account.
• B.Create a manual snapshot. Share the snapshot from the production account to the development account.
• C.Share the snapshot that is encrypted by using the development account default KMS encryption key.
• D.Share the snapshot that is encrypted by using the production account custom KMS encryption key.
• E.Allow the development account to access the production account KMS encryption key.
• F.Allow the production account to access the development account KMS encryption key.

Comment: *

Name: *

Email: *

Verification: *

A finance company migrated its 3 on-premises PostgreSQL database to an Amazon Aurora PostgreSQL DB cluster. During a review after the migration, a database specialist discovers that the database is not encrypted at rest. The database must be encrypted at rest as soon as possible to meet security requirements. The database specialist must enable encryption for the DB cluster with minimal downtime.
Which solution will meet these requirements?

• A.Modify the unencrypted DB cluster using the AWS Management Console. Enable encryption and choose to apply the change immediately.
• B.Take a snapshot of the unencrypted DB cluster and restore it to a new DB cluster with encryption enabled. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.
• C.Create an encrypted Aurora Replica of the unencrypted DB cluster. Promote the Aurora Replica as the new master.
• D.Create a new DB cluster with encryption enabled and use the pg_dump and pg_restore utilities to load data to the new DB cluster. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.

Comment: *

Name: *

Email: *

Verification: *

A Database Specialist is working with a company to launch a new website built on Amazon Aurora with several Aurora Replicas. This new website will replace an on-premises website connected to a legacy relational database. Due to stability issues in the legacy database, the company would like to test the resiliency of Aurora.
Which action can the Database Specialist take to test the resiliency of the Aurora DB cluster?

• A.Stop the DB cluster and analyze how the website responds
• B.Remove the DB cluster endpoint to simulate a master DB instance failure
• C.Use Aurora Backtrack to crash the DB cluster
• D.Use Aurora fault injection to crash the master DB instance

Comment: *

Name: *

Email: *

Verification: *