Data Governance

Which TWO of the following are effective techniques for presenting data to a non-technical audience?

An analyst needs to present quarterly sales data to the board. The CEO wants to see both overall trend and breakdown by region. Which dashboard layout is most effective?

A government agency's data analyst is commissioned to produce a report on public transportation usage trends. The report will be read by policymakers, transit planners, and the general public. The data includes ridership numbers, delay rates, and demographic breakdowns. The analyst needs to ensure the report is accessible and persuasive, especially to non-technical readers. The goal is to advocate for increased funding in underserved areas. The report must be data-driven but also tell a compelling story. What strategy should the analyst prioritize?

A data analyst discovers an anomaly in a dataset. Which two actions should be taken before reporting? (Choose TWO.)

A data analyst creates a line chart showing monthly sales over the past year. The chart uses a y-axis starting at $100,000 instead of zero. What is the most likely misinterpretation a viewer might have?

A data analyst is creating a data story about sales performance. Which THREE elements are essential for effective data storytelling? (Choose THREE.)

A company is designing a dashboard for real-time monitoring. Which THREE considerations are most critical?

A data analyst needs to present findings about customer churn to business stakeholders. The analysis identified that churn is highest among customers who have called customer support more than three times in the last month. Which of the following is the best way to communicate this insight?

A data analyst is creating a report on customer satisfaction scores across different regions. The analyst wants to highlight regions that are significantly below average. Which of the following statistical methods is most appropriate for identifying these outliers?

A data analyst is creating a data story for a marketing campaign results. Which of the following narrative structures is most effective for engaging the audience?

A dashboard automatically refreshes every hour, but users report stale data. What is the most likely issue?

Refer to the exhibit. What is the impact of the validation result?

A data analyst is designing a dashboard for non-technical managers. Which TWO design principles should be applied? (Choose TWO.)

Refer to the exhibit. A data analyst wants to create a visualization that best shows the trend of sales over time for each department. Which chart type should be used?

A data analyst is presenting a complex statistical analysis to a group of data scientists. The audience is highly knowledgeable. Which TWO approaches are most appropriate? (Choose two.)

A data analyst is preparing a data storytelling presentation for a non-technical audience. Which THREE techniques are most effective for communicating insights?

A data analyst is creating a presentation for the board of directors. The board members have varying levels of data literacy. The analyst wants to ensure that the key insight—that customer satisfaction scores have declined by 15% due to longer wait times—is understood by everyone. Which approach is best?

A data analyst needs to present the results of a customer segmentation analysis to the marketing team. The analysis identified four segments based on purchasing behavior. Which visualization is most effective for showing the characteristics of each segment?

A data team is communicating findings from a machine learning model that predicts equipment failure. The model has high accuracy but low recall. Which of the following statements is the most accurate way to communicate the model's performance to the maintenance team?

Drag and drop the steps to conduct a hypothesis test in the correct order.

During a data presentation, an audience member questions the accuracy of the data shown. Which of the following is the best way for the analyst to respond?

Refer to the exhibit. A data analyst is troubleshooting a failed dashboard refresh. The error log shows repeated SQL syntax errors. Which of the following is the most likely cause?

Refer to the exhibit. A data analyst receives this error when running a data load script. What is the most likely cause?

A stakeholder asks for the exact number of customers who churned last month. Which metric should the analyst report?

A business user asks a data analyst to include several charts in a weekly report. The user wants to see the trend of sales over the last 12 months at a glance. Which chart type should the analyst use?

A data analyst needs to communicate findings to a non-technical audience that is concerned with overall performance but not interested in details. Which approach is best?

A data analyst is creating a report to compare the performance of different sales regions. The report will be used by regional managers to identify areas needing improvement. Which of the following visualization techniques would be most effective?

A data analyst creates a dashboard that includes a map showing sales by region. The map uses a continuous color gradient from light yellow to dark blue. Some regions with very high sales appear as dark blue, but many regions with moderate sales appear similar. Which improvement would most enhance the readability?

Which TWO are common pitfalls when communicating data insights?

A data analyst creates a dashboard for executives to monitor quarterly sales. Which best practice ensures the dashboard is effective?

