Practice Exam

Explanations for each answer:

• Download the data to your computer, then use Lakehouse explorer to upload it to TRAINHOUSE is incorrect. Manual data transfer is completely unsuitable for this scenario. It cannot run on a schedule (requires manual execution each week), provides no monitoring or error handling, is inefficient and time-consuming, requires unnecessary local storage and network bandwidth, and is prone to human error.
• Use Dataflow Gen2 is incorrect. Dataflow Gen2 is designed for data transformation and preparation, not for simple data ingestion. While it can be scheduled, it adds unnecessary complexity and processing overhead when no transformations are needed.
• Use a Spark notebook is incorrect. While Spark notebooks can handle data ingestion and can be scheduled, they require coding and development skills to write and maintain the PySpark or Scala code. This violates the requirement for a no-code solution.
• Use the Copy activity in a pipeline is correct. The Copy activity in a Data Pipeline is the ideal solution. It provides a no-code visual interface, supports scheduled execution, includes built-in monitoring and error handling, is cost-effective for simple data movement, and is specifically designed for copying data between storage systems without transformations.