70-764

70-764 practice questions, page 8 of 14, with answer review and explanations.

Question 36

You have a test server that contains a database named DB1. Backups of the database are written to a single backup device. The backup device has a full, differential, and transaction log backup. You discover that the database is damaged. You restore the database to the point at which the differential backup was taken. You need to rebuild the database with data stored in the latest transaction logs. How should you complete the Transact-SQL statement? To answer. drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. Select and Place:

Question 37

You have a database named DB1 that is configured to use the full recovery model. You have a full daily backup job that runs at 02:00. The job backs up data from DB1 to the file B:\DB1.bak. You need to restore the DB1 database to the point in time of May 25, 2016 at 02:23 and ensure that the database is functional and starts to accept connections. Which Transact-SQL statement should you run? A. B. C. D.

Question 38

You manage a Microsoft-SQL Server database named sales Orders. You need to verify the integrity of the database and attempt to repair any errors that are found. Repair must not cause any data to be lost in the database. How should you complete the DBCC command? To answer, select the appropriate options in the answer area. Hot Area:

Question 39

You manage a Microsoft SQL Server environment. You have a database named salesOrders that includes a table named Table1. Table1 becomes corrupt. You repair the table. You need to verify that all the data in Table1 complies with the schema. How should you complete the Transact-SQL code statement? To answer, select the appropriate Transact-SQL code segments in the dialog box in the answer area. Hot Area:

Question 40

You are configuring a new Microsoft SQL Server Always On Availability Group. You plan to configure a shared network location at \\DATA-CI1\SQL. You need to create an availability group listener named AGL1 on port 1433. In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order. Select and Place: