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

Question 74: You administer all the deployments of Microsoft SQL Server 2016 in your company. A database contains a large product catalog that is updated periodically. You…
Question 77: You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA. Currently, Server01l/HA is the primary repl…
Question 78: You administer a Microsoft SQL Server 2016 instance that has several SQL Server Agent jobs configured. SQL Server Agent jobs fail, the error messages returned…
Question 79: You administer a Microsoft SQL Server 2016 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server…
Question 80: You administer a Microsoft SQL Server 2016 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need t…
Question 81: You administer two instances of Microsoft SQL Server 2016. You deploy an application that uses a database on the named instance. The application is unable to c…
Question 82: You administer a Microsoft SQL Server 2016 database. Users report that an application that accesses the database displays an error, but the error does not prov…
Question 83: You use Microsoft SQL Server 2016 to write code for a transaction that contains several statements. There is high contention between readers and writers on sev…
Question 84: You plan to migrate the db to azure. You verify that all objects are valid for azure sql database. You need to ensure that users and logins are migrated to azu…
Question 85: You administer a Microsoft SQL Server 2016 database instance. You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Age…