- All Exams Instant Download
Which user account should you use?
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:...
Which features should you identify?
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...
What should you include in the recommendation?
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...
Which server should you recommend?
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...
Which of the following features must you install on the ETL server in addition to SSIS to accomplish this goal?
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...
In which order should you perform the actions?
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...
Which of the following failover types should you configure for the availability group?
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...
Which features should you identify?
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...
What should you do?
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:...
Which technologies should you recommend?
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...
