ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-200 All Questions

View all questions & answers for the PL-200 exam
Go to Exam

Exam PL-200 topic 5 question 27 discussion

Actual exam question from Microsoft's PL-200
Question #: 27
Topic #: 5
[All PL-200 Questions]

DRAG DROP
-

You create a canvas app that uses data from a Microsoft SQL Server database.

You use a dataflow to move some of the data from the database to Microsoft Dataverse. Users will filter the data by using the app.

You need to filter data in the dataflow and in the canvas app.

Which tools should you use? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by prajmen at Jan. 20, 2023, 2:57 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
prajmen
Highly Voted 2 years, 4 months ago
Could this really be correct? Shouldnt "Filter data in the canvas app" be "Power FX"?
upvoted 17 times
UdaraG
2 years, 4 months ago
I "think" given answer is correct as in question it states that Canvas app uses data from MS SQL database
upvoted 5 times
HARRISONP04
2 years, 4 months ago
correct
upvoted 1 times
...
...
Sweden2022
1 year, 5 months ago
I tried out and it is 1. Power Query 2. Power Fx
upvoted 4 times
...
...
HARRISONP04
Highly Voted 2 years, 4 months ago
UPDATE: https://www.techtarget.com/searchdatamanagement/definition/T-SQL This page describes well how using T-SQL will assist the filtering of data going into the canvas app from an external SQL database
upvoted 8 times
DSM_LM
1 year, 6 months ago
But the data is supposed to be filtered within the canvas app and not before.
upvoted 2 times
MrEz
1 year, 4 months ago
depending on the scenario, it might make sense to filter some data before you load it, e.g. if the app is built for only a specific region, maybe it makes sense to filter only the few hundred mb out of hundreds of gigs of data prior loading it to the canvas app. So you need just to load a few hundred MB instead of hundreds of gigs. however, the requirement says 'in the canvas app'. therfore, i would go for powerfx.
upvoted 1 times
...
...
...
Hamed64
Most Recent 4 months, 2 weeks ago
Copilot To filter data in the dataflow and in the canvas app, you should use the following tools: Power Query: Use Power Query to filter and transform the data within the dataflow before it is moved to Microsoft Dataverse. Power Query allows you to apply various transformations and filters to the data, ensuring that only the necessary data is imported. Power Fx: Use Power Fx within the canvas app to filter the data that users interact with. Power Fx is the formula language for canvas apps and allows you to create dynamic filters and conditions based on user input. Combining these tools will enable you to efficiently filter data both during the dataflow process and within the canvas app itself.
upvoted 1 times
...
33a7f9e
8 months ago
Filter data in the dataflow: B. Power Query. Filter data in the canvas app: A. PowerFx.
upvoted 1 times
...
Masoud1
1 year, 1 month ago
Power Query Power FX
upvoted 1 times
...
jkaur
1 year, 1 month ago
1. Power Query 2. Power Fx
upvoted 2 times
...
JohnChung
1 year, 3 months ago
This question mentions filtering data at 2 scenarios: 1) Filtering data from Microsoft SQL server to Dataverse Use T-SQL (Transact SQL) https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16 2) Users filtering data in canvas app Of course, use Power Fx
upvoted 1 times
...
DSM_LM
1 year, 6 months ago
2nd answer needs to be Power Fx. You can only use Power Fx formulas within a canvas app. "You use a dataflow to move some of the data from the database to Microsoft Dataverse. Users will filter the data by using the app."
upvoted 3 times
...
MSNoob123
1 year, 9 months ago
on exam 08/23
upvoted 2 times
...
damdam10
2 years, 1 month ago
ChatGPT says 1. Power Query 2. Power Fx
upvoted 4 times
anjanraiz
1 year, 10 months ago
Question the ChatGPT again, and it will mention otherwise.
upvoted 1 times
...
anjanraiz
1 year, 10 months ago
Just mentioning, because ChatGPT does not always provide right answer. But in this case, I think the correct answer for the second condition is Power Fx as the question mentions filtering data in canvas app.
upvoted 2 times
...
...
[Removed]
2 years, 1 month ago
Hmmm... 1. Best practice to filter data in the dataflow is to do it in T-SQL if you are pulling data using a query. But I guess what they might want to hear for this is Power Query 2. Should be Power FX
upvoted 1 times
...
Ikhalil
2 years, 2 months ago
1 Power query 2 Power Fx
upvoted 1 times
...
HARRISONP04
2 years, 4 months ago
Never heard of T-SQL filtering canvas app data before
upvoted 6 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel