Data Governance

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 needs to present the distribution of customer ages to a non-technical audience. Which type of chart would be most appropriate?

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 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?

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 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?

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?

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

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

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

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 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 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 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?

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 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?

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

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

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?

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?

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

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

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

Match each ETL process step to its description.

Match each data security concept to its description.

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

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?

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

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

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?

Which TWO are best practices for data storytelling?

Which TWO are common pitfalls when communicating data insights?

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?

A data analyst is presenting findings to a non-technical audience. Which data visualization technique is most appropriate?

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

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

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

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

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

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

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

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

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

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 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?

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?

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?

A data analyst is tasked with presenting the results of a customer churn analysis to a group of marketing managers. The model identified that customers with low engagement scores are 3 times more likely to churn. The analyst wants to effectively communicate this finding to persuade the managers to focus on engagement. Which of the following is the most compelling way to present this insight?

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?

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?

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.)

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 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.)

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

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 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 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?

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 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 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 is designing a dashboard for a sales team. Which TWO of the following are best practices for dashboard design?

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

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?

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?

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 company wants to ensure that data visualizations are accessible to colorblind users. Which of the following is a best practice?

A data analyst creates a dashboard for executives that shows a key metric trending downward. The analyst notices that the metric is highly volatile day-to-day. Which visualization type is most appropriate to show the underlying trend?

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 preparing a presentation for a mixed audience of executives and technical staff. Which two of the following practices would be most effective? (Select TWO.)

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.)

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

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

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?

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?

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?

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

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

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?

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?

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 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 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?

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 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 mid-sized insurance company stores policyholder records in a Microsoft SQL Server database. The compliance team must ensure that any column containing Social Security numbers is masked whenever the data is queried by analysts who are not authorized to view full identifiers. The database administrators want a solution that enforces masking at query time without altering the stored values or requiring application changes. Which SQL Server feature should they implement?

A financial services firm stores customer records in a cloud data warehouse. A new analyst requests read access to a table containing account balances and Social Security numbers. The data governance team must decide how to grant access while following the principle of least privilege. Which action best satisfies this requirement?

A financial services firm is establishing a data governance program for its customer analytics platform. The chief data officer wants to ensure that data quality issues are detected and resolved systematically. Which two of the following practices are most appropriate for maintaining data quality on an ongoing basis? (Choose two.)

A national hotel chain stores guest records in a cloud data warehouse. Before a loyalty-analytics project begins, the governance team must document what each field means, how it is formatted, and who owns it. Which deliverable best satisfies this requirement?

A marketing team wants to use customer email addresses collected for newsletter subscriptions to send third-party promotional offers. The data governance policy states that data must be used only for the purpose for which it was collected. Which action should the data governance team take?

A payroll analyst receives a spreadsheet of employee compensation and needs to share aggregate salary statistics with an external benchmarking vendor. Which action best aligns with data minimization principles?

A multinational corporation is implementing a data governance program. The Chief Data Officer wants to ensure that data quality issues are detected and resolved promptly across all business units. Which combination of roles and responsibilities is most appropriate for this goal?

A data analyst at a regional bank is asked to share a de-identified customer churn dataset with an external marketing consultancy. Before releasing the data, the analyst must confirm that all direct identifiers such as names, account numbers, and Social Security numbers have been removed. Which data governance concept does this action primarily address?

A financial services firm classifies its datasets into public, internal, confidential, and restricted tiers. A data engineer requests access to a restricted customer transaction dataset to build a fraud model. Which combination of controls best enforces the governance policy for this request?

A data analyst at a healthcare organization is preparing a dataset for analysis that includes patient identifiers. The organization must comply with HIPAA and internal data governance policies. Which two actions should the analyst take to protect patient privacy while enabling analysis? (Choose two.)

A financial services firm stores customer account records in a relational database. An analyst must assign a classification label to a new table containing Social Security numbers, account balances, and transaction histories. The firm's data governance policy defines four tiers: Public, Internal, Confidential, and Restricted. Which classification tier is most appropriate for this table?

A regional bank's analytics team maintains a data catalog. A new analyst needs to know which column in the 'loan_applications' table stores the customer's country of residence, what values are permitted, and who owns the table. Which data governance artifact should the analyst consult FIRST to obtain all three pieces of information?

A data analyst at a healthcare insurer is building a new analytics dataset that combines claims data with member demographic data. The compliance team requires the analyst to apply data governance controls that support accountability and traceability. Which TWO actions best satisfy this requirement? (Choose two.)

A multinational corporation is implementing a data governance framework. The legal team requires that data stored in the European Union not be transferred to the United States without adequate safeguards. The data engineering team uses a cloud-based data warehouse that replicates data across regions for performance. Which mechanism should the governance team prioritize to ensure compliance with cross-border data transfer requirements?

