ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 1 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 1
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306. The company's Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging a `could not connect to server: Connection times out` error message to Amazon CloudWatch Logs.
What is the cause of this error?

  • A. The user name and password the application is using are incorrect.
  • B. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
  • C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
  • D. The user name and password are correct, but the user is not authorized to use the DB instance.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by activeprep1 at July 9, 2020, 3:14 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
aws4myself
Highly Voted 3 years, 5 months ago
Correct Answer: C
upvoted 7 times
...
storm0710
Most Recent 1 year ago
B. Since requirement is of handling random activity peaks
upvoted 1 times
...
Pranava_GCP
1 year, 8 months ago
Selected Answer: C
C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
upvoted 1 times
...
haison8x
1 year, 11 months ago
I got this question in the exam: an aurora cluster has some replica in current region and other regions the admin accidentally delete primary cluster. a. all replica are promoted to standalone b. all replica in other regions are promoted c. only replica in current region are promoted d. dont remember
upvoted 2 times
Kodoma
1 year, 11 months ago
Do you know what the correct answer was?
upvoted 1 times
...
chikorita
1 year, 7 months ago
please try to remember option D
upvoted 1 times
...
...
novice_expert
3 years ago
Selected Answer: C
DB needs to allow inbound
upvoted 2 times
...
megadba
3 years ago
Selected Answer: C
Correct Answer: C
upvoted 2 times
...
guru_ji
3 years, 5 months ago
Anyone passed "AWS Certified Database - Specialty" exam recently, could you please share your experience of actual exam?? How many Questions were came from examtopics Q set of 145 in real exam? Your comments will be highly appreciated.. Thanks..
upvoted 1 times
guru_ji
3 years, 5 months ago
I gave exam today. Only 40 questions came from here out of 65.
upvoted 2 times
lihze
3 years, 5 months ago
Guru - 40 questions from out of 112 or 149? I can able to access only 112. Can you possible to share the dump if you have 149 questions.
upvoted 2 times
...
...
...
aws4myself
3 years, 5 months ago
Basically, it is a connection timeout error, so A, D can be deleted. B is wrong, because if it has a problem in SG rules, it should affect at outbound not inbound, Hence C is correct, which is the inbound rule for DB instance SG.
upvoted 1 times
guru_ji
3 years, 5 months ago
Are you planning for exam? We can share study material, it would be beneficial for both. You can email me on "awsdbguru at gmail"
upvoted 1 times
...
...
guru_ji
3 years, 5 months ago
Answer is C Anyone preparing for DB Speciality and want to do group study with us, comment below with email
upvoted 1 times
...
anandbabu
3 years, 5 months ago
its C for me
upvoted 2 times
...
guru_ji
3 years, 5 months ago
C ==>> Correct Answer.
upvoted 1 times
...
Dr_Kiko
3 years, 5 months ago
It's C. I actually had to configure SG on my MYSQL instance to allow me connect from home PC with a SQL client :)
upvoted 1 times
...
db_interest
3 years, 6 months ago
A company has an application that uses an Amazon DynamoDB table to store user dat a. Every morning, a single-threaded process calls the DynamoDB API Scan operation to scan the entire table and generate a critical start-of-day report for management. A successful marketing campaign recently doubled the number of items in the table, and now the process takes too long to run and the report is not generated in time. A database specialist needs to improve the performance of the process. The database specialist notes that, when the process is running, 15% of the table’s provisioned read capacity units (RCUs) are being used. What should the database specialist do? A. Enable auto scaling for the DynamoDB table. B. Use four threads and parallel DynamoDB API Scan operations. C. Double the table’s provisioned RCUs. D. Set the Limit and Offset parameters before every call to the API.
upvoted 1 times
Zhongkai
3 years, 6 months ago
Looks like B
upvoted 1 times
db_interest
3 years, 6 months ago
Yep, B looks right. Since autoscaling would increase the WCU/RCU which is not needed.
upvoted 1 times
...
...
...
db_interest
3 years, 6 months ago
A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company’s migration to AWS. Which MySQL database option would meet these requirements? A. Amazon RDS for MySQL with Multi-AZ B. Amazon Aurora Serverless MySQL cluster C. Amazon Aurora MySQL cluster D. Amazon RDS for MySQL with read replica
upvoted 1 times
Zhongkai
3 years, 6 months ago
random activity peaks -> Aurora Serverless -> B
upvoted 2 times
...
ch321
3 years, 4 months ago
Should be B
upvoted 1 times
...
...
agrawalachin
3 years, 6 months ago
A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company’s migration to AWS. Which MySQL database option would meet these requirements? A. Amazon RDS for MySQL with Multi-AZ B. Amazon Aurora Serverless MySQL cluster C. Amazon Aurora MySQL cluster D. Amazon RDS for MySQL with read replica
upvoted 1 times
...
agrawalachin
3 years, 6 months ago
A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues. A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created. The database specialist must effectively apply this new partition key to all existing and new data. How can this solution be implemented? A. Use Amazon EMR to export the data from the current DynamoDB table to Amazon S3. Then use Amazon EMR again to import the data from Amazon S3 into a new DynamoDB table with the new partition key. B. Use AWS DMS to copy the data from the current DynamoDB table to Amazon S3. Then import the DynamoDB table to create a new DynamoDB table with the new partition key. C. Use the AWS CLI to update the DynamoDB table and modify the partition key. D. Use the AWS CLI to back up the DynamoDB table. Then use the restore-table-from-backup command and modify the partition key.
upvoted 1 times
db_interest
3 years, 6 months ago
B. Since requirement is of handling random activity peaks
upvoted 1 times
db_interest
3 years, 6 months ago
Ignore the above answer. It's for another question :)
upvoted 1 times
...
...
Zhongkai
3 years, 6 months ago
DDB cannot change Partition key of a table -> C/D wrong. DMS cannot choose DDB as source -> B wrong. So A should be the correct one although it appears to need a lot of efforts.
upvoted 4 times
...
...
LMax
3 years, 6 months ago
It's C
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago