You have four databases that are accessed by using an Online Transaction Processing (OLTP) application. The databases are stored on a server named SQL1 that has SQL Server 2014 installed. You plan to deploy an additional server that has SQL…
You administer a SQL Server 2014 instance. Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing issues. You want to write a query of…
You are designing a monitoring application for a new SQL Server 2014 instance. You need to recommend a solution to generate a report that displays the 10 most frequent wait types that occur for the instance. What should you include…
You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows. You need to recommend a repeatable method to migrate the database to SQL Azure. Which method should you recommend? More than one answer choice…
You are designing a database named DB1. Changes will be deployed to DB1 every Wednesday night. You need to recommend a strategy to deploy the changes to DB1. The strategy must meet the following requirements: . The strategy must not…
You are building a stored procedure for a Windows Azure SQL Database. The procedure will add multiple rows to a table. You need to design the stored procedure to meet the following requirements: If any of the new rows violates…
DRAG DROP You are the senior database administrator at Contoso, Ltd. You manage a SQL Server 2014 Instance, with multiple databases used for reporting. You have recently hired a junior database administrator. You want this person to be able to…
You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store and reuse the credit card numbers in the database. What should you recommend? More than one…
You have a query that is used by a reporting dashboard. Users report that the query sometimes takes a long time to run. You need to recommend a solution to identify what is causing the issue. What should you recommend?…
You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You need to identify the isolation level used by the query when a deadlock occurs. What should you do? More than one answer choice may achieve…