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

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

Suggested Answer: BD 🗳️

by Guru1337 at Sept. 7, 2022, 9:22 a.m.

Comments

Submit Cancel

dnpr

Highly Voted 2 years, 6 months ago

Selected Answer: BD

B & D Agreed with XIKTA

upvoted 25 times

...

June15

Highly Voted 2 years, 10 months ago

D&E? Anyone have the same thoughts?

upvoted 18 times

itenginerd

1 year, 10 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, 8 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

2 years, 4 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

2 years ago

That would remove Traffic data that is used in other visuals, so it's incorrect.

upvoted 5 times

...

889efe8

Most Recent 4 months, 3 weeks ago

Selected Answer: BD

Referenced fields not used in the analysis

upvoted 1 times

...

DBMS_DA

6 months 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 2 times

...

jaume

8 months, 2 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

11 months, 2 weeks 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

11 months, 2 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, 6 months ago

Selected Answer: BD

B and D are correct because the data are not needed

upvoted 2 times

...

Dsbuff

1 year, 7 months ago

Selected Answer: BD

B and D are correct

upvoted 3 times

...

TrustMyAnswers

1 year, 8 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, 4 months 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

1 year, 3 months 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, 8 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, 11 months ago

B and D

upvoted 3 times

...

Ravisha27

2 years ago

so how decides the final answer?

upvoted 1 times

Fra04

1 year, 5 months ago

B&D risposta corretta

upvoted 1 times

...

GB32

1 year, 10 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 5 times

RicoPallazzo7

1 year, 9 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

2 years 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

2 years ago

ok join by URL so implicite...

upvoted 2 times

...

itenginerd

1 year, 10 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

2 years, 3 months ago

Selected Answer: BD

both are clear!

upvoted 3 times

...

UlyUkr

2 years, 3 months ago

I would go with B and D.

upvoted 3 times

...

RazaTheLegend

2 years, 3 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

2 years, 1 month ago

Do all blogs have "blog" in the URL? I would say most don't.

upvoted 3 times

...

Nemesizz

2 years, 5 months ago

I dont understand what "ג€blogג€." means in the possible answers. Can someone explain?

upvoted 2 times

LouStar2

2 years, 1 month ago

Its character encoding, its a mistake on this website B should have "blog" E should have "/"

upvoted 4 times

...

Load full discussion...