Exam 70-767 topic 2 question 6 discussion

Actual exam question from Microsoft's 70-767

Question #: 6
Topic #: 2

You are developing a Microsoft SQL Server Data Warehouse. You use SQL Server Integration Services (SSIS) packages to import files from a Microsoft Azure blob storage to the data warehouse.
You plan to use multiple SQL Server instances and SSIS Scale Out to complete the workload faster.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct solution is worth one point.

A. Deploy the SSIS project to the SSIS catalog on all three SQL Servers in the SSIS Scale Out environment.
B. Install the SSIS Scale Out Worker feature on two servers. Install the Scale Out Master role feature on one server.
C. Deploy the SSIS project to the SSIS catalog on the SQL Server which has the Scale Out Master role installed.
D. Install the SSIS Scale Out Worker feature on all three servers. Install the Scale Out Master role on one server.

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/sql/integration-services/scale-out/walkthrough-set-up-integration-services-scale-out?view=sql-server-ver15

by ialberto at June 6, 2020, 3:50 p.m.