DA0-002 Data Concepts and Environments Practice Test 7 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Ordinal. The data is ordinal because the satisfaction levels have a clear, ordered ranking from 'Very Unsatisfied' to 'Very Satisfied', but the intervals between categories are not necessarily equal. This type of categorical data preserves the order without assuming a consistent numerical difference between each level.

Answer

Interval

Answer

Ratio

Answer

Nominal

Question 2

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?

Accepted Answer

Internal vs. External data. The scenario involves comparing internal CRM data (generated and owned by the company) with external government census data (publicly sourced from outside the organization). This directly maps to the Internal vs. External data concept, where internal data is collected within the enterprise (e.g., sales transactions, customer records) and external data is acquired from third-party sources (e.g., census bureaus, market research firms). The key distinction is the data's origin and ownership, not its structure, collection method, or measurement type.

Answer

Primary vs. Secondary data

Answer

Structured vs. Unstructured data

Answer

Quantitative vs. Qualitative data

Question 3

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?

Accepted Answer

Temperature is interval; wind speed is ratio. Temperature measured in Celsius has an arbitrary zero point (0°C does not mean 'no heat'), so it is interval data. Wind speed in meters per second has a true zero point (0 m/s means no wind), making it ratio data. Therefore, option D correctly identifies temperature as interval and wind speed as ratio.

Answer

Both are ratio data

Answer

Temperature is discrete; wind speed is continuous

Answer

Both are discrete data

Question 4

A company stores customer data in a relational database with tables for orders, products, and customers. Which type of data best describes this?

Accepted Answer

Structured data. A is correct because the data is stored in a relational database with predefined schemas (tables for orders, products, and customers), which enforces a fixed structure of rows and columns. This makes it structured data, as each field has a specific data type and relationships are defined via foreign keys, enabling efficient querying with SQL.

Answer

Unstructured data

Answer

Qualitative data

Answer

Semi-structured data

Question 5

A researcher wants to study the effect of a new drug. She collects data directly from clinical trial participants. Later, she compares her findings with historical data from medical journals. Which contrast best describes her data sources?

Accepted Answer

Primary vs. Secondary. The researcher is directly collecting data from clinical trial participants (primary data) and then comparing it with historical data from medical journals (secondary data). Primary data is original data collected firsthand for a specific purpose, while secondary data is pre-existing data collected by others for different purposes. This contrast directly maps to the primary vs. secondary data classification in data management.

Answer

Internal vs. External

Answer

Quantitative vs. Qualitative

Answer

Structured vs. Unstructured

Question 6

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?

Accepted Answer

Mixing quantitative and qualitative data. The 'Income' column contains both numeric values (e.g., '$50,000', '$75,000') which are quantitative data, and categorical labels ('High', 'Low') which are qualitative data. Mixing these two distinct data types in a single column violates data consistency principles and prevents proper statistical analysis or machine learning processing. This is a classic example of mixing quantitative and qualitative data.

Answer

Mixing discrete and continuous data

Answer

Mixing nominal and ordinal data

Answer

Mixing structured and unstructured data

Question 7

Which of the following is an example of qualitative data?

Accepted Answer

Customer feedback comments. Customer feedback comments are qualitative data because they consist of non-numerical, descriptive text that captures opinions, sentiments, or experiences. Unlike quantitative data, which can be measured or counted, qualitative data is categorical and often requires thematic analysis to derive insights.

Answer

Stock price

Answer

Number of website visitors

Answer

Product weight in grams

Question 8

A data team is building a predictive model. They have data on 'Number of employees' (whole numbers) and 'Revenue' (currency). Which statement correctly compares these data types?

Accepted Answer

Number of employees is discrete; revenue is continuous. 'Number of employees' is a count of distinct entities, making it discrete data (only whole numbers), while 'Revenue' can take any value within a range (including decimals), making it continuous data. Discrete data arises from counting, whereas continuous data arises from measurement.

Answer

Both are continuous data

Answer

Both are ratio data

Answer

Number of employees is qualitative; revenue is quantitative

Question 9

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?

Accepted Answer

Treating ordinal data as interval. The analyst assigned numeric values (1-4) to 'Education Level' categories and computed an average. This treats the ordinal data as if it were interval data, assuming equal spacing between categories (e.g., the difference between 'High School' and 'Bachelor' is the same as between 'Master' and 'PhD'), which is not valid. Ordinal data only preserves order, not magnitude or equal intervals, so calculating a mean is inappropriate.

