Microsoftcomen ussqlrelational databasessystem stored

This preview shows page 8 - 11 out of 23 pages.

EXEC sp_who \\'10\\' --specifies the process_id; References:- databases/system-stored-procedures/sp-who-transact-sql QUESTION 11 You plan to migrate a Microsoft sql server instance between physical servers. You must migrate the metadata associated with the database instance. You need to ensure that the new instance retains the existing jobs and alerts. Solutions: You restore the model database. Does the solution meet the goal? A. Yes B. No Correct Answer: B The model database does not handle alerts and jobs. It is used as the template for all databases created on an instance of SQL Server. The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. Latest 70-765 Dumps | 70-765 Practice Test | 70-765 Braindumps 8 / 23
Image of page 8
2020 Latest pass4itsure 70-765 PDF and VCE dumps Download References: QUESTION 12 You are developing customized Microsoft Azure Resource Group templates to automate the process of deploying Microsoft SQL Server in Azure to enforce consistency during future deployments. You need to deploy the customized templates to the Azure environment and to external endpoints. Which resource value should you populate? A. properties B. name C. resources D. dbType E. apiVersion Correct Answer: E QUESTION 13 You use a Microsoft Azure SQL database as a data warehouse. The database is in the Standard service tier and has 400 elastic database throughput units (eDTUs). You load data to the database by using Azure Data Factory. You need to reduce the amount of time it takes to load the data. Solution: You move the database to a Standard database pool that has 800 eDTUs. Does the solution meet the goal? A. Yes B. No Correct Answer: A We need at least 400 eDTUs and the use of a Standard database pool. References: QUESTION 14 You administer a Microsoft SQL Server 2014 database named Contoso on a server named Server01. Latest 70-765 Dumps | 70-765 Practice Test | 70-765 Braindumps 9 / 23
Image of page 9
2020 Latest pass4itsure 70-765 PDF and VCE dumps Download You need to prevent users from disabling server audits in Server01. What should you create? A. A Database Audit Specification B. A Policy C. An Alert D. A SQL Profiler Trace E. A Resource Pool F. An Extended Event session G. A Server Audit Specification Correct Answer: B Writing to the Windows Security log requires the SQL Server service account to be added to the Generate security audits policy. By default, the Local System, Local Service, and NetworkService are part of this policy. This setting can be configured by using the security policy snap-in (secpol.msc). Additionally, the Audit object access security policy must be enabled for both Success and Failure.
Image of page 10
Image of page 11

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