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 226 discussion

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

A company hosts an on-premises Microsoft SQL Server Enterprise edition database with Transparent Data Encryption (TDE) enabled. The database is 20 TB in size and includes sparse tables. The company needs to migrate the database to Amazon RDS for SQL Server during a maintenance window that is scheduled for an upcoming weekend. Data-at-rest encryption must be enabled for the target DB instance.
Which combination of steps should the company take to migrate the database to AWS in the MOST operationally efficient manner? (Choose two.)

  • A. Use AWS Database Migration Service (AWS DMS) to migrate from the on-premises source database to the RDS for SQL Server target database.
  • B. Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.
  • C. Restore the backup to the RDS for SQL Server DB instance. Enable TDE for the RDS for SQL Server DB instance.
  • D. Set up an AWS Snowball Edge device. Copy the database backup to the device. Send the device to AWS. Restore the database from Amazon S3.
  • E. Encrypt the data with client-side encryption before transferring the data to Amazon RDS.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️
by mbar94 at Sept. 5, 2022, 9:08 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
cloudsunriser
Highly Voted 2 years, 8 months ago
Selected Answer: BC
A - DMS is out of question as it doesn't support sparse tables. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html D - D will not work as migration is scheduled for an upcoming weekend and snowball takes time for shipping. E - E will come into picture if using DMS and we can't use DMS. B and C is correct. Though as per latest updates disabling TDE is no longer required. https://aws.amazon.com/blogs/database/migrate-tde-enabled-sql-server-databases-to-amazon-rds-for-sql-server/
upvoted 7 times
...
Sab
Most Recent 2 years, 6 months ago
B and C are correct. But with the new release, we don't have to disable TDE. https://aws.amazon.com/blogs/database/migrate-tde-enabled-sql-server-databases-to-amazon-rds-for-sql-server/
upvoted 4 times
...
hello_aws
2 years, 8 months ago
Selected Answer: BC
DMS doesn't support sparse tables. https://aws.amazon.com/blogs/database/migrate-tde-enabled-sql-server-databases-to-amazon-rds-for-sql-server/
upvoted 1 times
...
yxyj
2 years, 8 months ago
B & C, TDE needs certificate created and installed.
upvoted 3 times
...
zoomac
2 years, 9 months ago
A is wrong because Limitations on using SQL Server as a source for AWS DMS: The SQL Server endpoint doesn't support the use of sparse tables. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html
upvoted 1 times
...
mbar94
2 years, 9 months ago
Selected Answer: AE
A and E, any thoughts?
upvoted 1 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