AWS Certified Database Specialty-(DBS-C01)
The AWS Certified Database Specialty-(DBS-C01) were last updated on today.
- Viewing page 3 out of 68 pages.
- Viewing questions 11-15 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
A pharmaceutical company uses Amazon Quantum Ledger Database (Amazon QLDB) to store its clinical trial data records. The company has an application that runs as AWS Lambda functions. The application is hosted in the private subnet in a VPC. The application does not have internet access and needs to read some of the clinical data records. The company is concerned that traffic between the QLDB ledger and the VPC could leave the AWS network. The company needs to secure access to the QLDB ledger and allow the VPC traffic to have read-only access. Which security strategy should a database specialist implement to meet these requirements?
- A Move the QLDB ledger into a private database subnet inside the VPC. Run the Lambda functions inside the same VPC in an application private subnet. Ensure that the VPC route table allows read-only flow from the application subnet to the database subnet.
- B Create an AWS PrivateLink VPC endpoint for the QLDB ledger. Attach a VPC policy to the VPC endpoint to allow read-only traffic for the Lambda functions that run inside the VPC.
- C Add a security group to the QLDB ledger to allow access from the private subnets inside the VPC where the Lambda functions that access the QLDB ledger are running.
- D Create a VPN connection to ensure pairing of the private subnet where the Lambda functions are running with the private subnet where the QLDB ledger is deployed.
NOTE:
A company is using an Amazon Aurora MySQL database with Performance Insights enabled. A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦` Which action will resolve this alert message?
- A Truncate the events_statements_summary_by_digest table.
- B Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.
- C Set the value for the performance_schema parameter in the parameter group to 1.
- D Disable and reenable Performance Insights to be effective in the next maintenance window.
NOTE: Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/ USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.MySQL.html
A company has deployed an application that uses an Amazon RDS for MySQL DB cluster. The DB cluster uses three read replicas. The primary DB instance is an 8XL-sized instance, and the read replicas are each XL-sized instances. Users report that database queries are returning stale data. The replication lag indicates that the replicas are 5 minutes behind the primary DB instance. Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary. Which changes will reduce the lag? (Choose two.)
- A Deploy two additional read replicas matching the existing replica DB instance size.
- B Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas.
- C Move the read replicas to the same Availability Zone as the primary DB instance.
- D Increase the instance size of the primary DB instance within the same instance class.
- E Increase the instance size of the read replicas to the same size and class as the primary DB instance.
NOTE:
A company has an ecommerce website that runs on AWS. The website uses an Amazon RDS for MySQL database. A database specialist wants to enforce the use of temporary credentials to access the database. Which solution will meet this requirement?
- A Use MySQL native database authentication.
- B Use AWS Secrets Manager to rotate the credentials.
- C Use AWS Identity and Access Management (IAM) database authentication.
- D Use AWS Systems Manager Parameter Store for authentication.
NOTE: Reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.html
An application reads and writes data to an Amazon RDS for MySQL DB instance. A new reporting dashboard needs read-only access to the database. When the application and reports are both under heavy load, the database experiences performance degradation. A database specialist needs to improve the database performance. What should the database specialist do to meet these requirements?
- A Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.
- B Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.
- C Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.
- D Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.
NOTE: Reference: https://www.nops.io/enable-multi-az-for-rds-instances/
