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

  1. Question 45: You have a SQL Server database named DB1. You plan to load 10 million rows to DB1 by running bcp.exe. You need to modify DB1 to minimize the amount of space re…
  2. Question 48: You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured. When SQL Server Agent jobs fail, the error messages retu…
  3. Question 50: You administer a Microsoft SQL Server 2012 default instance. The instance is hosted by a server that has a local firewall configured. The firewall only allows…
  4. Question 51: 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…
  5. Question 52: You have configured Resource Governor with three resource pools. You have assigned the first resource pool a minimum CPU and memory value of 20%. You have assi…
  6. Question 53: You install SQL Server on a new server named SQL1 and create several databases. Users report that they fail to connect to any of the databases on SQL1. You dis…
  7. Question 54: You administer a Microsoft SQL Server instance that contains a financial database hosted on a storage area network (SAN). The financial database has the follow…
  8. Question 55: You administer a Microsoft SQL Server database that includes a table named Application.Events. Application.Events contains millions of records about user activ…
  9. Question 56: You administer a Microsoft SQL Server database named Contoso that contains a single user-defined database role named BillingUsers. All objects in Contoso are i…
  10. Question 57: You administer a single server that contains a Microsoft SQL Server 2012 default instance on which several production databases have been deployed. You plan to…