During a presentation, a stakeholder questions the validity of a correlation found. What is the best response?

Which TWO of the following are best practices when presenting data insights to a non-technical audience?

A data analyst is designing a dashboard for senior executives who need to quickly monitor key business metrics. Which TWO design principles should the analyst follow? (Choose two.)

Refer to the exhibit. A data analyst is reviewing the configuration of an executive dashboard. The dashboard refreshes daily at 6:00 AM. Which of the following best describes a potential issue with this dashboard for executive use?

A logistics company tracks delivery times and customer satisfaction scores. The data analyst finds that delivery times have increased over the past quarter, correlating with a drop in satisfaction. The analyst needs to present this to the operations team, which is interested in root cause analysis. The team wants to identify whether the increase is due to specific regions, routes, or time periods. The analyst has access to granular data including timestamps, route IDs, and region codes. The presentation should lead to actionable insights for process improvement. What visualization should the analyst use as the primary chart?

A data analyst is designing a dashboard for a sales team. Which TWO of the following are best practices for dashboard design?

Which THREE of the following are appropriate ways to handle outliers when communicating data insights?

A retail company's data analyst developed a dashboard for store managers to monitor daily sales performance. The dashboard includes numerous metrics such as sales by hour, product category, employee, and customer demographics, along with trend lines and forecast graphs. Despite the comprehensive data, store managers are ignoring the dashboard because they find it cluttered and confusing. They prefer to rely on their intuition and verbal updates from shift leads. The analyst needs to improve communication of data insights to ensure the dashboard is used effectively. Which of the following actions should the analyst take FIRST?

A company's sales dashboard shows that the current month's revenue is $1.2M, which is 10% below the target of $1.33M. The analyst wants to highlight this shortfall. Which method of data presentation is most effective?

A data analyst creates a dashboard for operational metrics. The operations team reports that the dashboard is confusing because it shows too many metrics on one screen. Which design principle should the analyst apply?

A data analyst needs to present findings to a non-technical executive audience. Which visualization type is most appropriate to communicate a clear comparison of sales performance across multiple regions for the current quarter?

A data team is creating a dashboard to monitor real-time sales. What design principle is critical?

An analyst finds that a key metric drops significantly after a data pipeline update. How should the analyst proceed?

A data team created a dashboard for executives. The dashboard updates daily and includes several KPIs. Executives complain that they cannot quickly identify the most critical issues. Which design change would best address this?

When presenting data insights to a technical audience, which of the following is most important to include?

A data analyst includes a map showing customer locations by zip code. The map reveals exact addresses for a few customers due to data granularity. This violates which principle?

Which TWO are best practices for data storytelling?

A retail company has a data warehouse that integrates sales data from multiple sources including online transactions, in-store POS, and third-party marketplaces. The data team recently updated the ETL pipeline to add a new data source: mobile app purchases. After the update, the daily sales report shows a 15% increase in total sales compared to the previous day, which is unexpected because the mobile app is new and only contributed 2% of sales in tests. The report is created by a SQL script that aggregates sales by date and runs every morning. The data team needs to identify the cause of the discrepancy. Which of the following should the team do first?

An analyst is presenting findings to stakeholders. Which TWO techniques effectively communicate uncertainty in data? (Choose TWO.)

A data analyst at a marketing firm is creating a weekly performance report for the marketing team. The report includes metrics like click-through rates, conversion rates, and cost per acquisition. The team prefers a quick overview of the week's performance to identify trends and make decisions in their Monday morning meeting. The meeting is only 30 minutes, and the team has limited time to review data. The analyst wants to provide a report that is concise and actionable. What format should the analyst use?

Which THREE elements should be included in a data insight report to ensure it is actionable? (Choose three.)

Refer to the exhibit. A data analyst is creating a report that includes customer transaction data from 6 years ago. According to the policy, what should the analyst do?

A data analyst is communicating insights about a sales forecast to stakeholders. Which three of the following should the analyst include to build trust and clarity? (Select THREE.)

An analyst needs to communicate a data insight about a sudden drop in website traffic. Which communication method should be used first?

When designing a report for executive leadership, which aspect is most important?

An analyst is creating a report for both technical and executive audiences. Which two strategies are effective? (Choose TWO.)

A data analyst is preparing a presentation on customer churn. The audience consists of both technical and non-technical stakeholders. Which visualization approach is most effective?

Refer to the exhibit. An analyst runs a query to count orders in June 2023 and gets 12,345. However, a dashboard shows 12,298 for the same month. What is the most likely cause?

Match each ETL process step to its description.

A data analyst reports being unable to run the query shown in the exhibit. The data governance team reviews the access control policy. Which of the following is the most likely explanation for the denied access?

A healthcare analytics team is responsible for producing a monthly dashboard for hospital administrators. The dashboard includes key metrics such as patient admission rates, average length of stay, readmission rates, and bed occupancy. For the current month, the data shows a significant increase in average length of stay. The data analyst suspects that this increase is due to a new chronic disease management program that was implemented at the beginning of the month. However, the analyst also notices that the data for the previous month had an error: some discharge dates were incorrectly recorded, causing the average length of stay to be artificially low. The analyst needs to communicate the insights to the administrators, who are concerned about the increase. Which of the following is the best course of action?

A healthcare data analyst is presenting findings on patient readmission rates to a group of hospital administrators. The analysis reveals a 15% increase in readmissions over the past quarter for patients aged 65+ from a specific zip code. However, the administrators are skeptical because previous quarterly reports showed no such trend, and they suspect data quality issues. The analyst must communicate this insight effectively while maintaining credibility. Which of the following approaches should the analyst take?

You are a data analyst at a retail company. The marketing team has asked you to analyze the effectiveness of a recent email campaign. You have data on email open rates, click-through rates, and conversion rates. The campaign targeted 50,000 customers; 20,000 opened the email, 5,000 clicked a link, and 500 made a purchase. The marketing director wants to know the campaign's overall performance and whether the email content was engaging. You prepare a dashboard but notice that the click-through rate (CTR) is 25% and the conversion rate is 10%, which seem high. Upon reviewing the data, you discover that the click-through rate was calculated as (clicks / opens) * 100, and the conversion rate as (purchases / clicks) * 100. The director expects the conversion rate to be calculated as (purchases / opens) * 100. Which action should you take to ensure accurate communication of insights?

A data analyst needs to communicate a forecast with uncertainty. Which visualization is best?

A company wants to ensure that data visualizations are accessible to colorblind users. Which of the following is a best practice?

A data analyst is creating a dashboard for executives to show monthly sales trends over the past year. Which chart type is most appropriate?

A data analyst is preparing a presentation for a mixed audience of executives and technical staff. Which two of the following practices would be most effective? (Select TWO.)

Which TWO actions are appropriate when creating a data visualization for a diverse audience with varying levels of data literacy? (Choose two.)

An analyst presents a report to stakeholders who are not data-savvy. The report includes a box plot showing the distribution of customer satisfaction scores. One stakeholder asks, 'What do the whiskers mean?' Which communication strategy should the analyst use?

A healthcare company's data analyst is tasked with presenting patient readmission rates to a group of doctors and nurses. The data shows that readmission rates are higher among patients with certain chronic conditions. The audience has limited data literacy, but they are familiar with clinical terms. The analyst wants to communicate the insights effectively and encourage discussion on preventive measures. The presentation will last 15 minutes, and the audience expects actionable insights. What should the analyst do?

Refer to the exhibit. The data shows sales by product category for two years. Which product category had the highest percentage increase from 2023 to 2024?

A data analyst creates a bar chart showing monthly sales for the current year. The CEO asks to see the same data but grouped by region. Which chart type is most appropriate for this new requirement?

A data analyst is preparing a presentation to share findings with non-technical stakeholders. Which TWO practices should the analyst follow to effectively communicate data insights? (Choose two.)

A data analyst wants to compare the sales performance of four different stores over the same time period. Which chart type is most suitable?

A data analyst is reviewing a data lake access policy that controls access to a data lake. The analyst wants to communicate that the current policy restricts data downloads to a specific IP range. Which of the following best describes the policy's effect?