A hospital's data governance committee is drafting a policy that defines who may access patient diagnosis records, how long those records must be retained, and the process for requesting exceptions. Which governance artifact is the committee creating?

A data governance committee is reviewing a new analytics project that will combine customer data from a CRM system with clickstream data from a website. The committee must ensure compliance with the organization's data retention policy. Which consideration is most critical when determining the retention period for the combined dataset?

A junior data analyst at an e-commerce company wants to query a production customer table that contains email addresses and purchase history. Company policy states that analysts may access only the columns needed for their assigned task and must request elevated access for sensitive fields. Which data governance principle is the policy enforcing?

A marketing analyst wants to append a purchased third-party demographic file to the company's customer records. The vendor's contract states the data may be used for internal analytics but not redistributed. Which data governance concept governs how the analyst may lawfully use this dataset?

A multinational retailer must comply with GDPR for its European customers. The governance team is mapping where personal data originates, how it flows between the CRM, marketing automation platform, and analytics warehouse, and which transformations occur at each hop. Which governance capability does this mapping effort primarily establish?

A data analyst at a pharmaceutical company is asked to create a report on clinical trial adverse events. The report will be shared with the FDA. The analyst must ensure that the data is accurate, complete, and traceable to source documents. Which data governance practice is most critical to meet these requirements?

A multinational retailer stores customer records in a cloud data warehouse. The governance council must classify each attribute by its sensitivity so downstream masking rules can be applied automatically. The privacy officer asks which classification label should be applied to a field containing government-issued identification numbers that, if exposed, would create legal liability and identity-theft risk.

A financial services firm is designing access controls for a new analytics platform. Regulators require that analysts see only the customer records relevant to their assigned region, and that every access to personally identifiable information be logged. Which combination of controls should the governance team implement to satisfy both requirements?

A multinational retailer stores customer transaction data in a cloud data warehouse hosted in the European Union. A new analytics team in Brazil needs to analyze this data, but legal counsel warns that transferring personal data out of the EU may violate GDPR. The company decides to keep the data in the EU region and give the Brazil team remote access through a governed query layer. Which data governance concept does this decision primarily address?

A data governance council at an insurance company is establishing a data stewardship program. The council wants to define the core responsibilities that data stewards will own within their assigned domains. Which two responsibilities are most appropriate for data stewards? (Choose two.)

A data governance council is reviewing how a national retailer handles its customer master data. The council must document the people and groups accountable for the data across its lifecycle. Which TWO roles should be formally defined in the governance charter to establish clear accountability? (Choose two.)

A financial services firm maintains a data catalog for its analytics platform. The governance team is defining the roles and responsibilities for a new data stewardship program. The chief data officer wants a single accountable person for each critical data domain, such as customer or transaction data, who approves definitions, resolves quality issues, and enforces policy. Which role should be assigned this accountability?

A data analyst receives a complaint that a dashboard shows a customer's city as 'New York' while the source CRM shows 'NYC'. The analyst traces the issue to a transformation that maps state abbreviations but does not standardize city names. Which data quality dimension is most directly affected by this inconsistency?

A telecommunications company's data governance audit reveals that a marketing analyst downloaded a full customer call detail record dataset to a personal laptop for weekend analysis. The dataset contains names, phone numbers, and call timestamps. The governance team must recommend a control that most directly prevents this specific scenario from recurring while preserving legitimate analytical work. Which control is most appropriate?

A logistics company maintains a master customer table used by billing, operations, and analytics. Two source systems submit conflicting addresses for the same customer, and reports now disagree. Which governance practice should be applied to resolve the conflict and prevent recurrence?

An insurer's data governance team discovers that a legacy reporting pipeline transforms policy effective dates using a hard-coded time zone offset that was correct five years ago but is now wrong for a newly acquired business unit. The team must document where the defect originates, which downstream reports are affected, and how to prevent recurrence. Which governance capability is MOST directly suited to this investigation?

A hospital analytics team is preparing to share a de-identified patient outcomes dataset with an external research partner. The privacy officer requires that the dataset satisfy governance requirements for lawful secondary use while preserving analytical utility. Which two practices should the team apply? (Choose two.)

A marketing analytics team maintains a customer contact table that includes email addresses and mobile numbers. The governance policy states that consent must be recorded and honored for each channel before outreach. A campaign manager wants to email everyone in the table, but the analyst notices that many records lack a consent timestamp. Which governance principle should guide the analyst's decision?

A data governance council at an insurance company is reviewing an incident in which an analyst exported a customer dataset to a personal cloud drive. The council wants a control that detects and blocks sensitive data leaving the managed environment regardless of which application initiates the transfer. Which control type should the council implement?