Online Access Free 70-459 Exam Questions

You need to recommend a solution to synchronize Database2 to App1_Db1. What should you recommend?

• A.Transactional replication
• B.Master Data Services
• C.Snapshot replication
• D.Change data capture

DRAG DROP
You need to build a stored procedure that amortizes the invoice amount. Which code segment should you use to create the stored procedure? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
Build List and Reorder:

Correct Answer:

You need to modify the stored procedure usp.LookupConcurrentUsers.
What should you do?

• A.Use a table variable instead of the summary table.
• B.Add a nonclustered index to the summary table.
• C.Add a clustered index to the summary table.
• D.Add a clustered columnstore index to the summary table.

You need to recommend a change to sp3 to ensure that the procedure completes only if all of the UPDATE statements complete.
Which change should you recommend?

• A.Set the IMPLICIT_TRANSACTIONS option to off.
• B.Set the XACT_ABORT option to off
• C.Set the XACT_ABORT option to on.
• D.Set the IMPLICIT_TRANSACTIONS option to on.

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.
You plan to synchronize SQLDev and SQLProd.
You need to recommend a solution that meets the following requirements:
- The database schemas must be synchronized from SQLDev to SQLProd. - The database on SQLDev must be deployed to SQLProd by using a package. - The package must support being deployed to SQL Azure.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.a data-tier application
• B.a database snapshot
• C.SQL Server Integration Services (SSIS)
• D.SQL Data Sync
• E.change data capture