WGU D492 Data Analytics – Applications | CompTIA
Data+ DA0-002 Certification Exam | Complete Study
Guide with 200+ Verified Questions & Answers |
2026/2027 Update | Graded A+
EXAM OVERVIEW
Component Details
Course WGU D492 Data Analytics – Applications
Certification CompTIA Data+ (DA0-002)
EXAM DOMAINS
Domain
1.0 Data Concepts and Environments
2.0 Data Acquisition and Preparation
3.0 Data Analysis
4.0 Visualization and Reporting
5.0 Data Governance
SECTION 1: DATA CONCEPTS AND ENVIRONMENTS Questions 1-45
,Question 1
Which of the following file types separates data using a delimiter?
A. XML
B. JSON
C. CSV
D. HTML
Correct Answer: C
Rationale: CSV (Comma-Separated Values) uses delimiters (typically commas) to
separate data fields . XML and HTML use tags to structure data, while JSON uses key-
value pairs and nested structures .
Question 2
Which data repository should a company use when structured data about the whole
company needs to be stored in a predefined data structure?
A. Data lake
B. Data warehouse
C. Data silo
D. Data mart
Correct Answer: B
Rationale: A data warehouse is designed to store structured data from across an entire
company in a predefined schema, optimized for analytics and reporting . A data lake
stores raw data without a predefined structure; a data mart stores data for a specific
business area; a data silo is isolated .
Question 3
Which of the following best describes semi-structured data gathered from web
scraping?
A. Data with a rigid schema like a relational database table
B. Data with some organizational structure but not as rigid as a relational table
,C. Data with no structure at all
D. Data that only exists in XML format
Correct Answer: B
Rationale: Semi-structured data has some organizational properties (like tags or key-
value pairs) but does not conform to a rigid schema . JSON is the most common semi-
structured format used in web scraping .
Question 4
Which data structure is used in a relational database to store data in rows and columns?
A. Key-value pair
B. Table
C. Nested structure
D. JSON object
Correct Answer: B
Rationale: Data structures in a database context include structured data types like
tables (fact tables, dimensional tables), schemas, and nested structures . Strings,
integers, and booleans are data types, not data structures .
Question 5
Which data type should be used to store geographic coordinates?
A. String
B. Numeric
C. Spatial
D. Boolean
Correct Answer: C
Rationale: The spatial data type is specifically designed to store geographic and
geometric data, such as coordinates, points, lines, and polygons . String, numeric, and
boolean types are not appropriate for spatial data.
, Question 6
What is the purpose of a BLOB (Binary Large Object) data type?
A. To store large text documents
B. To store binary data such as images or videos
C. To store date and time values
D. To store globally unique identifiers
Correct Answer: B
Rationale: BLOB (Binary Large Object) is used to store binary data like images, videos,
and other multimedia files . CLOB (Character Large Object) is used for large text data .
Question 7
What is a GUID (Globally Unique Identifier) used for?
A. To identify rows in a database table uniquely across all tables
B. To store geographic data
C. To encrypt data
D. To compress data
Correct Answer: A
Rationale: GUID (Globally Unique Identifier), also known as UUID, is a 128-bit value
used to uniquely identify rows in a database table, often as a primary key .
Question 8
Which of the following is an example of a data repository?
A. API
B. Data lakehouse
C. JSON
D. Python
Correct Answer: B
Data+ DA0-002 Certification Exam | Complete Study
Guide with 200+ Verified Questions & Answers |
2026/2027 Update | Graded A+
EXAM OVERVIEW
Component Details
Course WGU D492 Data Analytics – Applications
Certification CompTIA Data+ (DA0-002)
EXAM DOMAINS
Domain
1.0 Data Concepts and Environments
2.0 Data Acquisition and Preparation
3.0 Data Analysis
4.0 Visualization and Reporting
5.0 Data Governance
SECTION 1: DATA CONCEPTS AND ENVIRONMENTS Questions 1-45
,Question 1
Which of the following file types separates data using a delimiter?
A. XML
B. JSON
C. CSV
D. HTML
Correct Answer: C
Rationale: CSV (Comma-Separated Values) uses delimiters (typically commas) to
separate data fields . XML and HTML use tags to structure data, while JSON uses key-
value pairs and nested structures .
Question 2
Which data repository should a company use when structured data about the whole
company needs to be stored in a predefined data structure?
A. Data lake
B. Data warehouse
C. Data silo
D. Data mart
Correct Answer: B
Rationale: A data warehouse is designed to store structured data from across an entire
company in a predefined schema, optimized for analytics and reporting . A data lake
stores raw data without a predefined structure; a data mart stores data for a specific
business area; a data silo is isolated .
Question 3
Which of the following best describes semi-structured data gathered from web
scraping?
A. Data with a rigid schema like a relational database table
B. Data with some organizational structure but not as rigid as a relational table
,C. Data with no structure at all
D. Data that only exists in XML format
Correct Answer: B
Rationale: Semi-structured data has some organizational properties (like tags or key-
value pairs) but does not conform to a rigid schema . JSON is the most common semi-
structured format used in web scraping .
Question 4
Which data structure is used in a relational database to store data in rows and columns?
A. Key-value pair
B. Table
C. Nested structure
D. JSON object
Correct Answer: B
Rationale: Data structures in a database context include structured data types like
tables (fact tables, dimensional tables), schemas, and nested structures . Strings,
integers, and booleans are data types, not data structures .
Question 5
Which data type should be used to store geographic coordinates?
A. String
B. Numeric
C. Spatial
D. Boolean
Correct Answer: C
Rationale: The spatial data type is specifically designed to store geographic and
geometric data, such as coordinates, points, lines, and polygons . String, numeric, and
boolean types are not appropriate for spatial data.
, Question 6
What is the purpose of a BLOB (Binary Large Object) data type?
A. To store large text documents
B. To store binary data such as images or videos
C. To store date and time values
D. To store globally unique identifiers
Correct Answer: B
Rationale: BLOB (Binary Large Object) is used to store binary data like images, videos,
and other multimedia files . CLOB (Character Large Object) is used for large text data .
Question 7
What is a GUID (Globally Unique Identifier) used for?
A. To identify rows in a database table uniquely across all tables
B. To store geographic data
C. To encrypt data
D. To compress data
Correct Answer: A
Rationale: GUID (Globally Unique Identifier), also known as UUID, is a 128-bit value
used to uniquely identify rows in a database table, often as a primary key .
Question 8
Which of the following is an example of a data repository?
A. API
B. Data lakehouse
C. JSON
D. Python
Correct Answer: B
