Question 510
To protect records before sending them to a third-party hosting provider, which approach should a data protection engineer choose?
- Application-layer encryption
- Full-disk encryption
- Mutual TLS for databases
- Database transparent encryption
- SMTP STARTTLS enforcement
Explanation
Correct Answer
A:Client-controlled encryption limits provider visibility when keys remain outside the provider's control; this mechanism directly supports the requirement to protect records before sending them to a third-party hosting provider.
Incorrect Answers
B:Volume encryption prevents straightforward offline reading when key protection and unlock configuration are sound; a team would select it to protect a stolen corporate laptop's data while it is powered off, which does not provide the particular result to protect records before sending them to a third-party hosting provider.
C:Two-way certificate checks help prevent unauthorized database clients and counterfeit servers; its operational purpose is to authenticate both an application server and its database endpoint, not to achieve the specific requirement to protect records before sending them to a third-party hosting provider.
D:TDE protects data at rest but does not prevent authenticated database queries from returning plaintext; applying it would serve encrypt database files and backups without application query changes without directly satisfying the goal to protect records before sending them to a third-party hosting provider.
E:Required authenticated transport rejects delivery when the expected secure SMTP channel cannot be negotiated; it addresses the different need to prevent sensitive mail being sent over an opportunistically downgraded SMTP path, leaving the requested ability to protect records before sending them to a third-party hosting provider unresolved.
Question 511
To protect credentials while a client communicates with a remote service, which method is designed for the task?
- Mutual TLS for databases
- Column-level encryption
- TLS transport encryption
- Full-disk encryption
Explanation
Correct Answer
C:TLS negotiates an authenticated encrypted channel under validated certificates and accepted algorithms; it supplies the specific control needed to protect credentials while a client communicates with a remote service.
Incorrect Answers
A:Two-way certificate checks help prevent unauthorized database clients and counterfeit servers; it could help someone trying to authenticate both an application server and its database endpoint, but the problem is instead to protect credentials while a client communicates with a remote service.
B:Field encryption narrows exposure when authorized application functions can manage the relevant keys; that is useful when the task is to shield selected high-sensitivity fields from ordinary database storage access, not the stated requirement to protect credentials while a client communicates with a remote service.
D:Volume encryption prevents straightforward offline reading when key protection and unlock configuration are sound; its operational purpose is to protect a stolen corporate laptop's data while it is powered off, not to achieve the specific requirement to protect credentials while a client communicates with a remote service.
Question 512
A database server already validates client certificates. The security team must now give two application services different database privileges based on their authenticated certificate identities rather than using one shared privileged account. What is required?
- Mutual TLS transport authentication
- Certificate-to-database-role authorization mapping
- Transparent database encryption at rest
- A database server TLS certificate only
Explanation
Correct Answer
B:Mapping a validated client certificate identity to a distinct database principal or role lets authorization follow the service identity, enabling appropriately scoped privileges after authentication.
Incorrect Answers
A:Mutual TLS authenticates endpoints, but requiring a client certificate alone does not assign distinct database table permissions to different application service identities.
C:Transparent database encryption protects stored database files against relevant offline disclosure threats. It does not establish per-service application authorization inside the running database.
D:A database server TLS certificate helps the client validate its destination and secure the channel. It does not map client certificate subjects to the server-side roles requested here.
Question 513
To prevent sensitive mail being sent over an opportunistically downgraded SMTP path, which protective or investigative measure applies?
- Column-level encryption
- S/MIME message encryption
- Database transparent encryption
- SMTP STARTTLS enforcement
- Key management service access
- TLS transport encryption
Explanation
Correct Answer
D:Required authenticated transport rejects delivery when the expected secure SMTP channel cannot be negotiated; its relevant protective or investigative effect is to prevent sensitive mail being sent over an opportunistically downgraded SMTP path.
Incorrect Answers
A:Field encryption narrows exposure when authorized application functions can manage the relevant keys; the outcome it supports is to shield selected high-sensitivity fields from ordinary database storage access, whereas this scenario asks defenders to prevent sensitive mail being sent over an opportunistically downgraded SMTP path.
B:End-to-end message encryption uses recipient certificates, subject to key and client management; although relevant to keep email content confidential beyond individual mail transport hops, it does not by itself achieve the required task to prevent sensitive mail being sent over an opportunistically downgraded SMTP path.
C:TDE protects data at rest but does not prevent authenticated database queries from returning plaintext; it could help someone trying to encrypt database files and backups without application query changes, but the problem is instead to prevent sensitive mail being sent over an opportunistically downgraded SMTP path.
E:Central key policies, rotation and audit reduce uncontrolled copying and use of data-encryption secrets; a team would select it to separate control of encryption keys from routine storage administration, which does not provide the particular result to prevent sensitive mail being sent over an opportunistically downgraded SMTP path.
F:TLS negotiates an authenticated encrypted channel under validated certificates and accepted algorithms; its operational purpose is to protect credentials while a client communicates with a remote service, not to achieve the specific requirement to prevent sensitive mail being sent over an opportunistically downgraded SMTP path.
Question 514
To keep email content confidential beyond individual mail transport hops, what is the most direct option?
- S/MIME message encryption
- SMTP STARTTLS enforcement
- Application-layer encryption
- Mutual TLS for databases
Explanation
Correct Answer
A:End-to-end message encryption uses recipient certificates, subject to key and client management; the requested outcome is precisely to keep email content confidential beyond individual mail transport hops.
Incorrect Answers
B:Required authenticated transport rejects delivery when the expected secure SMTP channel cannot be negotiated; the outcome it supports is to prevent sensitive mail being sent over an opportunistically downgraded SMTP path, whereas this scenario asks defenders to keep email content confidential beyond individual mail transport hops.
C:Client-controlled encryption limits provider visibility when keys remain outside the provider's control; although relevant to protect records before sending them to a third-party hosting provider, it does not by itself achieve the required task to keep email content confidential beyond individual mail transport hops.
D:Two-way certificate checks help prevent unauthorized database clients and counterfeit servers; it could help someone trying to authenticate both an application server and its database endpoint, but the problem is instead to keep email content confidential beyond individual mail transport hops.
Question 515
To separate control of encryption keys from routine storage administration and to encrypt large datasets with data keys wrapped by a separately protected key, which TWO measures should the defender select? Choose TWO.
- Cryptographic key destruction
- Envelope encryption
- S/MIME message encryption
- Key management service access
- SMTP STARTTLS enforcement
Explanation
Correct Answers
B:Hierarchical key use supports efficient bulk encryption and centralized key revocation or rotation; it satisfies the distinct requirement to encrypt large datasets with data keys wrapped by a separately protected key within the multi-control task.
D:Central key policies, rotation and audit reduce uncontrolled copying and use of data-encryption secrets; it satisfies the distinct requirement to separate control of encryption keys from routine storage administration within the multi-control task.
Incorrect Answers
A:Crypto-erasure depends on exhaustive key-copy control and sound cryptographic implementation; the technique works for situations involving make encrypted archived data inaccessible by securely retiring its only valid keys, rather than this need to separate control of encryption keys from routine storage administration and to encrypt large datasets with data keys wrapped by a separately protected key.
C:End-to-end message encryption uses recipient certificates, subject to key and client management; the outcome it supports is to keep email content confidential beyond individual mail transport hops, whereas this scenario asks defenders to separate control of encryption keys from routine storage administration and to encrypt large datasets with data keys wrapped by a separately protected key.
E:Required authenticated transport rejects delivery when the expected secure SMTP channel cannot be negotiated; it could help someone trying to prevent sensitive mail being sent over an opportunistically downgraded SMTP path, but the problem is instead to separate control of encryption keys from routine storage administration and to encrypt large datasets with data keys wrapped by a separately protected key.
Question 516
To encrypt large datasets with data keys wrapped by a separately protected key, which mechanism best fits?
- Envelope encryption
- Mutual TLS for databases
- Key management service access
- Cryptographic key destruction
Explanation
Correct Answer
A:Hierarchical key use supports efficient bulk encryption and centralized key revocation or rotation; this mechanism directly supports the requirement to encrypt large datasets with data keys wrapped by a separately protected key.
Incorrect Answers
B:Two-way certificate checks help prevent unauthorized database clients and counterfeit servers; the technique works for situations involving authenticate both an application server and its database endpoint, rather than this need to encrypt large datasets with data keys wrapped by a separately protected key.
C:Central key policies, rotation and audit reduce uncontrolled copying and use of data-encryption secrets; its mechanism supports separate control of encryption keys from routine storage administration, while the requested control must be able to encrypt large datasets with data keys wrapped by a separately protected key.
D:Crypto-erasure depends on exhaustive key-copy control and sound cryptographic implementation; the outcome it supports is to make encrypted archived data inaccessible by securely retiring its only valid keys, whereas this scenario asks defenders to encrypt large datasets with data keys wrapped by a separately protected key.
Question 517
To make encrypted archived data inaccessible by securely retiring its only valid keys, which mechanism best fits?
- Key management service access
- Cryptographic key destruction
- Envelope encryption
- SMTP STARTTLS enforcement
Explanation
Correct Answer
B:Crypto-erasure depends on exhaustive key-copy control and sound cryptographic implementation; it supplies the specific control needed to make encrypted archived data inaccessible by securely retiring its only valid keys.
Incorrect Answers
A:Central key policies, rotation and audit reduce uncontrolled copying and use of data-encryption secrets; applying it would serve separate control of encryption keys from routine storage administration without directly satisfying the goal to make encrypted archived data inaccessible by securely retiring its only valid keys.
C:Hierarchical key use supports efficient bulk encryption and centralized key revocation or rotation; the technique works for situations involving encrypt large datasets with data keys wrapped by a separately protected key, rather than this need to make encrypted archived data inaccessible by securely retiring its only valid keys.
D:Required authenticated transport rejects delivery when the expected secure SMTP channel cannot be negotiated; its mechanism supports prevent sensitive mail being sent over an opportunistically downgraded SMTP path, while the requested control must be able to make encrypted archived data inaccessible by securely retiring its only valid keys.
Question 518
To detect alteration of an exported evidence package under a trusted key, which measure best meets the requirement?
- Authenticated hashes
- Dynamic data masking
- Immutable object retention
- Static data masking
Explanation
Correct Answer
A:HMAC or signature-based validation binds content to authenticators more strongly than an unsecured checksum; that is why it addresses the operational task to detect alteration of an exported evidence package under a trusted key.
Incorrect Answers
B:Runtime presentation controls reduce routine exposure but should not be treated as a full authorization boundary; applying it would serve hide sensitive columns from lower-privilege query output while retaining stored originals without directly satisfying the goal to detect alteration of an exported evidence package under a trusted key.
C:Object-lock controls enforce write-once behavior under the chosen retention governance model; it addresses the different need to prevent alteration or deletion of archived records during a fixed compliance period, leaving the requested ability to detect alteration of an exported evidence package under a trusted key unresolved.
D:Stored values are transformed for test use rather than merely concealed in query results; the technique works for situations involving provide a nonproduction analytics dataset without real customer identifiers, rather than this need to detect alteration of an exported evidence package under a trusted key.
Question 519
To record unauthorized changes to protected customer records, what control should be selected?
- Format-preserving encryption
- Immutable object retention
- Database audit logging
- Static data masking
Explanation
Correct Answer
C:Audit trails associate operations with users and time, supporting incident reconstruction and accountability; its relevant protective or investigative effect is to record unauthorized changes to protected customer records.
Incorrect Answers
A:The cipher preserves structural constraints but still requires sound keys, tweak handling and threat evaluation; a team would select it to encrypt identifiers while retaining a specified data format for compatible systems, which does not provide the particular result to record unauthorized changes to protected customer records.
B:Object-lock controls enforce write-once behavior under the chosen retention governance model; its operational purpose is to prevent alteration or deletion of archived records during a fixed compliance period, not to achieve the specific requirement to record unauthorized changes to protected customer records.
D:Stored values are transformed for test use rather than merely concealed in query results; it addresses the different need to provide a nonproduction analytics dataset without real customer identifiers, leaving the requested ability to record unauthorized changes to protected customer records unresolved.
Question 520
To prevent alteration or deletion of archived records during a fixed compliance period, which security control is most appropriate?
- Dynamic data masking
- Database audit logging
- Static data masking
- DLP endpoint inspection
- Immutable object retention
Explanation
Correct Answer
E:Object-lock controls enforce write-once behavior under the chosen retention governance model; the requested outcome is precisely to prevent alteration or deletion of archived records during a fixed compliance period.
Incorrect Answers
A:Runtime presentation controls reduce routine exposure but should not be treated as a full authorization boundary; that is useful when the task is to hide sensitive columns from lower-privilege query output while retaining stored originals, not the stated requirement to prevent alteration or deletion of archived records during a fixed compliance period.
B:Audit trails associate operations with users and time, supporting incident reconstruction and accountability; a team would select it to record unauthorized changes to protected customer records, which does not provide the particular result to prevent alteration or deletion of archived records during a fixed compliance period.
C:Stored values are transformed for test use rather than merely concealed in query results; its operational purpose is to provide a nonproduction analytics dataset without real customer identifiers, not to achieve the specific requirement to prevent alteration or deletion of archived records during a fixed compliance period.
D:Endpoint content policy detects sensitive transfers where network gateways lack visibility; applying it would serve prevent confidential spreadsheets from being copied to unapproved USB storage without directly satisfying the goal to prevent alteration or deletion of archived records during a fixed compliance period.