A report uses red and green colors to indicate performance; a stakeholder who is colorblind complains. What is the BEST remedy?

Refer to the exhibit. What is the best course of action for the data analyst?

When presenting data insights, which three practices help ensure clarity? (Choose THREE.)

A data analyst is asked to create a visualization showing the trend of monthly revenue over the last five years. Which chart type is most suitable?

When creating a data story, what should be the FIRST step?

A data analyst is preparing a presentation for executive leadership. The analyst wants to highlight the correlation between marketing spend and revenue over the past year. Which visualization type is most appropriate for showing this relationship?

A data team is preparing a quarterly business review for the CEO. The report must include both high-level summaries and the ability for the CEO to drill down into specific departments. Which reporting technique best meets this requirement?

A data analyst creates a report and wants to ensure it tells a compelling story. Which element is most important for data storytelling?

A data analytics team has created a report for stakeholders. The report includes complex statistical terms and raw data tables. Stakeholders are confused and ask for clarification. Which of the following should the team do to improve communication?

A data team needs to communicate insights about customer churn to the sales team. The insights include confidence intervals and p-values. The sales team is not familiar with statistics. Which of the following should the data team do?

A data analyst at a retail company is building a dashboard for store managers to track sales performance. The data comes from three sources: point-of-sale (POS) systems, inventory, and customer loyalty. The POS table contains columns transaction_id, store_id, date, product_id, quantity, and price. The inventory table has product_id, store_id, stock_level, and reorder_point. The loyalty table has customer_id, transaction_id, and points_earned. The analyst creates a star schema with a sales_fact fact table containing all rows from POS, dimension tables for store, product, date, and customer. To calculate average transaction value, the analyst uses the formula SUM(quantity * price) / COUNT(*). Store managers report that the average transaction value appears too low, especially for stores with multiple registers. The analyst realizes that because each product sold in a transaction creates a separate row in sales_fact, a single transaction with multiple items contributes multiple rows. The current calculation divides by the number of rows rather than the number of distinct transactions. Which of the following is the best course of action to correct the average transaction value metric? (Choose one.)

A data analyst creates a scatter plot showing the relationship between advertising spend and revenue. The plot shows a strong positive correlation. Which of the following should the analyst include in the report to ensure accurate communication?

While reviewing a dashboard, an analyst notices that the data in a trend line chart does not match the underlying data due to a filter setting. The dashboard is used for weekly executive meetings. What should the analyst do?

A data analyst notices that a line chart showing monthly sales over the past two years has a steep drop in one month. Upon investigation, the analyst discovers that a new sales region was added mid-month and the data was not normalized. Which of the following best practices should the analyst apply to communicate this insight accurately?

Refer to the exhibit. A data analyst is unable to access the dataset during weekends. Based on the policy, what is the most likely reason?

Which type of chart is most suitable for showing the distribution of a single continuous variable?

A data analyst discovers a data discrepancy in a report that has already been distributed to executives. The discrepancy is due to a known bug that will be fixed next month. What is the most appropriate action?

A data team is preparing a dashboard for executives. The team wants to highlight key performance indicators (KPIs) that are below target. Which of the following visualization techniques would most effectively draw attention to underperforming metrics without causing confusion?

A data analyst is building a dashboard that will be used by both executives and operational managers. The executives need high-level summaries, while managers need granular details. Which dashboard design principle should the analyst apply?

Match each data security concept to its description.

A large e-commerce company has a data warehouse that stores daily sales transactions. The data analytics team creates a weekly report for the executive team that includes total revenue, number of orders, and average order value. Recently, the report showed a sudden 20% drop in total revenue compared to the previous week. Upon investigation, the data analyst discovers that a major promotional event ended the previous week, and the current week's data includes a new product launch with lower prices. The analyst needs to present this data to the executives in a way that accurately reflects the business situation. The analyst must also provide recommendations for actions. Which of the following is the best course of action?

A data analyst needs to present the distribution of customer ages to a non-technical audience. Which type of chart would be most appropriate?

A company must comply with GDPR when reporting customer data. What must be included in the report?

