Securing Applications and Data unit test
A test on this unit alone, marked as a percentage and a letter grade — for the test your class is actually sitting, rather than for May. Answer everything, then submit once: seeing the answer to question 3 before attempting question 4 makes the final percentage meaningless.
Attribute-based access control (ABAC)
Data loss prevention (DLP)
Personally identifiable information
Public key infrastructure (PKI)
End-to-end encryption
Data at rest, in transit, in use
Digital signature
Rainbow table
Why backups must be tested and offline
Privilege creep
Hashing
Key stretching
Short answer 1. Define or explain: Code review and static analysis
3 ptsShort answer 2. Define or explain: Insecure deserialization
3 ptsShort answer 3. Define or explain: Why both are used together
3 ptsShort answer 4. Define or explain: Account lifecycle
3 ptsFree response
6 ptsA student-built web application lets users search a course catalog. The developer builds the database query by concatenating the user's search text directly into a SQL string, and displays the search term back on the results page exactly as typed. (a) Name the vulnerability created by the query construction and explain the mechanism by which it is exploited. (b) Explain why parameterized queries fix it, and why filtering out the word "DROP" does not. (c) Name the separate vulnerability created by echoing the search term back to the page, and describe its impact on other users. (d) Explain what defense in depth means and apply it to this application with two distinct layers.