PL-300 · Question #224
PL-300 Question #224: Real Exam Question with Answer & Explanation
Sign in or unlock PL-300 to reveal the answer and full explanation for question #224. The question stem and answer options stay visible for context.
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.
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''
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.