What should you do?

Correct Answer for the following Question is given below

You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database.The package contains a data flow task that has seven source-to-destination execution trees.Only three of the source-to-destination execution trees are running in parallel.You need to ensure that all the execution trees run in parallel.What should you do?

Question:

What should you do?

Options:

Set the EngineThreads property of the data flow task to 7.

Set the MaxConcurrentExcecutables property of the package to 7.

Create seven data flow tasks that contain one source-to-destination execution tree each.

Place the data flow task in a For Loop container that is configured to execute seven times.

Correct Answer

The Correct Answer for this Question is

Set the EngineThreads property of the data flow task to 7.

Explanation

The Question – What should you do? has been answered correctly and answers for the question is Set the EngineThreads property of the data flow task to 7.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment