Certified Data Privacy Solutions Engineer (CDPSE) — Question 133

Which of the following is the BEST way to prevent dangerous SQL write statements from being executed on data?

Answer options

• A. Restrict access to row-specific data.
• B. Create encrypted versions of the data.
• C. Exclude access to specific tables or columns of data.
• D. Create a read-only data warehouse.

Correct answer: D

Explanation

Creating a read-only data warehouse (D) is the best approach as it ensures that no write operations can be performed on the data, effectively preventing dangerous SQL commands. The other options, while they may limit access to certain data, do not eliminate the risk of SQL write statements being executed.