Online Access Free 070-469 Exam Questions

You need to recommend a solution for the error handling of USP_3. The solution must minimize the amount of custom code required.
What should you recommend?

• A.Use the @@ERROR variable in the nested stored procedures.
• B.Use the @@ERROR variable in the called stored procedures.
• C.Use a TRY CATCH block in the called stored procedures.
• D.Use the RAISERROR command in the nested stored procedures.

You need to implement a solution that addresses the bulk insert requirements. What should you add to line 08 in usp_ImportOrderDetails?

• A.BATCHSIZE=1000.
• B.LASTROW = 1000.
• C.BATCHSIZE=0.
• D.LASTROW=0.

You have a SQL Server 2012 database named DB1. You have a backup device named Device1.
You discover that the log file for the database is full.
You need to ensure that DB1 can complete transactions. The solution must not affect the chain of log sequence numbers (LSNs).
Which code segment should you execute?

• A.BACKUP LOG DB1 TO Device1
• B.BACKUP LOG DB1 TO Device1 WITH NORECOVERY
• C.BACKUP LOG DB1 TO Device1 WITH COPY_ONLY
• D.BACKUP LOG DB1 TO Device1 WITH TRUNCATE_ONLY

DRAG DROP
You plan to deploy two stored procedures named SP1 and SP2 that read data from the database.
Your company identifies the following requirements for each stored procedure:
- SP1 must allow dirty reads.
- SP2 must place range locks on the data to ensure read consistency.
You need to identify which isolation level you must set for each stored procedure. The solution must minimize the number of locks.
Which isolation level should you identify?
To answer, drag the appropriate isolation level to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)

Correct Answer:

You need to recommend a disaster recovery strategy for the Inventory database.
What should you include in the recommendation?

• A.SQL Server Failover Clustering
• B.Peer-to-peer replication
• C.AlwaysOn availability groups
• D.Log shipping