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

  1. Question 2: You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a Windows Server 2008 R2 64-bit server. You need to migrate the databases to a…
  2. Question 4: You administer a Microsoft SQL Server database instance. You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jo…
  3. Question 5: You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from SQL Server 2008 to SQL Server 2012. You wan…
  4. Question 7: You are developing a database application by using Microsoft SQL Server 2012. You have a query that runs slower than expected. You need to capture execution pl…
  5. Question 8: Which of the following SQL Server 2012 database is NOT created by default in a new installation?
  6. Question 9: You administer a Microsoft Azure SQL Database database named Orders. Users report that a query that filters on OrderDate is taking an exceptionally long time.…
  7. Question 10: You administer a Microsoft SQL Server database named Orders. Users report that during peak usage periods, certain operations are taking more time than expected…
  8. Question 11: You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named Quotes. The table has no indexes and consists of seven…
  9. Question 13: You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundr…
  10. Question 16: You are the lead database administrator (DBA) of a Microsoft SQL Server environment. All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You gran…