Amazon AWS Certified Database - Specialty
Prev

There are 231 results

Next
#211 (Accuracy: 100% / 5 votes)
A company's applications store data in Amazon Aurora MySQL DB clusters. The company has separate AWS accounts for its production, test, and development environments. To test new functionality in the test environment, the company's development team requires a copy of the production database four times a day.
Which solution meets this requirement with the MOST operational efficiency?
  • A. Take a manual snapshot in the production account. Share the snapshot with the test account. Restore the database from the snapshot.
  • B. Take a manual snapshot in the production account. Export the snapshot to Amazon S3. Copy the snapshot to an S3 bucket in the test account. Restore the database from the snapshot.
  • C. Share the Aurora DB cluster with the test account. Create a snapshot of the production database in the test account. Restore the database from the snapshot.
  • D. Share the Aurora DB cluster with the test account. Create a clone of the production database in the test account.
#212 (Accuracy: 100% / 2 votes)
A database specialist needs to enable IAM authentication on an existing Amazon Aurora PostgreSQL DB cluster. The database specialist already has modified the DB cluster settings, has created IAM and database credentials, and has distributed the credentials to the appropriate users.

What should the database specialist do next to establish the credentials for the users to use to log in to the DB cluster?
  • A. Add the users' IAM credentials to the Aurora cluster parameter group.
  • B. Run the generate-db-auth-token command with the user names to generate a temporary password for the users.
  • C. Add the users' IAM credentials to the default credential profile, Use the AWS Management Console to access the DB cluster.
  • D. Use an AWS Security Token Service (AWS STS) token by sending the IAM access key and secret key as headers to the DB cluster API endpoint.
#213 (Accuracy: 100% / 3 votes)
A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer. The EC2 instances use the security group named sg-application-servers. The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance. The DB instance is deployed in a private DB subnet.
What is the MOST restrictive configuration for the DB instance security group?
  • A. Only allow incoming traffic from the sg-application-servers security group on port 3306.
  • B. Only allow incoming traffic from the sg-application-servers security group on port 443.
  • C. Only allow incoming traffic from the subnet of the application servers on port 3306.
  • D. Only allow incoming traffic from the subnet of the application servers on port 443.
#214 (Accuracy: 100% / 4 votes)
A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle the anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)
  • A. Amazon DynamoDB
  • B. Amazon Redshift
  • C. Amazon Neptune
  • D. Amazon Elasticsearch Service
  • E. Amazon ElastiCache
#215 (Accuracy: 100% / 3 votes)
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 with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?
  • A. Edit the my.cnf file for the DB cluster to increase max_connections
  • B. Increase the instance size of the DB cluster
  • C. Change the DB cluster to Multi-AZ
  • D. Increase the number of Aurora Replicas
#216 (Accuracy: 100% / 7 votes)
A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when survey responses are being collected, a Database
Specialist sees the ProvisionedThroughputExceededException error.
What can the Database Specialist do to resolve this error? (Choose two.)
  • A. Change the table to use Amazon DynamoDB Streams
  • B. Purchase DynamoDB reserved capacity in the affected Region
  • C. Increase the write capacity units for the specific table
  • D. Change the table capacity mode to on-demand
  • E. Change the table type to throughput optimized
#217 (Accuracy: 100% / 3 votes)
A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A
Database Specialist needs to control the access privileges at the table level.
How can the Database Specialist meet these requirements?
  • A. Use AWS IAM database authentication and restrict access to the tables using an IAM policy.
  • B. Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.
  • C. Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
  • D. Define access privileges to the tables containing sensitive data in the pg_hba.conf file.
#218 (Accuracy: 100% / 3 votes)
A database specialist deployed an Amazon RDS DB instance in Dev-VPC1 used by their development team. Dev-VPC1 has a peering connection with Dev-VPC2 that belongs to a different development team in the same department. The networking team confirmed that the routing between VPCs is correct; however, the database engineers in Dev-VPC2 are getting a timeout connections error when trying to connect to the database in Dev-VPC1.
What is likely causing the timeouts?
  • A. The database is deployed in a VPC that is in a different Region.
  • B. The database is deployed in a VPC that is in a different Availability Zone.
  • C. The database is deployed with misconfigured security groups.
  • D. The database is deployed with the wrong client connect timeout configuration.
#219 (Accuracy: 93% / 7 votes)
A database specialist at a large multi-national financial company is in charge of designing the disaster recovery strategy for a highly available application that is in development. The application uses an Amazon DynamoDB table as its data store. The application requires a recovery time objective (RTO) of 1 minute and a recovery point objective (RPO) of 2 minutes.
Which operationally efficient disaster recovery strategy should the database specialist recommend for the DynamoDB table?
  • A. Create a DynamoDB stream that is processed by an AWS Lambda function that copies the data to a DynamoDB table in another Region.
  • B. Use a DynamoDB global table replica in another Region. Enable point-in-time recovery for both tables.
  • C. Use a DynamoDB Accelerator table in another Region. Enable point-in-time recovery for the table.
  • D. Create an AWS Backup plan and assign the DynamoDB table as a resource.
#220 (Accuracy: 100% / 3 votes)
A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.
Which solution meets these requirements?
  • A. Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cache application data from the replica to generate the dashboards.
  • B. Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1 Region. Use Amazon QuickSight for displaying dashboard results.
  • C. Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
  • D. Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.