No account needed. Every question has a worked explanation, just like the full bank.
lock_openFree samplePrepare the Datamedium
An analyst uses Power BI dataflows in the service and also Power Query in Power BI Desktop. The Power Query Online experience and Power Query for Desktop expose almost the same user experience for shaping data in every scenario. Is this statement correct?
- AYescheck_circle Correct
- BNo
Power Query Online and Power Query Desktop deliver almost the same user experience for shaping data. The Power Query overview explicitly notes that although two Power Query experiences exist, Online and Desktop, both provide almost the same user experience in every scenario.
Why A is correct: Correct. The Power Query overview explicitly notes that although two Power Query experiences exist, Online and Desktop, both provide almost the same user experience in every scenario.
Why B is wrong: The two experiences differ in a few features, such as fuzzy grouping being Online-only and Percentile and Count distinct values aggregations being Online-only, but the overall ribbon-driven shaping experience is parity-matched.
lock_openFree sampleVisualize and Analyze the Dataeasy
A pricing team needs a visual that reveals correlations and clusters between unit price and units sold across hundreds of SKUs. Which built-in visual matches the documented intent?
- AUse a stacked column chart with unit price as the legend across each SKU.
- BUse a scatter chart with unit price on one axis and units sold on the other.check_circle Correct
- CUse a donut chart with each SKU contributing a slice of the total.
- DUse a card visual showing the average of unit price across the SKU population.
Scatter charts are the documented choice for surfacing correlation between two numerical measures. Scatter charts plot data points at the intersection of two numerical values, revealing correlations and clusters. That is the documented use case for comparing price and volume across many SKUs.
Why A is wrong: Stacked columns compare category totals, not the intersection of two numerical measures across many points.
Why B is correct: Correct. Scatter charts plot data points at the intersection of two numerical values, revealing correlations and clusters.
Why C is wrong: Donut charts show part-to-whole composition for a small number of categories, not correlation.
Why D is wrong: Card visuals display a single fact and cannot reveal pairwise correlation or clustering between two measures.
lock_openFree sampleDeploy and Maintain Assetsmedium
An analyst is creating a collaborative workspace and expands the Advanced section in the Settings pane. Which optional settings can be configured at workspace creation? (Select 3 answers)
- AUpload a workspace image as a .png or .jpg file under 45 KB.check_circle Correct
- BSpecify a Workspace OneDrive backed by a Microsoft 365 Group document library.check_circle Correct
- CAllow contributors to update the app for the workspace through a delegation toggle.check_circle Correct
- DAdd multiple Power BI tenants as backing capacities for the workspace.
- EConfigure a custom OAuth identity provider for the workspace at creation time.
Workspace image (under 45 KB), OneDrive backing, and the contributor app-update toggle are all set in the Advanced settings pane at creation. The Settings pane exposes workspace image (.png or .jpg under 45 KB), Workspace OneDrive linkage, a Contact list, the contributor app-update delegation toggle, Premium capacity assignment, and Azure Data Lake Gen2 connection. The three correct answers are all listed; tenant federation and identity providers are out of scope.
Why A is correct: Correct. Upload a workspace image as a .png or .jpg file under 45 KB is one of the keyed answers. The Settings pane exposes workspace image (.png or .jpg under 45 KB), Workspace OneDrive linkage, a Contact list, the contributor app-update delegation toggle, Premium capacity assignment, and Azure Data Lake Gen2 connection.
Why B is correct: Correct. Specify a Workspace OneDrive backed by a Microsoft 365 Group document library is one of the keyed answers. The Settings pane exposes workspace image (.png or .jpg under 45 KB), Workspace OneDrive linkage, a Contact list, the contributor app-update delegation toggle, Premium capacity assignment, and Azure Data Lake Gen2 connection.
Why C is correct: Correct. Allow contributors to update the app for the workspace through a delegation toggle is one of the keyed answers. The Settings pane exposes workspace image (.png or .jpg under 45 KB), Workspace OneDrive linkage, a Contact list, the contributor app-update delegation toggle, Premium capacity assignment, and Azure Data Lake Gen2 connection.
Why D is wrong: A workspace belongs to one tenant and one capacity; there is no setting to attach multiple tenants.
Why E is wrong: Authentication is handled by Microsoft Entra ID at the tenant level, not as a workspace-creation setting.
