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.
Sign in or unlock 70-465 to reveal the answer and full explanation for question #143. The question stem and answer options stay visible for context.
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.
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 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
#Database security#views#GRANT permissions#role-based access control#principle of least privilege