Valid 70-764 Dumps shared by PrepAwayExam.com for Helping Passing 70-764 Exam! PrepAwayExam.com now offer the newest 70-764 exam dumps, the PrepAwayExam.com 70-764 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 70-764 dumps with Test Engine here:
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You administer a SQL Server Instance at Contoso Ltd. A new employee named Kim Ralls must be able to read data only from the dbo.Order table in the SalesDB database. You create a SQL login named KimRalls. You then create a SQL user account named KimRalls in SalesDB. The user account is associated with the SQL login. You need to grant KimRalls the necessary permission or permissions. Your solution must follow the principle of least privilege. Solution: You perform the following actions: 1. Add KimRalls to the db_denydatawriter database role in SalesDB. 2. Add KimRalls to the db_owner database role in SalesDB. Does the solution meet the goal?
Correct Answer: B
Explanation/Reference: Explanation: Need to set up select permission on dbo.Order table.