Data Factory must nightly copy data from a private on-premises SQL Server reachable only inside the company network. Which two components should be planned? Select 2 answers.

Select all that apply. Every correct option and no extras are required for credit in the app.

A.Azure-SSIS runtime merely because the source database is SQL Server, even though no SSIS package exists
B.A supported self-hosted integration runtime with source network access
C.Only a cloud linked-service password, because credentials create the network route
D.A linked service with correct credentials plus routes, firewall, and DNS reachability

Show the answer and explanation

✓ Correct answers

A supported self-hosted integration runtime with source network access
A linked service with correct credentials plus routes, firewall, and DNS reachability

Self-hosted runtime reaches supported private sources; connection credentials and network reachability both matter. Authentication cannot create routes, and Azure-SSIS is for supported existing SSIS package execution rather than every SQL source. Source guide: PDF page 33.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.