70-764

You administer a SQL Server 2016 database instance. You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use?A . A domain userB . The BUILTINSYSTEM accountC . A local user with Run as Service permissionsD . The SQLBrowser accountView AnswerAnswer:...

DRAG DROP You plan to deploy SQL Server 2014. Your company identifies the following monitoring requirements: Tempdb must be monitored for insufficient free space. Deadlocks must be analyzed by using Deadlock graphs. You need to identify which feature meets each monitoring requirement. Which features should you identify? To answer, drag...

You have a SQL Server 2012 database named DB1. You plan to import a large number of records from a SQL Azure database to DB1. You need to recommend a solution to minimize the amount of space used in the transaction log during the import operation. What should you include...

You have a SQL Server 2014 environment That includes four servers. The servers are configured as shown in the following table. You plan to configure Policy-Based Management to enforce the following rules: On Server1, enable SQL Server password policies and enable the default trace. On Server3, ensure that the names...

You are planning on deploying a server that will be dedicated for ETL (Extraction, Transformation, and Loading) processes. You want to ensure that SSIS (SQL Server Integration Services) packages will run on this dedicated ETL server and not on any other server on which they were started. Which of the...

DRAG DROP You are configuring a new Microsoft SQL Server Always On Availability Group. You plan to configure a shared network location at \DATA-CI1SQL. You need to create an availability group listener named AGL1 on port 1433. In which order should you perform the actions? To answer, move all actions...

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are configuring a highly-available database solution using an AlwaysOn availability group on two servers running SQL Server 2012. The two servers are in separate datacenters. The two datacenters...

DRAG DROP You plan to deploy SQL Server 2014. Your company identifies the following monitoring requirements for the database: An e-mail message must be sent when a user logs in. An e-mail message must be sent if CPU utilization exceeds 90 percent. You need to identify which feature meets each...

You administer a Microsoft SQL Server 2016 instance. You need to stop a blocking process that has an SPID of 64 without stopping other processes. What should you do?A . Execute the following Transact-SQL statement: EXECUTE sp_KillSPID 64B . Restart the SQL Server service.C . Execute the following Transact-SQL statement:...

DRAG DROP You are designing an authentication strategy for a new server that has SQL Server 2014 installed. The strategy must meet the following business requirements: The account used to generate reports must be allowed to make a connection during certain hours only. Failed authentication requests must be logged. You...