BenchMark Quizzes by MDFT Pro

Copy Data From On-Premises To Warehouse

You work as a Data Migration Specialist for Mark at MDFT Pro, a well-known training agency. MDFT Pro operates a Fabric workspace that contains a warehouse named Warehouse1, which is being set up to consolidate all the agency’s reporting data. Currently, MDFT Pro has an on-premises Microsoft SQL Server database named Database1 that stores legacy student enrollment records, course schedules, and trainer assignments. This on-premises database is accessible through an on-premises data gateway that has already been configured. Mark has tasked you with migrating the data from Database1 to Warehouse1 to enable modern analytics and reporting capabilities for the training agency’s operations team.

Which item should you use to copy the data?

Choose the correct answer from the options below.

Explanations for each answer:

A Dataflow Gen1 dataflow is incorrect. Dataflow Gen1 is primarily designed for data transformation and loading into Power BI datasets, not for direct loading into Fabric warehouses. Dataflow Gen2 would be more appropriate, but a data pipeline is the recommended approach for warehouse loads.
A data pipeline is correct. Data pipelines in Fabric support the Copy Data activity, which can connect to on-premises SQL Server through a data gateway and efficiently copy data to a Fabric warehouse. This is the recommended approach for warehouse data ingestion.
A KQL queryset is incorrect. KQL querysets are used for querying data in KQL databases or Real-Time Analytics, not for copying data from on-premises SQL Server to a Fabric warehouse.
A notebook is incorrect. While notebooks can be used to copy data, they require custom code and are not the recommended approach for simple data copy operations. Data pipelines provide a more robust, no-code solution with better monitoring and error handling.

Learn more about data pipelines in Fabric:

Fabric Data Pipelines

Practice Exam

Copy Data From On-Premises To Warehouse

Discuss this question on social media: