exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 46 discussion

Actual exam question from Microsoft's PL-300
Question #: 46
Topic #: 2
[All PL-300 Questions]

You have a Power BI report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns.
The report contains the visuals shown in the following table.

The dataset takes a long time to refresh.
You need to modify Posts and Traffic queries to reduce load times.
Which two actions will reduce the load times? Each correct answer presents part of the solution.
NOTE:
Each correct selection is worth one point.

  • A. Remove the rows in Posts in which Posts[Publish Date] is in the last seven days.
  • B. Remove the rows in Traffic in which Traffic[URL Visited] does not contain ג€blogג€.
  • C. Remove Traffic[IP Address], Traffic[Browser Agent], and Traffic[Referring URL].
  • D. Remove Posts[Full Text] and Posts[Summary].
  • E. Remove the rows in Traffic in which Traffic[Referring URL] does not start with ג€/ג€.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️

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
dnpr
Highly Voted 2 years, 2 months ago
Selected Answer: BD
B & D Agreed with XIKTA
upvoted 24 times
...
June15
Highly Voted 2 years, 6 months ago
D&E? Anyone have the same thoughts?
upvoted 18 times
itenginerd
1 year, 5 months ago
E is not correct. There are perfectly valid blog hits that won't have a referring URL, so filtering those rows removes valid hits that need to be counted. The answer is D & B. It feels a bit unnatural to me to be pulling rows instead of columns, but all the visuals we're talking about here involve blog hits specifically, so pulling the non-blog website traffic out of the dataset appears to be the right path forward.
upvoted 8 times
...
andregrahamnz
2 years, 4 months ago
Must be....presume the whacko characters are the same filtered '/' character. A, B and C all definitely don't work.
upvoted 1 times
...
zerzil
1 year, 12 months ago
I disagree, we would remove the line which do not start with "/", but those are the lines exactly what we need in the last visual
upvoted 5 times
...
Maniula
1 year, 7 months ago
That would remove Traffic data that is used in other visuals, so it's incorrect.
upvoted 5 times
...
...
889efe8
Most Recent 5 days, 20 hours ago
Selected Answer: BD
Referenced fields not used in the analysis
upvoted 1 times
...
DBMS_DA
1 month, 2 weeks ago
Selected Answer: BD
Since we are looking into Blog data and url are the join key so its by default that we might not have any url without 'blog" and if at all we have , we can get rid of those D because Full text and Summary col are not being used in any viz. so why to even have them.
upvoted 1 times
...
jaume
3 months, 4 weeks ago
Selected Answer: BD
Looks like all doubts are mainly about whether B or E is the valid solution and no discussion about D (as Posts[Full Text] and Posts[Summary] are not adding any value to any of the visuals. I will vote for B instead E as we are looking just for 'Blogs" and Traffic table is storing "Activity data from your company's ENTIRE website" so I'm assuming there would be more data than just data related to 'blogs'. On the other hand, about E, Traffic[Referring URL] not starting with '/' is a condition/filter for te last visual but this information but it's not a condition to be filtering other visuals.
upvoted 1 times
...
rcaliandro
7 months ago
Selected Answer: B
Help me guys! I totally agree with D because we do not user Full Text and Summary in any visual. But why B is correct? We can't filter the traffic by URL because there is the report "Top 10 blog posts from the last seven days" which shows the traffic in the last 7 days independently from the URL
upvoted 1 times
rcaliandro
6 months, 4 weeks ago
I will answer to myself =) I just realized that we can filter the blogs because it is a specific requirement. So BD is correct =)
upvoted 2 times
...
...
tienanbich
1 year, 2 months ago
Selected Answer: BD
B and D are correct because the data are not needed
upvoted 2 times
...
Dsbuff
1 year, 2 months ago
Selected Answer: BD
B and D are correct
upvoted 3 times
...
TrustMyAnswers
1 year, 4 months ago
Selected Answer: BD
Although some visuals have no filter related to "blog", the title of the visual suggests that only blogs are being analyzed. Therefore, we can safely remove everything that does not contain "blog". B and D are correct.
upvoted 6 times
Elektrolite
1 year ago
That's not "safely" removing. Going by just the title is exactly the opposite of safely removing, it's unsafely removing.
upvoted 3 times
da66a09
10 months, 4 weeks ago
i agree, you can't just assume based on the description of the visual. if it was necessary to include 'blog' in one filter it should be included in others if that was the intention. the only correct answer is D based on the limited information provided
upvoted 1 times
...
...
...
Ryan_042
1 year, 4 months ago
Selected Answer: DE
B makes no sense because there is no filter on "blog" on the first two visuals, so removing it causes a lack of data.
upvoted 5 times
...
nai_
1 year, 7 months ago
B and D
upvoted 3 times
...
Ravisha27
1 year, 7 months ago
so how decides the final answer?
upvoted 1 times
Fra04
1 year ago
B&D risposta corretta
upvoted 1 times
...
GB32
1 year, 5 months ago
B & D you don't need rows of data which has no "blog" in it in the Traffic table, and in regards of the Posts table we don't either used the "Full Text & Summary" data in the analysis. Hope it makes sense to you.
upvoted 4 times
RicoPallazzo7
1 year, 5 months ago
I agree, but looking at the filters, in the first two visuals even posts that are not "blog" are used. Looking at the name they seems to be filtered, but hard to decide without the actual filter
upvoted 1 times
...
...
...
XiaoV587
1 year, 8 months ago
The filters of the first two reports don't mention 'contains BLOG' So for me deleting lines with BLOG has impacts. The basis is not clear for the two reports.
upvoted 3 times
XiaoV587
1 year, 8 months ago
ok join by URL so implicite...
upvoted 2 times
...
itenginerd
1 year, 5 months ago
It's a fair criticism of the way the question is laid out. For me, the intention was clear enough in the visual names, but I see what you're saying there.
upvoted 1 times
...
...
Shalaleh
1 year, 10 months ago
Selected Answer: BD
both are clear!
upvoted 3 times
...
UlyUkr
1 year, 10 months ago
I would go with B and D.
upvoted 3 times
...
RazaTheLegend
1 year, 11 months ago
Selected Answer: BD
All 4 visualizations are about blogs: so we can remove rows what do not contain "blog" - thus B is correct. We do not need columns Posts[Full Text] and Posts[Summary] in any visualization, they can be removed.
upvoted 6 times
LouStar2
1 year, 9 months ago
Do all blogs have "blog" in the URL? I would say most don't.
upvoted 3 times
...
...
Nemesizz
2 years, 1 month ago
I dont understand what "ג€blogג€." means in the possible answers. Can someone explain?
upvoted 2 times
LouStar2
1 year, 9 months ago
Its character encoding, its a mistake on this website B should have "blog" E should have "/"
upvoted 4 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