Free AWS-Certified-Database-Specialty Exam Braindumps

A company is using an Amazon RDS for MySQL DB instance for its internal applications. A security audit shows that the DB instance is not encrypted at rest. The company’s application team needs to encrypt the DB instance.
What should the team do to meet this requirement?

1. A. Stop the DB instance and modify it to enable encryptio
2. B. Apply this setting immediately without waiting for the next scheduled RDS maintenance window.
3. C. Stop the DB instance and create an encrypted snapsho
4. D. Restore the encrypted snapshot to a new encrypted DB instanc
5. E. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
6. F. Stop the DB instance and create a snapsho
7. G. Copy the snapshot into another encrypted snapsho
8. H. Restore the encrypted snapshot to a new encrypted DB instanc
9. I. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
10. J. Create an encrypted read replica of the DB instanc
11. K. Promote the read replica to maste
12. L. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.

Correct Answer: C

A business need a data warehouse system that stores data consistently and in a highly organized fashion. The organization demands rapid response times for end-user inquiries including current-year data, and users must have access to the whole 15-year dataset when necessary. Additionally, this solution must be able to manage a variable volume of incoming inquiries. Costs associated with storing the 100 TB of data must be maintained to a minimum.
Which solution satisfies these criteria?

1. A. Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storag
2. B. Provision enough instances to support high demand.
3. C. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
4. D. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
5. E. Provision enough instances to support high demand.
6. F. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
7. G. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
8. H. Enable Amazon Redshift Concurrency Scaling.
9. I. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
10. J. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
11. K. Leverage Amazon Redshift elastic resize.

Correct Answer: C
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."

A ride-hailing application stores bookings in a persistent Amazon RDS for MySQL DB instance. This program is very popular, and the corporation anticipates a tenfold rise in the application's user base over the next several months. The application receives a higher volume of traffic in the morning and evening.
This application is divided into two sections:
An internal booking component that takes online reservations in response to concurrent user queries. A component of a third-party customer relationship management (CRM) system that customer service
professionals utilize. Booking data is accessed using queries in the CRM.
To manage this workload effectively, a database professional must create a cost-effective database system. Which solution satisfies these criteria?

1. A. Use Amazon ElastiCache for Redis to accept the booking
2. B. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
3. C. Use Amazon DynamoDB to accept the booking
4. D. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queu
5. E. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
6. F. Use Amazon ElastiCache for Redis to accept the booking
7. G. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
8. H. Use Amazon DynamoDB to accept the booking
9. I. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

Correct Answer: B
"AWS Lambda function to capture changes" capture changes to what? ElastiCache? The main use of ElastiCache is to cache frequently read data. Also "the company expects a tenfold increase in the user base" and "correspond to simultaneous requests from users"

A Database Specialist is constructing a new Amazon Neptune DB cluster and tries to load data from Amazon S3 using the Neptune bulk loader API. The Database Specialist is confronted with the following error message:
€Unable to establish a connection to the s3 endpoint. The source URL is s3:/mybucket/graphdata/ and the region code is us-east-1. Kindly confirm your Configuration S3.
Which of the following activities should the Database Specialist take to resolve the issue? (Select two.)

1. A. Check that Amazon S3 has an IAM role granting read access to Neptune
2. B. Check that an Amazon S3 VPC endpoint exists
3. C. Check that a Neptune VPC endpoint exists
4. D. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
5. E. Check that Neptune has an IAM role granting read access to Amazon S3

Correct Answer: BE
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-tutorial-IAM.html https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-data.html
“An IAM role for the Neptune DB instance to assume that has an IAM policy that allows access to the data files in the S3 bucket. The policy must grant Read and List permissions.” “An Amazon S3 VPC endpoint. For more information, see the Creating an Amazon S3 VPC Endpoint section.”

A large company has a variety of Amazon DB clusters. Each of these clusters has various configurations that adhere to various requirements. Depending on the team and use case, these configurations can be organized into broader categories.
A database administrator wants to make the process of storing and modifying these parameters more systematic. The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required.
Which AWS service or feature will help automate and achieve this objective?

1. A. AWS Systems Manager Parameter Store
2. B. DB parameter group
3. C. AWS Config
4. D. AWS Secrets Manager

Correct Answer: B