A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in CPU utilization was not determined using the standard metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A Database Specialist needs to determine what caused the CPU spike.
Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)

• A.Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
• B.Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
• C.Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
• D.Use Amazon QuickSight to view the SQL statement being run.
• E.Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQL statements, hosts, or users.

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.

Comment: *

Name: *

Email: *

Verification: *

A company has a on-premises Oracle Real Application Clusters (RAC) database. The company wants to migrate the database to AWS and reduce licensing costs. The company's application team wants to store JSON payloads that expire after 28 hours. The company has development capacity if code changes are required.
Which solution meets these requirements?

• A.Use Amazon RDS for Oracle with Multi-AZ. Create an AWS Lambda function to purge the expired data. Schedule the Lambda function to run daily using Amazon EventBridge.
• B.Use Amazon DynamoDB and leverage the Time to Live (TTL) feature to automatically expire the data.
• C.Use Amazon DocumentDB with a read replica in a different Availability Zone. Use DocumentDB change streams to expire the data.
• D.Use Amazon Aurora PostgreSQL with Multi-AZ and leverage the Time to Live (TTL) feature to automatically expire the data.

Comment: *

Name: *

Email: *

Verification: *

A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.
What is the MOST likely reason that the items are not being deleted?

• A.The TTL attribute's value is set as a Number data type.
• B.The TTL attribute's value is set as a Binary data type.
• C.The TTL attribute's value is a timestamp in the Unix epoch time format in seconds.
• D.The TTL attribute's value is set with an expiration of 1 year.

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: *