After you answer a question in this sections you will

This preview shows page 3 - 6 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. Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 3 / 51
Image of page 3
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download You have a Microsoft Azure SQL database that has Blob Auditing configured. You need to review the audit logs. Solution: From Microsoft SQL Server Management Studio, you connect to the database, and then you execute the following statement. Does this meet the goal? A. Yes B. No Correct Answer: B The fn_get_audit_file, not dm_db_audit_file, the returns information from an audit file created by a server audit in SQL Server. This example reads from a file that is named ShiraServer/MayaDB/SqlDbAuditing_Audit/2017-07-14/10_45_22_173_1.xel: SELECT * FROM sys.fn_get_audit_file (\\' SqlDbAuditing_Audit/2017-07-14/10_45_22_173_1.xel\\',default,default); Note: Blob auditing logs are saved as a collection of blob files within a container named sqldbauditlogs. References: - sql QUESTION 5 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 need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail. Solution: You add the DatabaseMailUserRole to Mail1 in the master database. Does the solution meet the goal? A. Yes B. No Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 4 / 51
Image of page 4
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download Correct Answer: B Database Mail is guarded by the database role DatabaseMailUserRole in the msdb database, not the master database, in order to prevent anyone from sending arbitrary emails. Database users or roles must be created in the msdb database and must also be a member of DatabaseMailUserRole in order to send emails with the exception of sysadmin who has all privileges. Note: Database Mail was first introduced as a new feature in SQL Server 2005 and replaces the SQL Mail feature found in previous versions. References: QUESTION 6 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 next of the scenario is exactly the same in each question in this series.
Image of page 5
Image of page 6

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