CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
A fintech firm's DBMS lets the marketing team see only customer names and cities, while hiding PAN and Aadhaar columns stored in the same base table, without altering the underlying data. Which concept in the three-level architecture best explains this, and why is it relevant to data protection compliance?
The external level, implemented through views. It shows each user group only the data it needs, hiding sensitive columns such as PAN and Aadhaar without changing stored data. This supports access limitation, which helps meet data protection and security obligations.
- AInternal level; it fixes the physical file blocks used for storage
- BConceptual level; it defines the full logical schema for all users together
- CExternal level (view); it presents tailored subsets of data to users, supporting limited access to personal dataCorrect
- DPhysical level; it encrypts the network packets between servers
Explanation
The external level gives each user group its own view of selected data, hiding the rest. This supports restricting access to sensitive personal data, in line with data protection and reasonable security practice expectations. The conceptual level describes the whole logical structure and the internal level describes physical storage, so neither provides per-group tailoring.
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
- 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…
- A table EMP has 6 rows with salaries 20000, 30000, 30000, 40000, 50000 and NULL. Which of the following statements about the results is corr…
- An insurer's DBA wants staff in the claims department to see only the claim number, claimant name and claim status from a table that also ho…