security

A data analyst has built a dashboard for a retail chain that shows sales by product category. During user testing, store managers report that they cannot tell which categories are the top performers because the bars are arranged in the order the categories appear in the database, and the y-axis starts at zero with a very high maximum that compresses all bars. Which change should the analyst make to improve the chart's communicative value?

A business analyst creates a one-time report to analyze customer churn for a special project. Which report type is being used?

A healthcare provider needs to integrate patient data from multiple clinics into a single data warehouse. Which process is used to extract, transform, and load the data?

An analyst runs an A/B test with 1000 users per group and observes a conversion rate of 5% in the control and 6% in the treatment. The p-value is 0.12. What should the analyst conclude?

A financial services company is implementing a data governance program. The chief data officer wants to ensure that data is classified according to its sensitivity and that access is restricted accordingly. The company must comply with GDPR and internal policies. Which data governance component is primarily responsible for defining and enforcing data classification and access controls?

In A/B testing, the null hypothesis typically states that:

A data analyst wants to show the relative proportions of defects by type in a manufacturing process. There are 6 defect types. Which chart is most appropriate?

A retail company wants to analyze customer purchase patterns over time. The data is stored in a relational database with tables for Customers, Orders, and Products. Which database concept should be used to ensure that each order references a valid customer?

An analyst wants to show the trend of monthly sales over the past two years. Which chart type is most appropriate?

Which TWO of the following are benefits of database normalization to 3NF? (Select 2)

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

A data analyst receives a sales dataset where the 'order_date' column is stored as text in the format '2024-03-15'. The analyst needs to calculate the number of days between each order date and the current date. Which action should the analyst take first?

An analyst computed the mean, median, and mode of a dataset and found they are all equal. Which of the following best describes the distribution?

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?

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 time series of monthly sales data exhibits a clear upward trend over several years, with consistent peaks each December. Which components are present in this series?

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 dataset contains a feature with values ranging from 10 to 1000. The analyst applies min-max normalization to scale the feature between 0 and 1. What is the normalized value of 520?

A data analyst needs to count the number of orders placed by each customer, but only for customers who have placed more than 5 orders. Which SQL clause should be used to filter the aggregated results?

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 company uses a dashboard to monitor server uptime. The data is collected every minute, but the dashboard only refreshes every hour. Users see gaps in the line chart. What is the most likely cause, and how should it be fixed?

A retail analyst must build a single dashboard that executives will view on a large conference-room display and regional managers will open on tablets in the field. The executive layout uses a dense 4x3 grid of small KPI tiles. Which design approach best preserves readability across both viewing contexts?

A data analyst is creating a dashboard for a retail company. The dashboard should provide insights into sales performance across multiple dimensions. Which TWO chart types are best suited for showing the contribution of each product category to total sales?

Which chart type is best for comparing the distribution of a continuous variable across different categories?

A data analyst wants to show the distribution of customer ages for a retail store. The ages are continuous and the analyst needs to visualize the frequency of different age ranges. Which chart type is most appropriate?

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

A data analyst needs to combine customer data from two tables: Customers (CustomerID, Name) and Orders (OrderID, CustomerID, Amount). Only customers who have placed at least one order should be included. Which JOIN type should be used?

A large retail company is integrating customer data from two separate CRM systems into a new data warehouse. System A stores customer IDs as integers (e.g., 12345), while System B stores them as alphanumeric strings (e.g., 'CUST-12345-X'). Additionally, some customers exist in both systems but with slight name variations (e.g., 'John Smith' vs 'Jon Smith'). The data warehouse requires a unified customer table with a single unique identifier for each customer. The analyst needs to design the data acquisition process. Which of the following is the most appropriate first step?

A data analyst is creating a report that compares the performance of five different marketing campaigns over the past year. The analyst wants to show both the total revenue generated by each campaign and the proportion of total revenue that each campaign represents. Which combination of visualizations is most effective for this purpose?

An analyst is comparing the average sales of two different store locations using a t-test. The p-value obtained is 0.03, and the significance level is 0.05. What should the analyst conclude?

A data analyst is working with a dataset that includes customer names, email addresses, and purchase history. The analyst wants to ensure that each customer is uniquely identified. Which TWO database concepts should be used to enforce uniqueness and link related data?

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 preparing to run an A/B test comparing two email subject lines. Which TWO of the following should the analyst define before the test begins?

In a dataset of employee salaries, the analyst notices one value that is significantly higher than the rest. Using the IQR method, which values are typically considered outliers?

A retailer wants to test if a new website layout increases the average time spent on the site. They split traffic: control group (old layout) and treatment group (new layout). Which statistical test is most appropriate to compare the average time spent between the two groups?

A data analyst is working with a dataset that contains a column for 'order_date' stored as text in the format 'YYYY-MM-DD'. The analyst needs to calculate the average time between orders for each customer. Which of the following steps should the analyst take first?

A data analyst is performing a hypothesis test with a significance level of 0.05. The p-value obtained is 0.03. What should the analyst conclude?

A data analyst needs to visualize the relationship between advertising spend and sales revenue for 50 products. Which chart type is most appropriate?

A data analyst runs an A/B test on a new website layout. The test yields a p-value of 0.04 with the null hypothesis being no difference in conversion rates. The significance threshold is α=0.05. Which of the following is the correct conclusion?

A healthcare analytics team is ingesting a nightly CSV extract of patient encounters. The extract occasionally contains rows where the 'discharge_date' is earlier than the 'admission_date'. The team wants the pipeline to flag these rows for review rather than silently load them. Which data preparation action best addresses this requirement?

A business intelligence analyst is designing a dashboard for executives. The dashboard includes revenue, profit margin, and customer satisfaction score. To maximize the data-ink ratio, the analyst should:

A data analyst needs to combine two datasets: one contains customer information (customer_id, name, address) and the other contains order information (order_id, customer_id, order_date). The analyst wants to include all customers, even those who have not placed orders. Which type of join should be used?

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

Refer to the exhibit. What does the query return?

Match each data quality dimension to its description.

A data analyst is performing a chi-square test of independence on a 2x2 contingency table. The p-value is 0.04. At α=0.05, which THREE of the following statements are correct?

A data analyst notices that a column labeled 'Income' contains values like '$50,000' and '$75,000', but also 'High' and 'Low'. What data concept issue is occurring?

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 company needs to store user session data for a web application. Each session has a unique session ID, and the data must be retrieved very quickly by session ID. The data does not require complex relationships or transactions. Which type of NoSQL database is most appropriate?

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 marketing team needs to store customer feedback from social media posts, including text, images, and emojis. Which data concept is most appropriate for this storage?

Which TWO of the following data quality dimensions are most directly affected by duplicate records?

A data architect is evaluating storage engines for a new analytics platform. The platform must support storing large volumes of structured historical sales data and must efficiently handle queries that aggregate a few columns across billions of rows. The architect is considering column-oriented storage. Which two characteristics accurately describe column-oriented storage in this context? (Choose two.)

A data engineer is designing a data pipeline for a retail company. The source system is an OLTP database that records sales transactions. The target is a data warehouse used for reporting. The engineer is evaluating whether to use ETL or ELT. Which three factors would favor using ELT over ETL? (Select THREE)

A company uses a NoSQL document database to store product catalogs. Each product document includes fields like product_id, name, category, and price. The operations team frequently queries by product_id and by category. Which type of NoSQL database is being used, and what should be created to optimize queries by category?

In a dataset with variables on different scales (e.g., age in years and income in dollars), which preprocessing step is necessary before applying k-means clustering?

A data analyst at a retail company is building a multiple linear regression model to forecast weekly sales. The dataset contains 50 predictor variables, including store size, promotional spend, holiday indicators, and many others. After training the model, the analyst observes an R-squared of 0.99 on the training set but only 0.55 on the holdout test set. Which action should the analyst take first to address this discrepancy?

A marketing analyst needs to combine customer data from a CRM database with social media engagement data from a third-party API. Which data acquisition method is most appropriate?

A data analyst is working with a dataset that contains a column for customer satisfaction ratings on a scale of 1 to 5, where 1 means 'very dissatisfied' and 5 means 'very satisfied'. The analyst wants to calculate the median satisfaction score. Which level of measurement does this data represent?

Which THREE are best practices for acquiring data via web scraping? (Select exactly 3)

A data analyst is evaluating a classification model that predicts whether a customer will churn. The model's confusion matrix shows 80 true positives, 20 false negatives, 30 false positives, and 120 true negatives. Which TWO of the following metrics can be directly calculated from this confusion matrix? (Choose two.)

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?

During data profiling, an analyst wants to identify the number of distinct values in a column. Which SQL function should be used?

A data analyst is writing a query to rank products by total sales amount within each category. They want ties to have the same rank and no gaps in the ranking sequence. Which window function should they use?

Which THREE of the following are appropriate methods to handle outliers in a dataset?

A marketing team wants to collect data on competitor pricing for similar products. Which data source is most appropriate?

An analyst is preparing data for a clustering algorithm that uses Euclidean distance. Which TWO data preprocessing techniques should be applied to ensure all features contribute equally?

An analyst calculates a Pearson correlation coefficient of -0.8 between advertising spend and customer churn rate. Which interpretation is correct?

In Tableau, which of the following is used to create a calculated field that aggregates data at a different level of detail than the view?

A data analyst has built a dashboard tracking monthly active users (MAU) for a mobile app over the past two years. The executive sponsor complains that the line chart is hard to read because the y-axis starts at zero, making month-to-month variation look small. The analyst wants to emphasize the trend and small fluctuations while still being honest about the data. Which change to the y-axis is most appropriate?

A data analyst wants to segment customers into groups based on their purchasing behavior. The dataset includes numerical features such as annual income and purchase frequency. Which algorithm is most appropriate for this task?

To consolidate data from multiple operational databases into a central repository for reporting, a company decides to transform data before loading it into the target system. Which data integration approach is being used?

When designing a dashboard for executives, which principle is most important to follow to ensure key information is immediately visible?

Which THREE of the following are NoSQL database types?

Which TWO of the following are common methods for acquiring data from external sources?

A senior data analyst is advising a team on dashboard design principles. Which THREE of the following are recommended best practices? (Choose three.)

An analyst needs to count the number of orders per customer but only for customers who have placed more than 5 orders. Which SQL construct allows filtering after aggregation?

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?

Which TWO visualization types are suitable for showing the distribution of a single continuous variable?

A data analyst needs to design a report for two audiences: executives want a high-level trend, and operational managers need current inventory levels. Which approach best satisfies both?

A data analyst needs to determine whether the mean sales of two different regions are significantly different. The samples are independent and the data is normally distributed. Which statistical test should be used?

A data analyst needs to visualize the relationship between two continuous variables, such as sales revenue and advertising spend, to identify potential correlation. Which chart type is most appropriate?

A data scientist is conducting an A/B test with a significance level of 0.05. Which three factors should be considered when calculating the required sample size? (Choose THREE)

A logistic regression model is used to predict the probability of customer churn. The model's coefficient for the feature 'customer support calls' is 0.8 with a p-value of 0.001. Which interpretation is correct?

In time series decomposition, a data analyst separates a retail sales series into trend, seasonal, and residual components. After decomposition, the residual component shows no pattern and is random. Which of the following best describes the seasonal component?

A data analyst calculates the mean, median, and mode of a dataset. Which measure of central tendency is most affected by extreme outliers?

A retail analyst needs to determine the most popular product category. The dataset includes columns: ProductID, Category, SalesDate, QuantitySold, UnitPrice. Which column contains qualitative data?

A data analyst is presenting a story about why customer churn increased last quarter. They start by showing the current churn rate, then identify a key event (a pricing change), and finally show the impact of a proposed retention campaign. This structure follows which narrative arc?

Which TWO are common mistakes when creating data visualizations?

A retail company wants to identify customer segments based on purchase history and demographics. Which technique is most appropriate for this task?

In Tableau, an analyst wants to create a parameter that allows users to select a threshold for highlighting products with sales above that value. The parameter is used in a calculated field that returns TRUE if sales exceed the parameter value. Which type of calculated field is this?

A data scientist is using K-means clustering with k=3. After the first iteration, the centroids are recalculated. Which step occurs next in the algorithm?

In a multiple regression model, one predictor has a high p-value (0.45). What should the analyst consider doing?

A data engineer is designing a system to store raw sensor data from thousands of IoT devices. The data is expected to be used for exploratory analytics and machine learning. Which storage solution is most appropriate?

A data architect is designing a schema for a product catalog where each product has a variable number of attributes. Which NoSQL database type is most appropriate?

A data analyst is examining a dataset of customer transactions. The analyst notices that the 'TransactionAmount' column contains values like 100.50, 200.75, and 50.00. The analyst wants to determine the average transaction amount. Which type of data is 'TransactionAmount'?

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 data analyst needs to join two tables in a SQL database: Orders and Customers. The analyst wants to include all orders, even if there is no matching customer record. Which type of join should be used?

A data analyst wants to show the correlation between advertising spend and website traffic. Which chart type should they use?

A business analyst wants to compare the proportion of total sales contributed by each product category in the current year. Which visualization is most suitable?

A data analyst wants to show the sales trend for a product over the past 12 months. Which chart type is most appropriate?

A data scientist is merging retail transaction data from online and in-store sources. Which THREE steps are required to ensure data consistency?

A company is implementing a centralized reporting layer to replace departmental spreadsheets. Which TWO benefits are most directly achieved?

A data engineer needs to acquire data from a legacy mainframe system that does not support modern APIs or direct database connectivity. Which approach is most feasible?

In a multiple regression model with three predictors, the coefficient for one predictor is 5.2 with a p-value of 0.001. Which of the following is the best interpretation?

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 marketing manager wants to visualize the conversion rate at each stage of a sales funnel, from leads to closed deals. The data shows the number of prospects at each stage. Which chart type is most appropriate for this pipeline analysis?

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 company wants to determine if there is a significant difference in the average sales revenue between two different store layouts. They collect sales data from 30 stores with Layout A and 30 stores with Layout B. Which statistical test is most appropriate for comparing the means of these two independent groups?

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

A sales manager wants to display the contribution of each product category to total revenue, with a maximum of six categories. Which chart type is most suitable?

A database has a table 'Orders' with columns OrderID (PK), CustomerID, OrderDate, and a table 'OrderDetails' with OrderID (FK), ProductID, Quantity. To ensure that every OrderID in OrderDetails exists in Orders, which integrity constraint is enforced?

A data analyst is troubleshooting a map visualization that shows null values for some regions. Which TWO actions should the analyst take to resolve the issue?

While profiling a customer dataset, an analyst finds that the 'country' column contains values including 'USA', 'United States', 'U.S.A.', and 'US' for the same nation, plus 'usa ' with trailing whitespace. Reports grouped by country show fragmented counts. Which preparation step resolves this issue?

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?

An analyst creates a bar chart showing average sales by region. They want to ensure that the y-axis starts at zero to avoid misleading interpretation. This practice aligns with which dashboard design principle?

A data analyst is examining a dataset of customer orders and notices that the 'order_total' column contains values ranging from $5 to $50,000, with most orders under $200. The analyst wants to reduce the influence of extreme values on a linear regression model predicting customer lifetime value. Which technique should the analyst apply?

A data analyst is working with a dataset that contains a 'salary' column with extreme outliers. Before performing a linear regression analysis, the analyst wants to reduce the impact of these outliers. Which technique should be applied?

A logistics company receives GPS tracking data from fleet vehicles at 1-second intervals via a cellular network. The data is used to optimize routes and monitor driver behavior. Recently, the data acquisition system has been missing updates for some vehicles when they pass through tunnels or remote areas. The data team notices gaps during these periods. The company needs a solution to ensure near-real-time data continuity. What should they do?

A time series dataset has several missing months of data. Which chart type will present the most honest picture of the trend?

A data analyst is building a report that will be distributed as a PDF to stakeholders who will view it on various devices, including smartphones. The report includes several charts with small text labels and thin lines. Which action should the analyst take to ensure the charts remain legible on smaller screens?

A retail company wants to test whether a new website layout increases the conversion rate compared to the current layout. They randomly assign visitors to either the control or treatment group. Which statistical test is most appropriate to compare the conversion rates?

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 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 scientist builds a logistic regression model to predict customer churn (yes/no). The model outputs a probability of 0.75 for a particular customer. Which of the following best describes this output?

A company's database has a table 'orders' with columns: order_id, customer_id, order_date, and total_amount. A data analyst needs to identify customers who have placed more than 5 orders in the past year. Which data concept should be used to group orders by customer and count them?

A data analyst at a regional bank is examining monthly account balances for 5,000 customers. The distribution is strongly right-skewed because a small number of high-net-worth clients hold very large balances. The analyst must report a measure of central tendency that best represents the typical customer without being pulled upward by those few extreme accounts. Which measure should the analyst report?

A retail company is migrating its on-premises data warehouse to a cloud data warehouse. The current ETL process extracts data from a transactional database (SQL Server) and a web analytics system (JSON logs). The ETL runs nightly and takes 6 hours. The business requires that the new cloud warehouse support real-time reporting with data latency of less than 15 minutes. The data engineer proposes using change data capture (CDC) from the SQL Server database and streaming the JSON logs via a message queue. However, management is concerned about cost and complexity. The engineer must design a solution that meets the latency requirement while minimizing operational overhead. Which approach should the engineer recommend?

A data analyst at a marketing firm is tasked with segmenting customers based on their purchasing behavior. The dataset contains 10,000 customers with features such as annual spend, frequency of purchases, recency of last purchase, and average order value. The analyst decides to use k-means clustering. After standardizing the features, the analyst runs k-means with k=3, k=4, and k=5, and computes the silhouette score for each: k=3: 0.45, k=4: 0.52, k=5: 0.48. The analyst also plots the elbow curve and observes that the within-cluster sum of squares (WCSS) decreases sharply from k=2 to k=4, then levels off. Based on these results, what is the most appropriate number of clusters?

