Free 70-764 sample questions
Real questions from the Administering a SQL Database Infrastructure practice bank, with the correct answer and an explanation for each one. No junk, no filler.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 4 of 8 free sample questions.
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?
4 more free samples are waiting
Create a free account to unlock the whole 70-764 sample bank, or get full access to all 49 practice questions in the simulator.