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

Question 86: You are the administrator of a Microsoft SQL Server 2016 server. Some applications consume significant resources. You need to manage the server workload by res…
Question 87: You administer a Microsoft SQL Server 2016 database that includes a table named dbo.Log. This table contains millions of records about user activity in an appl…
Question 88: You administer a Microsoft SQL Server 2016 database named Orders. Users report that during peak usage periods, certain operations are taking more time than exp…
Question 89: You administer a Microsoft SQL Server 2016 database. Users report that a billing application becomes unresponsive during busy times of the day. While investiga…
Question 90: You install Microsoft SQL Server 2016 on a new server. After setup is complete, you attempt to start the SQL Server service. After being in a starting state fo…
Question 91: 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 shou…
Question 93: You administer a Microsoft SQL Server 2016 database. The database is currently configured to log ship to a secondary server. You are preparing to cut over to t…
Question 94: You administer a Microsoft SQL Server 2016 database. You want to make a full backup of the database to a file on disk. In doing so, you need to output the prog…
Question 95: 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 96: 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…