PL-300 · Question #224
You have a Power Bl 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…
The correct answer is D. Remove Posts [Full Text] and Posts [Summary]. E. Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''. D is correct: Removing Posts[Full Text] and Posts[Summary] eliminates large text columns that are not used in any of the report visuals. Large text columns significantly increase dataset size and refresh time. E is correct: Removing rows from Traffic where Traffic[URL Visited]…
Question
You have a Power Bl 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 toad times. Which two actions will reduce the toad times? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Exhibits
Options
- ARemove the rows m Traffic in which Traffic [Referring URL] does not start with "/"
- BRemove the rows in Posts m which Post [Publish Date] is in the last seven days.
- CRemove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).
- DRemove Posts [Full Text] and Posts [Summary].
- ERemove the rows in Traffic in which Traffic [URL visited] does not contain "blog''
How the community answered
(25 responses)- A8% (2)
- B16% (4)
- C4% (1)
- D72% (18)
Explanation
D is correct: Removing Posts[Full Text] and Posts[Summary] eliminates large text columns that are not used in any of the report visuals. Large text columns significantly increase dataset size and refresh time. E is correct: Removing rows from Traffic where Traffic[URL Visited] does not contain 'blog' filters the Traffic table to only rows relevant to the blog report, dramatically reducing row count and load time. Option A filters on Referring URL which may remove legitimate blog traffic data. Option B would remove recent posts that should be included. Option C filters on IP/Browser/Referring URL columns - while Referring URL might be removable, IP and Browser Agent may be used, making this risky.
Topics
Community Discussion
No community discussion yet for this question.