Administering a SQL Database Infrastructure Free Sample Questions

Your company’s environment includes on-premises Microsoft SQL Server as well as Microsoft Azure SQL Database instances. A number of client databases are hosted in this environment.

A client has complained that query completion in their on-premises instance takes longer than necessary.

You are required to make sure that the query optimizer is able to use the optimal query execution plans available by reconfiguring table statistics.

Solution: You make use of the UPDATE STATISTICS Transact-SQL segment.

Does the solution meet the goal?

Your company makes use of SQL Server 2014 in their environment.

You have been tasked with deploying a database. You have been informed that stored procedures should start with "usp_" at all times. You need to make use of the correct feature to achieve this goal.

Solution: You make use of the change data capture feature.

Does the solution meet the goal?

Your company has a Microsoft SQL Server 2016 database hosted on a server running Windows Server 2012.

You have been tasked with tracking SELECT statements issued in the database by users in a specific role only.

Solution: You create a policy.

Does the solution meet the goal?

Your company has a Microsoft SQL Server database that is accessed by users via a client application.

The database storage experiences a failure, which results in the application being unable to connect to the database.

You want to make sure that the database is repaired, and that a connection can be established via the client application.

Solution: You start by placing the database in single-user mode.

Does the solution meet the goal?