- Home
- Microsoft
- Administering a SQL Database Infrastructure
- Microsoft.70-764.v2020-02-03.q100
- Question 5
Valid 70-764 Dumps shared by ExamDiscuss.com for Helping Passing 70-764 Exam! ExamDiscuss.com now offer the newest 70-764 exam dumps, the ExamDiscuss.com 70-764 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-764 dumps with Test Engine here:
Access 70-764 Dumps Premium Version
(452 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 5/100
You are the database administrator for a Microsoft SQL Server instance. You develop an Extended Events package to look for events related to application performance.
You need to change the event session to include SQL Server errors that are greater than error severity 15.
Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
You need to change the event session to include SQL Server errors that are greater than error severity 15.
Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Correct Answer:
Explanation
Step 1: ALTER EVENT SESSION Contoso1 ON SERVER
Step 2: ADD EVENT ...
Step 3: (ACTION ...
Step 4: WHERE...
Step 5: ) GO
Example: To start an Extended Events sessions in order to trap SQL Server errors with severity greater than
10,just run the following script:
CREATE EVENT SESSION [error_trap] ON SERVER
ADD EVENT sqlserver.error_reported
(
ACTION
(package0.collect_system_time,package0.last_error,sqlserver.client_app_name,sqlserver.client_hostname,sqlserv sqlserver.plan_handle,sqlserver.query_hash,sqlserver.session_id,sqlserver.sql_text,sqlserver.tsql_frame,sqlserver WHERE ([severity]>10) ) ADD TARGET package0.event_file ( SET filename=N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\XEvents\error_trap.xel' ) WITH ( STARTUP_STATE=OFF ) GO References:
http://sqlblog.com/blogs/davide_mauri/archive/2013/03/17/trapping-sql-server-errors-with-extended-events.aspx
- Question List (100q)
- Question 1: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 2: Note: This question is part of a series of questions that pr...
- Question 3: You administer a Microsoft SQL Server 2016 database that has...
- Question 4: You are planning the deployment of two new Always On Failove...
- Question 5: You are the database administrator for a Microsoft SQL Serve...
- Question 6: You have a SQL Azure database named Database1. You need to d...
- Question 7: Note: This question is part of a series of questions that pr...
- Question 8: You administer a Microsoft SQL Server 2016 instance. The ins...
- Question 9: Overview You are a database administrator for a company name...
- Question 10: You are a database administrator for Contoso, LTD, You confi...
- Question 11: Note: This question is part of a series of questions that us...
- Question 12: Note: This question is part of a series of questions that us...
- Question 13: You have a Microsoft SQL Server instance that hosts a databa...
- Question 14: You use SQL Server 2014. You need to create a single object ...
- Question 15: Note: This question is part of a series of questions that us...
- Question 16: Note: This question is a part of a series of questions that ...
- Question 17: You need to validate rows before they are added to a table e...
- Question 18: Overview General Overview ADatum Corporation has offices in ...
- Question 19: Note: This question is part of a series of questions that us...
- Question 20: Note: This question is part of a series of questions that us...
- Question 21: Note: This question is part of a series of questions that us...
- Question 22: Note: This question is part of a series of questions that pr...
- Question 23: You deploy a database by using SQL Server 2012. The database...
- Question 24: A Microsoft SQL Server database named DB1 has two filegroups...
- Question 25: You are designing an authentication strategy for a new serve...
- Question 26: Note: This question is part of a series of questions that pr...
- Question 27: You have a query that is used by a reporting dashboard. User...
- Question 28: You administer a Microsoft SQL Server 2016 database. You wan...
- Question 29: You have a data warehouse that stores sales data. One fact t...
- Question 30: You manage a Microsoft SQL Server instance that has a databa...
- Question 31: You have a database. The existing backups for the database a...
- Question 32: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 33: Note: This question is part of a series of questions that pr...
- Question 34: You have a server named Server1 that has 16 processors. You ...
- Question 35: Your company hosts Microsoft SQL Server instances for custom...
- Question 36: Note: This question is part of a series of questions that pr...
- Question 37: You need to recommend a backup process for an Online Transac...
- Question 38: Overview Application Overview Contoso, Ltd., is the develope...
- Question 39: Overview You are a database administrator for a company name...
- Question 40: You have two databases named DB1 and DB2 that are located on...
- Question 41: You use SQL Azure to store data used by an e-commerce applic...
- Question 42: You administer a Microsoft SQL Server 2016 database. You pro...
- Question 43: You are configuring log shipping for a Microsoft SQL Server ...
- Question 44: Overview General Overview ADatum Corporation has offices in ...
- Question 45: Note: This question is part of a series of questions that us...
- Question 46: You need to address the requirements for disc usage monitori...
- Question 47: You have a database named DB1. Users report that queries tha...
- Question 48: You have a database named DB1. DB1 contains a table named Sa...
- Question 49: Note: This question is part of a series of questions that pr...
- Question 50: Note: This question is part of a series of questions that us...
- Question 51: You are designing a database named DB1. Changes will be depl...
- Question 52: You are troubleshooting an application that runs a query. Th...
- Question 53: You define a table by using the following statement. (Exhibi...
- Question 54: You have four databases that are accessed by using an Online...
- Question 55: Note: This question is part of a series of questions that pr...
- Question 56: You work as a Database Administrator (DBA) for a company nam...
- Question 57: Note: This question is part of a series of questions that pr...
- Question 58: Note: This question is part of a series of questions that us...
- Question 59: You use Microsoft SQL Server 2016 to write code for a transa...
- Question 60: Note: This question is part of a series of questions that us...
- Question 61: You need to recommend the actions that are required to parti...
- Question 62: You use SQL Server 2014 to maintain the data used by applica...
- Question 63: You administer all the deployments of Microsoft SQL Server 2...
- Question 64: Your organization is developing a web application. The appli...
- Question 65: Note: This question is part of a series of questions that pr...
- Question 66: Note: This question is part of a series of questions that pr...
- Question 67: You plan to deploy a database by using SQL Server 2014. Your...
- Question 68: Note: This question is part of a series of questions that us...
- Question 69: Note: This question is part of a series of questions that pr...
- Question 70: You have five servers that run Microsoft SQL Server, Each se...
- Question 71: You plan to implement a fault tolerance solution for a Micro...
- Question 72: A company has an on-premises Microsoft SQL Server environmen...
- Question 73: General Overview You are the Senior Database Administrator (...
- Question 74: Note: This question is part of a series of questions that pr...
- Question 75: Note: This question is part of a series of questions that us...
- Question 76: An organization deploys Microsoft SQL Server instances at a ...
- Question 77: You are a database administrator at Contoso, Ltd. You are pr...
- Question 78: You have a Microsoft SQL Server database named DB1. Nested a...
- Question 79: Note: This question is part of a series of questions that pr...
- Question 80: General Overview You are the Senior Database Administrator (...
- Question 81: You administer a Microsoft SQL Server 2016 server. When tran...
- Question 82: You store Microsoft SQL Server backups at an off-site locati...
- Question 83: Note: This question is part of a series of questions that pr...
- Question 84: You have a table that contains a column named Department. Ea...
- Question 85: You work as a Database Administrator (DBA) at ABC.com. You a...
- Question 86: Note: This question is part of a series of questions that us...
- Question 87: Note: This question is part of a series of questions that us...
- Question 88: Note: This question is part of a series of questions that pr...
- Question 89: You have a Microsoft SQL Server instance that has database n...
- Question 90: You administer all the deployments of Microsoft SQL Server 2...
- Question 91: Note: This question is part of a series of questions that pr...
- Question 92: You are configuring a new Microsoft SQL Server Always On Ava...
- Question 93: Note: This question is part of a series of questions that us...
- Question 94: You have 10 Microsoft SQL Server 2016 servers. You deploy a ...
- Question 95: Note: This question is part of a series of questions that pr...
- Question 96: Note: This question is part of a series of questions that pr...
- Question 97: You work as a Database Administrator (DBA) for a company nam...
- Question 98: Which feature should you enable and configure so session req...
- Question 99: You have a Microsoft SQL Server instance that hosts a databa...
- Question 100: Note: This question is part of a series of questions that pr...
