- All Exams Instant Download
What should you do?
You administer a Microsoft SQL Server 2016 database named Orders. Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause. You need to gather more data to be able to determine which processes are being blocked...
What should you do?
You administer a Microsoft SQL Server 2016 server. The MSSQLSERVER service uses a domain account named CONTOSOSQLService. You plan to configure Instant File Initialization. You need to ensure that Data File Autogrow operations use Instant File Initialization. What should you do? Choose all that apply.A . Restart the SQL Server...
Which isolation level should recommend?
Overview You are a database administrator for a company named Litware, Inc. Litware is a book publishing house. Litware has a main office and a branch office. You are designing the database infrastructure to support a new web-based application that is being developed. The web application will be accessed at...
Which isolation levels should you recommend?
DRAG DROP You plan to deploy a database to SQL Azure. You are designing two stored procedures named USP_1 and USP_2 that have the following requirements: Prevent data read by USP_1 from being modified by other active processes. Allow USP_2 to perform dirty reads. You need to recommend the isolation...
Does the solution meet the goal?
You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail. Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Database Mail is...
What should you create?
You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01. You need to collect data for a long period of time to troubleshoot wait statistics when querying Contoso. You also need to ensure minimum impact to the server. What should you create?A . An AlertB...
Which of the following files will you generate by using SQL Server Setup to accomplish this goal?
You want to reproduce the same SQL Server 2016 installation configuration across five servers. Which of the following files will you generate by using SQL Server Setup to accomplish this goal?A . Configuration.xmlB . Setup.iniC . Setup.xmlD . ConfigurationFile.iniView AnswerAnswer: D
What should you use?
You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table. You need to monitor...
What should you configure?
General Overview You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements. Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application...
What should you include in the recommendation?
Overview General Overview A Datum Corporation has offices in Miami and Montreal. The network contains a single Active Directory forest named adatum.com. The offices connect to each other by using a WAN link that has 5-ms latency. A. Datum standardizes its database platform by using SQL Server 2014 Enterprise edition....
