exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 454 discussion

A company has a customer relationship management (CRM) application that stores data in an Amazon RDS DB instance that runs Microsoft SQL Server. The company's IT staff has administrative access to the database. The database contains sensitive data. The company wants to ensure that the data is not accessible to the IT staff and that only authorized personnel can view the data.
What should a solutions architect do to secure the data?

  • A. Use client-side encryption with an Amazon RDS managed key.
  • B. Use client-side encryption with an AWS Key Management Service (AWS KMS) customer managed key.
  • C. Use Amazon RDS encryption with an AWS Key Management Service (AWS KMS) default encryption key.
  • D. Use Amazon RDS encryption with an AWS Key Management Service (AWS KMS) customer managed key.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
AnuhyaTech
Highly Voted 3 years, 8 months ago
Answer D AWS KMS Custom master key will allow to create a key policy which will define uses/roles to access the master key
upvoted 52 times
noahsark
3 years, 7 months ago
For an Amazon RDS encrypted DB instance, all logs, backups, and snapshots are encrypted. Amazon RDS uses an AWS KMS customer master key (CMK) to encrypt these resources. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html
upvoted 7 times
...
...
Shiner
Highly Voted 3 years, 5 months ago
I picked D. A & B are irrelevant since the data is already in AWS RDS, thus client-side encryption cannot be used. Out of C & D, I picked D. Simply because having a CMK means you can use resource-based policies to restrict access to the key. This means, if you can't access the key, you can't decrypt the data.
upvoted 11 times
rav009
3 years, 5 months ago
Yes, the data is already in AWS RDS so client side encryption is not useful here.
upvoted 1 times
...
...
cloud_collector
Most Recent 2 years, 10 months ago
Customer managed keys is better. The KMS keys that you create are customer managed keys. Customer managed keys are KMS keys in your AWS account that you create, own, and manage. You have full control over these KMS keys, including establishing and maintaining their key policies, IAM policies, and grants, enabling and disabling them, rotating their cryptographic material, adding tags, creating aliases that refer to the KMS keys, and scheduling the KMS keys for deletion. https://docs.aws.amazon.com/kms/latest/developerguide/concepts.html
upvoted 1 times
cloud_collector
2 years, 10 months ago
You have permission to view the AWS managed keys in your account, view their key policies, and audit their use in AWS CloudTrail logs. However, you cannot change any properties of AWS managed keys, rotate them, change their key policies, or schedule them for deletion. And, you cannot use AWS managed keys in cryptographic operations directly; the service that creates them uses them on your behalf.
upvoted 1 times
...
...
cutecolt
3 years, 1 month ago
Selected Answer: D
The question is talking about inaccessible to IT personnel means it is already stored and at rest. So, no question about in transit and no need to talk about client side encryption. So, the choice is between C and D. and I would go with D due to customer managed key where the customer has full control.
upvoted 2 times
adesixams
2 years, 10 months ago
A RDS created DB can't be encrypted, so you must Delete the actual DB and create another one encrypted... move the data to the new DB. Or better client-side encrypt your data and keep encrypted with your own key in the DB.
upvoted 1 times
...
...
osel
3 years, 4 months ago
I think there should be a difference meaning between the 2 terms as CMK (Customer Master Key) and Customer Managed Key? Here is my understanding. Customer Managed Key means customer to generate its own CMK using KMS Svc and such CMK is only kept within KMS Svc and cannot be fetched by the client App. CMK is used to encrypt/decrypt the Data Encryption Key DEK whereby such DEK can be fetched by the client App.
upvoted 1 times
...
envest
3 years, 4 months ago
IMO: C because of the guaranteed access (no custom access control) & RDS allows both key types. https://docs.aws.amazon.com/kms/latest/developerguide/concepts.html
upvoted 1 times
...
FF11
3 years, 4 months ago
Selected Answer: D
D seems good.
upvoted 2 times
...
prex
3 years, 5 months ago
Selected Answer: D
Customer Key Managed
upvoted 3 times
...
xyzray
3 years, 5 months ago
Selected Answer: B
Amazon RDS encrypted DB instances provide an additional layer of data protection by securing your data from unauthorized access to the underlying storage. The AWS Encryption SDK is a client-side encryption library that enables developers to focus on the core functionality of their application while adhering to security best practices. The AWS Encryption SDK also integrates with KMS.
upvoted 2 times
...
gargaditya
3 years, 6 months ago
ITs D. There are 3 main things: 1.Encryption in flight using SSl/TLS certificates 2.Encryption at rest->using Client side encryption, meaning sending encrypted data into AWS. Encryption/decryption managed at client end. 3.Encryption at rest-> Server Side Encryption ie encryption happens after data reaches AWS. This can be done using AWS and its KMS service. ========= KMS is a service that manages encryption keys('Customer Master keys',not Data keys).A 'data key' is used to encrypt the actual data data.CMK is basically used to protect the data key which is used for encrypting data.To decrypt the data,one calls the KMS service and uses the CMK to decrypt the 'data key'.Once we have the decrypted(plaintext) data key, we use the same to decrypt the actual data. ======
upvoted 6 times
gargaditya
3 years, 6 months ago
KMS has 3 flavors for the CMK: -AWS Managed service default -User keys created in KMS -User keys imported I think,as per https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html,RDS supports only KMS or TDE,no client side encryption. Further, default encryption key would be accessed by IT personnel as well(if they have AWS console access/admin access). Better to create new user keys in KMS(customer managed).
upvoted 3 times
...
...
mdangel1
3 years, 7 months ago
Can someone please assist with the following? why use cmk and not AWS key? I cant find the answer lease
upvoted 1 times
Jonfernz
3 years, 7 months ago
using CMK is best practice.
upvoted 1 times
...
violonchelo
3 years, 7 months ago
The data should only be accessible to authorized personnel and not IT staff. We can asume that it staff has administrator access to the aws account. If they have admin access to the account they also have access to the keys.
upvoted 2 times
...
...
spydii
3 years, 7 months ago
Well D for today.
upvoted 3 times
...
Goozian
3 years, 7 months ago
D https://aws.amazon.com/blogs/database/securing-data-in-amazon-rds-using-aws-kms-encryption/
upvoted 3 times
...
Deyemzy
3 years, 7 months ago
C https://aws.amazon.com/about-aws/whats-new/2015/01/06/amazon-rds-encryption-with-kms-mysql-postgresql/
upvoted 2 times
...
zxing233
3 years, 7 months ago
B ! https://aws.amazon.com/blogs/database/performing-sql-database-client-side-encryption-for-multi-region-high-availability/
upvoted 4 times
gargaditya
3 years, 6 months ago
It still talks about KMS and creating custom keys, not truly 'client-side' where client encrypts data and sends into AWS.
upvoted 1 times
...
...
Maddy_aws2020
3 years, 7 months ago
Ans : d : RDS can be encrypted by CMKs. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html
upvoted 4 times
...
shantest1
3 years, 8 months ago
B. I guess when they mean IT staff they meant DBA, for DBA not to see the data, you need to encrypt the data in the application itself aka Client side encryption other encryption methods DBA will be able to see the data, my 2 cents as DBA. :0)
upvoted 7 times
Vizz5585
3 years, 7 months ago
what about data that already exists.
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
Loading ...