70-764 exam

You administer a Microsoft SQL Server 2016 server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long wait times when they submit data into the application. You need to identify which queries are taking longer than 1 second to run over an...

A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instancethat hosts a database named DB1. You need to ensure that you can perform auditing at the database level for DB1. Solution: You migrate DB1 to the default instance on a server...

You have an on-premises server that runs Microsoft SQL Server 2016 Standard Edition. You need to identify missing indexes. What should you use?A . Activity MonitorB . Sp_who3C . SQL Server Management Studio (SSMS) Object ExplorerD . SQL Server Data CollectorE . SQL Server Data Tools (SSDT)F . SQL Server...

You are the administrator of a Microsoft SQL Server 2016 server. Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications. You need to dynamically limit resource consumption. What should you do?A . Set up Service Broker to ensure that applications are not allowed...

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2016. You attempt to add the [CorpnetUser1] login to the database. However, you receive the following error message: "User already exists in current database." You need to configure the [CorpnetUser1] login to be able...

You administer a Microsoft SQL Server 2016 database that has Trustworthy set to On. You create a stored procedure that returns database-level information from Dynamic Management Views. You grant User1 access to execute the stored procedure. You need to ensure that the stored procedure returns the required information when User1...

HOTSPOT You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. You have an Always On Availability group named AG1. The details for AG1 are shown in the following table. Instance1...

You plan to create a database. The database will be used by a Microsoft .NET application for a special event that will last for two days. During the event, data must be highly available. After the event, the database will be deleted. You need to recommend a solution to implement...

You administer a Microsoft SQL Server 2016 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured...

You use Microsoft SQL Server 2016 to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking...