Practice Exam

Explanations for each answer:

• Add a Lookup activity to query ControlObject is correct. The Lookup activity is used to retrieve data from the control table containing the list of schemas and tables to be copied. This is the appropriate activity for querying database tables.
• Add a Get Metadata activity to query ControlObject is incorrect. Get metadata activities are used to retrieve metadata properties like file size and modification date, not to query database tables. For retrieving data from a control table, a Lookup activity is the appropriate choice.
• Add a ForEach activity to iterate over the list of tables from the Lookup result is correct. The ForEach activity is used to iterate over each table returned by the Lookup activity. This allows the pipeline to process each table individually in a single execution.
• Add an Until activity to iterate over the list of tables is incorrect. An Until activity is designed for conditional looping (repeating until a condition is met), not for iterating over a collection of items. A ForEach activity is the proper choice for iterating over the list of tables.
• Add a Copy data activity inside the ForEach activity is correct. The Copy data activity inside the ForEach loops processes each table individually, copying data from the source Azure SQL database to the Fabric lakehouse for each table in the control object.
• Add a Copy data activity inside an Until activity is incorrect. While Copy data activities can be used to copy data, they should be nested inside a ForEach activity (not Until) to iterate over the tables from the control object.
• Add a Script activity to manually define each table to copy is incorrect. Script activities execute code but are not needed for this metadata-driven approach. The combination of Lookup, ForEach, and Copy data activities handles the dynamic ingestion without manual table definitions.
• Add a Filter activity to filter the table list from ControlObject is incorrect. While filtering could be useful in some scenarios, it's not a required step for building the basic dynamic ingestion pipeline. The Lookup, ForEach, and Copy data activities form the core solution.