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 20/100

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.
Start of repeated scenario
Contoso, Ltd. has Microsoft SQL Server databases that support a custom application. The current SQL Server environment consists of two servers: ContosoSQL1 and ContosoSQL2. These two servers participate in an Always On Availability Group named ContosoAG1 that is configured to use synchronous-commit with automatic failover. The secondary replica is not configured for read-only access.
The application performs both transactional processing and historical data retrieval in a database named ContosoDB. The application includes an inventory management module. The inventory management module and database have experienced performance issues.
Users report that a query named InventoryQuery1 takes a long time to complete. The query is shown as follows:
SELECT ProductNumber, Name, ProductLine
FROM Production.Product
WHERE ProductNumber = N'<specific product>'
The query plan used by SQL Server for this query is shown in the exhibit. (Click the Exhibit tab.) Various performance issues, including frequent long-term blocking episodes, prevent business users from completing their daily tasks. You suspect the tempdb database resources could be responsible. You must create Blocking reports for the ContosoDB database to identify issues.
Exhibit.

You plan to use Extended Events to review all Transact-SQL statements that are run against the ContosoSQL1 instance. The output from the Extended Events session must contain both start and stop events and must be written to a file. You must configure the Extended Events session to minimize possible data loss and reduce the effect on server performance.
You plan to deploy an additional secondary replica named ContosoSQL3 to ContosoAG1. Read-only traffic must be load-balanced between the two secondary replicas, regardless of which instance is the primary replica.
Contoso plans to add an additional dedicated reporting system that will rely on real-time data from the transactional databases.
The company plans to improve their high availability/disaster recovery (HA/DR) solution. As part of the planned improvements, you will back up all databases from ContosoSQL1 directly to an off-site location.
End of repeated scenario
You need to identify the issue with
What should you do?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

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...