Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CompTIA DS0-001 Exam - Topic 2 Question 48 Discussion

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?
B) Create a view.
A) Create a stored procedure.
C) Create a csv export.
D) Create a trigger.

CompTIA DS0-001 Exam - Topic 2 Question 48 Discussion

Actual exam question for CompTIA's DS0-001 exam
Question #: 48
Topic #: 2
[All DS0-001 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

The best action for the administrator to take is to create a view. A view is a virtual table that shows a subset of data from one or more tables. The administrator can use a view to provide access to data from two different tables to multiple group users without exposing the restricted columns. The view can also simplify the queries and improve the performance of the reporting process. The other options are either not suitable for this scenario or do not address the requirement of hiding some columns from users. For example, creating a stored procedure would require additional coding and execution, creating a csv export would create a static file that may not reflect the latest data changes, and creating a trigger would perform an action in response to an event rather than provide access to data.Reference:CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.2 Given a scenario, create database objects using scripting and programming languages.


by Felix at Nov 24, 2025, 04:20 AM

Limited Time Offer

25%

Off

Get Premium DS0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Margart
3 months ago
Triggers aren't suitable for this scenario either.
upvoted 0 times
...
Galen
3 months ago
Views are flexible and secure for user access.
upvoted 0 times
...
Sabine
3 months ago
A CSV export won't protect the restricted data.
upvoted 0 times
...
Rory
3 months ago
I agree, a stored procedure might be too complex for this.
upvoted 0 times
...
Shayne
3 months ago
It can restrict access to specific columns easily.
upvoted 0 times
...
Rikki
3 months ago
Why a view?
upvoted 0 times
...
Shayne
4 months ago
I think creating a view is the best option.
upvoted 0 times
...
Kandis
4 months ago
Not sure about that... what if they find a way around it?
upvoted 0 times
...
Lucille
4 months ago
A stored procedure could work too, but views are cleaner.
upvoted 0 times
...
Pete
5 months ago
I agree, views are super useful for this!
upvoted 0 times
...
Jamal
5 months ago
Definitely B) Create a view. It's the best way to restrict access.
upvoted 0 times
...
Santos
5 months ago
I'm going with B. Can't go wrong with a good old view. Keeps the data locked down tight.
upvoted 0 times
...
Dana
5 months ago
B) Create a view. Easy peasy, lemon squeezy.
upvoted 0 times
...
Corinne
5 months ago
Definitely B. Views are the way to go for this scenario. Keeps things simple and secure.
upvoted 0 times
...
Adelina
5 months ago
B) Create a view. This is the best option to restrict access to specific columns while still providing access to the necessary data.
upvoted 0 times
...
Josefa
6 months ago
A trigger seems like it would be overkill for just providing access. I feel like it’s more about automating actions rather than controlling visibility.
upvoted 0 times
...
Aide
6 months ago
I practiced a similar question where views were mentioned as a way to limit data exposure. It seems like the right choice here too.
upvoted 0 times
...
Ronna
6 months ago
I'm not entirely sure, but I remember something about stored procedures being more for data manipulation rather than just providing access.
upvoted 0 times
...
Mose
6 months ago
I'm a little confused on the differences between a view and a stored procedure in this case. I'll need to review those concepts before deciding which one is the best solution.
upvoted 0 times
...
Rozella
6 months ago
The view makes the most sense to me. It's a simple and straightforward way to restrict access to the sensitive columns while still providing the necessary data to the users.
upvoted 0 times
...
Kenneth
6 months ago
Creating a CSV export seems like it would be a lot of extra work. And a trigger doesn't really fit what we're trying to do here. I'm leaning towards the view option.
upvoted 0 times
...
Hailey
7 months ago
I think creating a view might be the best option since it can restrict access to certain columns while still allowing users to see the data they need.
upvoted 0 times
...
Berry
7 months ago
I'd go with B as well. Creating a view is the cleanest and most efficient solution here.
upvoted 0 times
...
Dean
7 months ago
Wait, can users really not see restricted columns with a view?
upvoted 0 times
...
Sarah
8 months ago
Hmm, I'm not sure. A stored procedure might also work, but that seems a bit overkill for this scenario. I'll have to think it through.
upvoted 0 times
...
Mireya
8 months ago
I think creating a view would be the best approach here. That way we can control which columns are exposed to the users.
upvoted 0 times
Dominque
2 months ago
Plus, views can simplify complex queries for users.
upvoted 0 times
...
Keneth
2 months ago
Views are easier to manage for user access.
upvoted 0 times
...
Ammie
2 months ago
A stored procedure could work, but views are cleaner.
upvoted 0 times
...
Daren
7 months ago
Definitely! It keeps sensitive info hidden.
upvoted 0 times
...
Nydia
7 months ago
I agree, a view is the way to go.
upvoted 0 times
...
...

Save Cancel