Microsoft 70-761 - Querying Data with Transact-SQL Exam
Page: 1 / 41
Total 205 questions
Question #1 (Topic: Topic 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:
[Microsoft-70-761-1.0/xmlfile-2_1.png]
You have the following stored procedure:
[Microsoft-70-761-1.0/xmlfile-2_2.png]
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:
[Microsoft-70-761-1.0/xmlfile-3_1.png]
Does the solution meet the goal?
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:
[Microsoft-70-761-1.0/xmlfile-2_1.png]
You have the following stored procedure:
[Microsoft-70-761-1.0/xmlfile-2_2.png]
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:
[Microsoft-70-761-1.0/xmlfile-3_1.png]
Does the solution meet the goal?
A. Yes
B. No
Answer: B
Question #2 (Topic: Topic 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:
[Microsoft-70-761-1.0/xmlfile-4_4.png]
You have the following stored procedure:
[Microsoft-70-761-1.0/xmlfile-4_5.png]
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:
[Microsoft-70-761-1.0/xmlfile-5_4.png]
Does the solution meet the goal?
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:
[Microsoft-70-761-1.0/xmlfile-4_4.png]
You have the following stored procedure:
[Microsoft-70-761-1.0/xmlfile-4_5.png]
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:
[Microsoft-70-761-1.0/xmlfile-5_4.png]
Does the solution meet the goal?
A. Yes
B. No
Answer: B
Question #3 (Topic: Topic 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:
[Microsoft-70-761-1.0/xmlfile-6_1.png]
You have the following stored procedure:
[Microsoft-70-761-1.0/xmlfile-6_2.png]
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.
[Microsoft-70-761-1.0/xmlfile-6_5.png]
Solution: You run the following Transact-SQL statement:
[Microsoft-70-761-1.0/xmlfile-7_1.png]
Does the solution meet the goal?
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:
[Microsoft-70-761-1.0/xmlfile-6_1.png]
You have the following stored procedure:
[Microsoft-70-761-1.0/xmlfile-6_2.png]
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.
[Microsoft-70-761-1.0/xmlfile-6_5.png]
Solution: You run the following Transact-SQL statement:
[Microsoft-70-761-1.0/xmlfile-7_1.png]
Does the solution meet the goal?
A. Yes
B. No
Answer: A
Question #4 (Topic: Topic 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 Customer by running the following Transact-SQL statement:
[Microsoft-70-761-1.0/xmlfile-8_1.png]
You must insert the following data into the Customer table:
[Microsoft-70-761-1.0/xmlfile-8_2.png]
You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:
[Microsoft-70-761-1.0/xmlfile-8_3.png]
Does the solution meet the goal?
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:
[Microsoft-70-761-1.0/xmlfile-8_1.png]
You must insert the following data into the Customer table:
[Microsoft-70-761-1.0/xmlfile-8_2.png]
You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:
[Microsoft-70-761-1.0/xmlfile-8_3.png]
Does the solution meet the goal?
A. Yes
B. No
Answer: B
Question #5 (Topic: Topic 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 Customer by running the following Transact-SQL statement:
[Microsoft-70-761-1.0/xmlfile-9_1.png]
You must insert the following data into the Customer table:
[Microsoft-70-761-1.0/xmlfile-10_1.png]
You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:
[Microsoft-70-761-1.0/xmlfile-10_2.png]
Does the solution meet the goal?
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:
[Microsoft-70-761-1.0/xmlfile-9_1.png]
You must insert the following data into the Customer table:
[Microsoft-70-761-1.0/xmlfile-10_1.png]
You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:
[Microsoft-70-761-1.0/xmlfile-10_2.png]
Does the solution meet the goal?
A. Yes
B. No
Answer: B
