exam questions

Exam PL-900 All Questions

View all questions & answers for the PL-900 exam

Exam PL-900 topic 1 question 28 discussion

Actual exam question from Microsoft's PL-900
Question #: 28
Topic #: 1
[All PL-900 Questions]

HOTSPOT -
A company plans to use Power BI to visualize data from business systems.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Yes -
The following list provides advantages to using aggregations:
Query performance over big data - as users interact with visuals on Power BI reports, DAX queries are submitted to the dataset. Boost query speeds by caching data at the aggregated level, using a fraction of the resources required at the detail level. Unlock big data in a way that would otherwise be impossible.

Box 2: Yes -
With Power BI Desktop, you can connect to many different types of data sources, then shape the data to meet your needs, enabling you to create visual reports to share with others. Shaping data means transforming the data: renaming columns or tables, changing text to numbers, removing rows, setting the first row as headers, and so on. Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-aggregations https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

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
Vaishali_Goswami
Highly Voted 3 years, 1 month ago
Correct... Both should be "Yes"
upvoted 46 times
...
Stu_B
Highly Voted 3 years ago
I always thought only "A single dataset per report" https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboards
upvoted 14 times
Minghon
2 years, 11 months ago
Agree with you. A single dataset per report is a key point. I think the second answer should be "No".
upvoted 11 times
Puneet80
2 years, 11 months ago
DataSet is a memory-resident representation of data that provides a consistent relational programming model regardless of the data source. So Report can have one DataSet that contains data from multiple source.
upvoted 15 times
...
JulieBee
2 years, 11 months ago
Your single dataset can contain data from different sources, ex sharepoint list, excel file, website etc.
upvoted 7 times
...
...
Nekazrof
2 years, 11 months ago
I believe thats a good method but the question ask if you can do it, not if is recomendable
upvoted 4 times
...
itenginerd
2 years, 5 months ago
It's very meta, but I find questions like this on Fundamentals exams are almost a product flex--the answer is almost always "yes" (or the answer that indicates more capabilities/fewer limitations of the product in question)
upvoted 13 times
...
...
swatgo
Most Recent 7 months, 2 weeks ago
yes and yes
upvoted 2 times
...
Kolif
1 year ago
Saw on May '23
upvoted 2 times
...
AzureVikas
1 year, 2 months ago
1.YES 2.YES
upvoted 1 times
...
Eltooth
1 year, 6 months ago
Yes Yes
upvoted 1 times
...
JYKL88
1 year, 6 months ago
Both are yes
upvoted 1 times
...
Alumant
1 year, 8 months ago
Yes Yes
upvoted 2 times
...
Lee_Tonida
2 years ago
Verified. In exam 5/13/2022.
upvoted 3 times
...
easport
2 years, 1 month ago
Verified on exam 17/03/2022
upvoted 2 times
...
DDV
2 years, 5 months ago
If the raw data is already meet the requirement, therefore no need to clean up and you can publish it. So both answers are YES.
upvoted 3 times
...
Shradz93
2 years, 5 months ago
Both are yes. Verified. https://community.powerbi.com/t5/Desktop/Can-I-combine-2-different-data-sources-in-the-same-Power-BI/m-p/7677
upvoted 1 times
...
Khella
2 years, 8 months ago
Verified 6/9/2021
upvoted 3 times
...
MaHa_Ma
2 years, 8 months ago
verified 28/08/21
upvoted 2 times
...
Sarat122
2 years, 10 months ago
we cant represent raw data in pbi report we represent visuals which have abstract data or transformed data.
upvoted 1 times
...
arban
3 years ago
both are yes answer
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago