Microsoft 70-767 Questions Answers

You work as a database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.
You have been asked to revise a SQL Server Integration Services (SSIS) package. The package only includes Execute SQL tasks.
To make sure that, in the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks is rolled back. To do this, you want to alter the TransactionOption property of the package.
Which of the following is the value that must be set for the TransactionOption property of the package?

A. NotSupported.
B. Supported.
C. NotRequired.
D. Required.

Answer: D



You work as a senior database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL
Server 2012 in their environment.
You are hosting a training exercise for ABC.com's junior database developers. You are currently discussing an EventHandlerClass property that is used to retrieve or configure a value that indicates whether the container participates in transactions.
Which of the following is the EventHandlerClass property that you are discussing?

A. The TransactionOption property.
B. The Executables property.
C. The LoggingOptions property.
D. The Variables property.

Answer: A

https://www.microsoft.com/en-us/learning/exam-70-767.aspx

https://www.knowledge4sure.com/70-767-exam-questions.html