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

  1. Question 123: You administer a Microsoft SQL Server 2016 database that contains a table named AccountTransaction. You discover that query performance on the table is poor du…
  2. Question 124: You administer a Microsoft SQL Server 2016 failover cluster. You need to ensure that a failover occurs when the server diagnostics returns query_processing err…
  3. Question 125: You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities for your organization's SQL Server 2016 deployment. Which of the followin…
  4. Question 126: You are planning on deploying a server that will be dedicated for ETL (Extraction, Transformation, and Loading) processes. You want to ensure that SSIS (SQL Se…
  5. Question 127: You want to reproduce the same SQL Server 2016 installation configuration across five servers. Which of the following files will you generate by using SQL Serv…
  6. Question 128: Which feature should you enable and configure so session requests addressed to a specific instance can be allocated different processor resources based on sess…
  7. Question 129: You are the lead database administrator (DBA) of a Microsoft SQL Server 2016 environment. All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You…
  8. Question 130: You administer a Microsoft SQL Server 2016 database that has Trustworthy set to On. You create a stored procedure that returns database-level information from…
  9. Question 131: You administer a Microsoft SQL Server 2016 Enterprise Edition server that uses 64 cores. You discover performance issues when large amounts of data are written…
  10. Question 132: You administer a Microsoft SQL Server 2016 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non- clustered in…