COMPTIA DATA+ EXAMINATION TEST Q&A:
2026 STUDY GUIDE QUESTIONS AND
SOLUTIONS 100% CORRECT
◍ Field names and data types. Answer: What are the two main
components of a table design?
◍ Non-relational or NoSQL. Answer: Which type of database stores
data in a document format and uses XML or JSON?
◍ SQL. Answer: What is the language used for relational databases?
◍ Non-relational database (NoSQL). Answer: Which type of database
provides the most scalable and flexible options for web-based clients?
◍ One-to-many cardinality. Answer: A library database uses a book
table to store the information for each book in a record. The designer
used the primary key in the book table to identify the book in the
library loan and the library hold tables. What type of cardinality does
this represent?
◍ Normalize data
Create primary keys. Answer: A database designer is creating a
relational database. What must the designer do before establishing
,relationships between the data in different tables? (Select all that
apply.)
◍ Column-oriented. Answer: A database administrator is creating a
database that will record customer orders. Which of the following
non-relational database types will the administrator create to calculate
the total number of orders taken in a day?
◍ uses primary and foreign keys. Answer: Which of the following is
NOT a characteristic of NoSQL databases?
◍ 2NF
The data is in the Second Normal Form (2NF) where related
information that is applicable to multiple tables will have its own
table and will be associated through the use of a foreign key.. Answer:
A customer service representative is looking at customer data on the
company's software program, which stores the data in multiple tables.
The customer information is in one table and the software interface
identifies them by their customer account number. The software also
uses codes, pulled from another table, to represent the different types
of customer charges. What form is this data in?
◍ Primary key. Answer: A database designer created a table to track
book information for a school library and used a unique identifier for
each book. What is the book identifier called?
, ◍ RBMS. Answer: A data analyst is using software to manage and
manipulate tabular schema. What is this referred to?
◍ The designer will need to establish relationships between data.
The analysts will use the database with an RDBMS.. Answer: A
database designer is reviewing a list of requirements for a new
database and has determined that the new database will be relational.
Which of the following requirements did the designer see on the list
that helped make this determination? (Select all that apply.)
◍ The company uses relational databases.. Answer: A data analyst
went on a job interview and discovered that SQL is a required skill for
the job. Based on this requirement, what does the analyst know about
the company?
◍ It is a referential integrity option.
It updates all foreign key records.. Answer: A database designer
applied the cascade update option to a foreign key. What is true about
this option? (Select all that apply.)
◍ Datamart. Answer: Which subset of a data warehouse holds data
that is relevant to a specific department?
◍ Datalake. Answer: What is the most flexible storage system for
holding large amounts of both structured and unstructured data?
2026 STUDY GUIDE QUESTIONS AND
SOLUTIONS 100% CORRECT
◍ Field names and data types. Answer: What are the two main
components of a table design?
◍ Non-relational or NoSQL. Answer: Which type of database stores
data in a document format and uses XML or JSON?
◍ SQL. Answer: What is the language used for relational databases?
◍ Non-relational database (NoSQL). Answer: Which type of database
provides the most scalable and flexible options for web-based clients?
◍ One-to-many cardinality. Answer: A library database uses a book
table to store the information for each book in a record. The designer
used the primary key in the book table to identify the book in the
library loan and the library hold tables. What type of cardinality does
this represent?
◍ Normalize data
Create primary keys. Answer: A database designer is creating a
relational database. What must the designer do before establishing
,relationships between the data in different tables? (Select all that
apply.)
◍ Column-oriented. Answer: A database administrator is creating a
database that will record customer orders. Which of the following
non-relational database types will the administrator create to calculate
the total number of orders taken in a day?
◍ uses primary and foreign keys. Answer: Which of the following is
NOT a characteristic of NoSQL databases?
◍ 2NF
The data is in the Second Normal Form (2NF) where related
information that is applicable to multiple tables will have its own
table and will be associated through the use of a foreign key.. Answer:
A customer service representative is looking at customer data on the
company's software program, which stores the data in multiple tables.
The customer information is in one table and the software interface
identifies them by their customer account number. The software also
uses codes, pulled from another table, to represent the different types
of customer charges. What form is this data in?
◍ Primary key. Answer: A database designer created a table to track
book information for a school library and used a unique identifier for
each book. What is the book identifier called?
, ◍ RBMS. Answer: A data analyst is using software to manage and
manipulate tabular schema. What is this referred to?
◍ The designer will need to establish relationships between data.
The analysts will use the database with an RDBMS.. Answer: A
database designer is reviewing a list of requirements for a new
database and has determined that the new database will be relational.
Which of the following requirements did the designer see on the list
that helped make this determination? (Select all that apply.)
◍ The company uses relational databases.. Answer: A data analyst
went on a job interview and discovered that SQL is a required skill for
the job. Based on this requirement, what does the analyst know about
the company?
◍ It is a referential integrity option.
It updates all foreign key records.. Answer: A database designer
applied the cascade update option to a foreign key. What is true about
this option? (Select all that apply.)
◍ Datamart. Answer: Which subset of a data warehouse holds data
that is relevant to a specific department?
◍ Datalake. Answer: What is the most flexible storage system for
holding large amounts of both structured and unstructured data?
