Amazon (DBS-C01) Exam Questions And Answers page 23
A large retail company recently migrated its three-tier ecommerce applications to AWS. The company s backend database is hosted on Amazon Aurora PostgreSQL. During peak times, users complain about longer page load times. A database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events. The SQL attached to the wait events are all single INSERT statements.
How should this issue be resolved?
How should this issue be resolved?
Add a new Aurora Replica to the Aurora DB cluster.
Add an Amazon ElastiCache for Redis cluster and change the application to write through.
Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).
Database Performance Optimization and Tuning
Database High Availability and Disaster Recovery
A manufacturing company has an. inventory system that stores information in an Amazon Aurora MySQL DB cluster. The database tables are partitioned. The database size has grown to 3 TB. Users run one-time queries by using a SQL client. Queries that use an equijoin to join large tables are taking a long time to run.
Which action will improve query performance with the LEAST operational effort?
Which action will improve query performance with the LEAST operational effort?
Migrate the database to a new Amazon Redshift data warehouse.
Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on.
Take a snapshot of the DB cluster. Create a new DB instance by using the snapshot, and enable parallel query mode.
Add an Aurora read replica.
Database Performance Optimization and Tuning
A manufacturing company s website uses an Amazon Aurora PostgreSQL DB cluster.
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)
Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
Edit and enable Aurora DB cluster cache management in parameter groups.
Set TCP keepalive parameters to a high value.
Set JDBC connection string timeout variables to a low value.
Set Java DNS caching timeouts to a high value.
Database Deployment, Migration, and Management
Database High Availability and Disaster Recovery
A marketing company is using Amazon DocumentDB and requires that database audit logs be enabled. A Database Specialist needs to configure monitoring so that all data definition language (DDL) statements performed are visible to the Administrator. The Database Specialist has set the audit_logs parameter to enabled in the cluster parameter group.
What should the Database Specialist do to automatically collect the database logs for the Administrator?
What should the Database Specialist do to automatically collect the database logs for the Administrator?
Enable DocumentDB to export the logs to Amazon CloudWatch Logs
Enable DocumentDB to export the logs to AWS CloudTrail
Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs
Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operation and store the logs in Amazon S3
Database Security and Compliance
Database Monitoring and Troubleshooting
A marketing company is using Amazon DocumentDB and requires that database audit logs be enabled. A Database Specialist needs to configure monitoring so that all data definition language (DDL) statements performed are visible to the Administrator. The Database Specialist has set the audit_logs parameter to enabled in the cluster parameter group.
What should the Database Specialist do to automatically collect the database logs for the Administrator?
What should the Database Specialist do to automatically collect the database logs for the Administrator?
Enable DocumentDB to export the logs to Amazon CloudWatch Logs
Enable DocumentDB to export the logs to AWS CloudTrail
Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs
Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operation and store the logs in Amazon S3
Database Security and Compliance
Database Monitoring and Troubleshooting
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 corporate network IPs should connect to the DB instance.
• Connectivity is allowed from the corporate network only.
Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)
• Only certain on-premises corporate network IPs should connect to the DB instance.
• Connectivity is allowed from the corporate network only.
Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)
Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
Move the DB instance to a private subnet using AWS DMS.
Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
Disable the publicly accessible setting.
Connect to the DB instance using private IPs and a VPN.
Database High Availability and Disaster Recovery
Database Security and Compliance
A media company wants to use zero-downtime patching (ZDP) for its Amazon Aurora MySQL database. Multiple processing applications are using SSL certificates to connect to database endpoints and the read replicas.
Which factor will have the LEAST impact on the success of ZDP?
Which factor will have the LEAST impact on the success of ZDP?
Binary logging is enabled, or binary log replication is in progress.
Current SSL connections are open to the database.
Temporary tables or table locks are in use.
The value of the lower_case_table_names server parameter was set to 0 when the tables were created.
Database Deployment, Migration, and Management
An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to sub-second levels?
What should a Database Specialist do in this situation to increase performance and return latency to sub-second levels?
Increase the size of the DB instance storage
Change the underlying EBS storage type to General Purpose SSD (gp2)
Disable EBS optimization on the DB instance
Change the DB instance to an instance class with a higher maximum bandwidth
Database Performance Optimization and Tuning
Database High Availability and Disaster Recovery
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?
What should the database specialist do to meet these requirements?
Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.
Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.
Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.
Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.
Database Performance Optimization and Tuning
Database High Availability and Disaster Recovery
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?
What should the database specialist do to meet these requirements?
Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.
Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.
Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.
Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.
Database Performance Optimization and Tuning
Database High Availability and Disaster Recovery
Comments