DRAG DROP -You administer a Microsoft SQL Server database.The database is backed up according to the following schedule:✑ Daily full backup at 23:00 hours.✑ Differential backups on the hour, except at 23:00 hours.✑ Log backups every 10 minutes from the hour, except on the hour.The database uses the Full recovery model.A developer accidentally drops a number of tables and stored procedures from the database between 22:40 hours and 23:10 hours. You perform a database restore at 23:30 hours to recover the dropped table.You need to restore the database by using the minimum amount of administrative effort.You also need to ensure minimal data loss.Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
DRAG DROP -You administer a Microsoft SQL Server instance that contains a database of confidential data.You need to encrypt the database files at the page level. You also need to encrypt the transaction log files.Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
DRAG DROP -You administer three Microsoft SQL Server 2012 servers named ServerA, ServerB, and ServerC.ServerA is the acting principal and ServerB is the mirror.You need to add ServerC as a witness to the existing mirroring session between ServerA and ServerB.You need to achieve this goal without delaying synchronization.Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
You administer a Microsoft SQL Server server. You plan to deploy new features to an application.You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.What should you do?
You administer a Microsoft SQL Server database.You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01.You need to configure the availability group to prevent data loss. In the event of a database failure, the designed secondary database must come online automatically.Which Transact-SQL statement should you use?
You are the lead database administrator (DBA) of a Microsoft SQL Server environment.All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL Server.You need to create a server role named SpecialDBARole that can perform the following functions:✑ View all databases.✑ View the server state.✑ Assign GRANT, DENY, and REVOKE permissions on logins.You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least level of privileges necessary.Which three SQL statements should you use? Each correct answer presents part of the solution.
