Solution you run the following transact sql statement

This preview shows page 37 - 40 out of 51 pages.

Solution: You run the following Transact-SQL statement: For each database that you identify, you run the following Transact-SQL statement: Does the solution meet the goal? A. Yes B. No Correct Answer: A We should set the PAGE_VERIFY Database Option to CHECKSUM. Note: CHECKSUM is the Way to Go For Page Verify Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 37 / 51
Image of page 37
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download This isn\\'t about security?this is about you knowing if changes to SQL Server\\'s files are happening outside of its control, whether by corruption or any other means. It\\'s very easy to check if you\\'re using CHECKSUM. Take a look at your settings today, and make a plan to move to checksum for any databases which need it! SELECT NAME FROM sys.databases WHERE page_verify_option_desc \\'CHECKSUM\\' References: - option-to-checksum?view=sql-server-2017 QUESTION 28 Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You collect performance metrics on multiple Microsoft SQL Server instances and store the data in a single repository. You need to examine disk usage, query statistics, and server activity without building custom counters. What should you use? A. Activity Monitor B. Sp_who3 stored procedure C. Object Explorer in the Microsoft SQL Server Management Studio (SSMS) D. SQL Server Data Collector E. SQL Server Data Tools (SSDT) F. SQL Server Configuration Manager Correct Answer: D The data collector is a core component of the data collection platform for SQL Server 2017 and the tools that are provided by SQL Server. The data collector provides one central point for data collection across your database servers and applications. This collection point can obtain data from a variety of sources and is not limited to performance data QUESTION 29 You administer a Microsoft SQL Server 2016 database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 38 / 51
Image of page 38
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download Which server-level audit action group should you use? A. SERVER_STATE_CHANGE_GROUP B. SERVER_PRINCIPAL_IMPERSONATION_GROUP C. SUCCESSFUL_LOGIN_GROUP D. SERVER_ROLE_MEMBER_CHANGE_GROUP Correct Answer: D SERVER_ROLE_MEMBER_CHANGE_GROUP This event is raised whenever a login is added or removed from a fixed server role. This event is raised for the sp_addsrvrolemember and sp_dropsrvrolemember stored procedures.
Image of page 39
Image of page 40

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