A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost-effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

• A.Create an Amazon DocumentDB cluster
• B.Create an Amazon DynamoDB table with on-demand capacity mode
• C.Create an Amazon DynamoDB table with provisioned capacity mode
• D.Create an Amazon Aurora Serverless DB cluster

Comment: *

Name: *

Email: *

Verification: *

A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level.
How can the Database Specialist meet these requirements?

• A.Use AWS IAM database authentication and restrict access to the tables using an IAM policy.
• B.Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
• C.Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.
• D.Define access privileges to the tables containing sensitive data in the pg_hba.conf file.

Comment: *

Name: *

Email: *

Verification: *

A company is about to launch a new product, and test databases must be re-created from production dat a. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.
What should the Database Specialist do to meet these requirements?

• A.Create logical dumps of the production cluster and restore them into new test clusters
• B.Restore a snapshot from the production cluster into test clusters
• C.Use database cloning to create clones of the production cluster
• D.Add an additional read replica to the production cluster and use that node for testing

Comment: *

Name: *

Email: *

Verification: *

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.
How can the Database Specialists accomplish this?

• A.Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
• B.Enable Amazon RDS Performance Insights and review the appropriate dashboard
• C.Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
• D.Enable Enhanced Monitoring will the appropriate settings

Comment: *

Name: *

Email: *

Verification: *

A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting. These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency. System users run ad-hoc queries sporadically throughout the week. Cost is a primary concern for the company, and a solution that does not require significant rework is needed.
Which solution meets these requirements?

• A.Change the DB clusters to the burstable instance family.
• B.Upgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.
• C.Create new Aurora Serverless DB clusters for development and reporting, then migrate to these new DB clusters.
• D.Use existing DB clusters and stop/start the databases on a routine basis using scheduling tools.

Comment: *

Name: *

Email: *

Verification: *