Which TWO of the following chart types are appropriate for showing the distribution of a continuous variable? (Choose 2.)

A data analyst is building a dashboard that includes a filter for 'Region'. The dashboard also contains a table showing sales by product category. The analyst wants to ensure that when a user selects a region from the filter, the table updates to show only sales for that region. Which feature should the analyst configure?

A data analyst is creating a report that shows the percentage of total sales contributed by each product category. The categories are: Electronics (45%), Clothing (30%), Home Goods (15%), and Toys (10%). Which chart type is most effective for displaying this information?

A data analyst is building a time series forecasting model for monthly sales data. The analyst observes that the data has a clear upward trend and a seasonal pattern that repeats every 12 months. After differencing the data once to remove the trend, the analyst notices that the seasonal pattern remains. Which of the following should the analyst do next to properly model the data?

A data analyst is tasked with extracting data from a legacy system that outputs fixed-width text files. The analyst needs to parse these files into a structured format. Which tool or method is most appropriate for this task?

A data analyst is building a predictive model to forecast customer churn. The dataset includes a categorical feature 'payment_method' with categories: credit card, debit card, PayPal, and bank transfer. The analyst decides to use one-hot encoding. After encoding, the analyst notices that the model's performance on the training set is excellent but poor on the test set. Which issue is most likely contributing to this problem?

A marketing analyst is building a dashboard that groups customers by the state listed in their billing address so the sales team can compare performance across regions. The analyst retrieves the raw address data stored in a single text column. Which data type classification best describes the state field as the analyst intends to use it?

A data analyst is creating a weekly KPI email for executives. Which TWO attributes are most important for this type of report?

A data analyst has built a dashboard that tracks monthly website traffic. The dashboard currently uses a line chart to show the trend of total visits over time. The marketing team now wants to see how each of four traffic sources (organic, paid, social, referral) contributes to the total each month, while still being able to see the overall trend. Which chart type best meets this requirement?

A data analyst is creating a dashboard for a retail company. Which TWO of the following are considered Key Performance Indicators (KPIs) tied to strategic objectives?

A data analyst is presenting a time-series chart of monthly sales to executives. The sales dropped sharply in March due to a one-time supply chain disruption. Which storytelling technique would best help the audience understand this anomaly?

A data analyst is profiling a dataset of customer orders. The 'order_date' column contains dates in various formats, including 'YYYY-MM-DD', 'DD/MM/YYYY', and 'MM-DD-YYYY'. The analyst needs to standardize these dates into a single format for time-series analysis. Which approach should the analyst take?

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

A data analyst needs to sample 1000 customers from a database of 100,000 customers for a survey, ensuring every customer has an equal chance of selection. Which sampling method is most appropriate?

A data analyst is tasked with visualizing the distribution of customer ages across different regions. The dataset contains outliers. Which chart type best displays the distribution and highlights outliers?

A data analyst needs to retrieve current weather data from a third-party service. The service provides an endpoint that returns data in JSON format over HTTP. Which data source type is being used?

A data analyst is reviewing a dataset of customer transactions and notices that the 'transaction_amount' column contains several negative values. The analyst suspects these are refunds rather than errors. Which data validation technique should the analyst apply to confirm this?

A data analyst is preparing a dataset for analysis and discovers that the 'customer_id' column has missing values. The analyst decides to remove all rows with missing 'customer_id' because it is a primary key. Which data preparation technique is being applied?

A data analyst is working with a dataset containing customer ages. The ages range from 18 to 90, but the analyst notices that the distribution is heavily skewed to the right. To better understand the central tendency, the analyst decides to calculate a measure that is resistant to outliers. Which measure of central tendency should the analyst use?

During data acquisition, an analyst notices that the data from an external vendor has inconsistent date formats. What is the first step the analyst should take?

A business analyst is creating a dashboard to monitor sales performance. The primary goal is to quickly identify which regions are underperforming compared to the target. Which design principle is most important to apply?

An analyst creates a pie chart showing market share of four companies: A (45%), B (30%), C (15%), D (10%). A stakeholder complains that it is difficult to compare C and D. Which alternative chart should the analyst recommend?

A data analyst at a healthcare organization is analyzing patient readmission rates. The analyst has a dataset with patient demographics, diagnosis codes, and length of stay. Before performing any statistical modeling, the analyst must address data quality issues. Which TWO of the following actions are most appropriate for ensuring the dataset is ready for analysis? (Choose two.)

A dashboard designer is building a sales performance dashboard for executives. According to dashboard design principles, which TWO practices should be applied? (Choose two.)

A data analyst needs to extract data from a transactional database and load it into a data warehouse for reporting. Which process typically transforms the data before loading it into the warehouse?

A data analyst is presenting a story to executives about a decline in sales. The analyst wants to show the key events that led to the decline, such as a product recall and a competitor's launch. Which storytelling technique should be used?

A company needs to store raw data from IoT sensors for future machine learning projects. The data is expected to be massive and in various formats. Which storage solution is most appropriate?

A data analyst is working with a dataset that includes a column 'Annual Income' with values ranging from $20,000 to $500,000. The analyst wants to reduce the impact of extreme values on a machine learning model. Which technique should the analyst apply?

A data analyst wants to show the proportion of total sales for each product category. There are 4 categories. Which chart type is most appropriate?

Which THREE of the following are best practices when performing data extraction for a data pipeline?

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 warehouse team is considering moving from an ETL to an ELT approach. Which THREE of the following are advantages of ELT over ETL?

A data analyst at a logistics company is designing a new database table to store shipment records. Each shipment has a unique tracking number, a weight in kilograms, a destination city, and a delivery date. The analyst needs to choose a data type for the tracking number that ensures uniqueness and efficient lookups. Which data type is most appropriate for the tracking number?

A dataset contains the ages of 100 customers. The analyst wants to transform the ages to a 0-1 range for use in a distance-based algorithm. Which technique should be used?

A data analyst is creating a dashboard for a hospital's emergency department. The dashboard must display the current wait time, the number of patients waiting, and the average wait time over the past 24 hours. The analyst wants to ensure that the most critical information is immediately visible to the charge nurse. Which design principle should the analyst apply?

Which TWO actions are best practices for creating effective data visualizations?

A data analyst is cleaning a dataset and finds missing values in a categorical variable representing customer region. Which imputation method is most appropriate?

A data analyst is preparing a dataset for analysis and needs to combine data from two tables: 'orders' and 'customers'. The 'orders' table contains a 'customer_id' column, and the 'customers' table contains a 'customer_id' column as the primary key. The analyst wants to include all orders, even those without matching customers. Which type of join should be used?

A data analyst needs to identify duplicate customer records based on email and phone number. Which SQL techniques can be used to find duplicates? (Select TWO).

A data analyst is comparing characteristics of structured and unstructured data. Which TWO of the following are characteristics of structured data? (Choose two.)

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 needs to visualize the relationship between two continuous variables: advertising spend (in dollars) and monthly sales (in units). Which chart type is most appropriate?

A data engineer is ingesting streaming data from a fleet of delivery vehicles. Each vehicle sends GPS coordinates, speed, and timestamp every second. The engineer needs to store this data for real-time dashboards and also retain it for long-term historical analysis. Which data storage approach best balances real-time access and cost-effective long-term retention?

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

A data analyst wants to randomly select 100 customers from a database for a survey, ensuring that the sample reflects the proportion of male and female customers in the population. Which sampling method is most appropriate?

A marketing manager wants to visualize the conversion funnel from website visits to final purchase. Which chart type is most appropriate?

Which data sampling method involves selecting every k-th element from a list after a random start?

A data analyst is extracting data from a relational database using SQL. Which clause is essential for limiting the rows retrieved to only those needed?

An analyst is conducting an A/B test on a new website layout. Which TWO of the following must be defined before the test begins?

A data engineer loads a CSV export into a table. The source system writes the value '007' for a product code, but after loading, an analyst queries the table and sees the value 7. The analyst needs the leading zero preserved for downstream matching against another system. Which action should the engineer take?

A data scientist is building a model to predict customer churn. The company's internal CRM system provides customer demographics and transaction history. They also purchase demographic data from a third-party vendor. How should the purchased data be classified?

A data analyst needs to visualize the distribution of customer ages in a dataset. The analyst wants to see the frequency of ages grouped into bins. Which chart type should be used?

A data engineer is designing a data pipeline where raw data is loaded into a cloud data warehouse (Snowflake) and then transformed using SQL. This approach is called:

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

Which THREE of the following are common mistakes when creating data visualizations? (Choose 3.)

Which TWO color choices are appropriate for a categorical data visualization? (Select two.)

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?

Which SQL function can be used to extract the year from a date column 'order_date'?

A company needs to visualize monthly sales revenue for the past five years to identify seasonal trends. Which chart type is most appropriate?

An organization is implementing a centralized reporting layer to replace multiple departmental spreadsheets. Which governance principle does this support?

An analyst needs to identify outliers in a numeric column 'transaction_amount' using the interquartile range (IQR) method. Which TWO steps are part of this process? (Select TWO).

You are analyzing sales data and need to calculate the moving average of monthly sales over the previous 3 months for each month. Which type of function is best suited for this task?

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 sales report shows a 10% increase in revenue, but the analyst knows the data has limitations. Which TWO elements should be included to communicate uncertainty? (Select TWO.)

A marketing team runs an A/B test comparing two webpage designs. The null hypothesis states there is no difference in conversion rates. The p-value is 0.08 at α=0.05. Which is the correct interpretation?

Which measure best describes the spread of the middle 50% of a dataset?

A data analyst is performing data profiling on a customer dataset. Which metric would best reveal the number of distinct values in the 'state' column?

A data analyst publishes a quarterly financial report in which the same revenue figure is printed on a summary page, a regional breakdown page, and an appendix table. The three values currently come from three separately written queries. Which practice most directly reduces the risk of the pages disagreeing?

An analyst uses K-means clustering on customer purchase data. After plotting the within-cluster sum of squares for different values of k, they observe an elbow at k=4. What is the most appropriate number of clusters?

A data analyst is analyzing a time series of monthly sales for a retail store. The analyst observes a repeating pattern every 12 months. Which component of the time series is the analyst observing?

A data analyst needs to visualize the distribution of customer ages in a dataset containing 10,000 records. The analyst wants to see the shape of the distribution and identify any outliers. Which chart type is most appropriate?

A dataset has missing values in the 'age' column. The distribution of age is approximately normal with few outliers. Which imputation method is most appropriate?

Which chart type is best for displaying the distribution of a continuous variable, such as the age distribution of customers?

A data analyst is comparing the average test scores of students who attended a tutoring program versus those who did not. Which statistical test is most appropriate for determining if there is a significant difference between the means of these two independent groups?

Which THREE data quality dimensions are commonly assessed in a data profiling task?

Which TWO of the following are considered structured data?

In Looker Studio, a data analyst has two data sources: one with customer IDs and transactions, and another with customer demographics. They need to create a chart that includes fields from both sources. Which feature should they use?

Match each data sampling method to its description.

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?

In a linear regression model predicting house prices, the coefficient for the number of bedrooms is $30,000 and the intercept is $50,000. If a house has 3 bedrooms, what is the predicted price?

Which report type is best suited for monitoring the real-time status of manufacturing equipment on the factory floor?

A data team is designing an ETL process to extract data from an operational database daily. The database experiences heavy write loads during business hours. What is the best practice to minimize impact on operations?

In time series analysis, which component represents regular patterns that repeat over fixed periods, such as daily or yearly?

A data analyst receives a request from a sales manager for a one-time report on Q4 performance by product line. The report is not expected to be repeated. Which type of report should the analyst create?

A data analyst is integrating customer data from two source systems: a CRM and a billing system. The CRM uses a customer ID format of 'CUST-12345', while the billing system uses '12345'. The analyst needs to join records on customer ID. Which two steps are necessary to prepare the data for a successful join? (Choose two.)

After a marketing campaign, sales increased by 15%. The analyst wants to understand which customer segment contributed most to the increase. Which type of analysis is this?

A business analyst is asked to distinguish between KPIs and metrics for a new dashboard. According to CompTIA Data+, which TWO statements correctly differentiate KPIs from metrics? (Choose two.)

A marketing analyst needs to answer a one-time question about campaign performance for a specific week. Which report type is appropriate?

A data engineer is designing a data warehouse for a retail company. The fact table must record each sale transaction, including product ID, store ID, date, and quantity sold. The product details (name, category, price) are stored in a separate table. This design is an example of which data modeling concept?

A data analyst is designing a dashboard for executives. Which best practice should be followed regarding the placement of key performance indicators (KPIs)?

An e-commerce company stores customer support emails in a text database, product images in a blob store, and sales transactions in a SQL table. Which data store holds only structured data?

A data analyst wants to concatenate first_name and last_name columns with a space in between. Which string function combination should be used in SQL?

A data analyst is working with a dataset that contains a column 'income' with a highly skewed distribution. The analyst wants to apply a transformation to make the distribution more symmetric for use in a linear regression model. Which transformation is most appropriate?

Which THREE of the following are components of Master Data Management (MDM)? (Select 3)

A marketing analyst is reviewing a dataset of campaign responses. The 'response' column contains values 'Yes', 'No', 'Y', 'N', 'yes', and 'no'. Before analysis, the analyst needs to count how many customers responded positively. Which data preparation step is most appropriate?

A data scientist is building a K-means clustering model for customer segmentation. After plotting the within-cluster sum of squares (WCSS) against the number of clusters (k), she observes that the WCSS decreases sharply until k=5 and then levels off. Which value of k should she choose based on the elbow method?

A data analyst wants to visualize the distribution of customer ages, including quartiles and potential outliers, for a dataset with 10,000 records. Which TWO chart types are appropriate? (Choose two.)

A data analyst needs to combine customer data from a MySQL transactional database with product data from a MongoDB document store to create a unified view for reporting. The analyst uses a SQL query that joins the tables after extracting data from both sources. Which database concept is being applied?

A data analyst is designing a self-service reporting platform for business users. Which TWO practices will help ensure data consistency and trust? (Select TWO.)

A financial analyst needs to show how net income is derived from revenue, costs, and expenses over a period. The chart should highlight the contribution of each component. Which chart type is most appropriate?

Which database concept ensures that data in one table corresponds to data in another table, preventing orphan records?

A data analyst creates a dashboard showing average order value by region. The chart indicates that one region has an unusually high average. Investigation reveals that the region has very few orders, but one large purchase inflates the average. Which data transformation should the analyst apply to improve the visualization?

Which TWO are common pitfalls when communicating data insights?

A data analyst is designing a dashboard that will be viewed on both desktop monitors and mobile devices. The dashboard contains several charts and KPI cards. Which design approach best ensures usability across these devices?

A data analyst is pulling data from a production database for a report. The database contains customer orders with a column 'order_date'. The analyst notices that some orders have dates in the future. Which data quality issue does this represent?

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 data analyst at a hospital is building a report on patient readmissions. The analyst needs to combine the patient demographics table (which uses PatientID as the primary key) with the admissions table (which uses AdmissionID as the primary key and also contains PatientID as a foreign key). Which type of operation should the analyst use to combine these two tables?

A data analyst is building a report that will be distributed as a PDF to stakeholders. The report includes a bar chart showing sales by region. The analyst wants to ensure that the chart is accessible to color-blind readers. Which action should the analyst take?

A data analyst is preparing a dataset for a machine learning algorithm that assumes normally distributed features. Which TWO data transformation methods should the analyst consider to achieve this?

A retail company with 500 stores across North America wants to visualize its sales performance. The dataset includes store ID, region (Northeast, Southeast, Midwest, West), product category (Electronics, Clothing, Home Goods), monthly sales (in dollars), and date (from January 2018 to December 2023). The data has missing values for about 5% of store-month combinations, and a few stores have reported sales that are 10 times higher than the average for their region due to grand opening events. The goal is to create a dashboard that shows monthly sales trends for each region and product category, and allows users to identify which categories are driving growth. Which approach should the analyst take?

A retail analytics team is building a monthly dashboard that must show the running total of sales for each store from the first day of the fiscal year through the current transaction date. The sales table contains one row per transaction with columns store_id, transaction_date, and sale_amount. The analyst needs a query that returns every transaction row with an additional column showing the cumulative sales for that store up to and including that transaction. Which SQL approach should the analyst use?

A dataset contains employee salaries ranging from $30,000 to $200,000. An analyst wants to scale the salaries to a range of 0 to 1 for use in a distance-based clustering algorithm. Which method should they use?

In a table 'employee_hierarchy' with columns 'employee_id', 'manager_id', and 'employee_name', an analyst needs to generate a list of all employees under a specific manager, including multiple levels of subordinates. Which SQL construct is most appropriate for querying this hierarchical data efficiently?

A healthcare organization acquires data from multiple hospitals with different patient record systems. The data includes patient IDs but no common identifier across systems. Which technique should be used to link records?

Which SQL aggregate function would an analyst use to calculate the average value of a numeric column?

An organization wants to assign responsibility for data quality and metadata management. Which role is primarily accountable for defining data standards and ensuring data quality across a specific domain?

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

A research firm is acquiring data from public government databases via API. The API rate limits at 100 requests per minute. They need to download 10,000 records, but each request returns a maximum of 100 records. What is the most efficient approach to ensure complete acquisition without being blocked?

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?

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

In an A/B test, the null hypothesis states that there is no difference between the conversion rates of the control and treatment groups. After collecting data, the p-value is 0.03. Using a significance level α = 0.05, what should the analyst conclude?

Which of the following data sources is most likely to generate streaming data?

A financial report must be retained for seven years to comply with regulatory requirements. This is an example of which data governance principle?

A data analyst receives a dataset with a column 'salary' that contains values like '45,000', '55,000', and '65,000'. The analyst notices that the values are stored as text. Which data concept should be applied to convert the salary column from text to numeric format for analysis?

An analyst is profiling a newly acquired customer table and wants a quick summary of the central tendency and spread of the 'annual_income' column, which contains a few extreme outliers from data entry errors. Which combination of descriptive statistics is most appropriate to report the typical income while limiting the influence of those outliers?

An analyst needs to combine two datasets from different sources that share a common key but have different levels of granularity. Dataset A has daily sales per store, Dataset B has hourly foot traffic per store. The analyst wants to analyze correlation. Which approach is appropriate?

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 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 data analyst uses Python's pandas library to read a CSV file into a DataFrame. Which function is used to read the file?

A data analyst is designing a data model for a sales data warehouse. The model should optimize query performance for aggregations by minimizing joins and duplicating data where necessary. Which schema design should the analyst use?

A data analyst is merging two datasets: one containing customer demographics with a 'customer_id' column, and another containing transaction records with a 'cust_id' column. The analyst needs to combine these datasets to analyze purchasing behavior by demographic. Which SQL join condition should be used?

A dashboard designer wants to ensure that the most important metric, such as total revenue, is prominently displayed at the top left. Which dashboard design principle is being applied?

A data analyst uses linear regression to model the relationship between advertising spend and sales. The residual plot shows a clear U-shaped pattern. What assumption is violated?

A data engineer is profiling a dataset of customer orders and notices that the 'order_date' column contains values in multiple formats: 'YYYY-MM-DD', 'MM/DD/YYYY', and 'DD-Mon-YYYY'. The column is currently stored as a string. Which action should the engineer take to ensure consistent date handling for analysis?

In a sales database, an analyst needs to retrieve all orders where the order amount is between $100 and $500. Which WHERE clause should be used?

A BI analyst is creating a report in Power BI and needs to calculate the total sales for the current year compared to the previous year. Which DAX function should be used to calculate the previous year's sales?

A company requires real-time masking of credit card numbers for customer support agents while allowing full access for accountants. Which technique should be implemented?

A data architect is designing an ETL pipeline to ingest streaming data from IoT sensors. The data must be available for real-time analytics. Which acquisition method is best?

A healthcare analytics team is building a predictive model to identify patients at high risk of readmission within 30 days of discharge. The dataset includes 50,000 patient records with 200 features, including demographics, vital signs, lab results, and historical admissions. The target variable is binary (readmitted or not). The team uses a logistic regression model and achieves an AUC of 0.72 on the test set. However, the model's calibration is poor: for patients predicted to have a 70% risk, the actual readmission rate is only 40%. The team wants to improve calibration without significantly reducing discrimination (AUC). The data scientist suggests applying Platt scaling. However, the team lead is concerned that Platt scaling may reduce the model's ability to rank patients correctly. Which of the following is the best course of action?

A data analyst is examining a dataset of customer transactions and notices that the 'transaction_amount' column contains negative values. The analyst determines that these negative values represent refunds. Which data quality dimension is most directly relevant to this finding?

A data scientist is performing a hypothesis test with a significance level α=0.05. The p-value obtained is 0.03. What should the scientist conclude?

A healthcare analytics team is building a classification model to predict patient readmission within 30 days. The dataset contains 10,000 records with 30 features, including demographics, vital signs, lab results, and medication history. The target variable is imbalanced: 85% no readmission, 15% readmission. The team used logistic regression with default settings and achieved an accuracy of 85%, but the model predicted 'no readmission' for all patients. The lead analyst suspects the model is not learning due to class imbalance. The team has time to implement one corrective action before the next model review. Which action should the team take?

A data analyst is preparing a dataset for a machine learning model and needs to handle missing values in several columns. The analyst wants to choose appropriate imputation methods. Which TWO of the following are valid considerations when selecting an imputation technique? (Choose two.)

Which TWO of the following are components of time series data?

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 stores customer purchase history in a relational database. The database contains a table 'transactions' with columns: transaction_id, customer_id, product_id, quantity, price, and transaction_date. A data analyst needs to create a report that shows total revenue per customer for the last quarter. Which data concept describes the relationship between customer_id and total revenue?

An organization needs to acquire data from a third-party vendor. The data will be used for regulatory reporting. Which of the following should be the primary consideration before acquiring the data?

A data analyst wants to understand the relationship between advertising spend and sales revenue. The analyst calculates a Pearson correlation coefficient of 0.85. Which of the following is the best interpretation?

A data analyst is building a dataset from multiple sources and needs to ensure data quality. During the data acquisition phase, which activity is most important to perform?

A company is analyzing customer feedback sentiment. The dataset is highly imbalanced with 95% positive and 5% negative comments. Which technique should the analyst use to address class imbalance before modeling?

Which TWO of the following are measures of central tendency?

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 company's sales report shows revenue of $1.2M, but the calculation method is unclear. What data governance artifact would clarify the definition?

In Looker Studio, you have a data source with daily sales and a separate data source with marketing spend. You want to create a chart that shows sales and marketing spend on the same axis, but the two sources are not joined natively. Which feature should you use to combine them?

A data analyst wants to find the top 5 products by total sales amount, but only for products that have been sold more than 50 times. Which SQL query accomplishes this?

A retail analytics team is acquiring point-of-sale transaction files from 40 different store locations. Each store exports its nightly file with a different column order and slightly different header names (for example, 'TxnID' vs 'Transaction_ID' vs 'TransNo'). The analyst must load all files into a single normalized staging table before transformation. Which data preparation approach best addresses this inconsistency at acquisition time?

Which THREE are challenges in acquiring data from external sources? (Select three.)

A data analyst is creating a dashboard in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?

A data analyst needs to sample 10% of customers from each of three regions (North, South, Central) to ensure proportional representation. Which sampling method should be used?

A data engineer is choosing a storage approach for a new analytics platform. The workload consists of wide, denormalized event tables with dozens of attributes, queries that scan a few columns across billions of rows, and heavy aggregation rather than single-row lookups. Which storage structure is best suited to this workload?

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 data analyst wants to use a Z-score to standardize a dataset. The variable has a mean of 50 and a standard deviation of 10. What is the Z-score for a raw value of 70?

A data engineer is designing a database for an online store. The database must enforce strict consistency and handle complex transactions involving multiple tables, such as orders, customers, and inventory. Which database type should the engineer choose?

Which chart type is best for visualizing the correlation between two continuous variables?

A data engineer is acquiring semi-structured JSON event logs from a mobile application. Each event contains nested objects and arrays, and some fields are missing depending on event type. Before loading into a relational warehouse, the engineer must flatten and validate the data. Which TWO acquisition practices are most appropriate for this semi-structured source? (Choose two.)

A data analyst receives a file with the extension .json. This file contains product information with attributes that vary between records. How should this file be classified?

A data analyst notices that the sales numbers in a report differ from the numbers in the finance department's spreadsheet. This discrepancy is most likely due to a lack of:

A data analyst notices that a dataset of customer ages has several missing values. Which method for handling missing data is most appropriate if the data is missing completely at random and the analyst wants to preserve sample size?

A dataset contains a 'salary' column. The analyst wants to identify outliers using the IQR method. If Q1 = 40,000 and Q3 = 70,000, what is the upper threshold for a non-outlier?

An organization is implementing a data warehouse to support business intelligence reporting. The data warehouse must ensure that transactions are processed reliably. Which property guarantees that each transaction is treated as a single, indivisible unit?

The exhibit shows a SQL query result intended for a bar chart of revenue by region. However, the chart shows only the top 10 regions, but the query returns all regions. What is the most likely cause?

A manager in operations needs a real-time dashboard showing production line status, including machine uptime and error counts. Which type of report is most appropriate?

A data analyst must build a one-page dashboard for a hospital's bed-management team. The team needs to know, at a glance, how many beds are free right now, how that compares with the same hour yesterday, and whether the trend is worsening. Which combination of visual elements is MOST appropriate for the top band of this dashboard?

A data analyst needs to retrieve all unique job titles from the employees table. Which SQL clause should be used with the SELECT statement?

A data analyst is building a logistic regression model to predict whether a customer will churn (yes/no). Which TWO statements about logistic regression are correct?

A data analyst is evaluating a classification model that predicts customer churn. The model has an accuracy of 95%, but the analyst suspects it is not performing well on the minority class (churners). The dataset is highly imbalanced, with only 5% churners. Which metric should the analyst prioritize to assess the model's ability to correctly identify churners?

In Tableau, an analyst wants to create a calculated field that returns the average sales per customer only for customers who have made more than five purchases. Which Tableau function or approach would be most efficient?

Which TWO of the following are valid techniques for validating the performance of a predictive model?

An analyst runs a simple linear regression with an R² value of 0.85. Which interpretation is correct?

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 data governance team is drafting a policy for handling personally identifiable information (PII). According to data governance best practices, which document should define the classification levels and handling procedures?

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 wants to identify customers whose last name starts with 'Mc' from the 'customers' table. Which WHERE clause condition should be used?

A data analyst needs to communicate the findings of a marketing campaign analysis to the Vice President of Marketing. The VP typically only reads the first paragraph and wants the key takeaway immediately. Which format should the analyst use?

An analyst is performing K-means clustering on customer data. The elbow method shows a clear bend at k=4. Which THREE of the following are true about K-means clustering with k=4?

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 marketing analyst wants to predict whether a customer will churn (yes/no) based on account age and monthly charges. Which regression technique is most appropriate?

A data analyst is investigating a correlation between two continuous variables. Which THREE of the following are appropriate steps in this exploratory data analysis? (Select THREE.)

An organization wants to ensure that all reports use the same definitions for metrics like 'Active Customer' to avoid confusion. Which data governance element should be implemented?

A data analyst is merging two datasets: one containing employee details (employee_id, name, department) and another containing salary information (employee_id, salary). The employee_id in the first dataset is stored as an integer, while in the second dataset it is stored as a string with leading zeros (e.g., '00123'). The analyst attempts to join the tables on employee_id but gets no matches. What is the most likely cause of the join failure?

A data scientist is analyzing a dataset with multiple features and wants to apply k-means clustering to segment customers. She chooses k = 4 based on the elbow method. During the iteration process, which of the following correctly describes a step in the k-means algorithm?

Refer to the exhibit. Which type of ensemble method is being used?

A healthcare analyst is creating a report on patient outcomes. To comply with privacy regulations, which action should be taken before publishing?

A data analyst is reviewing a SQL query that joins three large tables. The query takes over an hour to run. The analyst notices that the WHERE clause filters on indexed columns in only two tables. Which of the following should the analyst do first to improve performance?

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

An analyst compares average sales across three different store locations using a statistical test. Which test is most appropriate?

A data analyst wants to compare the total sales of four different product categories for a single year. Which chart type is most appropriate for this comparison?

A retail company stores customer transaction data in a relational database. They want to analyze purchasing patterns over time. Which type of data structure best supports this analysis?

A data analyst is evaluating the quality of a customer database. Which THREE of the following are dimensions of data quality?

A data analyst at a marketing agency is working with a dataset containing customer demographics, purchase history, and social media engagement metrics. The agency wants to perform sentiment analysis on unstructured social media comments to identify brand perception. The dataset also includes structured fields like age, income, and purchase amounts. The analyst needs to choose a storage and processing platform that can handle both structured and unstructured data efficiently without requiring extensive schema definition upfront. Which platform should the analyst recommend?

Which data quality dimension ensures that data represents the real-world object or event correctly?

Which of the following is a characteristic of structured data?

A data analyst is performing time series analysis on monthly sales data and notices a consistent pattern of higher sales every December. Which component of time series does this represent?

In a table 'sales_team' with columns 'salesperson', 'quarter', and 'revenue', an analyst wants to assign a rank to each salesperson within their quarter based on revenue, with the highest revenue getting rank 1. However, if two salespeople have the same revenue, they should receive the same rank, and the next rank should be the next consecutive integer (no gaps). Which window function should be used?

A company ingests customer clickstream data from its website. The data arrives continuously in JSON format and must be stored for real-time analytics. Which type of data source is being described?

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 data analyst is cleaning a dataset and identifies several outliers. Which TWO methods are appropriate for handling outliers?

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 is examining sales data for a retail chain and notices that the mean monthly sales is $50,000 while the median is $35,000. Which of the following best describes the distribution of the sales data?

A financial institution needs to acquire credit transaction data from multiple sources while ensuring compliance with data privacy regulations. What is the most critical step?

A company receives daily sales data in CSV format. The data includes a 'Date' column in MM/DD/YYYY format. To load this into a database that expects YYYY-MM-DD, the analyst should:

An executive dashboard needs to display key performance indicators (KPIs) such as sales growth and customer satisfaction. Which design principle is most important?

Refer to the exhibit. A data analyst notices that direct S3 access to files outside the "incoming/" prefix is blocked. Which data governance principle does this policy enforce?

A data analyst is evaluating data quality issues during acquisition. Which TWO issues are most likely to arise from merging data from different sources? (Select exactly 2)

A financial analyst is working with a dataset of stock prices. The dataset contains a column 'Price' that records the closing price of each stock in USD. The analyst wants to calculate the percentage change in price from the previous day for each stock. Which data type is most appropriate for the 'Price' column?

A data audit reveals that some numbers in the "Revenue" column were manually entered from PDF invoices. This introduces potential errors. Which data concept is being addressed?

A data analyst is using pandas to clean a DataFrame. They need to replace missing values in the 'age' column with the median age. Which method should they use?

A data analyst is cleaning a dataset and finds that 5% of values in the 'income' column are missing. The analyst decides to impute missing values using the mean of the non-missing values. Which potential issue should the analyst be most concerned about?

A healthcare analytics team is building a patient readmission risk model. They have a dataset containing admission date, discharge date, primary diagnosis code, and patient age. To predict readmission within 30 days, the team needs to derive a new field that represents the number of days a patient stayed in the hospital. Which data transformation technique should they apply to create this derived field?

Which chart type is best for showing the sales pipeline from leads to closed deals, illustrating how many prospects drop off at each stage?

An organization is integrating data from multiple sources into a data warehouse. They need to handle differences in data granularity (e.g., daily vs. hourly sales data). Which technique is most appropriate?

An organization is implementing a data lake to store raw data from various sources. Which THREE characteristics are typically associated with a data lake compared to a data warehouse?

In Tableau, you want to create a view showing the total sales per region, but also want to allow users to filter by year without losing the ability to see all regions. What feature should you use to compute the total sales that ignores the year filter?

A dataset contains a variable 'Income' with many missing values. The analyst decides to impute missing values with the median income of the non-missing values. Which type of imputation is this?

A data analyst is reviewing a dashboard that tracks monthly sales. The analyst notices that the 'Total Sales' metric for the current month is significantly lower than previous months, but the underlying daily sales data appears normal. The dashboard uses a live connection to the database. Which of the following is the most likely cause of the discrepancy?

A business analyst needs to explain to a sales director that the reported revenue has a 95% confidence interval of ±2%. Which concept is being communicated?

A data analyst wants to generate a report showing employee names and their department names, but some employees are not assigned to any department. The analyst wants to include all employees. Which JOIN type should be used?

A data analyst needs to identify outliers in a dataset. Which of the following is a common method based on the interquartile range (IQR)?

A data analyst needs to count the number of distinct product categories in a table named 'products'. Which SQL function should be used in the SELECT clause?

Which THREE of the following are assumptions of linear regression? (Select THREE).

Which TWO of the following are examples of supervised learning algorithms?

A dashboard should be designed so that the most important metric is prominently displayed. This is an example of which design principle?

A company needs to visualize the trend of monthly sales revenue over the past two years. Which chart type is most appropriate?

A data analyst is examining the relationship between advertising spend (in dollars) and revenue (in dollars). The Pearson correlation coefficient r is calculated as +0.92. Which of the following interpretations is correct?

A data analyst wants to extract the year from a date column 'order_date' in a SQL database. Which function should be used?

A data steward at a retail company is classifying data assets. The company wants to identify which data elements are considered structured data. Which two of the following are examples of structured data? (Choose two.)

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 analyst is examining a dataset of daily website visits collected over the past year. The analyst wants to determine whether the distribution of visits on weekdays differs significantly from the distribution on weekends, without assuming normality. The analyst has already separated the data into two independent groups. Which statistical test should the analyst use?

Refer to the exhibit. What data quality issue is indicated?

A company needs to store raw, unprocessed data from IoT sensors for future machine learning experiments. The data is in various formats and schemas are not yet defined. Which storage solution is most appropriate?

A data governance team is defining roles and responsibilities for data management. Which TWO of the following are common data governance roles? (Select TWO).

In a dataset of customer orders, you need to count the number of distinct customers who have placed orders. Which SQL aggregate function should you use?

A data analyst needs to identify the most frequently occurring value in a dataset. Which measure of central tendency should they use?

Which TWO chart types are best suited for visualizing the distribution of a single continuous variable? (Select two.)

A data analyst is examining a dataset of employee salaries and notices that the distribution is heavily right-skewed due to a few executives with very high salaries. The analyst wants to apply a transformation to make the distribution more symmetric for further analysis. Which transformation is most appropriate?

A data analyst is performing a chi-square test of independence on a contingency table of customer satisfaction (satisfied vs. dissatisfied) and product type (A, B, C). The test yields a p-value of 0.04 with α = 0.05. What is the correct conclusion?

A company wants to share a dataset with external partners via an API. Which API type is typically used for web services and uses XML or JSON for messaging?

A dashboard designer needs to ensure that color choices are accessible to users with color vision deficiencies. Which practice should be followed?

A company wants to segment its customers into distinct groups based on purchasing behavior. Which algorithm is best suited for this task?

A data analyst is designing a dashboard for executives to monitor company performance. Which THREE practices should the analyst follow to ensure effective storytelling with data? (Select three.)

