Off size based cleanup wont be automatically

This preview shows page 13 - 16 out of 51 pages.

OFF – size based cleanup won’t be automatically activated. AUTO - size based cleanup will be automatically activated when size on disk reaches 90% of max_storage_size_mb. This is the default configuration value. Size based cleanup removes the least expensive and oldest queries first. It stops at approximately 80% of max_storage_size_mb. Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 13 / 51
Image of page 13
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download References: - transact-sql - optimal-query-capture-mode QUESTION 11 You are the administrator of a Microsoft SQL Server 2016 server. Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications. You need to dynamically limit resource consumption. What should you do? A. Set up Service Broker to ensure that applications are not allowed to consume more than the specified amount of resources. B. Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor. C. Configure Extended Events to monitor and restrict resource limits allowed by each application type. D. Create a new Plan Guide with a Scope Type of sql and define the resource limits for each application. Correct Answer: B QUESTION 12 You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails. You add two Windows groups as logins for the server: CORP\Employees - All company employees CORP\HRAdmins - HR administrators only HR Administrators are also company employees. You need to grant users access according to the following requirements: CORP\Employees should have SELECT access to the Employees table. Only users in CORP\HRAdmins should have SELECT access to the SalaryDetails table. Logins are based only on Windows security groups. What should you do? A. Create a database role called Employees. Add CORP\Employees to the db_datareader role. Add all company employees except HR administrators to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role. Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 14 / 51
Image of page 14
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download B. Create a database role called HRAdmins. Add all company employees except HR administrators to the db_datareader role, Add all HR administrators to the HRAdmins role. Grant SELECT access to the SalaryDetails table to the HRAdmins role. Deny SELECT access to the SalaryDetails table to the db_datareader role.
Image of page 15
Image of page 16

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