A data analyst is troubleshooting a dashboard that displays slowly. Which two of the following are common causes of dashboard performance issues? (Select TWO.)

A data team is creating a report for the board of directors. The board wants to see both the big picture and the ability to explore details for specific regions. Which TWO approaches should the team implement?

A data analyst is presenting a weekly sales report to a diverse audience that includes sales managers, marketing team, and finance. The analyst wants to ensure the data is understood correctly. Which communication strategy is most effective?

A data analyst is troubleshooting a dashboard that displays incorrect totals for sales by region. The data source queries are correct. Which of the following is the most likely cause?

Refer to the exhibit. A data analyst is unable to run a query on the customers table after October 1, 2023. What is the reason?

Which TWO of the following are best practices for designing a data dashboard?

A data analyst needs to create a dashboard that updates automatically every hour. The data source is a large database. Which approach minimizes performance impact?

Refer to the exhibit. A data analyst is reviewing a data quality report. Which of the following actions should the analyst take first?

A healthcare organization must ensure patient data privacy when sharing reports with external auditors. Which practice is most important?

During a presentation, a stakeholder questions the validity of a data insight because the sample size appears small. The analyst knows the sample is statistically significant. What is the best way to address this concern?

An analyst is presenting findings to a non-technical audience. The data shows a 20% increase in customer churn after a price change. Which presentation approach is BEST?

A data analyst is preparing a report to present to a mixed audience of technical and non-technical stakeholders. Which THREE techniques should the analyst use to ensure effective communication? (Choose three.)

A financial analyst at a bank is preparing a report on loan default risks to the risk management committee. The committee includes both technical (quantitative analysts) and non-technical (business managers) members. The analyst has built a logistic regression model that outputs probability scores for default. The model's performance is good, but the committee wants to understand the key drivers of default. The analyst needs to communicate both the model's accuracy and the impact of each feature. The report should be concise and persuasive, leading to policy changes. What is the best approach?

An analyst is creating a report to show the relationship between advertising spend and website traffic over the past 12 months. The data has a few outliers due to special promotional events. Which chart type should the analyst use to clearly show the trend while minimizing the impact of outliers?

You are a data analyst at a retail company. Your team has deployed a new dashboard that displays real-time inventory levels across all warehouses. The dashboard uses a traffic light color scheme (green = sufficient, yellow = low, red = out of stock). After one week, the warehouse managers complain that the dashboard is overwhelming because it shows all 500+ products at once, and they cannot quickly identify which items need immediate attention. They request a way to prioritize items that are red or yellow. Additionally, the dashboard updates every second, causing the screen to flicker constantly, which they find distracting. You need to redesign the dashboard to address these issues. Which course of action should you take?

Which TWO of the following are best practices when creating a data visualization for a presentation to stakeholders?

An analyst is creating a data story about the decline in customer satisfaction scores. The data shows that satisfaction dropped after a software update. Which narrative structure best helps the audience understand the cause and effect?

After presenting a data analysis to stakeholders, they ask for additional details on a specific trend. The analyst needs to provide a follow-up report. What is the best approach?

Refer to the exhibit. An ETL pipeline failed. What is the most likely root cause?

A data analyst creates a report showing sales by product category. The analyst notices that one category has a very high sales figure due to a one-time bulk order. Which of the following is the best way to communicate this insight to stakeholders?

A data analyst is presenting results from a customer segmentation analysis to a non-technical audience. The segmentation was performed using k-means clustering, and the analyst wants to explain the characteristics of each cluster. Which visualization is most appropriate for this audience?

A retail company has a dashboard that tracks daily sales across all stores. The dashboard is used by the CEO during monthly board meetings. Recently, the CEO complained that the dashboard is confusing and takes too long to interpret. The data analyst is asked to redesign the dashboard to improve usability. The analyst has access to all sales data. The CEO prefers a high-level overview with the ability to drill down into regions if needed. The analyst must decide on a course of action. What should the analyst do first?

Drag and drop the steps to perform a root cause analysis on data quality issues in the correct order.

An analyst notices that a dashboard displays conflicting data from two sources. What is the first step in troubleshooting?