A data analyst is working with a sales table that contains columns: sale_id, product_id, sale_date, and amount. They need to calculate a 7-day moving average of sales amount for each product, ordered by sale_date. Which window function syntax should they use?

Which TWO are best practices for data storytelling?

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

Which of the following data types best describes a JSON file containing customer orders with varying fields per record?

A data analyst needs to present the correlation between advertising spend and website traffic. Which chart type is most appropriate?

A company wants to show the number of products sold across different categories: Electronics, Clothing, Home Goods, and Books. Which chart type is most appropriate?

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 data analyst is creating a dashboard for a sales team. Which TWO actions adhere to dashboard design best practices?

A data team is using web scraping to collect competitor pricing data. The target website has anti-scraping measures like CAPTCHAs and rate limiting. Which approach is most effective?

A data analyst creates a bubble chart showing country GDP (x-axis), life expectancy (y-axis), and population (bubble size). However, large bubbles overlap and obscure many data points. Which corrective action should the analyst take?

Which of the following best describes a data mart?

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

A data analyst is preparing a dataset for analysis and needs to ensure data quality. Which TWO of the following are dimensions of data quality?

A data analyst wants to test if the proportion of customers who prefer Product A over Product B is different from 50%. She surveys 200 customers and finds that 120 prefer Product A. Which statistical test should she use?

Which of the following is an example of semi-structured data?

A data analyst is building a dashboard that includes a KPI card showing the current customer satisfaction (CSAT) score. The target is 90%. The analyst wants the card to immediately convey whether the current score is meeting, approaching, or below target. Which design approach best achieves this?

A data analyst needs to count the number of customers who have placed at least one order. Which SQL query should be used?

A data analyst is assessing the quality of a newly acquired dataset from an external source. The analyst needs to evaluate two dimensions of data quality that directly affect the dataset's fitness for use in analysis. Which two dimensions should the analyst prioritize? (Choose two.)

A company uses a data warehouse for reporting. They need to extract data from multiple sources, load it into a staging area, and then transform it before moving to the warehouse. This process is known as:

A data analyst is exploring a dataset of 8,000 customer transactions and notices that the 'transaction_amount' column has a mean of $120 but a median of $45. A small number of transactions exceed $10,000. Which measure of central tendency should the analyst report to describe the typical transaction?

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 retail company wants to predict sales based on advertising spend and season. Which data modeling technique should the analyst use?

A healthcare organization maintains a database of patient records. The database has a table 'patients' with columns: patient_id (primary key), first_name, last_name, date_of_birth, gender, and last_visit_date. A data analyst is tasked with creating a report that lists all patients who have not visited in the last two years. The analyst writes a query: SELECT * FROM patients WHERE last_visit_date < DATEADD(year, -2, GETDATE()); However, the query returns zero rows, even though the analyst knows there are patients who have not visited for over two years. Upon inspection, the analyst discovers that the last_visit_date column contains NULL values for patients who have never visited. Which modification to the query should the analyst make to include patients with NULL last_visit_date?

A data team is preparing data for a clustering analysis. Which THREE of the following steps are commonly part of data cleaning?

Match each data analysis tool to its primary function.

A data analyst is creating a report that will be printed in black and white for a quarterly business review. The report includes a bar chart comparing revenue across five product categories. To ensure the chart is interpretable without color, which design element should the analyst prioritize?

A financial analyst wants to create a dashboard that shows the monthly profit and loss, highlighting how each component (revenue, cost of goods sold, operating expenses) contributes to the final net profit. Which chart type is most appropriate?

In Power BI, an analyst wants to create a measure that calculates the total sales for the current year up to the latest date in the data. Which DAX function should be used?

A data analyst needs to retrieve all unique job titles from an employees table. Which SQL keyword should be used in the SELECT clause?

A healthcare organization collects patient questionnaire data via paper forms at clinics. The forms are scanned and sent to a central office, where staff manually enter data into an electronic system. This process is slow and error-prone. The organization wants to reduce manual entry errors and speed up data availability. Which method should they adopt?

A data scientist is performing K-means clustering on customer data. She plots the within-cluster sum of squares (WCSS) for different values of k and observes an 'elbow' at k=4. What does this indicate?

Which of the following is a key difference between a Key Performance Indicator (KPI) and a metric?

Which TWO of the following are characteristics of a data lake?

Which TWO of the following are characteristics of structured data? (Choose TWO.)

A data analyst is evaluating a multiple regression model with three predictors. The R² value is 0.85. Which of the following is the best interpretation of R²?

A financial institution wants to analyze transaction networks to detect fraud rings. Which database type is best suited for this analysis?

An analyst is profiling a table of laboratory test results. The ResultValue column stores numeric readings, but a subset of rows contains the literal text "N/A" in that column, and a separate ResultUnit column records units such as mg/dL or mmol/L. The analyst must compare average ResultValue across two hospital sites. Which data issue most directly prevents a valid comparison, and what is the appropriate first step?

A data analyst is troubleshooting a report that shows unusually high sales for a specific product. Upon investigation, the analyst finds that the product was returned by several customers, but the returns were recorded in a separate system and not reflected in the sales data. Which data integration concept was likely missing?

A business needs to store large volumes of raw data in its native format for future analytics. Which storage architecture is most appropriate?

A data analyst is using pandas in Python to merge two DataFrames: sales (columns: sale_id, product_id, amount) and products (columns: product_id, product_name). Which pandas function should they use to combine these DataFrames on the 'product_id' column?

You are a data analyst for an e-commerce company. Your team has built a dashboard to monitor daily sales performance across five regions: North, South, East, West, and Central. The dashboard includes a bar chart showing total sales per region, a line chart showing daily sales trend over the past 30 days, and a pie chart showing sales distribution by product category (Clothing, Electronics, Home, Books, Sports). Recently, stakeholders have complained that the pie chart is hard to interpret because the Sports category has very small sales and is barely visible. Also, the bar chart uses a rainbow color scheme that makes it difficult to compare bar heights because the colors are not ordered by magnitude. The line chart is fine. You need to redesign the dashboard to address these issues. Which combination of changes is most appropriate?

A market research firm collects survey responses where customers rate satisfaction on a scale of 'Very Unsatisfied', 'Unsatisfied', 'Neutral', 'Satisfied', 'Very Satisfied'. What type of data is being collected?

Which TWO of the following are dimensional modeling techniques commonly used in data warehouses?

A data scientist trains a regression model and observes high variance with low bias. Which technique is most appropriate to reduce variance?

A data architect is designing a system to store customer support tickets. The tickets are written in free-form text and include attachments such as screenshots and PDFs. The system must allow support agents to search for tickets by keywords within the text and attachments. The architect expects the volume of tickets to grow to millions and requires fast, full-text search capabilities. Which storage solution is most appropriate?

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

A data analyst frequently receives ad hoc requests for the same type of analysis. Which TWO approaches could reduce the number of ad hoc requests?

An executive dashboard must display high-level KPIs such as current revenue, profit margin, and customer count. Which visualization type is most appropriate for each KPI?

A data analyst is creating a self-service reporting environment. Which data governance practice ensures users see only data relevant to their department?

An analyst is creating a report in Power BI and needs to calculate year-to-date total sales compared to the same period last year. Which TWO DAX functions should be used? (Choose two.)

A data scientist is building a machine learning model to predict customer churn. The dataset includes both numerical features (age, income) and categorical features (gender, marital status). Which data concept describes the process of converting categorical features into numerical values that can be used by the algorithm?

A logistic regression model predicts customer churn (0=no churn, 1=churn). The model outputs probabilities. Which THREE of the following statements about logistic regression are correct?

A data analyst is creating a visualization to show the proportion of total sales contributed by each of five product categories. The analyst wants to emphasize the relative size of each category as part of a whole. Which type of chart is most appropriate?

A data analyst is performing data profiling on a customer table. Which metric would best help identify missing values in the 'phone' column?

A DBA wants to improve query performance on a large table that is frequently filtered on two columns: department_id and hire_date. The table has millions of rows. Which index strategy would be most effective?

A data analyst is performing a chi-square test for independence between two categorical variables. Which THREE of the following are necessary conditions for the test to be valid?

A retail company wants to analyze monthly sales data over the past three years to identify long-term trends. Which component of time series analysis is most relevant for this goal?

A company is planning an A/B test to compare two website designs. Which THREE of the following must be determined before the test begins to ensure valid results? (Select three.)

A marketing analyst wants to segment customers based on their purchase history, including total spent, number of transactions, and average order value. The analyst runs k-means clustering with k=5 on the raw data but notices that the cluster assignments change significantly every time the algorithm is executed. What should the analyst do first to obtain consistent and meaningful clusters?

Refer to the exhibit. Which clause is used to aggregate the data by department?

An analyst wants to visualize the relationship between advertising spend (x-axis) and revenue (y-axis) for 100 different products. Each product is in one of three categories. Which chart type best displays this data?

A data analyst creates a weekly KPI dashboard for executives. The analyst notes that the data is updated as of the previous day. Which report quality element should be included?

A data engineer is ingesting JSON data from an IoT sensor network. The JSON records contain nested arrays and objects. The engineer needs to flatten the structure to load it into a relational table. Which approach is most appropriate?

You are a data analyst at a logistics company. The operations manager wants to reduce delivery delays. You have historical data including order date, delivery date, distance, weather conditions, and driver ID. Initial analysis shows that the average delivery time has increased over the past six months. You suspect that weather is a contributing factor, but you need to confirm. The company also wants to build a model to predict delivery times to better manage customer expectations. The data contains missing values for weather conditions in about 10% of records, and some driver IDs are incorrect. You have limited time and resources. What should you do first?

Which THREE actions improve the accessibility of data visualizations for users with visual impairments? (Select exactly three.)

An analyst creates a stacked bar chart showing quarterly sales by product category. The chart becomes hard to read because some categories have very small contributions. Which redesign is most effective?

A data analyst is comparing the means of two independent groups using a t-test. The sample sizes are small and the data is not normally distributed. Which condition is violated for a valid t-test?

A data analyst finds that the "Age" column contains values like "N/A", "unknown", and negative numbers. Which data quality dimension is primarily affected?

A data engineer is loading a large CSV file into a relational staging table. Several columns contain numeric values with thousands separators, such as '1,234.56', and a few rows contain the text 'N/A' in those columns. The target columns are defined as DECIMAL. Which approach best prepares the data for a successful load while preserving the ability to audit rejected values?

An IT operations team monitors 200 servers. Each server reports CPU utilization (0-100%) every five minutes for the past year. The team wants to visualize the data to identify servers that are consistently over 80% utilization and detect any unusual spikes. They have a large dataset with 100,000+ records per server. The current visualization is a single scatter plot with CPU utilization on the y-axis, time on the x-axis, and each server as a different colored point. The chart is extremely cluttered, with points overlapping and colors indistinguishable. What should the team do to improve the visualization?

A data analyst needs to summarize customer satisfaction scores. The data contains a few extremely low scores that skew the distribution. Which measure of central tendency is most appropriate?

Which of the following is an example of qualitative data?

An analyst wants to identify outliers in a dataset using the IQR method. Which values are typically considered outliers?

In pandas, you have a DataFrame 'df' with columns 'product' and 'sales'. You want to calculate the total sales per product. Which method should you use?

A data analyst is performing a join between two tables: 'employees' and 'departments'. The 'employees' table has a foreign key 'dept_id' referencing the 'departments' table. Which two join types would include all rows from the 'employees' table, regardless of whether there is a matching department? (Select TWO)

A data engineer is profiling a dataset of online orders. The order_id column contains a unique value for every row, but the analyst notices that a join to the customer table unexpectedly returns fewer rows than the orders table. After investigation, the engineer finds that some customer_id values in the orders table do not exist in the customer table. Which data quality dimension is primarily violated by the customer_id values?

Match each database concept to its definition.

A data analyst is building a model to predict customer churn. The dataset has 10,000 records with 500 churned customers. The model predicts churn with 95% accuracy, but only identifies 10% of actual churners. Which metric best highlights this issue?

A data analyst is creating a dashboard to monitor key performance indicators (KPIs) for a retail company. The dashboard will be used by store managers to quickly assess daily performance. Which TWO design elements are most important to include? (Choose two.)

A data analyst is profiling a dataset of employee records. The birthdate column contains values stored as text in the format YYYY-MM-DD, while the hire date column is stored as a native date type. The analyst needs to calculate employee tenure. Which action should the analyst take first?

In an A/B test, the null hypothesis states that there is no difference between the control and treatment groups. After running the test, the p-value is 0.04. Assuming α = 0.05, what is the correct conclusion?

A data engineer is extracting data from a REST API that returns JSON. The API paginates results with a 'next_page' token. The engineer needs to load all pages into a database. Which approach should the engineer use to ensure all data is acquired?

In SQL, you want to retrieve all products whose names start with 'Pro'. Which WHERE clause should you use?

A data analyst is documenting a report for external stakeholders. Which THREE elements should be included to ensure report quality and transparency?

After building a binary classification model, the data analyst obtains the following confusion matrix: True Positives=80, True Negatives=100, False Positives=20, False Negatives=30. What is the F1 score?

A dashboard shows sales by region using a map with color intensity. Users complain that two regions with very different sales appear nearly the same color. What is the most likely cause?

A university database stores student information in a normalized schema. The 'students' table has a primary key 'student_id'. The 'enrollments' table has a foreign key 'student_id' referencing 'students'. Which two of the following are true about primary and foreign keys? (Select TWO)

A data analyst is creating a report that includes customer names and addresses. To comply with privacy regulations, which TWO actions should the analyst take?

A data analyst wants to combine first_name and last_name columns into a single full_name column in a SQL query. Which string function should be used?

Which TWO actions will improve the readability of a bar chart showing quarterly sales across five regions?

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 Avro schema is defined as shown. Which data design concept does this represent?

A data architect is designing a system to store data for a real-time analytics application. The application requires high-speed ingestion of semi-structured data with flexible schemas, and the ability to query data using SQL-like syntax. The data volume is expected to grow rapidly. Which type of database should the architect choose?

A healthcare analytics team stores patient visit records in a relational database. Each visit has a unique VisitID, and the team frequently needs to join visit data with physician and facility tables. The database must enforce referential integrity between these tables. Which data model characteristic best describes this environment?

A data analyst is preparing to build a predictive model. Which TWO steps are essential to ensure model validity? (Choose two.)

You have a hierarchical table 'Employees' with columns emp_id, emp_name, manager_id (referencing emp_id). You need to generate a full reporting chain from a given employee up to the CEO. Which SQL construct is most appropriate?

A data analyst needs to combine data from two tables: one containing customer information and another containing order details. The analyst wants to include all customers, even those who have not placed any orders. Which type of join should be used?

A data engineer is comparing data warehouses and data lakes. Which statement accurately describes a data warehouse?

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 data analyst is preparing a dataset for analysis and needs to address data quality issues. Which TWO of the following are common data cleaning tasks?

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.

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.

In a Power BI report, a user wants to create a measure that calculates total sales for the current year up to today. Which DAX function should they use?

A marketing team wants to segment customers into distinct groups based on purchasing behavior. The data includes numeric features such as frequency, monetary value, and recency. Which unsupervised learning algorithm should be used?

A data engineer is designing a data lake to store raw data from multiple sources, including JSON logs, CSV files, and Parquet files. The data will be used for both batch analytics and machine learning. The engineer must choose storage and processing strategies that align with the characteristics of a data lake. Which two of the following are core characteristics of a data lake? (Choose two.)

A data engineer is profiling a newly acquired customer table before loading it into a warehouse. The table has a customer_id column that should be unique, a signup_date column stored as text in 'YYYY-MM-DD' format, and a country column with values such as 'US', 'USA', 'United States', and 'U.S.'. The engineer must document which data quality dimensions are violated and plan remediation. Which TWO actions best address the identified data quality issues? (Choose two.)

An analyst is performing EDA and wants to measure the strength and direction of linear relationship between two continuous variables. Which statistical measure should they compute?

During data acquisition, a data engineer uses a tool to extract data from a source system incrementally based on a timestamp column. Which method is being used?

A data analyst at a retail bank is preparing a daily transaction file for loading into the analytics warehouse. The source system exports dates in the format 'MM/DD/YYYY', but the target warehouse requires ISO 8601 format 'YYYY-MM-DD'. The analyst needs to transform the date column without changing the underlying date value. Which transformation should the analyst perform?

A healthcare analytics team is acquiring a monthly extract of patient encounter records from a partner hospital. The extract arrives as a compressed CSV with a documented layout, but the team notices that the record count has dropped by roughly 15 percent compared with the prior month and that several encounters near month-end are absent. Which acquisition control should the team apply FIRST to determine whether the issue is a delivery problem or a source-system problem?

Which TWO are examples of leading indicators in a business context? (Select two.)

A data analyst is using pandas to read a CSV file named 'sales.csv'. Which line of code correctly reads the file into a DataFrame?

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 engineer is designing a system to handle high-velocity clickstream data from a website. The system must allow low-latency writes and support key-value lookups. Which type of database is most appropriate?

Which of the following data types is characterized by a flexible schema and is commonly represented using JSON or XML?

A company is merging two databases from different departments. In Database A, customer IDs are integers. In Database B, customer IDs are alphanumeric strings. To merge, the data analyst must reconcile these differences. Which step should be taken first?

A mid-sized e-commerce company stores customer data in a relational database. The database has a table named 'Customers' with columns: CustomerID (primary key), FirstName, LastName, Email, Phone, Address, City, State, ZipCode, and SignUpDate. The company is migrating to a new CRM system that requires a denormalized structure for performance reasons. The new system expects a single table 'CustomerDetails' with columns: CustomerID, FullName (concatenation of first and last name), ContactInfo (JSON object containing email, phone, and address), SignUpDate, and Region (derived from state). The data analyst must design an ETL process to transform the data. During a test run, the analyst notices that some records have missing Phone or Address values. Which of the following is the best approach to handle missing data in the ContactInfo JSON object?

