CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
A Mumbai-based fintech firm stores customer PAN and account details in a relational database. To ensure that a data analyst can run reports without ever seeing the actual PAN numbers, the DBA replaces the digits with irreversible substitute characters in the reporting copy. Which database security technique is being used?
The technique is data masking. It replaces sensitive values such as PAN digits with obscured substitute characters, so analysts can work on the reporting copy without seeing real data. Mirroring, referential integrity and checkpointing serve availability, consistency and recovery, not confidentiality.
- AData maskingCorrect
- BDatabase mirroring
- CReferential integrity enforcement
- DCheckpointing
Explanation
Data masking hides sensitive values by substituting obscured or fictitious characters so that users of the reporting copy cannot see the real data. Mirroring is for availability, referential integrity maintains key relationships, and checkpointing is a recovery aid. None of these conceal data from authorised viewers.
Did you get it right without looking?
One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.
More Database Management questions
- In an ER design for a listed company's compliance system, 'Dependent' (family members of an employee) has no key of its own and is identifie…
- In an Employee table, Emp_ID is the primary key, and columns are Dept_ID and Dept_Head, where Dept_ID determines Dept_Head. A company wants …
- A company's payment database transfers Rs 5,000 from Account A to Account B. The debit on A succeeds, but the system crashes before the cred…
- A bank's employee, while a transaction updating a customer's balance is still uncommitted, is shown by another session a balance value that …
- In the ETL process used to populate a data warehouse, which activity is performed in the 'Transform' step?
- An e-commerce firm stores personal data of buyers. Its database designer finds that a Buyer table holds buyer name, city and also the city's…