Answer

Misclassifying data as structured

Answer

Treating nominal data as ordinal

Answer

Treating ratio data as interval

Question 10

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

Accepted Answer

Stored in rows and columns. Structured data is organized into rows and columns, typically within relational databases or spreadsheets, where each column represents a specific attribute and each row represents a record. This tabular format enables efficient querying, sorting, and indexing using languages like SQL. The rigid row-and-column structure ensures data consistency and supports ACID (Atomicity, Consistency, Isolation, Durability) properties.

Answer

Lacks a fixed schema

Answer

Uses tags to define elements

Answer

Consists of free-form text

Question 11

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

Accepted Answer

Age in years. Age in years is a numerical measurement that can be counted or measured on a ratio scale, making it quantitative data. Quantitative data represents quantities that can be expressed numerically and subjected to mathematical operations, such as calculating the average age of a group.

Answer

Product color

Answer

Customer satisfaction rating (Poor, Fair, Good)

Answer

Country of origin

Question 12

Which THREE of the following are properties of ratio data? (Choose THREE.)

Accepted Answer

Supports multiplication and division. Ratio data supports multiplication and division because it has a true, meaningful zero point that indicates the absence of the measured attribute. This allows ratios to be computed (e.g., one value is twice another), which is a defining property of ratio scales in measurement theory.

Answer

Data can be categorized into groups

Answer

Allows negative values

Question 13

The exhibit shows a JSON schema for a dataset. Which statement correctly describes the data types represented?

Accepted Answer

All fields are qualitative. All fields in the dataset are qualitative (categorical or nominal). customer_id is a unique identifier (nominal), education is a categorical variable, age is often grouped into categories (ordinal), and income is typically treated as ordinal when bucketed into ranges. Despite being stored as numbers, age and income are not used for arithmetic in typical data analysis, making them qualitative.

Answer

age and income are continuous; customer_id and education are discrete

Answer

customer_id and age are discrete quantitative; income is continuous quantitative; education is qualitative

Answer

All fields are quantitative

Question 14

A retail company has merged with another firm and now needs to create a unified customer data warehouse. The existing systems use different data classification methods: System A stores customer income as a categorical range (e.g., '$0-$50k', '$50k-$100k', '$100k+') while System B stores exact income as a decimal number. A data analyst must combine these into a single table. The goal is to perform statistical analysis that includes calculating average income, but the categorical data from System A loses precision. The analyst proposes converting System B's exact values into the same ranges as System A to ensure consistency. However, the data governance team wants to preserve as much detail as possible. Which course of action should the analyst recommend?

Accepted Answer

Impute System A's categorical data with the midpoint of each range to create a continuous numeric field, then combine with System B's exact values. Imputing the midpoint of each income range converts System A's categorical data into a continuous numeric field, allowing it to be combined with System B's exact decimal values. This approach preserves the granularity of System B's data while enabling statistical calculations like average income across the unified dataset, balancing the data governance team's requirement for detail with the need for consistency.

Answer

Store both columns separately and treat them as independent attributes

Answer

Convert System B's exact income to ranges matching System A, then combine

Answer

Use only System B's data and discard System A because it is less precise

Question 15

A healthcare analytics team is building a dashboard to monitor patient vitals. They receive data from two sources: Source 1 provides 'heart rate' as an integer (beats per minute), and Source 2 provides 'blood pressure' as a ratio (systolic/diastolic, e.g., 120/80). The team wants to create a combined metric called 'cardiac stress index' that uses both heart rate and systolic blood pressure. However, they notice that heart rate data occasionally contains negative values due to sensor errors. The data governance policy requires that all data be valid and meaningful. Which action best addresses the data quality issue while preserving the data types?

Accepted Answer

Remove all records with negative heart rate values as they are invalid. Negative heart rate values are physiologically impossible and violate the data governance policy requiring valid and meaningful data. Removing these records ensures the dashboard only contains accurate, actionable data without altering the original integer data type of heart rate, preserving its numerical integrity for the 'cardiac stress index' calculation.

Answer

Convert heart rate to absolute values (remove the negative sign)

Answer

Keep negative values but set them to NULL to indicate missing data

Answer

Change heart rate from integer to categorical (e.g., low, normal, high) to avoid negative issues