A data analyst is cleaning a customer dataset. Which two actions are appropriate for handling duplicate records? (Choose TWO)

A data pipeline log shows the above error. Which data transformation should be applied during acquisition?

An e-commerce company uses a star schema for its data warehouse. The fact table 'sales_fact' contains foreign keys to dimension tables: customer_dim, product_dim, time_dim, and store_dim. A business user wants to know the total sales for each product category in the last month. Which join operation is required to retrieve this data?

A sensor records temperature readings in Celsius and a separate sensor records wind speed in meters per second. A data scientist wants to combine these datasets for analysis. Which statement accurately compares these data types?

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 profiling a dataset and finds that the 'email' column contains some NULL values. Which SQL query can be used to count how many rows have a NULL email?

A data analyst runs the query: SELECT AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 60000. What is the purpose of the HAVING clause?

A data analyst at a hospital network is exploring the relationship between patient age and length of stay for 400 discharged patients. A scatterplot shows a roughly linear upward trend, but the analyst wants a single number summarizing both the strength and direction of the association before reporting to clinicians. Which measure should the analyst calculate?

Which TWO of the following are best practices for designing an accessible data visualization? (Choose 2.)

A data analyst is creating a report to compare the total sales revenue for five different product categories over the last four quarters. The analyst wants to show both the overall total and how each category contributes to that total for each quarter. Which chart type is most appropriate?

A data analyst is cleaning text data in a SQL database. Which THREE string functions are commonly used to standardize and clean text? (Choose three.)

A financial analyst is integrating data from multiple stock exchanges. One exchange provides trade timestamps in UTC, another in Eastern Time. The analyst needs accurate time synchronization for time-series analysis. What is the best approach?

A company is designing a data pipeline to process streaming data from social media feeds. Which THREE of the following are characteristics of streaming data? (Select THREE).

A data analyst is performing EDA on a dataset with numerical features. Which methods are appropriate for identifying outliers? (Select TWO).

A heat map of store sales by region shows very low correlation between advertising spend and revenue, but a scatter plot of the same data shows a strong positive relationship. What is the most likely cause?

A data analyst is testing whether the average sales amount differs between two regions. Which statistical test is most appropriate?

A data scientist builds a simple linear regression model to predict house prices based on square footage. The model yields an R-squared value of 0.85. Which statement accurately interprets this result?

A data analyst is performing a chi-square test of independence on a contingency table of customer satisfaction (satisfied, neutral, dissatisfied) by region (North, South, East, West). Which THREE of the following are necessary assumptions for the test?

A dataset contains customer records with a column for 'Phone Number' that should be unique. However, the analyst finds several duplicate phone numbers. Which data quality dimension is primarily affected?

A data analyst runs a query to count the number of customers in each city. The query uses COUNT(*) and GROUP BY city. However, the result includes NULL for some cities. What will COUNT(*) return for a group where the city is NULL?

A marketing team runs an A/B test on email subject lines. The p-value is 0.03 with α = 0.05. Which of the following is the correct interpretation?

A market researcher conducts a survey with questions like "What is your favorite brand?" and "How many units do you purchase per year?" Which data types correspond?

A retail company's data analytics team needs to acquire point-of-sale (POS) transaction data from 200 stores daily. Each store sends a CSV file via email at the end of the day. The files often arrive late, have inconsistent column names (e.g., "StoreID", "Store_ID", "store_id"), and occasionally contain corrupted rows. The team manually processes these files, leading to frequent errors and delays. The company wants to automate the acquisition process to ensure data is available by 9 AM the next business day with high quality. Which approach best addresses these issues?

A data analyst needs to display the distribution of customer ages in a dataset containing 10,000 records. Which TWO chart types are appropriate? (Choose two.)

An organization is acquiring data from an external vendor. The vendor provides a flat file with inconsistent delimiters and missing values. Which step should be performed first in data acquisition?

In logistic regression, the output is a probability between 0 and 1. If the predicted probability for a customer churning is 0.7 and the decision threshold is 0.5, what is the predicted class?

Drag and drop the steps to implement a data classification policy in the correct order.

A data analyst is working with a dataset that includes a categorical variable 'product_category' with 50 unique values. The analyst wants to reduce dimensionality before clustering. Which technique should the analyst use?

A retail analyst is preparing a one-page executive dashboard. The CEO wants to see month-over-month revenue growth, while the operations director wants to monitor daily order volume. The analyst decides to use a bullet chart for the revenue growth and a line chart for daily order volume. Which design principle is best demonstrated by this choice?

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

A data analyst is validating a dataset acquired from an external source. Which TWO actions are appropriate for data quality assessment?

A marketing company is building a customer segmentation model. The data team has access to two sources: a CRM database with customer demographics and purchase history, and a third-party data provider that offers social media activity scores. The CRM data is updated daily, while the third-party data is refreshed weekly on Sundays. The analyst needs to create a unified dataset for the model training scheduled for Wednesday morning. The analyst runs a SQL query to join the two tables on CustomerID, but the resulting dataset has far fewer rows than expected. Upon investigation, the analyst finds that many customers in the CRM do not have matching records in the third-party data. Additionally, some customers in the third-party data have multiple entries due to unresolved duplicates. The analyst must produce the most complete dataset possible while maintaining data quality. Which course of action should the analyst take?

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

Which TWO of the following are true about Pearson correlation coefficient (r)?

What is the primary purpose of the HAVING clause in the query shown?

A data analyst is analyzing customer purchase amounts. The dataset contains several extreme high values due to luxury purchases. Which measure of central tendency is most robust to these outliers?

A data analyst at a logistics company is analyzing delivery times for three different shipping carriers. The analyst wants to determine whether the mean delivery time differs across carriers. The data are normally distributed, and the variances across carriers are assumed equal. Which statistical test should the analyst use?

A financial analyst wants to compare the mean annual returns of three different investment strategies. Which statistical test is most appropriate?

Which TWO of the following are considered internal data sources within an organization?

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

A dashboard designer wants to maximize the data-ink ratio. Which action should they take?

A company is designing a database for an e-commerce application that requires high transaction throughput and must guarantee that each transaction is processed atomically. Which property of ACID ensures that a transaction is either fully completed or not executed at all?

A financial application requires fast query performance for aggregations on large historical datasets. The schema has many lookup tables. Which schema design is most efficient for this workload?

A data analyst needs to visualize sales per capita across U.S. states. States with small populations but high sales (e.g., Delaware) appear too prominent on a choropleth map. Which technique best addresses this issue?

A retail company processes daily transactions. The current system transforms data before loading it into the data warehouse. The volume is growing rapidly, and they want to load raw data first to reduce processing time. Which approach should they adopt?

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

During ETL, a data analyst discovers that a date column contains values like '01/02/2023' and '2023-01-02'. Which of the following is the best practice to ensure consistent date format before analysis?

A data analyst is preparing a monthly performance report for a hospital network. The report will be distributed as a static PDF and must let department heads compare readmission rates across eight hospitals for the current month. The analyst wants the visual to remain accurate if the PDF is printed in grayscale. Which TWO design choices should the analyst make? (Choose two.)

A data analyst is building a report that will be refreshed weekly and distributed as a PDF to stakeholders. The report includes a table of sales by region and a bar chart of top products. Stakeholders have requested that the report be accessible on mobile devices. Which adjustment should the analyst make to ensure the report is mobile-friendly?

Which data cleaning method involves replacing a missing value with the average of the available values in that column?

A data analyst needs to collect customer sentiment data from social media platforms. Which data acquisition method is most appropriate?

A company has a dataset with 100 features. The data analyst wants to reduce dimensionality while preserving as much variance as possible. Which technique should be used?

A data analyst calculates a correlation coefficient of -0.85 between temperature and heating costs. What does this indicate?

A data analyst is validating referential integrity between orders and customers tables. Which TWO of the following checks should the analyst perform?

A data analyst is finalizing a recurring monthly operations report that will be exported to PDF and emailed to regional directors who read it on tablets. The analyst must choose design practices that keep the report readable and trustworthy in that fixed, non-interactive format. (Choose two.)

A sales analyst is designing a report for the sales team that includes the number of new leads, conversion rate, and total revenue. The team wants to identify which metrics are Key Performance Indicators (KPIs) tied to the strategic goal of increasing revenue. Which TWO of the following should be classified as KPIs?

Which TWO are examples of primary data? (Select two.)

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 analyst is preparing a report on customer satisfaction scores for the past quarter. The scores are measured on a scale from 1 to 5, and the analyst wants to show the distribution of scores, including the median and any outliers. Which visualization is most appropriate for this purpose?

A data analyst is designing a report that will be viewed on a large monitor in a conference room. The report includes a heatmap of customer satisfaction scores across different regions and time periods. The analyst notices that the color scale uses a rainbow gradient, and some viewers have difficulty distinguishing between adjacent colors. Which change should the analyst make to improve the readability of the heatmap?

A data analyst is preparing a report on monthly website traffic for the marketing team. The team wants to see how the total number of visits has changed over the past 12 months. Which chart type is most appropriate for this purpose?

A logistics company collects GPS pings from delivery trucks every few seconds. Each ping includes a device identifier, a timestamp, and latitude and longitude coordinates. The analytics team wants to compute the total distance each truck traveled per day and the average speed between consecutive pings. Which characteristic of the data must the team address first to make these calculations valid?

Refer to the exhibit. A data analyst is trying to understand access permissions for the company data folder. Which statement accurately describes the effective permissions?

A data analyst is performing a multiple linear regression with three predictors. The model output shows an R-squared of 0.85 and an adjusted R-squared of 0.80. Which of the following is the best interpretation of the difference between these two values?

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?

Which TWO are common methods for acquiring internal data? (Choose two.)

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 company is ingesting data from multiple sources into a cloud data warehouse. They decide to load the data raw and then perform transformations within the warehouse. Which approach does this describe?

A data analyst is building a dashboard that includes a map showing sales by state. The map uses a choropleth technique with a continuous color gradient from light blue (low sales) to dark blue (high sales). A stakeholder comments that it is difficult to compare sales between states because the colors look similar. Which adjustment would most improve the map's effectiveness for comparison?

A marketing team uses K-means clustering to segment customers based on purchase history. To determine the optimal number of clusters, they plot the within-cluster sum of squares (WCSS) against k and look for an elbow. What is the purpose of this method?

During an ETL process, a data quality check fails due to duplicate customer IDs. Which data quality dimension is violated?

A data analyst needs to visualize the distribution of salaries across departments and also compare the median and identify outliers. Which chart type is most suitable?

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 university is designing a data platform to consolidate student records from several departments. The data includes enrollment dates, course grades, and tuition payments. The team must classify each field correctly so that appropriate storage, aggregation, and visualization choices can be made. Which two statements correctly describe the measurement scales of these fields? (Choose two.)

