Administering a SQL Database Infrastructure Free Practice Exam Questions

141 real Administering a SQL Database Infrastructure exam questions with answers and AI explanations. Microsoft certification prep — page 9 of 15.

Question 134: You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a speci…
Question 137: 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 troubleshoo…
Question 138: You administer a Microsoft SQL Server 2016 instance. The instance contains a database that supports a retail sales application. The application generates hundr…
Question 140: 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…
Question 141: You deploy a database by using SQL Server 2014. The database contains a table named Table1. You need to recommend a solution to track all of the deletions exec…
Question 142: You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You need to identify which transaction causes the deadlo…
Question 143: 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. T…
Question 145: You have two SQL Server 2012 instances named SQLDev and SQLProd. You plan to create a new database on SQLProd that will use SQL Server Authentication. You need…
Question 146: Your company has offices in Seattle and Montreal. The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. The servers a…
Question 147: You have a server that has SQL Server 2014 installed. The server contains 100 user databases. You need to recommend a backup solution for the user databases. T…