CompTIACompTIA
DS0-001 · Question #14
DS0-001 Question #14: Real Exam Question with Answer & Explanation
Sign in or unlock DS0-001 to reveal the answer and full explanation for question #14. The question stem and answer options stay visible for context.
Data and Database Security
Question
A database administrator needs to provide access to data from two different tables to multiple group users in order to facilitate ongoing reporting. However, some columns in each table are restricted, and users should not be able to see the values in these columns. Which of the following is the best action for the administrator to take?
Options
- ACreate a stored procedure.
- BCreate a view.
- CCreate a .csv export.
- DCreate a trigger.
Unlock DS0-001 to see the answer
You've previewed enough free DS0-001 questions. Unlock DS0-001 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Views#Data Access Control#Column Restriction#Database Security