Integrated project (Visualising): Maji Ndogo part 3 [MCQ] (Version : 0)
TEST
Correct Answer
Answered in 61.683333333333 Minutes
Question 1/10
What is a key consideration for effective visual communication when designing a Power BI report page?
Keep all visuals the same size for
uniformity.
Use as many visuals as possible to show
detailed data.
Ensure a clear and logical layout that
guides the viewer's eye.
Use bright colours for all visuals to attract
attention.
Explanation:
Using too many visuals can clutter the report.
Overuse of bright colours can be distracting.
Uniform size for all visuals may not be effective for
emphasis or hierarchy.
Question 2/10
How would you enable a report user to view details for a specific province on a separate page when they select
it on the main page?
Use a slicer on the main page.
, Create a hyperlink in the report.
Implement drill-through functionality.
Use a bookmark to navigate to the specific
page.
Explanation:
Drill-through functionality allows users to select an
item on one page and see related details on
another page.
Slicers filter data but do not navigate to different
pages.
Hyperlinks in Power BI do not function in this
manner.
Bookmarks are for saving specific views, not for
drill-through scenarios.
Question 3/10
The project planners propose an additional 30% increase in the upgrade costs for rural water sources in Sokoto.
Which DAX formula would correctly calculate the adjusted cost?
Sokoto_budget =
infrastructure_cost[unit_cost_USD] +
(infrastructure_cost[unit_cost_USD] * 0.3)
Sokoto_budget =
infrastructure_cost[unit_cost_USD] * 1.3
Sokoto_budget =
SUM(infrastructure_cost[Rural_adjusted_cost])
* 1.3
Sokoto_budget =
infrastructure_cost[Rural_adjusted_cost] *
1.3
Explanation:
TEST
Correct Answer
Answered in 61.683333333333 Minutes
Question 1/10
What is a key consideration for effective visual communication when designing a Power BI report page?
Keep all visuals the same size for
uniformity.
Use as many visuals as possible to show
detailed data.
Ensure a clear and logical layout that
guides the viewer's eye.
Use bright colours for all visuals to attract
attention.
Explanation:
Using too many visuals can clutter the report.
Overuse of bright colours can be distracting.
Uniform size for all visuals may not be effective for
emphasis or hierarchy.
Question 2/10
How would you enable a report user to view details for a specific province on a separate page when they select
it on the main page?
Use a slicer on the main page.
, Create a hyperlink in the report.
Implement drill-through functionality.
Use a bookmark to navigate to the specific
page.
Explanation:
Drill-through functionality allows users to select an
item on one page and see related details on
another page.
Slicers filter data but do not navigate to different
pages.
Hyperlinks in Power BI do not function in this
manner.
Bookmarks are for saving specific views, not for
drill-through scenarios.
Question 3/10
The project planners propose an additional 30% increase in the upgrade costs for rural water sources in Sokoto.
Which DAX formula would correctly calculate the adjusted cost?
Sokoto_budget =
infrastructure_cost[unit_cost_USD] +
(infrastructure_cost[unit_cost_USD] * 0.3)
Sokoto_budget =
infrastructure_cost[unit_cost_USD] * 1.3
Sokoto_budget =
SUM(infrastructure_cost[Rural_adjusted_cost])
* 1.3
Sokoto_budget =
infrastructure_cost[Rural_adjusted_cost] *
1.3
Explanation:
