Online Access Free 070-462 Practice Test

You administer a Microsoft SQL Server database.
The database is in the Simple recovery mode.
You schedule the following backup plan:
* Full backup every day at midnight
* Differential backups every hour on the hour, except at midnight
The database fails at 20:45 hours.
You need to use SQL Server Management Studio (SSMS) to begin restoring the database with a minimum amount of data loss.
Which options should you select on the Options page of the Restore Database window? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Correct Answer:

Explanation

First, restore full database backup, differential database backup and all transaction log backups WITH NORECOVERY Option. After that, bring back database online using WITH RECOVERY option.
References:
https://blog.sqlauthority.com/2009/07/15/sql-server-restore-sequence-and-understanding-norecovery-and-recove

You use a Microsoft SQL Server 2012 database. You need to create an indexed view within the database for a report that displays Customer Name and the total revenue for that customer.
Which four T-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)

Correct Answer:

Explanation

References:

You administer a Microsoft SQL Server database named Orders.
Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause.
You need to gather more data to be able to determine which processes are being blocked and to identify the root cause.
What should you do?

• A.Start a trace using SQL Server Profiler to catch the Lock: Timeout event.
• B.Use sp_configure to set the blocked process threshold. Start a trace using SQL Server Profiler to catch the Blocked Process Report event.
• C.Use System Monitor to catch the Lock Wait Time event.
• D.Schedule a SQL Agent job to run every 60 seconds and insert the results of executing the sp_who2 stored procedure into a table.

Which of the following permissions must a user have in order to query all of the built-in Dynamic Management views?

• A.VIEW SERVER STATE
• B.VIEW ALL
• C.SELECT ALL VEWS
• D.VIEW SERVER INFO

You administer a Microsoft SQL Server 2012 database instance. Other applications run on the server. Some of the applications are throwing errors because of insufficient memory.
You need to ensure that the other applications have sufficient memory.
Which setting should you configure?

Correct Answer:

Explanation