AWS Certified Database Specialty-(DBS-C01)
The AWS Certified Database Specialty-(DBS-C01) were last updated on today.
- Viewing page 2 out of 68 pages.
- Viewing questions 6-10 out of 340 questions
- - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.and Azure
- - Trademarks, certification & product names are used for reference only and belong to Amazon.and Azure
Topic 1 - Exam A
An IT company wants to reduce its database operation costs in its development environment. The company's workflow creates an Amazon Aurora MySQL DB cluster for each development group. The DB clusters are used for only 8 hours a day. The DB clusters can be deleted at the end of a development cycle, which lasts 2 weeks. Which solution will meet these requirements MOST cost-effectively?
- A Use AWS CloudFormation templates. Deploy a stack with a DB cluster for each development group. Delete the stack at the end of each development cycle.
- B Use the Aurora cloning feature. Deploy a single development and test Aurora DB instance. Create clone instances for the development groups. Delete the clones at the end of each development cycle.
- C Use Aurora Replicas. From the primary writer instance, create read replicas for each development group. Promote each read replica to a standalone DB cluster Delete the standalone DB cluster at the end of each development cycle.
- D Use Aurora Serverless. Restore a current Aurora snapshot to an Aurora Serverless cluster for each development group. Select the option to pause the compute capacity on the cluster after a specified amount of time with no activity. Delete the Aurora Serverless cluster at the end of each development cycle.
NOTE:
A company's development team needs to have production data restored in a staging AWS account. The production database is running on an Amazon RDS for PostgreSQL Multi-AZ DB instance, which has AWS KMS encryption enabled using the default KMS key. A database specialist planned to share the most recent automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in the AWS Management Console. What should the database specialist do to resolve this?
- A Disable automated backups in the DB instance. Share both the automated snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account and enable automated backups.
- B Copy the automated snapshot specifying a custom KMS encryption key. Share both the copied snapshot and the custom KMS encryption key with the staging account. Restore the snapshot to the staging account within the same Region.
- C Modify the DB instance to use a custom KMS encryption key. Share both the automated snapshot and the custom KMS encryption key with the staging account. Restore the snapshot in the staging account.
- D Copy the automated snapshot while keeping the default KMS key. Share both the snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account.
NOTE: You then create a copy of that snapshot and specify a KMS key to encrypt that snapshot copy. You can then restore an encrypted DB instance from the encrypted snapshot. Reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CopySnapshot.html
A company is using Amazon Aurora MySQL as the database for its retail application on AWS. The company receives a notification of a pending database upgrade and wants to ensure upgrades do not occur before or during the most critical time of year. Company leadership is concerned that an Amazon RDS maintenance window will cause an outage during data ingestion. Which step can be taken to ensure that the application is not interrupted?
- A Disable weekly maintenance on the DB cluster.
- B Clone the DB cluster and migrate it to a new copy of the database.
- C Choose to defer the upgrade and then find an appropriate down time for patching.
- D Set up an Aurora Replica and promote it to primary at the time of patching.
NOTE: Reference: https://severalnines.com/database-blog/how-create-clone-your-mysql-or-postgresql-database-cluster
Application developers have reported that an application is running slower as more users are added. The application database is running on an Amazon Aurora DB cluster with an Aurora Replica. The application is written to take advantage of read scaling through reader endpoints. A database specialist looks at the performance metrics of the database and determines that, as new users were added to the database, the primary instance CPU utilization steadily increased while the Aurora Replica CPU utilization remained steady. How can the database specialist improve database performance while ensuring minimal downtime?
- A Modify the Aurora DB cluster to add more replicas until the overall load stabilizes. Then, reduce the number of replicas once the application meets service level objectives.
- B Modify the primary instance to a larger instance size that offers more CPU capacity.
- C Modify a replica to a larger instance size that has more CPU capacity. Then, promote the modified replica.
- D Restore the Aurora DB cluster to one that has an instance size with more CPU capacity. Then, swap the names of the old and new DB clusters.
NOTE: The automatic storage increase setting of a primary instance automatically applies to any read replicas of that instance. The automatic storage increase setting cannot be independently set for read replicas. Reference: https://cloud.google.com/sql/docs/postgres/instance-settings
A company wants to build a new invoicing service for its cloud-native application on AWS. The company has a small development team and wants to focus on service feature development and minimize operations and maintenance as much as possible. The company expects the service to handle billions of requests and millions of new records every day. The service feature requirements, including data access patterns are well-defined. The service has an availability target of 99.99% with a milliseconds latency requirement. The database for the service will be the system of record for invoicing data. Which database solution meets these requirements at the LOWEST cost?
- A Amazon Neptune
- B Amazon Aurora PostgreSQL Serverless
- C Amazon RDS for PostgreSQL
- D Amazon DynamoDB
NOTE: Reference: https://aws.amazon.com/neptune/
