ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 75 - PL-100 discussion

Report
Export

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.

Question 75
Correct answer: Question 75

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.

Incorrect Answers:

Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models. With Modeling view in Power BI Desktop, you can view and work with complex datasets that contain many tables.

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

asked 05/10/2024
Khaled Fouad
33 questions
User
0 comments
Sorted by

Leave a comment first