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 14 of 15.

Question 237: You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You need to identify the isolation level used by the que…
Question 238: Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the…
Question 240: You administer several Microsoft SQL Server 2016 database servers. Merge replication has been configured for an application that is distributed across offices…
Question 241: You have a SQL Server 2014 instance named SQL1. SQL1 creates error events in the Windows Application event log. You need to recommend a solution that will run…
Question 243: 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 ide…
Question 244: You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01. You need to write messages to the Application Log when users are…
Question 245: You work as a Database Administrator (DBA) at ABC.com. You are in the process of deploying new servers running SQL Server 2012. You need to deploy a SQL Server…
Question 249: You are creating a database that will store usernames and passwords for an application. You need to recommend a solution to store the passwords in the database…
Question 250: Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in…
Question 251: You administer a Microsoft SQL Server 2016 database instance. You plan to migrate the database to Windows Azure SQL Database. You verify that all objects conta…