Which methods should you use?
HOTSPOT
You are creating a capacity planning dashboard with Power BI desktop.
The dashboard must be able to be used within a model-driven manufacturing planning app as well as be embedded within a Microsoft Teams channel.
The data sources are as follows:
You need to determine the appropriate method for accomplishing each task.
Which methods should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Box 1: Use a Date Gateway
You can install an on-premises data gateway on the same local computer as SQL Server (in production, it would typically be a different computer).
Box 2: Create an entity relationship in CDS Solution Explorer
You can create relationships with CDS Solution Explorer.
Box 3: Create an aggregate table
Rollup columns help users obtain insights into data by monitoring key business metrics. A rollup column contains an aggregate value computed over the rows related to a specified row. This includes regular tables and activity tables such as emails and appointments.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/define-rollup-fields
Latest PL-100 Dumps Valid Version with 86 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund