Courseiva

CCNA Data Concepts and Environments Questions

75 of 186 questions · Page 2/3 · Data Concepts and Environments · Answers revealed

Practice these questionsDomain overviewAll questions
76
Multi-Selectmedium

A database designer wants to improve query performance on a large table that is frequently filtered by multiple columns. Which TWO types of indexes could be beneficial? (Select TWO).

Select 2 answers
A.Bitmap index
B.Composite index
C.Hash index
D.Full-text index
E.B-tree index
AnswersB, E

Composite indexes on multiple columns can speed up queries filtering by those columns.

Why this answer

Composite indexes cover multiple columns, and B-tree indexes are general-purpose and support range queries, both useful for filtering on multiple columns.

Practice this question →
77
MCQhard

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.Data sampling
B.Encoding
C.Feature scaling
D.Dimensionality reduction
AnswerB

Encoding converts categories to numbers, e.g., one-hot encoding.

Why this answer

Encoding is the correct data concept because it transforms categorical features (like gender and marital status) into numerical representations (e.g., one-hot encoding, label encoding) that machine learning algorithms can process. Unlike feature scaling or dimensionality reduction, encoding directly addresses the incompatibility of non-numeric data with mathematical model operations.

Exam trap

CompTIA often tests the distinction between encoding and feature scaling, where candidates mistakenly think scaling applies to categorical data, but scaling only adjusts numeric ranges and cannot convert text labels to numbers.

How to eliminate wrong answers

Option A is wrong because data sampling refers to selecting a subset of data for training/testing, not converting categorical data to numeric. Option C is wrong because feature scaling normalizes numerical ranges (e.g., via min-max scaling or z-score standardization) and does not handle categorical-to-numeric conversion. Option D is wrong because dimensionality reduction (e.g., PCA, t-SNE) reduces the number of features, but it assumes all input features are already numeric and does not address the encoding of categorical variables.

Practice this question →
78
MCQhard

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.Create a composite B-tree index on (department_id, hire_date)
B.Create a bitmap index on hire_date
C.Create a hash index on department_id only
D.Create two separate B-tree indexes, one on each column
AnswerA

Composite index on both columns in the filter order can be used for both conditions.

Why this answer

A composite B-tree index on (department_id, hire_date) is most effective because it allows the database to satisfy equality and range predicates on both columns in a single index scan. B-tree indexes are optimized for high-cardinality columns and support efficient multi-column filtering when the leading column matches the query's equality condition, followed by the range condition on hire_date.

Exam trap

The trap here is that candidates often assume two separate single-column indexes are equivalent to a composite index, but they fail to realize that the database cannot efficiently combine them for range predicates without a costly index merge operation.

How to eliminate wrong answers

Option B is wrong because bitmap indexes are designed for low-cardinality columns (e.g., gender or status) and perform poorly with high-cardinality columns like hire_date, leading to excessive bitmap merge overhead and poor query performance. Option C is wrong because a hash index on department_id only supports equality lookups, not range queries on hire_date, and cannot be used for filtering on both columns simultaneously. Option D is wrong because two separate B-tree indexes would force the optimizer to choose one index and then filter the other column via a table access (or perform an expensive index merge), which is less efficient than a single composite index that can directly satisfy both predicates.

Practice this question →
79
MCQmedium

When the analyst runs the query, it fails. What is the most likely reason?

A.The alias 'TotalValue' cannot be used in the WHERE clause.
B.The table name 'Products' is misspelled.
C.The data types of Price and Quantity are incompatible.
D.The expression 'Price * Quantity' is invalid in SQL.
AnswerA

Aliases are not recognized in WHERE due to order of execution.

Why this answer

The alias 'TotalValue' is defined in the SELECT clause but is referenced in the WHERE clause. In SQL, column aliases cannot be used in the WHERE clause because the WHERE clause is evaluated before the SELECT clause, so the alias does not yet exist at that point in the query execution order. This causes a syntax or 'unknown column' error.

Exam trap

CompTIA often tests the SQL query execution order, specifically that column aliases cannot be used in the WHERE clause, leading candidates to mistakenly think the alias is available everywhere in the query.

How to eliminate wrong answers

Option B is wrong because a misspelled table name would cause a 'table not found' error, not the alias-related failure described. Option C is wrong because Price and Quantity are typically numeric types (e.g., DECIMAL, INT), and multiplication is valid between compatible numeric types; if they were incompatible, the error would be about implicit conversion, not alias usage. Option D is wrong because 'Price * Quantity' is a valid arithmetic expression in SQL, and the multiplication operator works on numeric columns.

Practice this question →
80
Drag & Dropmedium

Drag and drop the steps for the ETL (Extract, Transform, Load) process in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4

Why this order

ETL begins with extraction, followed by cleaning, transformation, loading, and verification.

Practice this question →
81
MCQmedium

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.Accuracy
B.Consistency
C.Validity
D.Completeness
AnswerC

Correct. The values are not valid for the Age attribute.

Why this answer

Validity refers to the degree to which data conforms to defined business rules or constraints. Invalid entries (non-numeric, negative) violate the expected data type and range.

Practice this question →
82
MCQeasy

Which of the following is an example of qualitative data?

A.Stock price
B.Customer feedback comments
C.Number of website visitors
D.Product weight in grams
AnswerB

Comments are text, non-numeric, qualitative data.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse 'qualitative' with 'quantifiable' and may incorrectly select a numeric option like stock price or website visitors, not realizing that qualitative data is inherently non-numeric and descriptive.

How to eliminate wrong answers

Option A is wrong because stock price is a numerical value that can be measured and compared, making it quantitative data. Option C is wrong because the number of website visitors is a count, which is a discrete numerical value and thus quantitative data. Option D is wrong because product weight in grams is a continuous numerical measurement, falling under quantitative data.

Practice this question →
83
Multi-Selectmedium

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)

Select 2 answers
A.LEFT JOIN
B.INNER JOIN
C.CROSS JOIN
D.RIGHT JOIN
E.FULL OUTER JOIN
AnswersA, E

LEFT JOIN returns all rows from the left (employees) table.

Why this answer

LEFT JOIN and RIGHT JOIN (if reversed) can include all rows from the left table. Specifically, LEFT JOIN includes all rows from the left table. FULL OUTER JOIN also includes all rows from both tables, but the question says 'all rows from the employees table' – that is satisfied by LEFT JOIN and also by FULL OUTER JOIN (which includes all from employees).

However, the correct answer set: LEFT JOIN and FULL OUTER JOIN. The question says 'include all rows from the employees table' – RIGHT JOIN does not guarantee that unless employees is on the right side. So the correct two are LEFT JOIN and FULL OUTER JOIN.

Practice this question →
84
Multi-Selectmedium

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)

Select 2 answers
A.A foreign key must have the same name as the primary key it references
B.A foreign key ensures referential integrity between tables
C.A foreign key can reference a column that is not a primary key
D.A table can have multiple primary keys
E.A primary key column cannot contain NULL values
AnswersB, E

Foreign keys enforce that values match the referenced primary key.

Why this answer

A foreign key enforces referential integrity by ensuring that every value in the foreign key column of the 'enrollments' table matches a valid primary key value in the 'students' table. This prevents orphaned records and maintains consistency across related tables in a normalized relational database.

Exam trap

The trap here is that candidates often assume a foreign key can reference any column, forgetting that the referenced column must have a unique constraint (primary key or unique) to ensure a single target row, which is a common point of confusion in DA0-001.

Practice this question →
85
MCQeasy

Refer to the exhibit. An Avro schema is defined as shown. Which data design concept does this represent?

A.Schema-on-read
B.Schema-less design
C.Dynamic schema
D.Schema-on-write
AnswerD

Avro uses a predefined schema that is applied when data is written, typical of schema-on-write.

Why this answer

Avro requires defining the schema before writing data, imposing structure at write time (schema-on-write). Schema-on-read would apply structure when reading, and schema-less design has no predefined schema.

Practice this question →
86
MCQmedium

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.FULL OUTER JOIN
B.LEFT JOIN
C.INNER JOIN
D.RIGHT JOIN
AnswerB

LEFT JOIN includes all rows from the left table, even if no match exists in the right table.

Why this answer

A LEFT JOIN returns all rows from the left table (customers) and matching rows from the right table (orders). If a customer has no orders, the order columns will contain NULLs. This satisfies the requirement to include all customers, even those without orders.

Exam trap

The trap here is that candidates often confuse LEFT JOIN with FULL OUTER JOIN, thinking they need to preserve all rows from both tables, when the requirement only specifies preserving all customers.

How to eliminate wrong answers

Option A is wrong because a FULL OUTER JOIN returns all rows from both tables, which would include unmatched orders (if any) and is unnecessary when only all customers are needed. Option C is wrong because an INNER JOIN returns only rows with matches in both tables, excluding customers who have not placed orders. Option D is wrong because a RIGHT JOIN returns all rows from the right table (orders) and matching customers, which would omit customers without orders if the customer table is on the left.

Practice this question →
87
MCQmedium

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

A.Typically stores data in object storage
B.Optimized for complex queries on structured data
C.Stores raw, unprocessed data
D.Uses schema-on-read
AnswerB

Data warehouses are designed for analytical queries on structured data.

Why this answer

A data warehouse is optimized for complex queries on structured data because it uses a schema-on-write approach, where data is cleaned, transformed, and organized into relational tables (e.g., star or snowflake schemas) before loading. This pre-processing enables efficient execution of aggregations, joins, and reporting queries using SQL, making it ideal for business intelligence and analytics. In contrast, data lakes store raw data in native formats and rely on schema-on-read, which is less performant for structured query patterns.

Exam trap

The trap here is that candidates confuse the storage location (object storage) or data state (raw vs. processed) with the defining characteristic of a data warehouse, which is its schema-on-write design and optimization for structured query performance.

How to eliminate wrong answers

Option A is wrong because data warehouses typically store data in structured, columnar formats (e.g., Parquet, ORC) within relational databases or dedicated storage engines, not in object storage like Amazon S3 or Azure Blob Storage, which is characteristic of data lakes. Option C is wrong because data warehouses store processed, transformed, and cleansed data optimized for analysis, not raw, unprocessed data; raw data is a hallmark of data lakes. Option D is wrong because data warehouses use schema-on-write, where the schema is defined and enforced at data ingestion time, whereas schema-on-read is a property of data lakes where the schema is applied only when the data is queried.

Practice this question →
88
MCQhard

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?

A.Graph database (e.g., Neo4j)
B.Document store (e.g., MongoDB)
C.Key-value store (e.g., Redis)
D.Wide-column store (e.g., Cassandra)
AnswerC

Key-value stores excel at high-speed writes and lookups.

Why this answer

A key-value store like Redis is optimized for high-velocity writes and low-latency key-value lookups, making it ideal for clickstream data.

Practice this question →
89
MCQeasy

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

A.Unstructured data
B.Structured data
C.Semi-structured data
D.Relational data
AnswerC

JSON and XML are typical semi-structured formats.

Why this answer

JSON and XML are examples of semi-structured data, which has a flexible schema unlike structured data (fixed schema) or unstructured data (no schema).

Practice this question →
90
MCQhard

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.Exclude any record with missing Phone or Address from the migration.
B.Set missing values to an empty string in the JSON object.
C.Include the missing fields as null in the JSON object.
D.Replace missing values with 'N/A' string.
AnswerC

Null explicitly indicates missing data.

Why this answer

Representing missing fields as null in the JSON object preserves the data structure and allows downstream systems to explicitly handle null values. This approach maintains data integrity without discarding records or introducing ambiguous placeholder strings that could be misinterpreted as actual data.

Exam trap

The trap here is that candidates may confuse 'handling missing data' with 'filling in missing data,' leading them to choose placeholder strings (B or D) instead of preserving the null representation that JSON natively supports.

How to eliminate wrong answers

Option A is wrong because excluding records with missing Phone or Address would result in data loss, violating the migration requirement to preserve all customer data. Option B is wrong because setting missing values to an empty string conflates 'no data' with 'empty data,' which can cause incorrect processing in JSON parsers or CRM logic that expects null for absent values. Option D is wrong because replacing missing values with 'N/A' string introduces a non-standard placeholder that may be treated as valid data, leading to errors in downstream analytics or validation rules.

Practice this question →
91
MCQeasy

Refer to the exhibit. The data shown is an example of which data concept?

A.Structured data
B.Unstructured data
C.Metadata
D.Semi-structured data
AnswerA

Structured data conforms to a predefined schema, as shown in the CSV.

Why this answer

The exhibit shows data organized into rows and columns with a fixed schema (e.g., 'Name', 'Age', 'City'), which is the defining characteristic of structured data. Structured data conforms to a predefined data model, typically stored in relational databases or spreadsheets, and can be easily queried using SQL. This tabular format with consistent data types per column is the classic example of structured data.

Exam trap

CompTIA often tests the distinction between structured and semi-structured data, trapping candidates who see any organization (like tags in JSON) and mistakenly label it as structured, when the rigid row-and-column format is the key differentiator.

How to eliminate wrong answers

Option B is wrong because unstructured data lacks a predefined schema or organization, such as raw text, images, or audio files, whereas the exhibit clearly has a tabular structure. Option C is wrong because metadata is 'data about data' (e.g., file size, creation date), not the actual data values shown in the table. Option D is wrong because semi-structured data (e.g., JSON, XML) has some organizational properties (tags, key-value pairs) but does not enforce a rigid row-and-column schema like the exhibit does.

Practice this question →
92
MCQmedium

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.Self-join on the fact table
B.Cross join between fact and dimension tables
C.Inner join between fact table and dimension tables
D.Left outer join between fact and dimension tables
AnswerC

Inner join returns only matching rows, which is typical in star schema queries.

Why this answer

To retrieve total sales for each product category, you need to join the fact table with the product dimension table to map product keys to categories, and with the time dimension table to filter on the last month. An inner join is correct because it returns only rows where matching keys exist in both tables, which is the standard approach for star-schema queries where all required dimension attributes are present. This ensures that only valid sales transactions with corresponding product and time entries are included in the aggregation.

Exam trap

The trap here is that candidates often confuse the need for a left outer join to 'preserve all fact rows,' but in a well-designed star schema with referential integrity, inner join is sufficient and more performant, and left outer join is only needed when fact rows might lack matching dimension keys (e.g., orphaned records).

How to eliminate wrong answers

Option A is wrong because a self-join on the fact table would match rows within the same table, which is unnecessary here since the required attributes (product category and month) are in dimension tables, not in the fact table itself. Option B is wrong because a cross join between fact and dimension tables would produce a Cartesian product, generating every possible combination of fact rows with dimension rows, leading to massively inflated and incorrect sales totals. Option D is wrong because a left outer join would include fact rows even if there is no matching dimension row (e.g., a product key not in product_dim), which could introduce NULL values for category and potentially skew the aggregation; inner join is the standard for guaranteed referential integrity in a star schema.

Practice this question →
93
MCQhard

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.Both are ratio data
B.Temperature is discrete; wind speed is continuous
C.Both are discrete data
D.Temperature is interval; wind speed is ratio
AnswerD

Celsius has no true zero (interval), while wind speed has a true zero (ratio).

Why this answer

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.

Exam trap

The trap here is confusing interval and ratio data by overlooking the significance of a true zero point, leading candidates to incorrectly classify temperature as ratio data.

How to eliminate wrong answers

Option A is wrong because temperature in Celsius is interval data, not ratio data, due to the lack of a true zero point. Option B is wrong because temperature is continuous (can take any value within a range), not discrete; wind speed is also continuous. Option C is wrong because both temperature and wind speed are continuous data types, not discrete.

Practice this question →
94
Multi-Selecthard

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

Select 3 answers
A.Data is unbounded and infinite
B.Data is processed in micro-batches
C.Data arrives continuously
D.Data is stored permanently before processing
E.Data is processed in real-time
AnswersA, C, E

Streaming data is unbounded.

Why this answer

Streaming data is inherently unbounded and infinite because social media feeds generate a continuous, never-ending flow of events. Unlike batch data, there is no natural end to the stream; new tweets, posts, or interactions arrive constantly, making the dataset theoretically infinite in size.

Exam trap

The trap here is that candidates confuse processing strategies (like micro-batching) with the inherent nature of streaming data, or they assume streaming data must be stored before processing, which is a batch-oriented mindset.

Practice this question →
95
Multi-Selecthard

Which TWO of the following are examples of data governance best practices?

Select 2 answers
A.Defining data owners for each dataset
B.Implementing data quality standards
C.Creating indexes on frequently queried columns
D.Using a data lake for storage
E.Encrypting all data at rest
AnswersA, B

Ownership is a governance practice.

Why this answer

Defining data owners for each dataset is a core data governance practice that establishes accountability and responsibility for data assets. Data owners are typically senior stakeholders who ensure data is managed according to policies, including access controls and quality standards. This practice aligns with frameworks like DAMA-DMBOK, which emphasizes stewardship and ownership as foundational to governance.

Exam trap

CompTIA often tests the distinction between data governance (policies, ownership, quality) and data management (implementation, storage, performance) or security (encryption, access controls), leading candidates to confuse operational tasks with governance practices.

Practice this question →
96
MCQeasy

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.Qualitative & Quantitative
B.Quantitative & Qualitative
C.Both quantitative
D.Both qualitative
AnswerA

Correct. Brand is qualitative; units is quantitative.

Why this answer

'favorite brand' is a categorical label (qualitative data), while 'units purchased per year' is a numerical count (quantitative data). The question explicitly pairs these two distinct data types, matching the definition of qualitative (non-numeric categories) and quantitative (numeric measurements).

Exam trap

The trap here is that candidates often confuse the order of the data types in the question, assuming the first listed data type must be quantitative, leading them to select Option B instead of correctly identifying 'favorite brand' as qualitative.

How to eliminate wrong answers

Option B is wrong because it reverses the order: 'favorite brand' is qualitative, not quantitative, and 'units purchased per year' is quantitative, not qualitative. Option C is wrong because 'favorite brand' is not a numeric value; it is a categorical label, so both cannot be quantitative. Option D is wrong because 'units purchased per year' is a numeric count, not a categorical label, so both cannot be qualitative.

Practice this question →
97
Multi-Selectmedium

Which TWO roles are primarily responsible for defining and enforcing data governance policies within an organization?

Select 2 answers
A.Data analyst
B.Data architect
C.Data custodian
D.Data steward
E.Data owner
AnswersD, E

Ensures compliance and enforces data governance rules.

Why this answer

(Data steward) is correct because data stewards are responsible for the day-to-day management, quality, and enforcement of data governance policies, including data classification, access controls, and compliance with regulatory standards. Option E (Data owner) is correct because data owners are senior stakeholders who define the governance policies, approve data access decisions, and are accountable for the data assets within their domain.

Exam trap

The trap here is that candidates often confuse 'data custodian' (technical implementation) with 'data steward' (policy enforcement), or assume 'data analyst' has governance authority because they work closely with data, but the exam specifically tests the distinct RACI model roles in data governance.

Practice this question →
98
MCQeasy

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

A.Structured data
B.Unstructured data
C.Qualitative data
D.Semi-structured data
AnswerA

Relational databases impose a strict schema, making data structured.

Why this answer

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.

Exam trap

CompTIA often tests the misconception that any data stored in a database is automatically structured, but the trap here is that candidates might confuse semi-structured data (like JSON in NoSQL) with relational tables, which are strictly structured.

How to eliminate wrong answers

Option B is wrong because unstructured data lacks a predefined schema and cannot be stored in relational tables; examples include text files, images, or videos. Option C is wrong because qualitative data is non-numerical and descriptive (e.g., customer feedback text), but the scenario describes structured tables with quantitative and categorical fields. Option D is wrong because semi-structured data has some organizational properties (like tags or key-value pairs) but does not conform to a rigid relational schema; examples include JSON or XML files, not relational database tables.

Practice this question →
99
Multi-Selecteasy

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

Select 2 answers
A.Social media feeds
B.Employee payroll data
C.Government census data
D.Sales transaction records
E.Market research reports from third parties
AnswersB, D

Payroll data is generated and maintained internally by HR systems.

Why this answer

Employee payroll data (B) is generated and stored internally by an organization's HR or finance systems, making it an internal data source. Sales transaction records (D) are also generated internally through the organization's sales processes. Both are proprietary and not accessible from outside, fitting the definition of internal data.

In contrast, social media feeds (A), government census data (C), and third-party market research (E) originate externally and are therefore external data sources.

Exam trap

The trap here is that candidates may confuse 'data used internally' with 'internal data source,' mistakenly selecting options like social media feeds or third-party reports because the organization uses them for analysis, even though they originate externally.

Practice this question →
100
MCQeasy

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.Atomicity
B.Isolation
C.Durability
D.Consistency
AnswerA

Atomicity ensures the transaction is all-or-nothing.

Why this answer

Atomicity guarantees that a transaction is treated as a single unit; it either completes entirely or is rolled back, preventing partial updates.

Practice this question →
101
MCQmedium

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.Snowflake schema
B.Star schema
C.Wide table
D.Third normal form (3NF)
AnswerB

Star schema denormalizes dimension tables, reducing the number of joins and improving query performance for aggregations.

Why this answer

The star schema is most efficient for this workload because it denormalizes lookup tables into dimension tables, reducing the number of joins required for aggregations. This design optimizes query performance for large historical datasets by enabling faster full table scans and simpler query plans, which is critical for financial applications needing rapid aggregations.

Exam trap

The trap here is that candidates often confuse normalization with performance, assuming snowflake or 3NF schemas are faster due to reduced redundancy, when in fact denormalization in a star schema minimizes joins for analytical queries.

How to eliminate wrong answers

Option A is wrong because the snowflake schema normalizes dimension tables into sub-dimensions, increasing join complexity and degrading query performance on large datasets. Option C is wrong because a wide table, while denormalized, leads to excessive redundancy and storage overhead, and can cause performance issues due to wide row scans and index inefficiencies. Option D is wrong because third normal form (3NF) prioritizes data integrity over query speed, requiring many joins that slow down aggregations on historical data.

Practice this question →
102
MCQeasy

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?

A.Change data capture (CDC)
B.ETL (Extract, Transform, Load)
C.ELT (Extract, Load, Transform)
D.Data replication
AnswerC

ELT loads raw data first, then transforms in the warehouse, reducing initial load time and utilizing warehouse resources.

Why this answer

(ELT) because the company wants to load raw data first and then transform it later, reducing initial processing time. ELT leverages the power of modern data warehouses to perform transformations after loading, which is ideal for rapidly growing volumes of raw transaction data.

Exam trap

The trap here is that candidates often confuse ETL and ELT, assuming that 'transform before load' (ETL) is always faster, but the question explicitly states the goal is to reduce processing time by loading raw data first, which directly points to ELT.

How to eliminate wrong answers

Option A is wrong because Change Data Capture (CDC) is a technique for capturing incremental changes from source systems, not a data loading approach that loads raw data first. Option B is wrong because ETL (Extract, Transform, Load) transforms data before loading, which contradicts the requirement to reduce processing time by loading raw data first. Option D is wrong because Data Replication copies data between systems in real-time or near-real-time, but it does not inherently load raw data into a data warehouse for later transformation.

Practice this question →
103
Multi-Selecteasy

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

Select 2 answers
A.Industry reports from a trade association
B.Government census data
C.Customer survey responses collected by the company themselves
D.Company sales records
E.Social media data purchased from a vendor
AnswersC, D

Correct. Surveys conducted by the company are primary.

Why this answer

Primary data is collected directly by the researcher or organization for a specific purpose. Customer survey responses gathered by the company itself are firsthand, original data that have not been previously published or aggregated by an external source. This aligns with the definition of primary data as original, unprocessed information collected from the source.

Exam trap

CompTIA often tests the distinction between primary and secondary data by including options that appear firsthand but are actually collected by an external entity, such as purchased datasets or government reports, leading candidates to mistakenly classify them as primary.

Practice this question →
104
MCQmedium

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.DataAnalyst can read objects in the production folder except those in the sensitive subfolder.
B.DataAnalyst can read all objects in the production folder, including the sensitive subfolder.
C.No one can read from the production folder except DataAnalyst.
D.Only DataAnalyst is allowed to read from the entire production folder.
AnswerA

