exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 231 discussion

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

An ecommerce company is running AWS Database Migration Service (AWS DMS) to replicate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The company has set up an AWS Direct Connect connection from its on-premises data center to AWS. During the migration, the company's security team receives an alarm that is related to the migration. The security team mandates that the DMS replication instance must not be accessible from public
IP addresses.
What should a database specialist do to meet this requirement?

  • A. Set up a VPN connection to encrypt the traffic over the Direct Connect connection.
  • B. Modify the DMS replication instance by disabling the publicly accessible option.
  • C. Delete the DMS replication instance. Recreate the DMS replication instance with the publicly accessible option disabled.
  • D. Create a new replication VPC subnet group with private subnets. Modify the DMS replication instance by selecting the newly created VPC subnet group.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
backbencher2022
Highly Voted 2 years, 1 month ago
Selected Answer: C
Option C is correct. Option D has a slight caveat. While, you could create a new DMS subnet group (within DMS console) with private subnets however, you can't attach this newly subnet group to an existing DMS instance. This isn't supported and I have tested that in AWS console. What this note (https://repost.aws/knowledge-center/dms-disable-public-access) is describing is slightly different than some of us are interpreting and choosing option D. As per this note, you could remove the public subnets and choose only the private subnets of an EXISTING SUBNET Group and I've tried this. I modified the existing subnet group of an existing DMS instance. I removed all public subnets and chose only 2 private subnets. This worked however, option D is not talking about modifying an existing subnet group. It is saying that we should create a new subnet group and associate that with existing DMS instance which I've already mentioned above is an unsupported option at this moment. Therefore option D is incorrect.
upvoted 10 times
...
Stteve
Highly Voted 2 years, 7 months ago
D is most easy way to fix the issue. https://aws.amazon.com/premiumsupport/knowledge-center/dms-disable-public-access/ To disable public access to your replication instance, delete the replication instance and then recreate it. Before you can delete a replication instance, you must delete all the tasks that use the replication instance. Instead of recreating the replication instance, you can change the subnets that are in the subnet group that is associated with the replication instance to private subnets.
upvoted 9 times
...
tsangckl
Most Recent 1 year, 1 month ago
Selected Answer: D
I vote D
upvoted 1 times
...
missipssamarsh
1 year, 4 months ago
Selected Answer: C
it's C https://repost.aws/knowledge-center/dms-disable-public-access
upvoted 1 times
...
aviathor
1 year, 12 months ago
Selected Answer: D
Changing the instance from Public to Private would require deleting all the taskj, delete the replication instance, recreate the instance, recreate the tasks... From the Knowledge Center: "Instead of recreating the replication instance, you can change the subnets that are in the subnet group that is associated with the replication instance to private subnets."
upvoted 1 times
...
sk1974
2 years, 2 months ago
https://aws.amazon.com/premiumsupport/knowledge-center/dms-disable-public-access/ - C is the answer
upvoted 1 times
...
guau
2 years, 3 months ago
Selected Answer: D
I would try D, and looking the comments shouldn't be any problem.
upvoted 1 times
...
lollyj
2 years, 4 months ago
Selected Answer: D
The question is confusing because it says that the "replication instance must not be accessible from public" which means it should be in a private subnet group which also means that the instance must be dropped and re-created in the private subnet group but the option doesn't say to re-create the instance. IP addresses.
upvoted 1 times
...
ftrimmer
2 years, 4 months ago
Answer is D: Instead of recreating the replication instance, you can change the subnets that are in the subnet group that is associated with the replication instance to private subnets. A private subnet is a subnet that isn't routed to an internet gateway. Instances in a private subnet can't communicate with a public IP address, even if they have a public IP address. For more information, see Setting up a network for a replication instance. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html
upvoted 2 times
...
tucobbad
2 years, 4 months ago
Selected Answer: D
D as it is indeed possible to change subnet group to private according to https://aws.amazon.com/premiumsupport/knowledge-center/dms-disable-public-access Actually, C and D are correct, but D could be easier
upvoted 1 times
...
Sab
2 years, 5 months ago
C. D is wrong . We cannot modify DMS instance to assign a new subnet group with private subnets .
upvoted 1 times
tucobbad
2 years, 4 months ago
https://aws.amazon.com/premiumsupport/knowledge-center/dms-disable-public-access/ says: "Instead of recreating the replication instance, you can change the subnets that are in the subnet group that is associated with the replication instance to private subnets. A private subnet is a subnet that isn't routed to an internet gateway. Instances in a private subnet can't communicate with a public IP address, even if they have a public IP address."
upvoted 3 times
...
...
awsjjj
2 years, 7 months ago
Selected Answer: C
C will ensure there will be no public access
upvoted 2 times
...
Changwha
2 years, 7 months ago
Selected Answer: C
Dx : Not create VPC subnet. Change the subnets that are in the subnet group that is associated with the replication instance to private subnets.
upvoted 2 times
...
cloudsunriser
2 years, 7 months ago
Selected Answer: D
https://aws.amazon.com/premiumsupport/knowledge-center/dms-disable-public-access/
upvoted 2 times
...
JeanGat
2 years, 7 months ago
Selected Answer: D
From link provided, obviously C or D would work. I'd vote D, as it would be an easier fix. Kind of a dumb question, as there are two legit answers.
upvoted 1 times
...
SonamDhingra
2 years, 8 months ago
Selected Answer: C
C is correct
upvoted 2 times
...
gairaj
2 years, 8 months ago
Selected Answer: C
delete and create again with new publicly accessible option. https://aws.amazon.com/premiumsupport/knowledge-center/dms-disable-public-access/
upvoted 4 times
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago