Pdf practice test 7 51

This preview shows page 7 - 10 out of 51 pages.

Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 7 / 51
Image of page 7
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download QUESTION 8 You have a SQL Server 2014 environment That contains 20 servers. The corporate security policy states that all SQL Server 2014 instances must meet specific security standards. You need to recommend a management strategy for the SQL Server 2014 servers. What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer. A. Multi server jobs B. Policy-Based Management C. Common criteria compliance D. Maintenance plans Correct Answer: B Policy-Based Management is a system for managing one or more instances of SQL Server. When SQL Server policy administrators use Policy-Based Management, they use SQL Server Management Studio to create policies to manage entities on the server, such as the instance of SQL Server, databases, or other SQL Server objects. QUESTION 9 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. Create a custom database role named OrderReader in SalesDB. 2. Grant the Select permission on dbo.Order to the OrderReader role. Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 8 / 51
Image of page 8
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download 3. Add KimRalls to the OrderReader role. Does the solution meet the goal? A. Yes B. No Correct Answer: A We set up select permission on dbo.Order table. References: QUESTION 10 Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series. You maintain a Microsoft SQL Server instance that contains the following databases SalesDb1, SalesDb2, and SalesDb3. Each database has tabled named Products and Sales. The following table shows the configuration of each database.
Image of page 9
Image of page 10

You've reached the end of your free preview.

Want to read all 51 pages?

  • Fall '19
  • Microsoft SQL Server

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors