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 ג€/ג€.






 

Suggested Answer: BD

B: Only blog posts rows are useful for the visuals.
D: These two columns are not used in the visuals and can be removed.
Incorrect:
Not A: Three visuals need historical data.
Not C: Traffic[Referring URL] is used in one of the visuals and therefore cannot be removed.
Not E: These rows are used in 3 visuals.

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.