After you answer a question in this sections you will

This preview shows page 18 - 20 out of 51 pages.

After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a server named Server1 that has Microsoft SQL Server installed. Server1 has SQL Server Adult configured to send audit event records to a file. You need to ensure that a database user named User1 can review the audit data. Solution: You assign the db_datareader role to User1. Does this meet the goal? A. Yes B. No Correct Answer: B Each feature and command for SQL Server Audit has individual permission requirements. Unless otherwise specified, viewing catalog views requires a principal to have one of the following: The VIEW SERVER STATE permission. The VIEW AUDIT STATE permission (gives only the principal access to the sys.server_audits catalog view). Membership in the sysadmin fixed server role. The CONTROL SERVER permission. The ALTER ANY AUDIT permission. A principal must have the VIEW SERVER STATE or ALTER ANY AUDIT permission to use the Dynamic Management Views. References: (v=sql.105).aspx QUESTION 17 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. Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 18 / 51
Image of page 18
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases. One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented. You need to optimize query performance. Solution: You rebuild all indexes. Does the solution meet the goal? A. Yes B. No Correct Answer: A You can remedy index fragmentation by either reorganizing an index or by rebuilding an index. References: (v=sql.105).aspx QUESTION 18 Background Corporate Information Fabrikam, Inc. is a retailer that sells electronics products on the Internet. The company has a headquarters site and one satellite sales office. You have been hired as the database administrator, and the company wants you to change the architecture of the Fabrikam ecommerce site to optimize performance and reduce downtime while keeping capital expenditures to a minimum. To help with the solution, Fabrikam has decided to use cloud resources as well as on- premise servers.
Image of page 19
Image of page 20

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