A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries.
How should the company identify the source of the problem?

• A.Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
• B.Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
• C.Use AWS X-Ray deployed with Amazon RDS to track query system traces.
• D.Create a support request and work with AWS Support to identify the source of the issue.

Comment: *

Name: *

Email: *

Verification: *

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.
Where should the AWS DMS replication instance be placed for the MOST optimal performance?

• A.In the same Region and VPC of the source DB instance
• B.In the same Region and VPC as the target DB instance
• C.In the same VPC and Availability Zone as the target DB instance
• D.In the same VPC and Availability Zone as the source DB instance

Comment: *

Name: *

Email: *

Verification: *

A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries.
How should the company identify the source of the problem?

• A.Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
• B.Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
• C.Use AWS X-Ray deployed with Amazon RDS to track query system traces.
• D.Create a support request and work with AWS Support to identify the source of the issue.

Comment: *

Name: *

Email: *

Verification: *

An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second. The number of orders and exact schedule for the sale will vary each day. During the sale, approximately 10,000 concurrent users will look at the deals before buying items. Outside of the sale, the traffic volume is very low. The acceptable performance for read/write queries should be under 25 ms. Order items are about 2 KB in size and have a unique identifier. The company requires the most cost-effective solution that will automatically scale and is highly available.
Which solution meets these requirements?

• A.Amazon DynamoDB with on-demand capacity mode
• B.Amazon Aurora with one writer node and an Aurora Replica with the parallel query feature enabled
• C.Amazon DynamoDB with provisioned capacity mode with 5,000 write capacity units (WCUs) and 10,000 read capacity units (RCUs)
• D.Amazon Aurora with one writer node and two cross-Region Aurora Replicas

Comment: *

Name: *

Email: *

Verification: *

For the first time, a database professional is establishing a test graph database on Amazon Neptune. The database expert must input millions of rows of test observations from an Amazon S3.csv file. The database professional uploaded the data to the Neptune DB instance through a series of API calls.
Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)

• A.Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.
• B.Ensure the vertices and edges are specified in different .csv files with proper header column formatting.
• C.Use AWS DMS to move data from Amazon S3 to the Neptune Loader.
• D.Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.
• E.Ensure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.
• F.Create an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint.

Comment: *

Name: *

Email: *

Verification: *