DP-203 Practice Question: Drag and drop the steps to convert data from CSV…

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✓

  Define source CSV dataset, then define sink Parquet dataset, then create copy activity with mapping, then run and monitor.

  Why this is correct

  This is the correct order because you must first define the source and sink datasets before creating a copy activity that uses them. The copy activity requires both datasets to be defined. After setting the mapping, you run and monitor the pipeline.

• ✗

  Define sink Parquet dataset, then define source CSV dataset, then create copy activity with mapping, then run and monitor.

  Why it's wrong here

  This is incorrect because although the sink dataset is defined before the source, the order of defining datasets does not affect the pipeline as long as both are defined before the copy activity. However, the typical sequence is source first, then sink, but it's not a critical error. The bigger issue: the order is plausible but not the most logical, and some might argue it's still valid, but in a drag-and-drop question, the expected correct order is source then sink.

• ✗

  Define source CSV dataset, then create copy activity with mapping, then define sink Parquet dataset, then run and monitor.

  Why it's wrong here

  This is incorrect because you cannot create a copy activity with mapping before defining the sink dataset. The sink dataset must be defined before or at the time of creating the copy activity, as the activity references it.

• ✗

  Create copy activity with mapping, then define source CSV dataset, then define sink Parquet dataset, then run and monitor.

  Why it's wrong here

  This is incorrect because the copy activity requires both source and sink datasets to be defined before it can be created. Creating the activity first without datasets would result in an error.

Go deeper

Related to this question