Reference:
https://www.mssqltips.com/sqlservertip/6137/azure-data-factory-control-flow-activities-overview/ Basic Concept: This question tests task automation for database administration, including which Azure or SQL mechanism can run repeatable maintenance and configuration work.
Why D is Correct: Create a parent pipeline that contains the four pipelines and use a schedule trigger. matches the expected DP-300 administration action. Create a parent pipeline that contains the four pipelines and use a schedule trigger. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2.
Why A is Wrong: Add a schedule trigger to all four pipelines. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It does not meet the failover, restore, quorum, or cross-region continuity target stated in the question, even if it is valid in a different availability design.
Why B is Wrong: Add an event trigger to all four pipelines. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It handles a different resilience pattern and would not deliver the failover or recovery behavior required here.
Why C is Wrong: Create a parent pipeline that contains the four pipelines and use an event trigger. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It is not wrong technology in general, but it is the wrong HA/DR control for this scenario ' s failure model.