Which solution meets these requirements?

A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed. This solution also needs to handle...

November 19, 2023 No Comments READ MORE +

Which approach will meet these requirements?

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...

November 19, 2023 No Comments READ MORE +

What should the database specialist do to connect to the new, restored Amazon DocumentDB cluster?

A company’s database specialist disabled TLS on an Amazon DocumentDB cluster to perform benchmarking tests. A few days after this change was implemented, a database specialist trainee accidentally deleted multiple tables. The database specialist restored the database from available snapshots. An hour after restoring the cluster, the database specialist is...

November 19, 2023 No Comments READ MORE +

Which of the following will resolve this issue?

A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests...

November 19, 2023 No Comments READ MORE +

Which should the database specialist do to allow the database team to create the test tables?

A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica. The DB instance and the read replica are assigned to the default parameter group. The database team currently runs test queries against a read replica. The database team wants to create additional tables...

November 19, 2023 No Comments READ MORE +

Which action can the Database Specialist take to test the resiliency of the Aurora DB cluster?

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...

November 19, 2023 No Comments READ MORE +

To prepare the new table with identical settings, which steps should be performed?

A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table. To prepare the new table with identical settings,...

November 18, 2023 No Comments READ MORE +

Which combination of steps does the Database Specialist need to take to meet these new requirements?

A media company is using Amazon RDS for PostgreSQL to store user data. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well- Architected Framework review, a Database Specialist was given new security requirements. Only certain on-premises...

November 18, 2023 No Comments READ MORE +

How can the Database Specialists accomplish this?

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 . Enable...

November 18, 2023 No Comments READ MORE +

What is the likely cause of this problem?

After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect to the restored RDS DB instance. What is the likely cause of this problem?A . The restored DB instance does not have Enhanced Monitoring enabledB . The production DB instance is using a custom...

November 18, 2023 No Comments READ MORE +