Free Microsoft 70-469 Exam Dumps Questions & Answers

You need to identify which long running transactions use an index.
Which dynamic management view should you use?

• A.sys.dm_exec_query_stats
• B.sys.dm_exec_sessions
• C.sys.dm_exec_query_optimizer_info
• D.sys.dm_exec_connections

You need to recommend an isolation level for usp_UpdateOrderDetails.
Which isolation level should recommend?

• A.Read committed
• B.Read uncommitted
• C.Serializable
• D.Repeatable read

DRAG DROP
You use SQL Server 2014 Enterprise Edition. Your database contains a partitioned table named AuditData. AuditData is partitioned by year. Partition 1 contains data from the year 2010 and prior.
Management has decided to archive all AUDITDATA records from 2010 and prior. Management wants the records to be removed from the database entirely and provided to the backup team as a zipped text file. The data must no longer reside in the database. There is very little tolerance for performance degradation in your environment.
You need to remove all 2010 and prior data from the AuditData table by using the least amount of system resources possible.
Develop the solution by selecting and arranging the required SQL actions in the correct order.
You may not need all of the actions.

Correct Answer:

DRAG DROP
You plan to install two SQL Server 2014 environments named Environment1 and Environment.
Your company identifies the following availability requirements for each environment:
- Environment1 must have mirroring with automatic failover implemented.
- Environment2 must have AlwaysOn with automatic failover implemented.
You need to identify the minimum number of SQL Server 2014 servers that must be deployed to each environment to ensure that all data remains available if a physical server fails.
How many servers should you identify?
To answer, drag the appropriate number to the correct environment in the answer area.

Correct Answer:

You plan to migrate an instance of SQL Server 2008 to a new installation of SQL Server 2012.
You need to migrate alerts and e-mail notifications.
Which system stored procedures should you use? (Each correct answer presents part of the solution. Choose all that apply.)

• A.sp_audit_write
• B.sp_add_alert
• C.sp_add_operator
• D.sp_syspolicy_create_job