70-761

Review 201 70-761 practice questions with answer explanations and community insights.

Question 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a table named Products by running the following Transact-SQL statement: You have the following stored procedure: You need to modify the stored procedure to meet the following new requirements: ✑ Insert product records as a single unit of work. ✑ Return error number 51000 when a product fails to insert into the database. ✑ If a product record insert operation fails, the product information must not be permanently written to the database. Solution: You run the following Transact-SQL statement: Does the solution meet the goal?

  1. Yes
  2. No

Question 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a table named Products by running the following Transact-SQL statement: You have the following stored procedure: You need to modify the stored procedure to meet the following new requirements: ✑ Insert product records as a single unit of work. ✑ Return error number 51000 when a product fails to insert into the database. ✑ If a product record insert operation fails, the product information must not be permanently written to the database. Solution: You run the following Transact-SQL statement: Does the solution meet the goal?

  1. Yes
  2. No

Question 3

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a table named Products by running the following Transact-SQL statement: You have the following stored procedure: You need to modify the stored procedure to meet the following new requirements: ✑ Insert product records as a single unit of work. ✑ Return error number 51000 when a product fails to insert into the database. If a product record insert operation fails, the product information must not be permanently written to the database. Solution: You run the following Transact-SQL statement: Does the solution meet the goal?

  1. Yes
  2. No

Question 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a table named Customer by running the following Transact-SQL statement: You must insert the following data into the Customer table: You need to ensure that both records are inserted or neither record is inserted. Solution: You run the following Transact-SQL statement: Does the solution meet the goal?

  1. Yes
  2. No

Question 5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a table named Customer by running the following Transact-SQL statement: You must insert the following data into the Customer table: You need to ensure that both records are inserted or neither record is inserted. Solution: You run the following Transact-SQL statement: Does the solution meet the goal?

  1. Yes
  2. No
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.