MicrosoftMicrosoft
70-465 · Question #143
70-465 Question #143: Real Exam Question with Answer & Explanation
The correct answer is A: Create a view called CustProduct that includes columns ProductID. ProductName,. Give access to CustomerSupport through a view. The view must include all these columns (refer to scenario). GRANT Object Permissions (Transact-SQL)
Submitted by valeria.br· Mar 5, 2026Design database security solutions
Question
You need to configure security on the Product table for customer support representatives. Which two actions should you perform? Each correct answer presents part of the solution. Choose two.
Options
- ACreate a view called CustProduct that includes columns ProductID. ProductName,
- BGRANT ALL on CustProduct TO OurDomain\CustomerSupport
- CCreate a user-defined data type called CustProduct that includes columns ProductID,
- DCreate a view called CustProduct that includes columns ProductID, ProductName,
- EGRANT SELECT on CustProduct TO OurDomain\CustomerSupport.
- FGRANT SELECT on CustProduct TO public.
Explanation
Give access to CustomerSupport through a view. The view must include all these columns (refer to scenario). GRANT Object Permissions (Transact-SQL)
Topics
#Database security#views#GRANT permissions#role-based access control#principle of least privilege
Community Discussion
No community discussion yet for this question.