Administering Microsoft SQL Server 2012/2014 Databases Free Practice Exam Questions

48 real Administering Microsoft SQL Server 2012/2014 Databases exam questions with answers and AI explanations. Microsoft certification prep — page 2 of 5.

  1. Question 17: Which of the following statements will create an index called "SalesDate" on the DATEOFSALE column on the SALES table residing in the WAREHOUSE database?
  2. Question 18: Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the…
  3. Question 20: You want to remove SQL Server Integration Services from a server running the Windows Server 2008 R2 operating system that also has the Database Engine and SQL…
  4. Question 21: Which of the following SQL Server 2012 indexes stores data in a column-wise fashion instead of the traditional row-wise method?
  5. Question 22: You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the f…
  6. Question 23: Which of the following features can you install if you are installing SQL Server 2012 Enterprise edition on a computer running Windows Server 2008 R2 SP1 Enter…
  7. Question 28: You administer a Microsoft SQL Server. A process that normally runs in less than 10 seconds has been running for more than an hour. You examine the application…
  8. Question 29: You administer a Microsoft SQL Server instance. The instance contains a database that supports a retail sales application. The application generates hundreds o…
  9. Question 30: You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction. You discover that query performance on the table is poor du…
  10. Question 31: You manage a server that has SQL Server installed and hosts databases for five applications. Each application has a different login to the SQL Server instance.…