Microsoft DP-700: Implement and manage an analytics solution Practice Questions

Automatic executor scaling (dynamic allocation) allows Spark to automatically add or remove executors based on workload, releasing idle compute resources while keeping the session alive for active jobs. High Concurrency mode allows multiple users to share a Spark session but does not specifically manage idle resource release. Session-level Spark pool customization lets users override pool settings per session but doesn't automatically release idle resources. The Starter pool configuration adjusts initial pool size but doesn't dynamically scale during idle periods.

'Apply sensitivity labels from data sources to their data in Power BI' is the tenant setting that enables sensitivity label inheritance, ensuring that reports and other downstream artifacts inherit the label of their source semantic model. 'Automatically apply sensitivity labels to new content' applies a default label to new items but does not propagate labels from an upstream source. 'Allow workspace admins to override automatically applied sensitivity labels' is a governance relaxation setting, not an inheritance enforcement setting. 'Inherit the sensitivity label from the data source when creating new content in Fabric' describes a similar concept but is not an actual distinct Admin portal setting—the correct setting name is the first option.

Three components are required: (1) Install the on-premises data gateway on a machine in the on-premises network — the gateway initiates outbound connections to Microsoft cloud services, so no inbound ports need to be opened. (2) Register and configure the gateway in the Power Platform admin center and associate it with the appropriate workspace or capacity so Fabric can route requests through it. (3) Configure the Dataflows Gen2 data source connection to use the registered gateway for SQL Server connectivity. Opening inbound port 1433 violates IT policy and is unnecessary because the gateway uses outbound connections only. There is no specific 'Allow Dataflows Gen2 to use on-premises gateways' tenant switch required; gateway usage is controlled through gateway registration and data source configuration. A VNet data gateway with ExpressRoute is an alternative for Azure-hosted sources but adds unnecessary complexity for a straightforward on-premises SQL Server scenario.

Execute Pipeline activity with 'Wait on completion' enabled ensures sequential execution — the master pipeline waits for each child pipeline to finish before proceeding, satisfying the dependency chain between notebook, dimension load, and fact load steps. The If Condition activity evaluates expressions such as '@equals(activity('NotebookActivity').status, 'Failed')' or checks the overall pipeline result, enabling conditional routing to a notification activity (e.g., an Office 365 Outlook or Web activity) when any step fails. Using a Web activity to poll asynchronously adds unnecessary complexity when the built-in 'Wait on completion' option already handles synchronous execution. A Set Variable + Until loop is a workaround pattern for async polling and is not needed here. A Lookup activity retrieves data from a data store, not notebook execution results, and cannot be used to evaluate activity success/failure for conditional branching. A Switch activity routes based on a value expression with multiple cases but is designed for multi-branch routing, not for sequential dependency enforcement with failure handling.

Promoted is the endorsement level that workspace contributors (or above) can self-apply to indicate that an item is quality-assured and ready for broader use, without requiring any admin privileges. It allows the Finance data owners to designate their items as trustworthy after internal review. Certified is the higher endorsement tier and requires the user to be specifically authorized in tenant settings by a Fabric/Power BI administrator — it cannot be self-applied by ordinary workspace members, making it unsuitable given the 'no admin privileges required' constraint. The option stating Certified can be applied by any Member is incorrect — Certified has a tenant-controlled certifier list. The option stating Promoted requires a Power BI service administrator is incorrect — Promoted is self-service by workspace contributors. 'Trusted' is not a valid Fabric endorsement level; Fabric supports Promoted and Certified only.