A data analyst needs to perform a stratified random sample of a customer database. Which TWO steps are essential for this sampling method? (Select 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 logistics company collects GPS telemetry from delivery trucks. Each reading includes a truck identifier, a timestamp, latitude, and longitude, and the fleet generates roughly 500 million readings per day. Analysts mostly run aggregate queries such as average speed per route over the past 90 days, and they rarely update individual readings. Which storage approach best fits this workload?

After training a decision tree, the tree has depth 20 and 100% accuracy on training data but only 60% on test data. Which hyperparameter adjustment is most likely to improve generalization?

A dashboard designer wants to ensure the most important KPI is prominently displayed at the top left. Which design principle is being applied?

A data analyst is tasked with combining customer data from a CRM system and a billing system. The CRM uses a GUID for customer ID, while billing uses an integer. Which approach should the analyst use to ensure a reliable merge?

A company is migrating its data pipeline from on-premises to the cloud. The current ETL process transforms data before loading into a data warehouse. The new architecture will use ELT instead. Which THREE of the following are advantages of ELT over traditional ETL? (Select 3)

Which chart type is best for showing the distribution of a continuous variable, such as customer ages?

A data analyst needs to create a new column 'full_name' by concatenating 'first_name' and 'last_name' with a space. Which SQL function should be used in the SELECT clause?

A data analyst is conducting exploratory data analysis (EDA) on a dataset. Which TWO tasks are typically performed during EDA? (Select two.)

An analyst wants to show the distribution of test scores for 500 students. Which visualization type is best for understanding the shape of the distribution?

A data analyst at a subscription media company is asked to determine whether a new recommendation engine increased average watch time. The analyst plans a two-sample t-test comparing a randomly assigned control group against a randomly assigned treatment group, with watch time recorded in minutes per user per week. Which TWO conditions must hold for the pooled-variance two-sample t-test to be statistically valid here? (Choose two.)

An analyst wants to compare the mean sales revenue across three different store regions. The data is normally distributed and variances are equal. Which statistical test is most appropriate?

A researcher is designing an A/B test to compare two website layouts. Which TWO elements are essential for determining the required sample size?

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 data analyst is building a report that includes customer names and addresses. To comply with GDPR, what must the analyst do before publishing the report?

A data analyst needs to ensure that a customer's address is stored in a consistent format across multiple databases. Which data quality dimension is the analyst primarily concerned with?

A data quality assessment reveals that a column named 'email' contains values like 'user@example' (missing domain extension). Which data profiling technique would best identify such pattern violations?

A data analyst is writing a query to rank products by total sales within each category, showing dense rank and avoiding gaps. Which window function should be used?

A data analyst is examining a dataset of employee records. The 'EmployeeID' column contains unique alphanumeric codes, and the 'Department' column contains values like 'Sales', 'HR', and 'IT'. The analyst needs to determine which column is a key and which is a categorical attribute. Which statement correctly identifies the data types and roles?

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 retail analytics team loads a nightly CSV export into their warehouse. During validation, the analyst notices that the 'order_date' column, defined as DATE in the target schema, contains values like '2023-13-45' and 'N/A' in several rows. The ETL job currently fails silently on these rows. Which data acquisition and preparation action BEST addresses the root cause while preserving as much data as possible?

A data analyst is cleaning a dataset and finds that some records have duplicate entries based on customer ID. Which data quality dimension is most directly affected by these duplicates?

You are a data analyst for a logistics company. The company has a fleet of delivery trucks and tracks performance metrics including delivery time, fuel consumption, and distance traveled. Management wants a dashboard to monitor driver efficiency and identify underperforming drivers. You have access to a dataset with columns: DriverID, Date, RouteID, Distance (miles), FuelUsed (gallons), DeliveryTime (minutes). The dataset contains 10,000 records from the past year. You need to create a visualization that allows management to quickly compare the average fuel efficiency (miles per gallon) of drivers and also see how consistent each driver's efficiency is. Which of the following approaches is the best course of action?

A data visualization specialist needs to display the relationship between advertising spend and revenue for 50 product categories over 12 months. The data has many overlapping points. Which chart type best reveals the correlation and density?

A data analyst at a healthcare provider is reconciling patient records from two source systems. System A stores dates in 'MM/DD/YYYY' format, while System B stores dates in 'DD/MM/YYYY' format. During integration, the analyst notices that some records from System B have been incorrectly parsed, resulting in invalid dates. Which data preparation technique should the analyst apply to ensure consistent date interpretation?

A data analyst needs to combine sales data from multiple regional databases with different schemas. Which process is best?

A data analyst is building a supervised learning model to predict customer churn. The target variable is binary (churn = yes/no). Which TWO modeling techniques are appropriate for this task? (Select two.)

A company wants to collect real-time clickstream data from its website. Which acquisition method is most suitable?

In a customer database, each row represents a customer with columns: CustomerID, Name, Address, Phone. What does the column "Name" represent?

A data analyst is preparing a dataset for a machine learning model. The dataset contains a categorical column 'color' with values 'red', 'green', 'blue', and 'yellow'. The analyst needs to transform this column into a numerical format suitable for the model. Which technique should be used?

A data governance team is establishing policies for data quality. Which THREE of the following are common dimensions of data quality? (Select 3)

A financial services company is migrating its customer data from a legacy on-premises relational database to a cloud-based data warehouse. The legacy database uses a denormalized schema with a single table 'customer_master' that contains all customer attributes, including repeated groups for multiple accounts per customer (account1_type, account1_balance, account2_type, account2_balance, etc.). The data warehouse team wants to implement a normalized star schema with separate dimension and fact tables. During the ETL process, the team encounters an error: 'Data truncation: string data right truncation' when loading account_type values into the dim_account table. The account_type column in dim_account is defined as VARCHAR(10), but the source data contains account types like 'SavingsPlus' (11 characters) and 'CheckingPremium' (15 characters). The team must resolve this issue without losing data. Which course of action should the team take?

A data analyst is building a narrative around a quarterly sales decline. The story should follow a narrative arc. Which THREE elements should be included in the story?

A data analyst needs to compare sales data from the company's internal CRM with public demographic data from a government census. Which data concept best describes this scenario?

A data analyst at an e-commerce company is profiling a transactions table with ten million rows. The 'order_total' column is stored as text and contains values like '$1,299.00', a few entries of 'N/A', and several negative amounts that represent refunds. The analyst must produce a numeric column suitable for summation in a revenue report. Which sequence of operations best prepares the column?

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

An analyst needs to show the part-to-whole relationship of market share among four competitors. Which chart type is most appropriate, considering best practices?

A data analyst wants to ensure a sample proportionally represents different regions in a population. Which sampling method should be used?

In time series decomposition, a pattern that repeats at regular intervals (e.g., weekly, yearly) is called:

A data analyst is cleaning a dataset and finds that some cells in the 'email' column contain leading spaces. Which string function should be used to remove these spaces?

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 financial analytics team is building a data warehouse to support complex analytical queries on historical stock trades. The data volume is in terabytes, and queries frequently join multiple large tables and perform aggregations. The team needs a storage model that minimizes query latency for these read-heavy analytical workloads. Which data modeling approach is most appropriate?

An analyst is using SQL to analyze employee data. Which THREE of the following are valid uses of the WHERE clause? (Select three.)

In Power BI, a developer needs to create a measure that calculates total sales for the same period last year. Which DAX function should be used?

A scatter plot of advertising spend vs. revenue shows no clear correlation, but the analyst suspects a relationship exists. Which addition to the plot could help reveal a hidden trend?

A data analyst at a retail chain is importing a CSV file into a database. The file contains a 'transaction_date' column with values like '2023-13-01' and '2023-02-30'. The target column is defined as DATE. The analyst needs to ensure that invalid dates are flagged and not loaded. Which approach best handles this data quality issue during acquisition?

A data analyst is preparing a quarterly business review report for a retail company. The report includes a bar chart showing sales by region. The analyst notices that the chart is very wide and the region labels are overlapping, making it hard to read. The analyst wants to improve readability without losing any regions. Which action is most appropriate?

A data analyst wants to visualize the monthly sales trend for the past year. Which chart type is most appropriate?

A database administrator wants to ensure that every value in a column matches values in a primary key column of another table. Which constraint enforces this rule?

A data analyst is working with a dataset that contains a column for 'Order Date' stored as a string in the format 'YYYY-MM-DD'. The analyst needs to perform time-series analysis, such as calculating monthly sales trends. Which two actions should the analyst take to prepare the data for this analysis? (Choose two.)

An analyst is reviewing a table that stores customer orders. The table contains columns: OrderID, CustomerName, Product1, Product1Qty, Product2, Product2Qty. This design violates which normal form?

A simple linear regression model predicts sales (y) from advertising spend (x). The equation is y = 2.5x + 10, and R² = 0.81. Which interpretation is correct?

A data analyst is reviewing a dataset and notices that the 'ProductCategory' column contains inconsistent entries such as 'Electronics', 'electronics', and 'ELECTRONICS'. Which data cleaning technique should the analyst apply to standardize these values?

In a time series analysis, a retail analyst observes consistent peaks in sales every December and troughs every February. This pattern repeats annually. Which component of time series does this represent?

Refer to the exhibit. A data analyst runs this query to identify high-value customers. However, the result does not include customers with exactly 5 orders. Which data concept does the HAVING clause illustrate?

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 dataset contains outliers in a feature that will be used for linear regression. Which two outlier treatment methods are appropriate? (Choose TWO)

Refer to the exhibit. If the date column is stored as a string in 'MM/DD/YYYY' format, what will be the result?

A marketing analyst wants to segment customers based on purchasing behavior and demographics. The dataset includes continuous variables (spending amount, frequency) and categorical variables (region, gender). The analyst decides to use k-means clustering. What should the analyst do to prepare the data?

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 wants to predict customer churn based on categorical features like region and plan type, and continuous features like usage and tenure. Which regression type should be used?

During data exploration, an analyst notices that the target variable has a heavily right-skewed distribution. Which data transformation would be most appropriate to make the distribution more symmetric?

A company’s marketing team wants to segment customers based on purchase history, demographics, and website behavior. The data includes both numeric and categorical variables. Which clustering algorithm is best suited for handling mixed data types?

A data analyst is preparing a dataset for predictive modeling and must handle missing values in several numeric and categorical columns. The team needs defensible, documented choices rather than ad hoc deletion. Which TWO actions are appropriate for handling missing data in this scenario? (Choose two.)

A data analyst needs to merge two customer tables from different sources. One table uses 'CUST_ID' as the primary key, the other uses 'CustomerID'. To ensure accurate merging, the analyst should first:

A data analyst is creating a dashboard to monitor website traffic. The dashboard will include metrics such as page views, unique visitors, and average session duration. The analyst wants to ensure the dashboard effectively communicates performance to the marketing team. Which TWO design elements should the analyst prioritize? (Choose two.)

An analyst creates a dashboard with multiple visualizations. Which feature allows users to change the data displayed across all charts simultaneously?

A data analyst is working with a dataset that contains a column for 'customer satisfaction rating' on a scale from 1 to 5, where 1 is very dissatisfied and 5 is very satisfied. The analyst wants to summarize the central tendency of this data. Which measure of central tendency is most appropriate for this ordinal data?

A sales manager receives a daily report at 8 AM via email showing yesterday's sales by region. This is an example of which report type?

A data analyst at a university is asked to classify the variable 'Student Classification' with possible values Freshman, Sophomore, Junior, Senior. Which measurement scale best describes this variable?

A data analyst is creating a report to compare the performance of sales regions across multiple years. The report will be used by regional managers to identify trends. Which visualization approach best supports this?

A data analyst is working with a dataset containing house prices. After building a multiple linear regression model, the analyst observes that the model performs well on training data but poorly on validation data. Which technique is most appropriate to address this issue?

A data analyst is working with a dataset containing a categorical variable 'Education Level' with categories: High School, Bachelor's, Master's, PhD. The analyst wants to include this variable in a regression model. Which encoding technique should the analyst use?

A data analyst is tasked with gathering data from a legacy system that only exports CSV files. The files contain headers but no data types. Which tool would best facilitate initial data exploration?

A data team must implement a data retention policy to reduce storage costs while meeting legal requirements. Which TWO actions best achieve this?

During EDA, an analyst calculates the Z-score for each data point in a dataset. A data point with a Z-score of 3.5 is identified. What does this indicate?

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?

Drag and drop the steps to perform a data audit in the correct order.

A data analyst at a healthcare clinic is organizing patient records. The analyst needs to categorize each patient's blood pressure reading as 'Low', 'Normal', 'Elevated', or 'High' based on clinical thresholds. The categories have a clear order from lowest to highest risk. Which measurement scale best describes this classification?

Which TWO of the following are leading indicators that can help predict future performance?

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

A data analyst is designing a report that will be printed in black and white for a monthly management meeting. The report includes a bar chart comparing sales across five regions. To ensure the chart is easily interpretable in grayscale, which design choice should the analyst make?

A data analyst is evaluating a binary classification model for loan default prediction. The model achieves 98% accuracy on the test set, but the analyst notices that only 2% of loans in the dataset actually defaulted. The analyst is concerned that accuracy is misleading. Which metric should the analyst examine to better assess the model's ability to identify actual defaulters?

A data analyst has a time series of monthly sales data. They observe that sales are consistently higher every December and lower every January. Which component of time series does this pattern represent?

A data analyst is creating a dashboard in Looker Studio for an e-commerce company. They want to display the average order value by product category, and also allow users to filter by date range. Which combination of elements should be used?

A data analyst is compiling a monthly sales dashboard. The dataset contains a 'Revenue' column with a highly right-skewed distribution due to a few large enterprise transactions. The analyst wants a measure of central tendency that is robust to these outliers. Which measure should the analyst use?

Given the linear regression output, which independent variable has the strongest effect on price, based on standardized coefficients?

Which TWO chart types are best suited to show the proportion of total sales contributed by each product category? (Select exactly two.)

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

A company is building a data pipeline to ingest sensor data from IoT devices. The data arrives continuously in small batches and must be processed in real-time for monitoring. Which type of data source best describes this scenario?

A data analyst is integrating data from two source systems into a single customer dataset. Source A uses a customer ID format like 'CUST-12345', while Source B uses '12345'. Additionally, Source A records dates in 'MM/DD/YYYY' format, while Source B uses 'YYYY-MM-DD'. Which two data preparation tasks are essential to ensure the integrated dataset is consistent and usable? (Choose two.)

A data engineer is designing a data pipeline to ingest streaming data from IoT sensors. The sensors send data every second, and the pipeline must handle bursts of up to 10,000 messages per second. Which approach is most appropriate for capturing this data before processing?

Which THREE of the following are valid methods for handling missing data?

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

A data analyst is importing a CSV file that contains a mixture of numeric and text fields. What is the most common issue when importing?

An analyst is conducting an A/B test to compare two website designs. The null hypothesis is that there is no difference in conversion rates. The p-value obtained is 0.03, and the significance threshold is 0.05. What should the analyst conclude?

An organization needs to store raw data from IoT sensors in its native format for future analysis. Which storage solution is best suited for this purpose?

A data analyst is building a Power BI report to track KPIs for a retail chain. Which TWO of the following are considered leading indicators? (Choose two.)

Which of the following is an example of unstructured data?

A data analyst calculates the mean, median, and mode of a dataset. Which of the following best describes how these measures are used in descriptive statistics?

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

A marketing analyst is combining two datasets: one containing campaign IDs and spend, and another containing campaign IDs and impressions. The first dataset has 1,200 rows and the second has 950 rows. After an inner join on campaign_id, the result has 1,050 rows. Which statement best explains this result?

When communicating uncertainty in a report, which of the following is the most appropriate way to convey the reliability of a survey result showing 75% customer satisfaction?

A marketing team wants to analyze customer sentiment from social media posts. Which data acquisition method is most appropriate?

An e-commerce company is merging customer data from three legacy systems. Two systems use email as unique identifier, but one system allows multiple customers per email. The third uses phone number. To create a unified customer view, the analyst should first:

A data governance team is implementing a program to ensure consistent definitions and quality of customer data across the organization. They assign a senior manager to be accountable for the data asset. Which role does this manager fulfill?

A data analyst at an online retailer is examining a dataset of customer orders. The 'order_total' column has a mean of $85 and a median of $62. The analyst wants to describe the typical order amount for a presentation to the marketing team. Which measure of central tendency is most appropriate to report as the typical value, and why?

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?

In SQL, which string function would you use to remove leading and trailing spaces from a column named 'city'?

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 data engineer is designing storage for a fraud detection system that ingests millions of transaction events per second. The system must store each event with its timestamp and support fast writes without predefined schema enforcement, while allowing later analytical queries over semi-structured payloads. Which storage approach best fits these requirements?

A data analyst is evaluating a classification model that predicts whether customers will churn. The dataset is highly imbalanced, with only 5% of customers churning. The analyst wants to choose a metric that focuses on the model's ability to correctly identify actual churners. Which metric should the analyst prioritize?

A sales dashboard shows a map with many overlapping markers in the same city, making it hard to read. What is the best improvement?

Refer to the exhibit. A database administrator notices that queries filtering on both CustomerID and OrderDate are slow. Which single change would most likely improve performance for such queries?

A data quality report shows that 95% of records have all required fields completed, but 20% of the completed fields contain values that are outside valid ranges. Which data quality dimension is most affected?

Which chart type is best for showing the number of website visitors at each stage of a conversion funnel, from initial visit to purchase?

A stock analyst is analyzing monthly sales data for a retail company and observes a consistent pattern of high sales every December. This pattern is most likely an example of which time series component?

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 profiling a dataset and notices that the 'age' column contains negative values and values exceeding 120. The analyst needs to address these anomalies. Which data preparation technique is most appropriate?

Which THREE are best practices for data profiling during acquisition? (Choose three.)

In simple linear regression, the coefficient of determination R² measures:

A data analyst is using a recursive CTE to traverse an organizational hierarchy. What is the purpose of the anchor member in the recursive CTE?

A data analyst is evaluating data quality issues in a customer database. Which TWO actions are best practices for ensuring data consistency?

In a regression analysis, the coefficient of determination (R²) is 0.85. How should this value be interpreted?

A data analyst is preparing a report on customer satisfaction scores. To comply with GDPR, which THREE actions must be taken? (Select THREE.)

Match each data analysis technique to its primary purpose.

A data architect is designing a storage solution for a healthcare provider. The system must store patient records with varying structures, including unstructured clinical notes and semi-structured JSON data from wearables. The solution must scale horizontally and handle high write throughput. Which storage type is most appropriate?

A data analyst is profiling a newly acquired customer dataset before loading it into a warehouse. The analyst notices that the 'country' column contains values such as 'USA', 'United States', 'U.S.A.', and 'US'. Which TWO actions are appropriate for standardizing this column during data preparation? (Choose two.)

A hospital's data team needs to choose a storage model for its new electronic health record (EHR) system. Patient records contain many nested, variable attributes such as a list of allergies, multiple insurance policies, and a changing set of lab results per visit. The schema changes frequently as new clinical fields are added, and the team wants to avoid costly migrations. Which data model should the team select?

A data analyst is creating a presentation for executives to explain why customer churn has increased over the last quarter. The analyst wants to present the story in a compelling way. Which narrative structure is most appropriate?

A data analyst needs to compare the salary distribution across five departments. Which visualization is most appropriate?

A data analyst wants to compare the sales revenue of five different product categories for the current month. Which chart type is most suitable for this comparison?

A data analyst is creating a report to summarize customer satisfaction survey results. The survey asked customers to rate their satisfaction on a scale from 1 (very dissatisfied) to 5 (very satisfied). The analyst wants to show the number of respondents for each rating level. Which visualization is most appropriate?

An analyst wants to use Python (pandas) to compute the average sales amount per region from a DataFrame 'df' with columns 'region' and 'sales'. Which TWO pandas operations are needed? (Select TWO).

An analyst receives a dataset of website sessions where the session_duration_seconds column contains several negative values and a few values exceeding 86,400 seconds. The analyst must prepare this data for analysis of average session length. Which action best addresses this data quality issue while preserving analytical integrity?

A data analyst is working with a dataset that contains a column 'purchase_date' stored as a string in the format 'YYYY-MM-DD'. The analyst needs to calculate the number of days between each purchase and the current date. Which data transformation is required?

In a table with columns 'employee_id' and 'manager_id', a data analyst needs to retrieve the hierarchy level of each employee, where the top manager has manager_id NULL. Which SQL feature is best suited?

A data analyst is reviewing sales data and wants to find orders where the order total is between $100 and $500, inclusive. Which WHERE clause is correct?

A sales VP wants a quick summary of last month's revenue change and key drivers. Which report section is most relevant?

A data analyst is building a binary classification model to predict customer churn. The dataset is imbalanced, with only 10% churners. The analyst wants to evaluate model performance with a focus on correctly identifying churners. Which metric is most appropriate?

A hospital's data team is cataloging its data assets. They need to classify the blood type field stored for each patient (e.g., A+, O-). Which data type classification best describes this field?

A retail company wants to predict future sales based on historical data. Which modeling approach is most appropriate if the data shows a clear seasonal pattern?

A data governance team is establishing policies to ensure data quality. They define rules for data accuracy, completeness, and consistency. Which data governance function is primarily responsible for defining and enforcing these rules?

A retail company wants to segment its customers based on purchase history. Which THREE methods are appropriate for customer segmentation?

The exhibit shows an SQL query executed on an 'orders' table that contains 'order_id', 'customer_id', and 'order_date'. What is the purpose of this query?

An analyst is reviewing the above SQL query used to acquire data. What does this query retrieve?

A data analyst is building a dashboard for executives and wants to ensure the most important metric, total revenue, is immediately visible. Which design principle should the analyst apply?

An analyst is preparing data for an A/B test and wants to ensure valid results. Which TWO of the following should be considered when calculating the required sample size?

A data analyst is extracting data from a web page using web scraping techniques. The data will be used for market research. Which TWO of the following are common challenges associated with web scraping?

A dataset contains sales transactions with columns 'order_date', 'amount', and 'region'. The analyst wants to calculate the total sales per region for orders placed in 2023, but only include regions where total sales exceed $10,000. Which SQL clause should be used to filter the aggregated results?

A data analyst wants to compare the means of three different training methods on employee productivity. Which statistical test is most appropriate?

A marketing team wants to explore the relationship between advertising spend (in dollars) and resulting revenue. Which chart type is most suitable?

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

Refer to the exhibit. Which type of data is the field "region"?

A data analyst wants to show the relationship between advertising spend and sales revenue for 50 stores. Which chart type is most appropriate?

A data engineer is designing a schema for a new application. The application will store user profiles with fields such as UserID, Email, and SignupDate. The team expects the user base to grow rapidly, and the schema may evolve to include new profile attributes like phone number or social media handles. They want to minimize downtime and avoid complex migrations when adding fields. Which data model should the engineer choose?

An analyst is choosing a chart to show the correlation between two continuous variables. Which TWO chart types could be used? (Select two.)

A data analyst is examining the relationship between two continuous variables: temperature and ice cream sales. The analyst wants to quantify the strength and direction of their linear association. Which statistical measure should the analyst use?

Which TWO of the following are examples of semi-structured data?

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 uses a CTE to simplify a complex query. Which keyword is used to define a CTE?

An analyst is planning an A/B test to compare two website designs. Which TWO factors should be considered when calculating the required sample size?

Which stage of the data lifecycle involves converting raw data into a usable format, such as cleaning or validating?

A data analyst wants to retrieve data from a REST API that returns JSON. Which step is part of the data lifecycle for this activity?

A hospital wants to analyze patient readmission rates. The data contains daily patient visits. What is the level of granularity?

A data analyst is cleaning a dataset with missing values in a time series of daily temperatures. The missing values occur sporadically. Which imputation method is most appropriate to maintain the temporal trend?

A retail company analyzes customer purchase data to improve inventory management. They store daily transaction records in a relational database and monthly aggregate reports in a data warehouse. Which difference between these storage methods best explains why the warehouse is more suitable for trend analysis?

A marketing team conducted a customer satisfaction survey for five different departments (Sales, Support, Billing, Shipping, Returns). The survey asked customers to rate their satisfaction on a scale of 1 (Very Dissatisfied) to 5 (Very Satisfied). The data is ordinal and the team wants to visualize the distribution of responses for each department to quickly see which department has the most 'Very Satisfied' customers and which has the most 'Very Dissatisfied'. They also want to compare the spread of responses across departments. Which chart type should they use?

An analyst writes a SQL query that uses a window function: SELECT employee_id, salary, LAG(salary, 1) OVER (ORDER BY salary DESC) AS prev_salary FROM employees. What does the LAG function return for the row with the highest salary?

An analyst is sampling a large customer database to estimate the average purchase amount. To ensure that the sample proportionally represents different customer segments (e.g., age groups), which sampling method should be used?

A data engineer is designing a system to store raw sensor data from thousands of IoT devices. The data will be used later for various analytics projects, but the schema is not yet defined. Which storage solution is most appropriate?

A company is acquiring social media data via a public API. Which TWO considerations are important for ensuring ethical and legal compliance?

An OLTP system processes thousands of transactions per second. Which property ensures that a transaction is fully completed or fully rolled back, preventing partial updates?

A data analyst is reviewing a dataset containing house prices. The mean price is $350,000 and the median is $280,000. Which of the following best describes the distribution of house prices?

A data analyst is creating a report for a marketing campaign. The campaign data includes customer names, email addresses, and purchase history. Which of the following best describes the 'customer name' data type?

A logistics company uses a key-value store to cache real-time shipment tracking updates. The data model has no fixed schema, and each shipment record may contain different attributes. Which data storage approach is being used?

Refer to the exhibit. A stakeholder complains that the line chart exaggerates the changes in sales. What is the most likely cause?

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 needs to identify duplicate customer records. Which TWO methods are commonly used? (Select two.)

A marketing team wants a single view comparing this quarter's campaign performance against the same quarter last year across five channels, with the ability to drill from channel totals down to individual campaign rows. Which visualization structure best supports both the comparison and the drill path?

A data analyst receives the above JSON snippet from a web API. The analyst needs to extract the email addresses for all customers. Which JSONPath expression should be used?

In Looker Studio, what is the difference between dimensions and metrics?

A sales manager wants to see the conversion rates at each stage of the sales pipeline, from initial contact to closed deal. Which chart type is most appropriate?

A sales analyst wants to show total sales by product category, with each category's contribution to the total. Which chart type is best?

Which TWO of the following are primary benefits of implementing a data governance program?

A data team needs to extract data from a legacy system that only supports flat file exports. Which data acquisition method is most appropriate?

Refer to the exhibit. Which data quality dimension is compromised by the missing value for Charlie's salary?

A dashboard designer wants to highlight the sales performance of individual sales representatives compared to team averages. Which chart type is most suitable for this comparison?

An analyst is presenting a recommendation to increase marketing spend. Which statement best follows the data-driven recommendation structure (evidence → insight → recommendation → expected impact)?

Which THREE are best practices for designing a dashboard for executive consumption?

A data analyst is importing a fixed-width text file into a relational database. The file has no header row, and fields are separated by a single space, but some fields contain trailing spaces of varying lengths that shift the apparent column boundaries. The analyst must load the data reliably into the correct columns. Which approach is most appropriate?

A data analyst needs to perform stratified sampling on a customer database to ensure proportional representation across three regions: North (40%), South (30%), and West (30%). The total sample size required is 1,000. How many customers should be sampled from the North region?

Which TWO of the following are appropriate uses of min-max normalisation?

A data analyst is examining the relationship between advertising spend and sales revenue across 50 regions. The analyst calculates a Pearson correlation coefficient of 0.85. Which of the following conclusions is most appropriate?

A data analyst is designing a dashboard for a hospital's emergency department. The dashboard must display real-time patient wait times, current bed occupancy, and the number of patients waiting to be seen. The primary users are charge nurses and physicians who need to make quick staffing decisions. Which two design principles are most critical to ensure the dashboard is effective for this scenario? (Choose two.)

A junior analyst is asked to show how total monthly support ticket volume changed over the past 24 months so leadership can spot seasonal peaks. Which visualization is most appropriate?

A data analyst needs to create a recursive CTE to traverse a hierarchical employee-manager table. Which of the following is a key requirement for a recursive CTE?

A data analyst discovers that a dataset contains multiple records for the same customer with different spellings (e.g., 'Jon' vs 'John'). Which data preparation step should be applied first?

Which THREE of the following are common characteristics of unstructured data?

A data analyst is tasked with creating a report that shows the proportion of total sales contributed by each product category. The analyst wants to use a chart that clearly displays the parts of a whole. Which chart type is most appropriate?

A data analyst is using SQL to extract data. The analyst wants to retrieve all records from a table named 'sales' where the 'amount' column is greater than 100. Which SQL clause should be used?

A data analyst needs to show the relationship between advertising spend (in dollars) and the number of website visits. Both variables are continuous. Which chart type is most suitable?

Which data quality dimension ensures that data represents the real-world scenario correctly and without errors?

A data analyst is analyzing survey responses where respondents rated satisfaction on a scale of 1-5. The analyst wants to visualize the distribution of responses. Which chart type is most appropriate?

In A/B testing, which factor is increased by having a larger sample size?

A marketing analyst must combine two datasets: a CRM extract with one row per customer and a transactions extract with many rows per customer. The analyst wants every customer from the CRM to appear in the output, even customers with no matching transactions. Which join type should be used?

A financial analyst is creating a quarterly report compliant with SOX. Which requirement is most critical for the report's audit trail?

A data analyst wants to assign a unique sequential integer to each row in a result set, starting at 1, based on the order of the 'sales_amount' column descending. Which window function should be used?

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?

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

An organization has multiple systems that store customer information inconsistently. To create a single authoritative view of customer data, they implement a process that identifies and merges duplicate records. This is an example of which data management discipline?

A data analyst is using a decision tree to classify loan applications as approved or denied. To avoid overfitting, the analyst plans to prune the tree. Which TWO of the following are valid pruning techniques? (Choose two.)

A data analyst needs to retrieve the top 5 most expensive products from a 'products' table sorted by price descending. Which TWO SQL clauses are required to achieve this? (Select TWO).

A table named Orders has columns OrderID, CustomerID, OrderDate, and TotalAmount. Which column should be the primary key to uniquely identify each order?

Which TWO of the following are examples of data transformation? (Choose TWO.)

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

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 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 analyst is working with a dataset that contains customer names and addresses. Some records have missing state codes. Which data quality issue is this?

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?

Which TWO chart types are appropriate for visualizing the distribution of a continuous variable? (Select two.)

A data engineer is ingesting a 40 GB JSON event log into a columnar analytics platform. The file contains deeply nested arrays of user actions, and queries only ever filter on three top-level fields: event_id, event_type, and event_timestamp. The ingestion is currently slow and queries scan excessive data. Which preparation approach is MOST appropriate?

A retail company wants to analyze customer purchase patterns to identify products frequently bought together. Which data mining technique is most appropriate?

A data analyst is preparing to acquire clickstream data from a web analytics platform via its REST API. The API returns paginated results with a maximum of 500 records per page and issues a short-lived bearer token that expires after one hour. The analyst needs to backfill six months of event data reliably. Which acquisition design is most appropriate?

A data analyst needs to retrieve only unique job titles from the 'employees' table. Which SQL keyword should be used in the SELECT clause?

A data analyst is creating a visualization to show the relationship between two continuous variables: advertising spend and sales revenue. The analyst wants to display the strength and direction of the linear relationship. Which type of chart should the analyst use?

A retail analytics team needs to load a 40 GB CSV file of point-of-sale transactions into a cloud data warehouse nightly. The file is generated as a single object by an upstream system, and the team must minimize load time. Which approach best addresses the load performance bottleneck?

Which THREE of the following are common steps in data cleaning?

A data analyst is designing a dashboard and wants to maximize the data-ink ratio. Which action aligns with this principle?

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 company is designing a data lake to store raw sensor data from IoT devices. The data arrives as JSON objects with varying schemas. Which storage approach is most appropriate?

Which data quality dimension is violated if a customer record has a missing phone number?

A data analyst needs to combine rows from two tables based on a related column, but only wants rows that have matching values in both tables. Which join type should the analyst use?

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 financial analyst publishes a monthly report where a gauge chart shows the current debt-to-equity ratio against a target band. Executives repeatedly misread the gauge, assuming the needle's position alone indicates good or bad performance without checking the target thresholds. Which change would BEST improve accurate interpretation?

A data engineer needs to store logs from web servers that have varying fields. The logs are in JSON format. Which data type describes this JSON data?

A data analyst is presenting a story about declining sales. The narrative arc should include which three elements in order?

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 is creating a dashboard and wants to maximize the data-ink ratio. Which action supports this principle?

A financial analyst is preparing a dataset of stock transactions for a machine learning model. The 'transaction_amount' column has a highly skewed distribution with a few extremely large values. The analyst decides to apply a logarithmic transformation to this column. Which statement best describes the effect of this transformation?

A data analyst is working with a dataset that includes a categorical variable 'education_level' with four categories: High School, Bachelor's, Master's, and PhD. The analyst wants to include this variable in a linear regression model. Which encoding method should the analyst use to avoid the dummy variable trap?

Which TWO of the following are valid SQL clauses used to filter and sort data?

Which THREE factors should be considered when choosing a chart type for a dataset?

A marketing team wants to segment customers into groups based on purchasing behavior without prior labels. Which algorithm should the data analyst use?

A data analyst is working with a dataset that contains a column 'region' with values such as 'North', 'South', 'East', 'West', and 'N/A'. The analyst needs to prepare this column for a machine learning model. Which of the following is the most appropriate approach to handle the 'N/A' values?

A data analyst needs to combine customer information from a CRM table and order information from an orders table, returning only customers who have placed at least one order. Which type of join should the analyst use?

A data scientist creates a box plot of employee salaries and notices many outliers above the upper whisker. What action should be taken to best understand the salary distribution?

A data scientist is working with a dataset containing 1000 features and 500 samples. The goal is to build a predictive model. Which technique should be used to reduce the number of features while retaining most of the variance?

A data analyst is using Python pandas to perform exploratory data analysis. Which THREE methods are commonly used to assess data quality and distributions?

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 data analyst is preparing a dataset for a machine learning model. The dataset contains a 'country' column with 150 unique values. To reduce dimensionality, the analyst wants to group less frequent countries into an 'Other' category. Which technique is being applied?

A retail company generates a daily PDF report showing the previous day's sales by region and product category. The report is automatically emailed to store managers at 6:00 AM. Which type of report is this?

A logistics company has data on delivery times (continuous) and distance traveled (continuous). They want to visualize the relationship between these two variables. Which chart type is most appropriate?

A data governance committee is defining metadata standards for a new data lake. They need to distinguish between technical metadata and business metadata to ensure proper data management. Which two of the following are examples of technical metadata? (Choose two.)

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 financial analyst is preparing a report that must comply with the Sarbanes-Oxley (SOX) Act. What is the most critical requirement for this report?

A data analyst is presenting a recommendation to reduce inventory costs. The evidence shows that overstocking occurs in 30% of warehouses. Which of the following best structures the recommendation?

A database table has columns: OrderID (primary key), ProductID, CustomerID, CustomerName, OrderDate, ProductName. All products are purchased only by the customer who placed the order. Which normal form violation exists if CustomerName depends on CustomerID?

A data analyst is building a dashboard that tracks daily active users. The source system records one event row per user session, and a user can have multiple sessions in a day. The analyst needs to display the count of unique users per day. Which approach produces the correct daily active user count?

A data analyst at a retail company is profiling a newly acquired customer table. They observe that the 'last_purchase_date' column contains values such as '2023-13-45', '0000-00-00', and '2023-02-30'. Which data quality dimension is primarily violated?

Drag and drop the steps to perform a data backup using the 3-2-1 rule in the correct order.

A data analyst is profiling a new dataset and needs to assess data quality. Which two metrics are most appropriate for evaluating the completeness and consistency of the data? (Choose two.)

A data analyst is compiling a quarterly report for a retail chain and needs to show how sales revenue is distributed across five product categories. The analyst wants a single visualization that makes it easy to compare each category's share of total revenue and also includes a separate small panel displaying total revenue for the quarter. Which visualization approach best meets these requirements?

A data modeler is designing a dimensional model for a sales analytics system. The fact table contains sales transactions, and the dimension tables include product, customer, and time. To reduce data redundancy, the modeler normalizes the dimension tables into multiple related tables. Which schema is being implemented?

The exhibit shows log entries. A data analyst wants to visualize the frequency of each error type over time. Which chart type is most appropriate?

A data analyst is preparing a dataset for analysis and needs to address data quality issues. The dataset contains missing values, outliers, and inconsistent formats. Which two techniques are appropriate for handling missing values? (Choose two.)

An analyst is creating an executive summary for a quarterly business review. Which THREE components are essential for an effective executive summary?

A logistics company stores shipment records in a relational database. The ShipmentID column uniquely identifies every shipment, and the CarrierName column stores the name of the carrier that moved each shipment, such as "Northwind Freight" or "Acme Logistics". Analysts frequently group shipments by carrier to compare on-time performance. Which statement correctly describes the relationship between these two columns in this table?

Which TWO of the following are characteristics of OLTP systems? (Select 2)

A company has a large data warehouse running on Snowflake. They receive daily CSV files from multiple sources and load them directly into the warehouse, then run SQL transformations to clean and aggregate the data. Which data integration approach does this describe?

A data engineer needs to extract data from a REST API and load it into a data warehouse. The data is received in JSON format. Which data type best describes JSON?

An analyst recommends a pricing change based on data showing price elasticity. The recommendation includes expected revenue impact. What is this an example of?

A data analyst is examining a dataset of customer transactions and notices that the distribution of transaction amounts is highly skewed to the right. The analyst wants to apply a transformation to make the distribution more symmetric for use in a linear regression model. Which of the following transformations is most appropriate?

In a simple linear regression model y = 2.5 + 1.2x, what is the predicted value of y when x = 10?

A dashboard needs to show sales trends for each of five regions over the past year. The intended audience wants to compare trends easily. Which chart type is best?

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 data analyst is validating a regression model that predicts monthly churn probability for 50,000 subscribers. The analyst wants to detect whether the model is overfitting before deploying it. (Choose two.)

In the data lifecycle, which phase involves converting raw data into a usable format for analysis?

A data analyst wants to segment customers based on purchasing behavior such as frequency, monetary value, and recency. Which TWO clustering evaluation methods can help determine the optimal number of clusters? (Select two.)

A data analyst is asked to compare the average sales across three different store locations. The data is normally distributed and variances are approximately equal. Which statistical test is most appropriate?

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

A healthcare database stores patient records. Each patient has a unique patient_id, and the database includes a table 'visits' with visit_id, patient_id, visit_date, and diagnosis_code. To ensure data integrity, which constraint should be applied to the patient_id column in the 'visits' table?

An analyst is performing a logistic regression to predict customer churn (yes/no). The model outputs a probability of 0.75 for a particular customer. Which of the following best describes the interpretation?

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?

An analyst is conducting an A/B test on a new checkout process. To calculate sample size, which THREE factors must be considered?

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 wants to retrieve the top 5 highest-paid employees from the 'employees' table. Which SQL clauses could be used to achieve this? (Select TWO.)

A data analyst is preparing a presentation for the executive team to explain why quarterly revenue fell short of targets. They want to use storytelling with data. Which THREE elements should be included in the narrative arc? (Choose three.)

A data analyst is designing a dashboard for executives. Which best practice should be followed?

A data analyst is profiling a new dataset containing customer information. When assessing data quality, which metric would be most appropriate to determine if the 'email' column contains valid email addresses?

A data architect is designing a system for a subscription streaming service. The service must record every play, pause, and skip event from millions of concurrent viewers with very low write latency, and it must later support analytical queries over months of event history. The architect wants a single storage layer that handles both needs without a separate transformation pipeline. Which data architecture should the architect choose?

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 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 is using the IQR method to identify outliers in a dataset. The first quartile (Q1) is 25 and the third quartile (Q3) is 45. What is the upper bound for identifying outliers?

A data analyst is designing a dashboard for hospital administrators to monitor emergency department (ED) wait times. The dashboard will be viewed on large wall-mounted displays in the operations center and must be readable from a distance. The analyst wants to ensure the dashboard effectively communicates urgent situations. Which two design choices are most appropriate? (Choose two.)

A data analyst is performing data cleaning. Which THREE steps are part of this process? (Choose three.)

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?

Which THREE of the following are characteristics of a relational database?

Drag and drop the steps to resolve data integration conflicts in the correct order.

A company uses an OLTP system for processing customer transactions. Which characteristic is most important for this system to ensure that each transaction is processed reliably, even if multiple users access the system simultaneously?

A data analyst wants to visualize the distribution of employee salaries across departments and identify any outliers. Which chart type would best show quartiles, median, and potential outliers?

A data analyst is designing a dashboard to monitor real-time website traffic. The dashboard will be used by the operations team to quickly identify anomalies and take immediate action. Which two design elements are most critical to include? (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.)

An analyst creates a scatter plot with three variables: X, Y, and a third variable represented by the size of the markers. This chart is called a:

Which statistical test should be used to determine if there is a significant association between two categorical variables, such as gender and product preference?

A data analyst uses the following query: SELECT department, AVG(salary) AS avg_salary FROM employees GROUP BY department HAVING AVG(salary) > 50000. What is the purpose of the HAVING clause in this query?

After merging two datasets, an analyst finds that the resulting dataset has many null values in some columns. Which TWO steps should the analyst take to address this? (Select two.)

A table Orders has OrderID (primary key), CustomerID, and CustomerEmail. During analysis, it is found that CustomerID uniquely identifies CustomerEmail. Which normal form is violated if both CustomerID and CustomerEmail are stored in this table?

A data analyst runs the following query: SELECT DISTINCT city FROM customers. What is the primary purpose of using the DISTINCT keyword in this query?

A dashboard designer is creating a KPI dashboard for executives. Which of the following is a leading indicator?

A data scientist runs a linear regression model to predict customer spending based on income. The R-squared value is 0.45 and the p-value for the slope coefficient is 0.03. At a significance level of α=0.05, which of the following conclusions is correct?

Which TWO of the following are examples of unstructured data? (Select 2)

A data analyst at a subscription streaming service is designing a dashboard for the customer success team. The team needs to monitor, side by side, the current month's churn rate against the same month last year and against a target churn rate of 4.5%. The analyst wants viewers to instantly see whether the current rate is above or below target. Which design approach best supports this?

Which THREE are considered best practices in dashboard design? (Select three.)

A data analyst wants to compare the revenue across five different product categories. Which chart type is best suited?

A data analyst is using Power BI to create a report that shows sales by region. The data includes duplicate rows for some transactions due to a data entry error. The analyst needs to count only unique transactions. Which DAX function should be used to create a measure for unique count?

A data analyst is building a linear regression model to predict sales based on advertising spend. The analyst notices that the residuals are not normally distributed and have a non‑constant variance. Which of the following transformations is most appropriate to apply to the dependent variable?

A data architect needs to store raw data from various sources, including social media feeds and log files, for future analysis. The data may be used for machine learning and ad-hoc queries. Which storage solution is most appropriate for storing raw data in its native format?

A national retailer is consolidating data from 40 regional stores into a central analytics platform. Each region uses different codes for the same product categories, and store managers report sales in local currencies. Before loading the data, the integration team must resolve these inconsistencies. Which two activities are appropriate steps to standardize the data? (Choose two.)

A retail company is integrating sales data from three regional databases into a central data warehouse. The 'product_id' column is defined as an integer in two databases but as a variable-length string in the third. During the ETL process, the analyst must ensure that product_id values are consistent for joining with the product dimension table. Which data transformation should the analyst perform?

A data analyst is tasked with collecting data from multiple spreadsheets provided by different departments. Each spreadsheet has different column names and formats. What is the best first step?

A data analyst is preparing a dashboard that will be embedded in a public-facing web page and refreshed nightly. The source system contains customer names and account numbers, but the dashboard only needs aggregated counts by region and product line. Which two practices should the analyst apply to reduce disclosure risk while keeping the dashboard functional? (Choose two.)

A data analyst notices that customer addresses in the database contain invalid ZIP codes. Which data quality dimension is being violated?

A data analyst uses a CTE to find employees who earn more than the average salary in their department. Which SQL clause is used to define the CTE?

Which data quality dimension is most concerned with whether data values fall within a defined domain or acceptable range?

A retail analytics team is building a data catalog and must document the metadata for a new sales fact table. The team needs to record structural metadata that describes how the data is organized. Which two items qualify as structural metadata for this table? (Choose two.)

In Tableau, a data analyst creates a calculated field to compute the average sales per customer. The analyst wants this calculation to remain constant regardless of the level of detail in the view. Which Tableau feature should be used?

A data scientist applies K-means clustering to a customer dataset. The elbow method suggests using 4 clusters. After running K-means with k=4, the within-cluster sum of squares (WCSS) is plotted against k, and the elbow is at k=4. What does this indicate?

Refer to the exhibit. What is the best corrective action to resolve this error?

Which THREE of the following are properties of ratio data? (Choose THREE.)

A data analyst is examining the relationship between advertising spend (in thousands) and sales (in thousands). The Pearson correlation coefficient is computed as r = -0.85. Which of the following interpretations is correct?

A data analyst is evaluating a classification model for predicting customer churn. The model's confusion matrix shows 100 true positives, 20 false positives, 30 false negatives, and 850 true negatives. The analyst wants to assess the model's ability to correctly identify actual churners. Which metric should the analyst use?

A data analyst trains a complex model that achieves 99% accuracy on training data but only 65% on new data. What is the most likely issue?

An e-commerce company is acquiring product data from multiple supplier APIs. The APIs return JSON with inconsistent field naming conventions. Which data acquisition technique should be applied?

A data analyst is cleaning a dataset and finds that the 'age' column has several missing values. Which of the following is a valid method for handling missing numerical data?

A dataset contains transaction amounts with a few extremely high values. The analyst wants to reduce the impact of these outliers on the average. Which measure of central tendency is most robust?

A data analyst is using Tableau to build a dashboard. Which THREE features are available in Tableau for creating interactive dashboards?

A data analyst is using a decision tree to predict customer churn. The tree is very deep, with many branches, and achieves 99% accuracy on the training data but only 70% on the test data. Which technique should the analyst use to address this issue?

A dataset contains a column 'Education Level' with values: 'High School', 'Bachelor', 'Master', 'PhD'. An analyst computes the average by assigning numbers 1-4. Which data concept is being violated?

A data architect is designing a system to handle a workload that requires strong consistency and complex multi-table joins for financial reporting. Which two characteristics should the architect prioritize when selecting the database technology? (Choose two.)

During exploratory data analysis, you calculate the IQR for a numeric column and find that several data points fall below Q1 - 1.5*IQR. These points are likely:

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 is summarizing the central tendency of a dataset with extreme outliers. Which measure is most robust to outliers?

An analyst is creating a report that includes multiple charts. To ensure the audience quickly grasps the key insight, which principle of data storytelling should be applied?

A data team is ingesting JSON event data from a mobile application into a columnar warehouse. Each event has a nested array of product objects, and analysts frequently need to report on individual products within those events. The team wants to avoid repeated manual parsing in every query. Which approach best prepares the data for efficient product-level analysis?

Which TWO are valid data acquisition methods? (Select two.)

You are using pandas in Python to clean a dataset. You notice several rows with missing values in the 'age' column. Which method would you use to remove those rows?

A data analyst is creating a report on customer satisfaction scores. The analyst wants to ensure that regional managers can only see data for their own region. Which security measure should be applied?

A database administrator is designing a normalized database to reduce data redundancy. They have a table with columns: OrderID, ProductID, ProductName, and Quantity. The table is currently in 1NF. To move to 2NF, which issue must be resolved?

A data analyst is cleaning a dataset and finds that a numeric field has several missing values. The variable is normally distributed. Which imputation method is most appropriate?

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

A data analyst is designing a database for a retail application. Which TWO of the following are valid reasons to use a NoSQL document database like MongoDB instead of a relational database? (Select 2)

A data analyst is profiling a dataset of customer records and discovers that 12% of the rows have missing values in the "postal_code" column, while the "customer_id" column is fully populated. The analyst needs to document this finding for a data quality report. Which data quality dimension does the missing postal code values primarily violate?

A data analyst calculates the mean, median, and mode of a dataset. Which of the following measures of central tendency is least affected by extreme outliers?

A data analyst uses the elbow method to determine the number of clusters for k-means. The plot shows a sharp bend at k=3 and a small bend at k=5. What is the recommended number of clusters?

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 hospital's patient records system must process thousands of small transactions per second. Which type of database system is best suited for this workload?

A hospital's analytics team is designing a new repository for electronic health records. The records include patient demographics, lab results, and physician notes, and the schema must remain flexible because new lab test types are added frequently. The team needs to enforce relationships between patients, encounters, and lab orders while keeping the ability to evolve the schema. Which data model best fits these requirements?

A data analyst is building a decision tree to classify whether customers will churn. The analyst wants to prevent the tree from overfitting the training data. Which technique should the analyst use?

A data scientist has a dataset with 50 variables and wants to identify clusters of similar observations. Which visualization technique is most suitable for reducing dimensionality to 2D while preserving cluster structure?

An analyst needs to compute a running total of sales for each department, ordered by date. Which window function 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 e-commerce company wants to provide real-time personalized product recommendations based on customer browsing behavior. Currently, they have a traditional data warehouse that processes batch updates every night. The marketing team complains that recommendations are outdated within hours because customers see yesterday's data. The data engineer needs to modify the architecture to support near-real-time analytics. The budget is limited, and the existing warehouse infrastructure must be reused as much as possible. Which architectural change would best meet the requirement?

A data analyst is performing hypothesis testing to compare the mean sales of two store locations. Which TWO conditions must be satisfied to use a two‑sample t‑test? (Select TWO.)

A data analyst is performing data profiling on a customer table. Which metric provides the number of unique values in a column?

A data analyst is preparing a dataset for a machine learning model and notices that several numerical features have different scales (e.g., age ranges from 18-90, income from 20,000-200,000). The analyst decides to apply feature scaling. Which TWO of the following statements about scaling techniques are correct? (Choose two.)

An analyst is performing a linear regression and obtains an R-squared value of 0.85. Which of the following is the best interpretation?

A data analyst is working with a relational database that contains a table of customer orders. To optimize query performance for a report that filters by order date and customer ID, the analyst wants to create an index. Which type of index would be most effective for queries that filter on both columns?

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?

An analyst creates a histogram of customer transaction amounts but observes that the distribution looks bimodal. Upon review, the analyst realizes that two different customer segments (retail and wholesale) were combined. Which action best addresses this?

A data analyst is building a self-service reporting environment. Which of the following is the primary benefit of this approach?

A data analyst is preparing a dataset for a machine learning model to predict customer churn. The dataset contains missing values in several columns. The analyst wants to handle missing data in a way that preserves as much information as possible and avoids introducing bias. Which TWO of the following techniques are appropriate? (Choose two.)

A data scientist is building a model to predict customer churn (yes/no). After training a logistic regression model, the coefficient for 'monthly charges' is 0.05 with a p-value of 0.03. Which interpretation is correct at α=0.05?

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?

Drag and drop the steps to normalize a database table from 1NF to 3NF in the correct order.

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 analyst is performing K-means clustering on customer data. Which THREE of the following are steps in the K-means algorithm?

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 dataset contains a column 'Age' with values: [22, 25, 25, 30, 35, 40, 45]. What is the interquartile range (IQR)?

A retail analytics team publishes a dashboard showing average order value by store. A regional manager notices that the store with the highest average order value is also the store with the fewest orders, and questions whether that store is genuinely the best performer. Which dashboard design change would BEST let the manager judge that store fairly?

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 dashboard designer is creating a sales performance dashboard and wants to minimize non-data ink to improve clarity. Which action best follows the principle of maximizing the data-ink ratio?

You are a data analyst at a logistics company. You have created a dashboard to monitor delivery performance. The dashboard includes a scatter plot showing delivery time (hours) vs. distance (miles) for each delivery, with points colored by delivery region (A, B, C, D, E). Users have reported that the scatter plot is cluttered because there are over 10,000 points, making it hard to see patterns. Additionally, the color legend for the five regions uses similar shades of blue, making it difficult to distinguish which region a point belongs to. You need to improve the scatter plot to reduce overplotting and improve region differentiation. Which approach is most effective?

An organization uses a data warehouse for analytics. The data team wants to load data from source systems into the warehouse. They choose to load raw data first and then perform transformations within the warehouse. Which approach are they using?

A data analyst receives a dataset with inconsistent date formats (e.g., "01/02/2023", "2023-01-02", "Jan 2, 2023"). Which data quality dimension is most directly affected?

An e-commerce company stores product descriptions that contain accented characters and emoji in customer reviews. The database currently fails to store these characters correctly, replacing them with question marks. Which action should the data engineer take to resolve this issue?

An analyst creates a dashboard with a large amount of decorative graphics and background images. According to CompTIA Data+, which design principle is being violated?

A data governance team is establishing policies. Which three activities are part of data governance? (Select THREE.)

A data analyst is performing data acquisition from multiple source files. Which TWO data profiling tasks should the analyst complete before loading the data into the target system?

A data analyst is building a dashboard for a regional sales director who needs to monitor daily performance across 12 territories. The director wants to instantly see which territories are below target, with the ability to click a territory to view its individual store details. The analyst decides to use a bullet chart for each territory. Which design choice best supports the director's need for immediate exception identification and drill-down?

A small business wants to acquire customer feedback through a short questionnaire emailed after purchase. Which data acquisition method does this represent?

A junior data analyst is asked to create a chart that shows total monthly revenue for the past 24 months so the finance team can see whether revenue is generally rising or falling over time. Which chart type is most appropriate?

A data analyst is using a public API to collect historical weather data. The API has a rate limit of 100 requests per minute, but the analyst needs to retrieve 10,000 records as quickly as possible. What strategy should be used?

A data analyst is designing a dashboard that will be displayed on a large monitor in a call center. The dashboard shows real-time metrics such as average handle time, call volume, and customer satisfaction. The analyst wants to ensure that the most critical metric—average handle time—is immediately noticeable when it exceeds a threshold. Which design technique best achieves this?

A business analyst needs to show the monthly sales trend for the past three years. Which chart type is most appropriate?

A data analyst is preparing a dataset for analysis and notices that the 'age' column has a significant number of missing values. The analyst decides to impute the missing values using the mean age. Which data preparation technique is being applied?

A data analyst is using a window function to assign a unique rank to each employee within their department based on salary, with ties receiving the same rank and leaving gaps. Which function should be used?

A retail company operates 50 stores across the country. The data analyst has been asked to create a dashboard to visualize monthly sales trends over the past two years and compare the performance of the top 5 stores. The dataset includes store name, date, and daily sales amount. Initial exploration reveals that some stores have missing sales data for certain months due to system outages, and there are occasional extreme values caused by promotional events (e.g., Black Friday sales are 10x normal). The analyst needs to choose an appropriate visualization approach that accurately represents the trends and comparisons while handling these data quality issues. What should the analyst do to best meet the requirements?

A data scientist is preparing data for a K-means clustering algorithm. The dataset contains features measured in different units (e.g., income in dollars and age in years). Which preprocessing step is most critical before running K-means?

A large online retailer stores customer orders in a PostgreSQL database. Each order has a unique order ID, and the database is normalized to 3NF. Which type of data is this?

A business analyst wants to show the relationship between advertising spend (independent variable) and sales revenue (dependent variable) for 12 different regions. Each region will be represented by a point. Which chart type is most appropriate?

A company is merging two customer databases from different acquisitions. They need to identify duplicate records. Which data profiling technique is most effective?

A marketing analyst receives a dataset containing customer ages recorded as whole numbers (for example, 25, 42, 67). The analyst wants to classify the measurement scale of the age field. Which measurement scale applies?

A data analyst at a healthcare clinic is preparing a patient records dataset for analysis. The analyst discovers that the 'date_of_birth' column contains values stored as text strings in the format 'MM/DD/YYYY', but the analytics tool requires a date data type for age calculations. Which data transformation technique should the analyst apply?

Drag and drop the steps to clean a dataset with missing values in the correct order.

A data scientist is building a predictive model to forecast monthly sales. The data shows a linear trend with no seasonality. Which regression technique is most appropriate?

A data engineer is designing an ETL pipeline to extract sales data from a legacy on-premise database and load it into a cloud data warehouse. The database is slow and queries during business hours affect performance. Which extraction strategy minimizes impact?

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?

In a logistic regression model predicting customer churn (1 = churn, 0 = not churn), the coefficient for 'contract length' is -0.5. Which of the following is the correct interpretation?

A data analyst is performing exploratory data analysis on a dataset containing house prices. They want to identify outliers in the 'price' column using the IQR method. The first quartile (Q1) is $200,000, the third quartile (Q3) is $350,000, and the IQR is $150,000. What is the upper bound for identifying outliers?

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?

A data analyst needs to share a weekly sales report with the marketing team. The report includes aggregated data from the data warehouse. To simplify access, the analyst creates a virtual table that encapsulates the complex query. Which database object should the analyst create?

Based on the exhibit, what is the most likely cause of the import failure?

A data analyst is designing a dashboard for executives. Which TWO practices improve dashboard effectiveness? (Select two.)

A data analyst has built a dashboard tracking daily website sessions. The product owner wants to know which acquisition channel contributed the largest share of sessions over the past quarter, and how those shares shifted month by month. Which chart type is MOST appropriate?

A data analyst needs to show the relationship between advertising spend (in dollars) and monthly sales revenue (in dollars) for the past 12 months. Which chart type is most appropriate?

A data analyst discovers that the sales data for the current quarter shows a 15% increase in revenue. However, the analyst notes that the data does not include returns from the last week due to a system lag. How should the analyst communicate this uncertainty?

Which database index type is most commonly used for exact-match lookups and range queries in a B-tree structure?

A data analyst is preparing a dataset for analysis and needs to handle outliers. Which TWO of the following are common methods for treating outliers?

A data analyst is using pandas to clean a DataFrame that contains missing values in the 'age' and 'income' columns. Which THREE pandas methods are appropriate for handling missing data? (Select THREE).

A data analyst must build a monthly dashboard for the executive team. The dashboard will be viewed on large screens in the boardroom and must display the current month's revenue, profit margin, and customer acquisition cost at a glance. Which design approach best ensures the dashboard is immediately understandable?

A healthcare analytics team is analyzing patient readmission rates. They have a dataset with thousands of records including patient age, diagnosis, length of stay, number of prior admissions, and discharge date. The goal is to identify key factors influencing readmission and create a model to predict high-risk patients. The data is imbalanced: only 5% of patients are readmitted within 30 days. The team plans to use logistic regression. What is the most appropriate approach?

An e-commerce company wants to analyze sales performance across product categories. The dataset includes transaction amounts and a column 'category' with values (Electronics, Clothing, Home). The analyst decides to use stratified sampling to ensure proportional representation. Which THREE steps are required to implement this? (Select THREE).

A data engineer is designing a data warehouse for a multinational corporation. The company has sales data from different regions with varying currencies and date formats. To ensure consistency, which data concept should be applied to standardize the data before loading into the warehouse?

A logistics company is analyzing truck delivery times. Which variable is discrete?

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 data analyst at a logistics company receives a shipment-tracking table in which the carrier identifier column contains values such as 'FEDX', 'FedEx', 'fed ex', and 'FX'. The analyst needs to consolidate these into a single carrier value before building a delivery-performance dashboard. Which data preparation step should the analyst perform?