After you answer a question in this section you will

This preview shows page 44 - 46 out of 51 pages.

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 View Definition permission on dbo.Order to the OrderReader role. 3. Add KimRalls to the OrderReader role. Does the solution meet the goal? A. Yes B. No Correct Answer: B The VIEW DEFINITION permission lets a user see the metadata of the securable on which the permission is granted. However, VIEW DEFINITION permission does not confer access to the securable itself. References: QUESTION 35 General Overview You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements. Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application will eventually replace a desktop application that the customer is currently using. The current application will remain in use while the users are trained to use the new webbased application. You need to design the SQL Server and database infrastructure for the web-based application. Databases Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 44 / 51
Image of page 44
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download You plan to implement databases named Customers, Sales, Products, Current_Inventory, and TempReporting. The Sales database contains a table named OrderTotals and a table named SalesInfo. A stored procedure named SPUpdateSalesInfo reads data in the OrderTotals table and modifies data in the SalesInfo table. The stored procedure then reads data in the OrderTotals table a second time and makes further changes to the information in the SalesInfo table. The Current_Inventory database contains a large table named Inv_Current. The Inv_Current table has a clustered index for the primary key and a nonclustered index. The primary key column uses the identity property. The data in the Inv_Current table is over 120GB in size. The tables in the Current_Inventory database are accessed by multiple queries in the Sales database. Another table in the Current_Inventory database contains a self-join with an unlimited number of hierarchies. This table is modified by a stored procedure named SPUpdate2. An external application named ExternalApp1 will periodically query the Current_Inventory database to generate statistical information. The
Image of page 45
Image of page 46

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