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

Comment: *

Name: *

Email: *

Verification: *

A startup company is building a new application to allow users to visualize their on-premises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. The application should be able to identify:
The networks and routes affected if a particular component fails.
The networks that have redundant routes between them.
The networks that do not have redundant routes between them.
The fastest path between two networks.
Which database engine meets these requirements?

• A.Amazon Aurora MySQL
• B.Amazon Neptune
• C.Amazon ElastiCache for Redis
• D.Amazon DynamoDB

Comment: *

Name: *

Email: *

Verification: *

A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-of-concept project. A database specialist has configured automated database snapshots. As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created.
Which of the following are possible reasons why the snapshot was not created? (Choose two.)

• A.A copy of the RDS automated snapshot for this DB instance is in progress within the same AWS Region.
• B.A copy of the RDS automated snapshot for this DB instance is in progress in a different AWS Region.
• C.The RDS maintenance window is not configured.
• D.The RDS DB instance is in the STORAGE_FULL state.
• E.RDS event notifications have not been enabled.

Comment: *

Name: *

Email: *

Verification: *

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 a fluctuating number incoming queries. Storage costs for the 100 TB of data must be kept low.
Which solution meets these requirements?

• A.Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.
• B.Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storage. Provision enough instances to support high demand.
• C.Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize.
  https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html
  "With the Concurrency Scaling feature, you can support virtually unlimited concurrent users and concurrent queries, with consistently fast query performance. When concurrency scaling is enabled, Amazon Redshift automatically adds additional cluster capacity when you need it to process an increase in concurrent read queries. Write operations continue as normal on your main cluster. Users always see the most current data, whether the queries run on the main cluster or on a concurrency scaling cluster. You're charged for concurrency scaling clusters only for the time they're in use. For more information about pricing, see Amazon Redshift pricing. You manage which queries are sent to the concurrency scaling cluster by configuring WLM queues. When you enable concurrency scaling for a queue, eligible queries are sent to the concurrency scaling cluster instead of waiting in line."
• D.Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Provision enough instances to support high demand.

Comment: *

Name: *

Email: *

Verification: *

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. The company recently conducted tests on the database after business hours, and the tests generated additional database logs. As a result, free storage of the DB instance is low and is expected to be exhausted in 2 days.
The company wants to recover the free storage that the additional logs consumed. The solution must not result in downtime for the database.
Which solution will meet these requirements?

• A.Modify the rds.log_retention_period parameter to 0. Reboot the DB instance to save the changes.
• B.Modify the rds.log_retention_period parameter to 1440. Wait up to 24 hours for database logs to be deleted.
• C.Modify the temp file_limit parameter to a smaller value to reclaim space on the DB instance.
• D.Modify the rds.log_retention_period parameter to 1440. Reboot the DB instance to save the changes.

Comment: *

Name: *

Email: *

Verification: *