Allow on prod/*, Deny on prod/sensitive/* explicitly blocks access to sensitive subfolder.

Why this answer

The exhibit shows an access control policy that grants the DataAnalyst user read permission on the production folder, but includes an explicit deny rule for the sensitive subfolder specified via a path condition. In most access control systems, explicit deny rules take precedence over allow rules, so the deny on the sensitive subfolder overrides the allow on the production folder, effectively blocking read access to objects in the sensitive subfolder while permitting reads elsewhere in the production folder.

Exam trap

The trap here is that candidates often assume an allow rule on a folder grants full access to all subfolders, forgetting that an explicit deny rule on a specific subfolder (via a path condition) takes precedence and creates a narrower effective permission.

How to eliminate wrong answers

Option B is wrong because it claims DataAnalyst can read all objects including the sensitive subfolder, but the explicit Deny on that subfolder prevents read access, so this statement is false. Option C is wrong because it states 'No one can read from the prod bucket except DataAnalyst,' which is incorrect; the policy only applies to DataAnalyst and does not grant or deny permissions to other principals, so other users or roles may have separate policies allowing read access. Option D is wrong because it says 'Only DataAnalyst is allowed to read from the entire prod bucket,' but the Deny on the sensitive subfolder means DataAnalyst cannot read from the entire bucket, and other principals might also have read permissions via different policies.

Practice this question →
105
MCQmedium

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 lake ingestion
B.ETL
C.ELT
D.Stream processing
AnswerC

ELT loads raw data then transforms within the warehouse.

Why this answer

ELT (Extract, Load, Transform) loads raw data first, then transforms it inside the data warehouse, as opposed to ETL which transforms before loading.

Practice this question →
106
MCQhard

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

A.Consistency
B.Uniqueness
C.Completeness
D.Accuracy
AnswerB

Duplicates violate the uniqueness dimension.

Why this answer

Duplicate customer IDs violate the uniqueness dimension because uniqueness ensures that each record in a dataset has a distinct identifier with no duplicates. In an ETL process, a primary key or unique constraint on the customer ID column would reject duplicate values, causing the data quality check to fail. This is distinct from consistency, which checks for logical agreement across data sources.

Exam trap

The trap here is that candidates confuse uniqueness with accuracy, thinking a duplicate ID is 'inaccurate' data, but accuracy concerns correctness of values, not their distinctness.

How to eliminate wrong answers

Option A is wrong because consistency refers to data being logically coherent across systems (e.g., same customer name in CRM and ERP), not to the absence of duplicate IDs. Option C is wrong because completeness measures whether all required data is present (e.g., missing customer names), not whether values are duplicated. Option D is wrong because accuracy checks if data correctly reflects real-world values (e.g., correct spelling of a name), not uniqueness of identifiers.

Practice this question →
107
Multi-Selecthard

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)

Select 3 answers
A.Ensures data quality before loading
B.Provides ability to reprocess raw data if transformation logic changes
C.Leverages the processing power of the cloud data warehouse
D.Reduces storage costs by storing only transformed data
E.Allows for schema-on-read, enabling flexible analysis
AnswersB, C, E

Raw data is preserved, allowing re-transformation.

Why this answer

ELT leverages cloud scalability, allows raw data storage for flexibility, and enables schema-on-read.

Practice this question →
108
MCQeasy

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.Consistency
B.Completeness
C.Accuracy
D.Timeliness
AnswerA

Consistency ensures data is uniform across systems.

Why this answer

The data analyst is primarily concerned with consistency, which ensures that the same data values are represented uniformly across different systems or databases. In this scenario, the customer's address must follow the same format (e.g., street, city, state, ZIP code) in every database to enable reliable merging and querying. Consistency is a key data quality dimension that focuses on cross-system uniformity, distinct from accuracy (correctness of values) or completeness (presence of all required fields).

Exam trap

The trap here is that candidates often confuse consistency with accuracy, thinking that if the address is correct (accurate), it must be consistent, but consistency is about format uniformity across systems, not the truthfulness of the data.

How to eliminate wrong answers

Option B (Completeness) is wrong because completeness measures whether all required data fields are present, not whether the data is formatted uniformly across databases. Option C (Accuracy) is wrong because accuracy refers to the correctness of the data values relative to the real-world entity, not the format or representation. Option D (Timeliness) is wrong because timeliness concerns whether the data is up-to-date and available when needed, not the consistency of its format across systems.

Practice this question →
109
MCQmedium

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

A.Instance
B.Entity
C.Attribute
D.Record
AnswerC

Correct. Name is an attribute of the customer entity.

Why this answer

In the context of a relational database, a column represents an attribute of an entity. The 'Name' column stores a specific characteristic (the customer's name) for each row, making it an attribute. This aligns with the data modeling concept where attributes define the properties of an entity.

Exam trap

The trap here is that candidates confuse 'attribute' with 'record' because they think of a row as containing all attributes, but the question specifically asks what a single column represents, not the row itself.

How to eliminate wrong answers

Option A is wrong because an instance refers to a single occurrence of an entity (e.g., a specific customer row), not a column. Option B is wrong because an entity is a table-level concept representing a real-world object (e.g., the Customer table), not a column within it. Option D is wrong because a record is a row in the table, which contains values for all attributes, not a single column like 'Name'.

Practice this question →
110
MCQeasy

Refer to the exhibit. A data pipeline is failing to parse this log entry. What is the most likely cause of the error?

A.Missing comma between fields
B.Incorrect data type for age
C.Extra whitespace
D.Unquoted string for country
AnswerD

The country value 'United States' contains a space and is not quoted. In a space-delimited file, such values must be quoted to prevent the space from being interpreted as a delimiter. This causes the parser to fail.

Why this answer

The log entry uses space as a delimiter. The country field 'United States' contains a space but is not enclosed in quotes. When parsing, the space within the value is misinterpreted as a delimiter, causing the parser to split the field incorrectly.

This results in a parsing failure. The unquoted string containing a space is the most direct cause of the error.

Exam trap

Candidates often assume that missing or inconsistent delimiters cause parsing failures, but in this case, the delimiter is consistent (space). The trap is that they may overlook the need to quote fields containing the delimiter character itself.

How to eliminate wrong answers

Option B is wrong because the age field '30' is a valid integer and would parse correctly if the fields were properly delimited; the error is not due to data type mismatch. Option C is wrong because extra whitespace is not the issue—the spaces are part of the intended delimiter or the country value, and the parser is failing due to the lack of a comma, not due to excessive whitespace. Option D is wrong because the country 'United States' is not unquoted in a way that causes the error; the core problem is the missing comma between fields, not the lack of quotes around the string.

Practice this question →
111
Multi-Selectmedium

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

Select 3 answers
A.Consistency
B.Completeness
C.Accuracy
D.Velocity
E.Volume
AnswersA, B, C

Data is uniform across systems.

Why this answer

Consistency is a common dimension of data quality because it ensures that data values are uniform across different datasets or systems, preventing contradictions. For example, if a customer's address is stored as '123 Main St' in one database and '123 Main Street' in another, consistency rules would flag this discrepancy. This dimension is critical for reliable reporting and integration.

Exam trap

The trap here is that candidates confuse the characteristics of big data (velocity, volume, variety) with the dimensions of data quality, leading them to select velocity or volume instead of the correct quality-focused options.

Practice this question →
112
MCQhard

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.Truncate the account_type values to 10 characters during ETL.
B.Change the data type of dim_account.account_type to TEXT.
C.Ignore the error and continue loading with NULL values for truncated rows.
D.Increase the VARCHAR length of dim_account.account_type to accommodate the longest account type.
AnswerD

This resolves truncation without data loss.

Why this answer

Increasing the VARCHAR length of dim_account.account_type to accommodate the longest account type (e.g., VARCHAR(15) for 'CheckingPremium') resolves the data truncation error without data loss. This aligns with the star schema design principle of preserving source data integrity while ensuring the column definition matches the actual data length. The team must avoid truncation or NULL insertion to maintain accurate dimensional attributes for analytics.

Exam trap

The trap here is that candidates may choose truncation (Option A) or NULL insertion (Option C) as quick fixes, overlooking the requirement to preserve data integrity, or mistakenly think TEXT (Option B) is a safe catch-all without considering performance implications in a data warehouse context.

How to eliminate wrong answers

Option A is wrong because truncating account_type values to 10 characters would lose data, violating the requirement to resolve the issue without data loss. Option B is wrong because changing the data type to TEXT is unnecessary and can introduce performance overhead in indexing and querying, as TEXT is a large object type not optimized for VARCHAR-like operations in a data warehouse. Option C is wrong because ignoring the error and loading NULL values for truncated rows would discard valid account_type data, breaking referential integrity and analytics accuracy.

Practice this question →
113
MCQmedium

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.Internal vs. External data
B.Primary vs. Secondary data
C.Structured vs. Unstructured data
D.Quantitative vs. Qualitative data
AnswerA

CRM data is internal; census data is external, directly contrasting sources.

Why this answer

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.

Exam trap

CompTIA often tests the Internal vs. External data concept by presenting a scenario where the key differentiator is the data's source (inside vs. outside the organization), tempting candidates to confuse it with Primary vs. Secondary data, which focuses on whether the data was collected firsthand or repurposed.

How to eliminate wrong answers

Option B (Primary vs. Secondary data) is wrong because both datasets could be primary (collected firsthand by the CRM or census) or secondary (repurposed from another source), but the question focuses on the origin relative to the organization, not the collection method. Option C (Structured vs.

Unstructured data) is wrong because both CRM sales data and census demographic data are typically structured (e.g., tables with rows and columns), so the contrast is not about format but about source. Option D (Quantitative vs. Qualitative data) is wrong because both datasets contain quantitative values (e.g., sales figures, population counts) and possibly qualitative labels (e.g., region names), but the core distinction in the scenario is internal versus external sourcing, not measurement scale.

Practice this question →
114
MCQmedium

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.Unique constraint
B.Primary key
C.Check constraint
D.Foreign key
AnswerD

Foreign key enforces referential integrity.

Why this answer

A foreign key constraint ensures referential integrity by requiring that values in a column match values in the primary key of another table.

Practice this question →
115
MCQhard

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.No violation
B.Third normal form (3NF)
C.Second normal form (2NF)
D.First normal form (1NF)
AnswerD

Repeating groups violate 1NF.

Why this answer

The table violates First Normal Form (1NF) because it contains repeating groups (Product1, Product1Qty, Product2, Product2Qty) instead of storing each product in a separate row. 1NF requires that each column contains atomic values and that there are no repeating groups or arrays. The presence of multiple product columns for a single order breaks this atomicity and normalization rule.

Exam trap

The trap here is that candidates often think the table is already in 1NF because it has a primary key (OrderID), but they overlook the repeating group columns that violate the atomicity requirement of 1NF.

How to eliminate wrong answers

Option A is wrong because the table clearly violates normalization rules due to repeating groups, so a violation exists. Option B is wrong because Third Normal Form (3NF) requires that the table already be in 2NF and have no transitive dependencies; the immediate violation is at the 1NF level, not 3NF. Option C is wrong because Second Normal Form (2NF) requires that the table first satisfy 1NF and then have no partial dependencies; since the table fails 1NF, it cannot be evaluated for 2NF.

Practice this question →
116
MCQhard

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 sorting with ORDER BY
B.Data joining with INNER JOIN
C.Data aggregation with filtering on aggregated values
D.Data filtering on row-level conditions
AnswerC

HAVING filters after GROUP BY, operating on aggregated results.

Why this answer

HAVING filters groups after aggregation, unlike WHERE which filters rows before aggregation. This demonstrates data aggregation with filtering on aggregated values.

Practice this question →
117
Multi-Selectmedium

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

Select 2 answers
A.Set data retention limits with automated deletion
B.Use data compression
C.Increase primary storage capacity
D.Implement data deduplication
E.Archive historical data to tape or cloud archive
AnswersA, E

Ensures data is deleted after a defined period, complying with legal requirements.

Why this answer

Archiving old data to cheaper storage reduces primary storage costs, and setting retention limits ensures data is deleted when no longer needed, balancing cost and compliance.

Practice this question →
118
MCQeasy

A retail company is merging customer data from three separate systems: an e-commerce platform, a point-of-sale (POS) system, and a loyalty program. The e-commerce platform stores customer names in "FirstName LastName" format, the POS system stores names as "LastName, FirstName", and the loyalty program stores names in separate "first_name" and "last_name" fields. The data analyst needs to create a unified customer master table. After initial merging, there are 20% more records than expected, including duplicates with slight name variations (e.g., "John Smith" vs "John A. Smith"). To ensure accurate consolidation, which data concept should the analyst prioritize applying first?

A.Data profiling
B.Data standardization
C.Data indexing
D.Data encryption
AnswerB

Standardizing name formats to a common convention reduces variations and allows accurate matching and deduplication.

Why this answer

Data standardization is the correct first step because it resolves the inconsistent name formats (e.g., 'FirstName LastName', 'LastName, FirstName', and separate fields) into a single, consistent representation. By applying a standardized format (e.g., 'FirstName LastName'), the analyst can then accurately identify and merge duplicates like 'John Smith' and 'John A. Smith' using fuzzy matching or exact matching on the standardized values.

This ensures the unified customer master table has the correct number of records without the 20% inflation caused by formatting variations.

Exam trap

The trap here is that candidates confuse data profiling (which only identifies issues) with data standardization (which actively resolves format inconsistencies), leading them to choose A instead of B, even though profiling alone cannot fix the duplicate records caused by name variations.

How to eliminate wrong answers

Option A is wrong because data profiling is an exploratory process that assesses data quality and structure (e.g., detecting nulls, patterns, or anomalies), but it does not transform or resolve the inconsistent name formats that cause duplicate records. Option C is wrong because data indexing improves query performance by creating sorted structures (e.g., B-trees or hash indexes) on columns, but it does not address the underlying data inconsistency or deduplication needed for accurate consolidation. Option D is wrong because data encryption protects data at rest or in transit (e.g., using AES-256 or TLS 1.3), but it has no role in standardizing name formats or removing duplicates from merged datasets.

Practice this question →
119
MCQmedium

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.Transactional database
B.Streaming data
C.Web scraping
D.Flat file
AnswerB

IoT sensors produce streaming data that is continuous and requires real-time processing.

Why this answer

B is correct because the scenario describes data arriving continuously in small batches that must be processed in real-time for monitoring. This is the defining characteristic of streaming data, which is typically ingested via technologies like Apache Kafka, Amazon Kinesis, or MQTT brokers, enabling low-latency processing and immediate alerting.

Exam trap

The trap here is that candidates may confuse 'real-time' with 'fast batch processing' and incorrectly choose a transactional database, not recognizing that streaming data sources are specifically designed for continuous, unbounded data flows with sub-second latency requirements.

How to eliminate wrong answers

Option A is wrong because a transactional database (e.g., PostgreSQL, MySQL) is designed for ACID-compliant, query-based storage and retrieval, not for continuous real-time ingestion of sensor data; it would introduce latency and cannot handle unbounded streams efficiently. Option C is wrong because web scraping is a technique for extracting data from web pages via HTTP requests (e.g., using BeautifulSoup or Scrapy), which is batch-oriented and not suited for real-time IoT sensor data. Option D is wrong because a flat file (e.g., CSV, JSON file) is a static storage format that requires manual or scheduled batch loads, making it incapable of supporting real-time processing or continuous ingestion.

Practice this question →
120
Multi-Selecthard

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

Select 3 answers
A.Using a placeholder like 'Unknown' for categorical data
B.Ignoring missing values and proceeding with analysis
C.Replacing missing values with the mean of the column
D.Sorting the data to bring missing values to the top
E.Deleting rows with missing values
AnswersA, C, E

Placeholder is a valid approach.

Why this answer

Using a placeholder like 'Unknown' for categorical missing data preserves the dataset's structure and allows analysis to proceed without introducing statistical bias. This method is particularly valid for nominal data where the missing category can be treated as a distinct value, enabling downstream operations like one-hot encoding or frequency analysis without distorting the original distribution.

Exam trap

The trap here is that candidates may confuse 'handling missing data' with 'preprocessing steps'—sorting (Option D) is a data organization technique, not a valid method for dealing with missing values, and ignoring missing data (Option B) is often mistakenly considered acceptable in quick analyses, but it violates best practices for robust data science workflows.

Practice this question →
121
MCQeasy

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.Relational database
B.Data lake
C.Data mart
D.Data warehouse
AnswerB

Data lakes store raw data in native format.

Why this answer

A data lake is designed to store raw data in its native format, including unstructured and semi-structured data from IoT sensors, without requiring a predefined schema. This allows the organization to preserve the original data for future analysis, unlike traditional databases that enforce structure upon ingestion.

Exam trap

The trap here is that candidates often confuse a data warehouse with a data lake, assuming both are for storage, but a data warehouse requires ETL and structured schemas, making it unsuitable for raw, native-format IoT data.

How to eliminate wrong answers

Option A is wrong because a relational database requires a predefined schema and is optimized for structured data, not raw, native-format IoT sensor data. Option C is wrong because a data mart is a subset of a data warehouse focused on a specific business domain, not designed for storing raw, unprocessed data. Option D is wrong because a data warehouse stores processed, structured, and transformed data for analytical queries, not raw data in its native format.

Practice this question →
122
MCQeasy

Which of the following is an example of unstructured data?

A.A JSON file
B.An image file
C.A relational database table
D.A CSV file with rows and columns
AnswerB

Images are unstructured.

Why this answer

Unstructured data has no predefined schema. Images are a classic example of unstructured data.

Practice this question →
123
MCQmedium

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
B.Data custodian
C.Data owner
D.Data steward
AnswerC

Data owner is accountable for a specific data domain.

Why this answer

The data owner is the senior manager accountable for a specific data asset, including its quality, definition, and compliance. In the DA0-001 context, the data owner has ultimate responsibility for the data, not just day-to-day management. This role ensures consistent definitions and quality across the organization, aligning with the governance team's objectives.

Exam trap

The trap here is confusing the data owner's accountability with the data steward's operational duties, leading candidates to pick 'Data steward' because they associate governance with hands-on management rather than executive responsibility.

How to eliminate wrong answers

Option A is wrong because a data analyst focuses on analyzing and interpreting data, not on accountability for data definitions or quality. Option B is wrong because a data custodian is responsible for the technical environment and security of data, not for defining or governing its meaning. Option D is wrong because a data steward handles day-to-day data governance tasks like metadata management and quality monitoring, but does not hold the ultimate accountability that a senior manager does.

Practice this question →
124
MCQhard

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.Partition the table by OrderDate
B.Convert TotalAmount to VARCHAR
C.Add a composite index on (CustomerID, OrderDate)
D.Remove the primary key constraint
AnswerC

A composite index can satisfy both conditions in one index seek.

Why this answer

A composite index on (CustomerID, OrderDate) allows the database to use a single index to filter on both columns, which is more efficient than using separate indexes and combining results.

Practice this question →
125
MCQmedium

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?

A.Consistency
B.Accuracy
C.Timeliness
D.Completeness
AnswerB

Accuracy is compromised because values outside valid ranges are incorrect.

Why this answer

Accuracy measures how well data reflects real-world values or a defined standard. Here, 20% of completed fields contain values outside valid ranges, meaning the data is present but incorrect, directly degrading accuracy. Completeness (95% filled) is high, but the core issue is that the values themselves are wrong, not missing or late.

Exam trap

The trap here is that candidates see '95% of records have all required fields completed' and immediately think 'Completeness is high, so that dimension is fine,' but then incorrectly assume the 20% out-of-range values also affect Completeness, when in fact Accuracy is the dimension that suffers when present data is invalid.

How to eliminate wrong answers

Option A (Consistency) is wrong because consistency checks for logical coherence across datasets or over time (e.g., same customer ID format in two tables), not whether individual field values fall within valid ranges. Option C (Timeliness) is wrong because timeliness concerns whether data is available when needed or within a required time window, not the correctness of values. Option D (Completeness) is wrong because completeness measures the presence of data (95% of records have all required fields), which is high; the problem is with the quality of the present data, not its absence.

Practice this question →
126
Multi-Selecthard

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

Select 2 answers
A.Allowing null values for foreign keys
B.Standardizing date formats across all tables
C.Implementing referential integrity constraints
D.Enabling cascading updates on primary keys
E.Using data profiling to identify duplicate records
AnswersB, C

Correct: Uniform formats ensure consistency in temporal data.

Why this answer

Standardizing date formats across all tables (Option B) ensures that date values are stored and interpreted uniformly, eliminating inconsistencies that arise from mixed formats (e.g., MM/DD/YYYY vs. DD-MM-YY). This practice directly supports data consistency by enforcing a single representation, which is critical for accurate querying, reporting, and integration across systems.

Exam trap

CompTIA often tests the distinction between data quality dimensions (e.g., consistency vs. accuracy), leading candidates to confuse data profiling (which identifies duplicates) with a direct method for enforcing consistency.

Practice this question →
127
MCQhard

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.Data stewardship
B.Data ownership
C.Data quality management
D.Master data management
AnswerC

Data quality management is responsible for defining and enforcing quality rules.

Why this answer

Data quality management is the function that sets standards and processes to ensure data is accurate, complete, and consistent. Data stewardship often involves implementing these rules, but the overall responsibility lies with data quality management.

Practice this question →
128
Multi-Selectmedium

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?

Select 2 answers
A.Limited API rate limits
B.Legal and ethical restrictions
C.Website structure changes
D.High latency of data transfer
E.Inconsistent data formatting
AnswersB, C

Many websites prohibit scraping in their terms of service, and legal issues may arise.

Why this answer

Web scraping often involves accessing data that may be protected by copyright, terms of service, or privacy regulations such as GDPR or the Computer Fraud and Abuse Act (CFAA). Even if data is publicly accessible, repurposing it for market research without permission can lead to legal liability or ethical violations, making this a fundamental challenge.

Exam trap

CompTIA Data+ often tests the distinction between API-related challenges (rate limits, authentication) and web-scraping-specific challenges (structure changes, legal/ethical issues), so candidates mistakenly select 'Limited API rate limits' because they confuse web scraping with API consumption.

Practice this question →
129
MCQhard

Refer to the exhibit. Which conclusion can be drawn from this data quality report?

A.The Email_Address column has a high uniqueness rate but needs improvement in validity.
B.The column is fully consistent but has low completeness.
C.The column has low validity and low uniqueness.
D.The column requires immediate action to improve completeness.
AnswerA

Uniqueness is 97%, but validity is only 85%, meaning some emails may be in invalid format.

Why this answer

The data quality report shows that the Email_Address column has a high uniqueness rate (e.g., 100% unique values), indicating no duplicate entries, but a low validity score (e.g., many entries fail format checks like missing '@' or domain). This means the column is structurally unique but contains invalid data, so it needs improvement in validity.

Exam trap

CompTIA often tests the distinction between uniqueness and validity, trapping candidates who assume high uniqueness implies high quality, when in fact validity is a separate dimension that can be poor even with perfect uniqueness.

How to eliminate wrong answers

Option B is wrong because the report indicates low validity, not full consistency; consistency refers to adherence to a standard format, which is violated here. Option C is wrong because the report shows high uniqueness (not low uniqueness), so the claim of 'low uniqueness' is factually incorrect. Option D is wrong because completeness (non-null values) appears high or acceptable; the issue is with validity, not missing data.

Practice this question →
130
MCQmedium

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

A.Qualitative
B.Continuous
C.Quantitative
D.Discrete
AnswerA

Correct. Region is a descriptive category.

Why this answer

The field 'region' contains categorical labels (e.g., 'North', 'South', 'East', 'West') that represent distinct groups or categories, not numerical measurements. Qualitative data (also called categorical data) describes attributes or characteristics that can be named but not meaningfully ordered or measured on a numeric scale. Since 'region' assigns a name to a geographic area without any inherent numeric value or order, it is a classic example of qualitative data.

Exam trap

The trap here is that candidates may confuse 'region' with a numeric code (e.g., region ID 1, 2, 3) and incorrectly classify it as discrete quantitative data, but the field 'region' as shown contains text labels, making it qualitative.

How to eliminate wrong answers

Option B is wrong because continuous data represents measurements that can take any value within a range (e.g., temperature, time), but 'region' consists of discrete labels with no numeric continuum. Option C is wrong because quantitative data involves numerical values that can be counted or measured (e.g., sales amount, age), whereas 'region' is a non-numeric category. Option D is wrong because discrete data is a subset of quantitative data that takes countable integer values (e.g., number of customers), but 'region' is not numeric at all.

Practice this question →
131
Multi-Selectmedium

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

Select 2 answers
A.XML document
B.JSON object
C.Relational table
D.Plain text file
E.CSV file
AnswersA, B

XML uses tags and has flexible schema, semi-structured.

Why this answer

XML and JSON have tags/keys but no rigid schema, making them semi-structured. CSV is structured, relational tables are structured, plain text is unstructured.

Practice this question →
132
MCQeasy

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

A.Archival
B.Processing
C.Ingestion
D.Storage
AnswerB

Processing includes cleaning and transforming raw data.

Why this answer

Processing is the stage where raw data is transformed into a usable format through cleaning, validation, normalization, or aggregation. This step ensures data quality and consistency before analysis or storage, directly matching the question's description.

Exam trap

The trap here is confusing ingestion (data arrival) with processing (data transformation), as both occur early in the lifecycle but serve distinct purposes.

How to eliminate wrong answers

Option A is wrong because archival refers to moving data to long-term storage for compliance or historical purposes, not cleaning or validating. Option C is wrong because ingestion is the initial capture or import of raw data from sources, not its transformation. Option D is wrong because storage is the persistent retention of data in databases or filesystems, not the conversion into a usable format.

Practice this question →
133
MCQmedium

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.Data archival
B.Data sharing
C.Data deletion
D.Data ingestion
AnswerD

Ingestion is the initial step of bringing data from a source.

Why this answer

Ingestion is the process of bringing data into a system for further processing.

Practice this question →
134
MCQeasy

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

A.Patient
B.Visit
C.Day
D.Hospital
AnswerB

Correct. Each record captures one visit.

Why this answer

The level of granularity refers to the finest detail captured in the dataset. Since the data contains daily patient visits, each record represents a single visit event, not the patient or the day itself. Therefore, 'Visit' is the correct granularity because each row corresponds to one visit occurrence.

Exam trap

The trap here is confusing the subject of analysis (patient readmission rates) with the actual data granularity (each row is a visit), leading candidates to incorrectly select 'Patient' instead of 'Visit'.

How to eliminate wrong answers

Option A is wrong because 'Patient' would be the granularity if the data summarized all visits per patient (e.g., one row per patient with aggregated readmission counts), but here each visit is a separate record. Option C is wrong because 'Day' would be the granularity if the data aggregated all visits per day (e.g., total visits per day), but the data contains individual visit records, not daily summaries. Option D is wrong because 'Hospital' would be the granularity if the data aggregated across the entire hospital (e.g., total readmission rate for the hospital), but the data is at the individual visit level.

Practice this question →
135
MCQmedium

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.The database uses a star schema while the warehouse uses a normalized schema.
B.The database enforces ACID transactions, while the warehouse uses eventual consistency.
C.The database is optimized for write-heavy OLTP, while the warehouse is optimized for read-heavy OLAP.
D.The database stores only current data, while the warehouse stores historical data.
AnswerC

Correct: OLTP supports many writes; OLAP supports complex reads.

Why this answer

OLTP databases are optimized for high-frequency write operations (INSERT/UPDATE/DELETE) and ACID compliance, making them ideal for transaction processing but poor for complex analytical queries. In contrast, a data warehouse is optimized for read-heavy OLAP workloads, using columnar storage, pre-aggregated tables, and indexing strategies that enable fast aggregation and trend analysis over large historical datasets. This architectural difference directly supports the retail company's need to analyze purchase trends over time.

Exam trap

CompTIA often tests the misconception that 'data warehouses only store historical data' (Option D) as the primary reason for trend analysis suitability, but the real differentiator is the workload optimization (OLTP vs. OLAP), not merely the presence of history.

How to eliminate wrong answers

Option A is wrong because a star schema (with fact and dimension tables) is actually typical of data warehouses for analytical queries, while OLTP databases usually use normalized schemas to reduce redundancy and maintain data integrity. Option B is wrong because data warehouses often support ACID or snapshot isolation for consistency, and eventual consistency is more characteristic of NoSQL systems, not traditional data warehouses. Option D is wrong because relational databases can store historical data as well; the key difference is not the presence of history but the optimization for read-heavy analytical queries versus write-heavy transactional processing.

Practice this question →
136
MCQhard

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.Data lake
B.Data mart
C.Data warehouse
D.Relational database
AnswerA

Data lakes store raw data in any format and allow schema-on-read.

Why this answer

A data lake stores raw data in its native format (e.g., S3, ADLS) without requiring a predefined schema, making it suitable for IoT data.

Practice this question →
137
MCQmedium

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.Isolation
B.Durability
C.Atomicity
D.Consistency
AnswerC

Atomicity ensures all operations in a transaction complete or none do.

Why this answer

Atomicity guarantees that a transaction is treated as a single unit, completed entirely or not at all.

Practice this question →
138
MCQeasy

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.Nominal
B.Quantitative
C.Ordinal
D.Discrete
AnswerA

Nominal is categorical without order.

Why this answer

Customer names are categorical labels that identify individuals without any inherent order or numerical value. This fits the definition of nominal data, which is used for naming or classifying variables. In data analysis, nominal data can be stored as strings and used for grouping or filtering, but arithmetic operations are meaningless.

Exam trap

CompTIA often tests the distinction between nominal and ordinal data by presenting a label that could be mistaken for having an order (e.g., 'customer name' might be confused with 'rank' or 'tier'), but the trap here is that names are purely categorical with no intrinsic ranking.

How to eliminate wrong answers

Option B is wrong because quantitative data represents numerical measurements or counts (e.g., purchase amount), not text labels like names. Option C is wrong because ordinal data has a meaningful order or rank (e.g., customer satisfaction rating), but customer names have no inherent sequence. Option D is wrong because discrete data consists of countable numerical values (e.g., number of purchases), whereas customer names are non-numeric categories.

Practice this question →
139
Multi-Selecthard

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

Select 2 answers
A.Faster data processing speed
B.Increased data volume
C.Improved data quality and consistency
D.Lower storage costs
E.Reduced data redundancy
AnswersC, E

Governance establishes standards that enhance quality and consistency.

Why this answer

A primary benefit of a data governance program is improved data quality and consistency. Data governance establishes policies, standards, and procedures for data management, ensuring that data is accurate, complete, and reliable across the organization. This directly enhances decision-making and operational efficiency by reducing errors and inconsistencies in data assets.

Exam trap

The trap here is that candidates may confuse data governance with data management or data engineering tasks, mistakenly thinking it directly improves performance or reduces costs, when its core value is in quality, consistency, and compliance.

Practice this question →
140
MCQeasy

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

A.Uniqueness
B.Completeness
C.Timeliness
D.Accuracy
AnswerB

Correct. The salary field is missing, so data is incomplete.

Why this answer

Completeness measures whether all required data is present. Charlie's missing salary value means the record is incomplete, directly violating this dimension. In data quality frameworks, completeness is assessed by the proportion of non-null values in a field, and a null salary here fails that check.

Exam trap

CompTIA often tests the distinction between 'missing' (completeness) and 'wrong' (accuracy), leading candidates to confuse a null value with an incorrect value.

How to eliminate wrong answers

Option A is wrong because uniqueness refers to the absence of duplicate records or values, not missing data; a missing salary does not create a duplicate. Option C is wrong because timeliness concerns whether data is up-to-date or available when needed, not whether a value is present or absent. Option D is wrong because accuracy measures correctness of values against a reference source; a missing value is not an inaccurate value—it is an absent one.

Practice this question →
141
Multi-Selectmedium

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

Select 3 answers
A.Easily queried using SQL
B.Often stored in NoSQL databases or data lakes
C.Can include text, images, and video
D.Stored in relational tables
E.Lacks a predefined schema
AnswersB, C, E

NoSQL and data lakes are designed to store unstructured data at scale.

Why this answer

Options B, C, and E are correct. Unstructured data lacks a predefined schema, can include various media types, and is often stored in NoSQL or data lakes. A is wrong because unstructured data is not stored in relational tables.

D is wrong because SQL queries are not designed for unstructured data.

Practice this question →
142
MCQhard

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 governance
B.Data warehousing
C.Data quality
D.Master Data Management (MDM)
AnswerD

MDM focuses on creating a single, consistent view of master data entities like customers.

Why this answer

Master Data Management (MDM) is the discipline that creates a single authoritative view of customer data by identifying and merging duplicate records across systems. Option A is incorrect because Data governance focuses on policies and standards, not directly on merging records. Option B is incorrect because Data warehousing consolidates data for reporting and analysis, not for creating a golden record of master data.

Option C is incorrect because Data quality ensures accuracy and consistency but is a component of MDM, not the specific discipline for managing master data.

Practice this question →
143
MCQmedium

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

A.OrderDate
B.OrderID
C.TotalAmount
D.CustomerID
AnswerB

OrderID is unique per order.

Why this answer

The OrderID column is the correct choice for the primary key because it contains unique values for each order, ensuring that each row can be uniquely identified. A primary key must be unique, non-null, and stable; OrderID satisfies all these requirements, whereas the other columns do not guarantee uniqueness or are subject to change.

Exam trap

The trap here is that candidates may confuse a column that is frequently used for filtering or grouping (like CustomerID or OrderDate) with one that guarantees uniqueness, overlooking the fundamental primary key requirement of uniqueness and non-nullability.

How to eliminate wrong answers

Option A is wrong because OrderDate is not unique; multiple orders can occur on the same date, and it can also be null, violating primary key constraints. Option C is wrong because TotalAmount can have duplicate values (e.g., two orders with the same total) and is not inherently unique or stable. Option D is wrong because CustomerID is not unique per order; a single customer can place many orders, so it cannot uniquely identify each order row.

Practice this question →
144
Multi-Selecteasy

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

Select 2 answers
A.Normalizing data to eliminate redundancy
B.Creating a backup of the database
C.Converting string dates to date format
D.Generating summary statistics
E.Removing duplicate records
AnswersA, C

Normalization is a transformation.

Why this answer

Data normalization is a transformation process that reorganizes data to reduce redundancy and improve integrity, typically by decomposing tables into smaller, related tables (e.g., achieving 3NF in relational databases). This changes the structure and representation of the data, which is a core example of data transformation.

Exam trap

CompTIA often tests the distinction between data transformation (changing format/structure) and data cleansing (removing errors/duplicates) or data analysis (generating summaries), leading candidates to mistakenly select removal of duplicates or summary statistics as transformations.

Practice this question →
145
MCQmedium

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.Duplication
B.Incompleteness
C.Outliers
D.Inconsistency
AnswerB

Missing state codes make the record incomplete.

Why this answer

Incompleteness is the correct answer because missing state codes in customer address records represent a lack of required data. This is a classic example of incomplete data, where fields that should contain values are left null or blank, reducing the dataset's usability for analysis.

Exam trap

The trap here is that candidates may confuse incompleteness with inconsistency, but incompleteness is about missing data (nulls), while inconsistency is about contradictory data across records.

How to eliminate wrong answers

Option A is wrong because duplication refers to duplicate records (e.g., same customer appearing multiple times), not missing values. Option C is wrong because outliers are data points that deviate significantly from the norm (e.g., an unusually high age), not absent data. Option D is wrong because inconsistency involves contradictory or conflicting data (e.g., same customer with different state codes in different records), not missing values.

Practice this question →
146
MCQmedium

A telecommunications company is experiencing issues with its customer satisfaction survey data. The data is collected from multiple channels: phone, email, and web forms. Each channel uses a different scale for ratings: phone uses 1-10, email uses 1-5, and web uses 1-7. Additionally, some survey responses contain missing values for demographic fields. The data analyst needs to calculate an overall satisfaction score that is comparable across all channels. The company's leadership wants a single metric that minimizes distortion from the different scales. Which approach should the analyst use to standardize the ratings?

A.Normalize each rating to a 0-100 scale using min-max normalization.
B.Calculate the average rating separately for each channel and then compare the averages.
C.Convert all ratings to a binary metric of satisfied (above midpoint) or unsatisfied.
D.Convert all ratings to a 1-10 scale by multiplying email ratings by 2 and web by 1.43.
AnswerA

Correct: Min-max normalization maps each scale to a common range, preserving relative differences.

Why this answer

Min-max normalization rescales each rating to a common 0-100 range using the formula (x - min) / (max - min) * 100. This preserves the relative distribution of responses within each channel while eliminating the effect of different scale lengths, making the scores directly comparable. It minimizes distortion better than simple multiplication or binary conversion, as it accounts for the full range of each original scale.

Exam trap

The trap here is that candidates may think simple multiplication (Option D) is sufficient for scale conversion, but the understanding that linear scaling without considering the full range and distribution can introduce distortion is key, whereas min-max normalization is the proper technique for creating a comparable metric across different scales.

How to eliminate wrong answers

Option B is wrong because calculating separate averages per channel does not standardize the ratings; it only produces channel-specific means that remain on different scales, making direct comparison invalid. Option C is wrong because converting to a binary satisfied/unsatisfied metric discards granularity and loses information about the degree of satisfaction, which can distort the overall score and reduce statistical power. Option D is wrong because multiplying email ratings by 2 and web by 1.43 assumes linear proportionality between scales, which is arbitrary and does not account for differences in distribution shape or endpoints, potentially introducing systematic bias.

Practice this question →
147
Multi-Selectmedium

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

Select 2 answers
A.Product color
B.Age in years
C.Customer satisfaction rating (Poor, Fair, Good)
D.Country of origin
E.Shoe size
AnswersB, E

Age is a numeric, quantitative variable.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse ordinal data (like customer satisfaction ratings) with quantitative data because the categories have an order, but they are still qualitative since the values are not numeric measurements.

Practice this question →
148
MCQhard

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?

A.Ingest into a relational database with a predefined schema
B.Store each JSON object as a separate file in a compressed columnar format
C.Convert all JSON to Avro with a fixed schema before storing
D.Store raw JSON files in a distributed file system and apply schema-on-read
AnswerD

Schema-on-read allows handling varying schemas without upfront transformation.

Why this answer

A data lake is designed to store raw data in its native format, and IoT sensor data with varying schemas is best handled by storing raw JSON files in a distributed file system (e.g., HDFS or Amazon S3). This approach leverages schema-on-read, where the schema is applied at query time rather than at write time, allowing flexibility for heterogeneous JSON objects without data loss or transformation overhead.

Exam trap

The trap here is that candidates confuse 'schema-on-read' with 'schema-on-write' and assume that converting to a structured format like Avro or columnar storage is always better for performance, ignoring the requirement to store raw, varying-schema data as-is.

How to eliminate wrong answers

Option A is wrong because relational databases require a predefined schema and enforce ACID constraints, which cannot accommodate JSON objects with varying schemas without costly schema migrations or data loss. Option B is wrong because storing each JSON object as a separate file in a compressed columnar format (e.g., Parquet or ORC) is inefficient for small, variable-schema records; columnar formats are optimized for analytical queries on large, homogeneous datasets, not for raw ingestion of many small, schema-varying JSON objects. Option C is wrong because converting all JSON to Avro with a fixed schema before storing defeats the purpose of a data lake, which is to preserve raw data; Avro requires a predefined schema at write time, and forcing a fixed schema on varying JSON objects would either lose data or require complex schema evolution management.

Practice this question →
149
MCQmedium

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.RIGHT JOIN
B.INNER JOIN
C.FULL OUTER JOIN
D.LEFT JOIN
AnswerB

INNER JOIN returns only matching rows.

Why this answer

INNER JOIN returns only rows with matching values in both tables, which matches the requirement.

Practice this question →
150
MCQmedium

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.Binary data
B.Structured data
C.Semi-structured data
D.Unstructured data
AnswerC

JSON allows schema flexibility with key-value pairs, fitting the semi-structured definition.

Why this answer

JSON data with varying fields is classified as semi-structured data because it has organizational properties (key-value pairs, nested structures) but does not conform to a rigid schema like a relational table. The logs from web servers may have different fields per record, which is a hallmark of semi-structured data, as it allows flexibility while still being self-describing.

Exam trap

The trap here is that candidates confuse 'structured' with any data that has a format, but JSON's lack of a fixed schema and varying fields disqualifies it from being structured data, which requires a rigid, predefined schema like a relational database table.

How to eliminate wrong answers

Option A is wrong because binary data refers to raw bytes or encoded formats (e.g., images, executables) that lack any inherent structure or human-readable format, whereas JSON is text-based and has explicit key-value organization. Option B is wrong because structured data requires a fixed schema with predefined fields and data types (e.g., rows in a SQL table), but JSON logs with varying fields violate this strict schema requirement. Option D is wrong because unstructured data has no predefined format or organization (e.g., plain text, video files), while JSON has a defined syntax with keys, values, and nesting, providing a clear structure.

Practice this question →
← PreviousPage 2 of 3 · 186 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Data Concepts and Environments questions.

Start 20-question session