Each question in the series contains a unique

This preview shows page 17 - 20 out of 23 pages.

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 run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00. Solution: You install the Elastic Database jobs PowerShell package, and then you create an Elastic Database job. Does this meet the goal? A. Yes B. No Correct Answer: B QUESTION 24 You have Microsoft SQL Server on a Microsoft Azure virtual machine. You create a SQL Server Agent job by using the following statement. You need to send an email message if the job fails. Which stored procedure should you use? A. msdb. dbo. sp_updace_alerc B. msdb.dbo.sp_add_jobstep C. msdb.dbo.sp_add_notification Latest 70-765 Dumps | 70-765 Practice Test | 70-765 Braindumps 17 / 23
Image of page 17
2020 Latest pass4itsure 70-765 PDF and VCE dumps Download D. msdb.dbo.sp_help_alert Correct Answer: C To notify an operator of job status through Transact-SQL. In Object Explorer, connect to an instance of Database Engine. On the Standard bar, click New Query. -- adds an e-mail notification for the specified alert (Test Alert). -- This example assumes that Test Alert already exists -- and that Franis Ajenstat is a valid operator name. USE msdb ; GO EXEC dbo.sp_add_notification @alert_name = N\\'Test Alert\\', @notification_method = 1 ; GO References: - status?view=sql-server-2017 QUESTION 25 You administer a Microsoft SQL Server 2014 database. You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges. You need to ensure that the job step can run using a different user account. What should you use? A. a schedule B. an alert C. an operator D. a proxy Correct Answer: D A SQL Server Agent proxy defines the security context for a job step. A proxy provides SQL Server Agent with access to the security credentials for a Microsoft Windows user. Each proxy can be associated with one or more subsystems. A job step that uses the proxy can access the specified subsystems by using the security context of the Windows user. Before SQL Server Agent runs a job step that uses a proxy, SQL Server Agent impersonates the credentials defined in the proxy, and then runs the job step by using that security context. References:(v=sql.105).aspx Latest 70-765 Dumps | 70-765 Practice Test | 70-765 Braindumps 18 / 23
Image of page 18
2020 Latest pass4itsure 70-765 PDF and VCE dumps Download QUESTION 26 You have an on-premises SQL Server database named DB1 that contains a table named TB1. TB1 is stretched to Microsoft Azure.
Image of page 19
Image of page 20

You've reached the end of your free preview.

Want to read all 23 pages?

  • Fall '19
  • Relational model, 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