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

  1. Question 191: 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…
  2. Question 193: You have a database named DB1. Users report that a database application that updates the data in DB1 is unresponsive. You need to identify which process preven…
  3. Question 194: You have 10 Microsoft SQL Server 2016 servers. You deploy a management data warehouse named DW1. You configure DW1 to gather all the performance data from the…
  4. Question 201: General Overview - You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software a…
  5. Question 203: 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…
  6. Question 208: 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…
  7. Question 210: General Overview - You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software a…
  8. Question 211: You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. The company has a database named Products.…
  9. Question 212: You administer a Microsoft SQL Server 2016 database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?
  10. Question 218: 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…