Deliver Reports DA0-001 Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A small non-profit organization needs to create a public-facing dashboard showing the impact of its programs. The data is stored in a Google Sheet and is updated weekly by a volunteer. The dashboard must be accessible to anyone with the link, without requiring a login, and must update automatically when the Google Sheet changes. Which tool and approach is most suitable?

   • AMicrosoft Power BI Desktop connected to the Google Sheet, with the report published to a Power BI Report Server.
   • BTableau Public connected to the Google Sheet, with the dashboard saved to a personal Tableau Public profile.
   • CA custom HTML page that embeds a static CSV export of the Google Sheet data, hosted on the non-profit's website.
   • DGoogle Data Studio (Looker Studio) connected directly to the Google Sheet, with the dashboard's sharing settings set to 'Anyone with the link'.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A data analyst has found that customer churn has increased by 15% over the last quarter. The analyst needs to present this finding to the executive team in a way that is compelling and drives action. Which approach best applies data storytelling principles?

   • AShow a complex scatter plot of churn rate vs. customer age, with no accompanying narrative.
   • BStart with the finding ('Churn is up 15%'), provide context by showing the trend over the last year, and conclude with a recommended action to investigate the cause.
   • CBegin with a detailed explanation of the data collection methodology before showing any findings.
   • DPresent a large table with all churn data for the last quarter, including every customer segment and reason code.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data analyst must create a weekly executive summary report. The CEO wants to see the top 3 business highlights, the most critical risk, and the overall revenue trend. The report will be read on a mobile device. What is the most effective way to structure this report?

   • AStart with a brief narrative summary of the top 3 highlights and the critical risk, followed by a simple line chart of the revenue trend.
   • BBegin with a large, detailed data table of all revenue transactions, followed by a list of all identified risks.
   • CPlace a complex, multi-axis chart showing revenue, expenses, and profit on the first page, with the highlights in a footnote.
   • DCreate a slide deck with one slide per highlight, one for the risk, and one for the revenue trend, with no narrative summary.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A logistics company's operations manager needs a daily dashboard to monitor fleet performance. The manager wants to see at a glance which trucks are underperforming on fuel efficiency, which routes have the most delays, and how today compares to the 7-day average. The dashboard will be viewed on a large wall-mounted monitor in the dispatch office. Which design approach best meets this need?

   • AA single-screen layout with three KPI tiles (fuel efficiency, delay rate, comparison to average) and a color-coded exception list of underperforming trucks and routes.
   • BA dense table showing every truck's fuel efficiency and delay count for the last 30 days, sorted by route.
   • CA multi-tab dashboard with a separate tab for fuel efficiency, delays, and historical comparison, each containing detailed line charts.
   • DA dashboard with a large scatter plot of fuel efficiency vs. delay rate, with each point labeled by truck ID.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A data analyst is preparing a quarterly business review for two different audiences. The first is the company's board of directors, who want a high-level overview of financial performance and strategic initiatives. The second is the product development team, who want to see detailed metrics on user engagement and feature adoption. What is the most effective way to customize the report for these two audiences?

   • ACreate a single report with a high-level overview and include a link to a separate detailed appendix for those who want more information.
   • BCreate a detailed report for the product team and send a one-sentence summary to the board, assuming they can request more information if needed.
   • CCreate a single comprehensive report that includes both the high-level overview and the detailed metrics, and send it to both audiences.
   • DCreate two separate reports: one with a high-level narrative and key financial charts for the board, and one with detailed engagement metrics and feature-level analysis for the product team.
   Reveal Solution Discussion Select an answer first