Microsoft MCTS 70-461

Access Routing and LAN Switching;Advanced Routing and Switching;APE;APE for Validating Knowledge;Architecture;
CCDA;CCDE; CCDP;CCENT;CCIE;CCIE Data Center;CCIP; CCNA;
CCNA Security;CCNA Wireless;CCNA Voice;CCNP;CCNP Data Center
;CCNP Service Provider; CCNP Wireless;CCNP Security;CCNP SP Operations; CCNP Voice;CCSP;CCVP;Cisco Express Foundation Field Specialist;Cisco Security Sales Specialist;Cisco Specialist;Cisco Virtual Classroom;Connected Grid;Content Networking;Data-Center;Field Technician;IP Communications;IronPort; Network Management; Optical;Others
;Proctored Exams for Validating Knowledge;Sales Expert; Security Specialist;Service Provider Video;SMB;SP Video
;Storage Networking; Substation Automation;TelePresence Video
;Unified Communications;VPN and Security; WAASSE; Wireless LAN

70-461 Querying SQL Server 2012 Der einfachste Weg für die IT-Prüfung vorzubereiten, ist die Praxis-Tests auf Zertifizierungsprüfung Muster zu nehmen und zu verstehen, die richtige sowie falsche Antwort Erklärungen Deine Zweifel klären. Lesen Sie dazu auch relevante technische Artikel zu versierter in der damit verbundenen Technologie.

Microsoft MCTS 70-461

1.You use SQL Server 2012 to develop a database application. You create a stored procedure named dbo.ModifyData that can modify rows. You need to ensure that when the transaction fails, dbo.ModifyData meets the following requirements:
Does not return an error
Closes all opened transactions
Which Transact-SQL statement should you use?

A. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ TRANCOUNT = 0
ROLLBACK TRANSACTION;
END CATCH
B. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ERROR != 0
ROLLBACK TRANSACTION;
THROW;
END CATCH
C. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@TRANCOUNT = 0
ROLLBACK TRANSACTION;
THROW;
END CATCH
D. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ERROR != 0
ROLLBACK TRANSACTION;
END CATCH

Answer: D

2.You are developing a database application by using SQL Server 2012. An application that uses a database begins to run slowly. You discover that during reads, the transaction experiences blocking from concurrent updates. You need to ensure that throughout the transaction the data maintains the original version. What should you do?

A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Answer: M

3.You are developing a database application by using SQL Server 2012. You have a query that runs slower than expected. You need to capture execution plans that will include detailed information on missing indexes recommended by the query optimizer. What should you do?

A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Answer: K

Microsoft MCTS 70-461