CompTIA Data+ Certification (DAO-002) Practice Test

These questions are part of the practice quiz. Start practicing

• Which statement best defines data governance?
• Which item is not a data lifecycle stage?
• During initial data analysis, which issue should the analyst flag?
• Which activity is part of a data governance process that involves documenting data sources and communicating data limitations?
• For a weekly sales report intended for the Chief Financial Officer, which delivery method is most appropriate?
• Which data quality check helps identify incorrect formats in identifiers such as customer IDs?
• Which statement best describes the relationship between data quality management and data profiling?
• A data analyst's code is failing during a large batch upload. After verifying the key, object definitions, syntax, and exception handling, what is the most appropriate next step?
• Which programming language is commonly used for data mining and statistical analysis?
• Which option best describes the sequence to retrieve and append historical data to a current dataset?
• To show all records from the right-hand table even if there is no matching row in the left-hand table, which join type should you use?
• In data warehousing, which data structure is used for multi-dimensional analysis and supports drill-down capabilities?
• Before creating dashboards for multiple teams, which step should be taken first?
• What practice involves creating a mock-up of the dashboard to gather feedback and clarify requirements?
• If you want to produce a single set of rows by combining two datasets with compatible columns, which operator is used?
• Which data integration pattern supports continuous updates?
• To resolve duplicates when counting employees earning $125,000 or more, which SQL construct should be used?
• In a data warehouse, which table type is used to store region information for sales analysis?
• What is data throttling or rate limiting in analytics pipelines?
• Which delivery method is least suitable for an ongoing automated weekly report that needs up-to-date data?
• Which term describes keeping multiple copies of data across locations to improve reliability?
• To prepare a report for external users, a visual should be identifiable as belonging to the organization. Which addition best meets this requirement?
• Describe the difference between data quality and data integrity.
• What is the primary purpose of a pivot table in a large dataset?
• Which statement best describes semi-structured data?
• Which data repository stores unformatted data in its original, raw form?
• How do you ensure ethical use of data in analytics projects?
• A data analyst needs to compute the number of days from dates in a flat file to the current date. What is the best approach?
• Which option best describes the function of a data flow diagram?
• Which are the six data quality dimensions?
• Which statement best reflects a data governance practice during analytics projects?
• Anonymization as a data protection technique is best described as?
• Which scenario best describes usage of non-relational databases?
• In designing a report for the business review team, which component is missing given the requirements?
• Which is an example of a primary data source?
• Which graphic best represents the relationship between ages and incomes of employees?
• A data engineer needs a reporting solution with predefined filters and the ability to download CSV files. Which option is best?
• How would you explain data culture to a non-technical stakeholder?
• During debugging, after confirming formatting and error handling, which action best helps identify the root cause?
• A data breach occurs. Which sequence of actions should be followed?
• If a report shows 'FullName' is invalid or does not exist, what is a good next step to investigate?
• Which technique groups continuous numeric values into discrete ranges to aid distribution analysis?
• Which data quality control measure helps identify incorrect values in a field that stores customer IDs in a defined format?
• Which approach is most appropriate to extend a dataset with data from the previous year?
• What is a data steward responsible for?
• Which statement describes the data steward role?
• Which statistic measures dispersion of a dataset around its mean?
• A sales manager wants a dashboard that shows sales aggregated by region and identifies high-volume sales by salesperson per region. Which of the following techniques best displays this information?
• Which option correctly describes data dictionary usage?
• Which SQL condition best returns rows where the name column starts with the letters ANT?
• For dashboards and tools aimed at helping a company achieve its strategic goals, which type of analytics should be incorporated?
• Which of the following best describes the reason an analyst would reference a data dictionary versus a source's metadata?
• When loading a large set of logs and memory is insufficient, what is the best approach?
• Which schema normalizes dimensions into multiple related tables?
• A data analyst is creating a dashboard for a group of visually impaired stakeholders. Which of the following communication approaches is best?
• Which normalization form eliminates partial dependencies?
• When designing a survey for Paralympic athletes, which consideration is important for accessibility?
• Which statistical method is used to summarize basic characteristics of a dataset?
• After meeting the initial requirements for a reporting deck that includes metrics tracking and row-level security, which action should the analyst take next?
• Which visualization is most appropriate to show availability zones from the last ten years and forecasted zones for the next five years?
• What protects data at rest?
• What practice helps monitor a dashboard for data quality and notify anomalies?
• Which schema design uses a central fact table with denormalized dimensions?
• Which data repository stores both unstructured and structured data?
• Which statement correctly identifies technical metadata?
• Which of the following describes a Boolean data type?
• Which description best matches containerization?
• Data profiling and its importance?
• Why is metadata important for data discovery and governance?
• Which data store is designed to hold both raw and curated data for analytics?
• What is least privilege and why important?
• Which technique should the analyst use to group service calls into low-, medium-, and high-priority levels for analysis?
• Which technique best addresses how to validate data moving forward?
• Which deployment approach enables running applications with their dependencies across different environments?
• A data analyst is creating a document that covers guidelines and transformation of the suite of sales dashboards that they are responsible for delivering. Which of the following is the analyst most likely creating?
• What does data lineage refer to in analytics?
• A manager requests a report that returns results based on a user's profile. Which of the following best describes this type of report?
• What is a recommended first step when dates are stored as strings before calculating differences?
• In an ER diagram, which elements are commonly represented?
• Which artifact provides a centralized reference for data elements, including names, data types, and definitions?
• Which data management artifact is used to define data field names, data types, and allowed values when creating a report?
• What is a data warehouse, data lake, and data lakehouse, and when would you use each?
• A dashboard loads more components than expected. Which step should be taken to correct this issue?
• After a database upgrade, a report using datetime calculations does not complete due to an arithmetic overflow error. What is the best way to troubleshoot?
• What is the primary purpose of Level of Detail (LOD) in dashboards?
• What is ELT and why is advantageous with cloud data warehouses?
• Which diagram is used to illustrate data flow in a data pipeline?
• In evaluating all conditions in a query, which logical function is most appropriate?
• Which statement about data lineage is true?
• To sort cellular numbers by the carrier of the called number and compute the total call durations, which operation should you perform?
• When faced with outliers in data analysis, what is the recommended approach?
• What does data drift refer to in data science?
• For forecasting a product metric, which data attribute types are appropriate to represent numerical measures and ordered categories?
• For a weekly financial report that updates automatically, which delivery method is least appropriate?
• What approach supports accessibility for visually impaired stakeholders when presenting dashboards?
• A product goes viral on social media, creating high demand. Distribution channels are facing supply chain issues because the testing and training models that are used for sales forecasting have not encountered similar demand. Which of the following best describes this situation?
• Which join returns only rows with matches in both tables?
• What makes a good data visualization story?
• To compute the mean score in science classes from the available tables, which function combination will produce the result?
• A dashboard shows traffic volume and mean response time, but the mean response time has not updated for more than an hour. What is the best way to verify the data's freshness?
• Which visualization type is typically used to display the relationship between two quantitative variables?
• Which data quality dimension relates to missing values in a data set?
• In a data warehouse, which type of table stores descriptive attributes used for analysis, such as region attributes?
• What is a simple approach to evaluating data quality using a scoring method?
• Which analytics describe what happened in the data?
• Which tool is used to summarize data by categories and measures?
• Which statement best differentiates data policies, standards, and procedures?
• To refine data selection from a second table using data from the first table, which approach is most efficient?
• A data analyst receives a request for the current employee head count and runs the following SQL statement: SELECT COUNT(EMPLOYEE_ID) FROM JOBS. The returned head count is higher than expected because employees can have multiple jobs. Which of the following should return an accurate employee head count?
• Before calculating the average, which exploration technique should have been considered?
• Which feature restricts data visibility at the row level based on user permissions within a dashboard?
• Which normalization form eliminates repeating groups?
• In an ER diagram, what does a line between two entities denote?
• Which language is best to use in a data notebook?
• Which data format is commonly used for interoperability with web APIs and can be loaded into pandas DataFrames?
• In data warehousing, what term refers to a dataset created specifically for drill-down reports?
• A data analyst wants to determine the total cost for each transaction in a data set. Which method should be used?
• Given the data set: Which value is the mode?
• Which data management artifact describes the origin and transformations of data as it flows through systems?
• Which concept describes the origin and movement of data through systems from source to destination?
• A data analyst is gathering data from multiple tables in a database and needs specific columns from each table. What is the best method to accomplish this task?
• Which option is most efficient for automating repeatable tasks?
• What is the primary purpose of a data catalog?
• Which of the following best describes a business glossary?
• Which statement best contrasts a data dictionary with a business glossary?
• Which statistic best describes dispersion of a dataset around the center for a numerical dataset?
• Which analytics type forecasts future outcomes?
• Which join type returns all records from both tables including unmatched rows, with NULLs where there is no match?
• Which statement best distinguishes PII, PHI, and anonymization?
• Which statement correctly describes KPI, metric, and dimension and explain how they relate in a dashboard?
• Which data quality dimension ensures there are no duplicate records?
• Which statement best explains the purpose of UAT?
• Which visualization type is best for showing a trend over time?
• Which SQL keyword ensures unique rows are returned?
• Before developing dashboards for multiple teams, which element should be defined to guide design?
• In a January sales data report, which data quality inconsistency is present?
• For forecasting next year's sales and customer satisfaction, which data attribute types are typically used?
• Which infrastructure model combines on-premises and cloud resources?
• Which approach enables transferring isolated applications to multiple environments by packaging them with their dependencies?
• Which statement describes a benefit of data governance?
• Which text-editing tool is commonly used to modify configuration files for data connections?
• Which category of analytics is used to summarize data and describe what has happened?
• Which artifact lists field names and data types for a dataset?
• Which data privacy technique is used to protect employees' email addresses when creating a report?
• Which infrastructure model requires a company to purchase and maintain all of its own servers?
• Name three common data privacy laws or concepts relevant to analytics.
• Which tool would a data analyst most likely use to modify a simple data connection property in a configuration file?
• What are two common data visualization pitfalls to avoid?
• An analytics manager wants all reports delivered on a fixed weekly schedule. Which delivery method is best?
• Which statement best describes the purpose of a data catalog?
• Which data management artifact documents the data elements and metadata, including definitions and data types?
• Which method protects data in transit?
• What strategy helps mitigate bias in analytics?
• Which statement best describes structured data?
• Which questions should you ask when scoping a data analytics project?
• If a dataset contains missing values, which data quality issue is present?
• Which data source makes online data consumption easier?
• Which technique makes data unreadable without a required key?
• What are GROUP BY and HAVING used for?
• As documented in metadata, which term describes the data's path from source through transformations to its destination?
• Which artifacts are commonly used to document data lineage?
• Which statement is true about relational databases?
• What is the function of a data retention and deletion policy?
• Which artifact should a data analyst consult to understand table names, field definitions, data types, and field definitions?
• Explain ETL vs ELT and give a scenario for each.
• Which operation would you use to produce a FullName by combining FirstName and LastName fields?
• Which technique should be used to segment customers based on spending behavior in a dataset with a million rows?
• Name three data integration patterns and describe them.
• Which of the following file types separates data using a delimiter?
• A data analyst needs to join together a table data source and web API data source using Python. Which of the following is the best way to accomplish this task?
• What is data anonymization used for?
• What is a data map and why is it useful?
• To derive a new field that flags sales within January from a sales table, which type of function should be used?
• In a data warehouse, which scenario is the best example of a slowly changing dimension that does not retain history?
• Which data privacy technique is non-reversible, often used to protect data by transforming values into a fixed representation?
• What is the primary purpose of a data warehouse?
• What is the role of a data analyst in the data governance process?
• Which piece of information, if made public, would constitute a data privacy violation?
• Which feature should be added to a report to ensure visuals are branded and identifiable as part of the organization?
• To create a combined report from two tables, which query method should be used?
• Why is data normalization often used in analytics pipelines?
• A manager requires a report to always reflect the latest data. What refresh frequency is this?
• Which statement about metadata is correct?
• Which visualization type is commonly used to display correlations among many variables?
• What is bias in data analytics?
• How does denormalization help analytics workloads?
• Which statement describes a conceptual data model?
• INNER JOIN vs LEFT OUTER JOIN explanation?
• Which SQL statement retrieves customer_id and name from customers where status='active'?
• Which example illustrates timeliness as a data quality dimension?
• To identify customers who made a purchase in January and flag them in a dataset, which type of function is most appropriate?
• Which Slowly Changing Dimension type preserves historical records by creating new rows for changes?
• Which concept is typically found in metadata?
• If a data integration process has issues after standard checks, which action is most appropriate as the next step?
• In data governance context, what is essential?