Microsoft
70-465 · Question #143
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.
The correct answer is A. Create a view called CustProduct that includes columns ProductID. ProductName, E. GRANT SELECT on CustProduct TO OurDomain\CustomerSupport. 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.
How the community answered
(57 responses)- A84% (48)
- B2% (1)
- C4% (2)
- D2% (1)
- F9% (5)
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.