CompTIA DataSys+
Certification Exam
Objectives
EXAM NUMBER: DS0-001

About the Exam
The CompTIA DataSys+ certification exam will certify the successful candidate has the knowledge andskills required to deploy, manage, and maintain databases, including employing the fundamentals ofscripting and programming in a database environment while using security and business continuity bestpractices.
EXAM DEVELOPMENT
CompTIA exams result from subject matter expert workshops and industry-wide survey results
regarding the skills and knowledge required of an IT professional.
CompTIA AUTHORIZED MATERIALS USE POLICY
CompTIA Certifications, LLC is not affiliated with and does not authorize, endorse, or condone utilizing
any content provided by unauthorized third-party training sites (aka “brain dumps”). Individuals who
utilize such materials in preparation for any CompTIA examination will have their certifications revoked
and be suspended from future testing in accordance with the CompTIA Candidate Agreement. In aneffort to more clearly communicate CompTIA’s exam policies on use of unauthorized study materials,CompTIA directs all certification candidates to the CompTIA Certification Exam Policies. Please review
all CompTIA policies before beginning the study process for any CompTIA exam. Candidates will be
required to abide by the CompTIA Candidate Agreement. If a candidate has a question as to whether
study materials are considered unauthorized (aka “brain dumps”), they should contact CompTIA atexamsecurity@comptia.org to confirm.
PLEASE NOTE
The lists of examples provided in bulleted format are not exhaustive lists. Other examples oftechnologies, processes, or tasks pertaining to each objective may also be included on the exam,although not listed or covered in this objectives document. CompTIA is constantly reviewing thecontent of our exams and updating test questions to be sure our exams are current, and the securityof the questions is protected. When necessary, we will publish updated exams based on existing
exam objectives. Please know that all related exam preparation materials will still be valid.

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

TEST DETAILS
Required examDS0-001

Number of questions

Maximum of 90Types of questions

Multiple-choice and performance-based

Length of test

90 minutes

Recommended experience

2–3 years of hands-on experience
as a database administrator

EXAM OBJECTIVES (DOMAINS)
The table below lists the domains measured by this examinationand the extent to which they are represented.
DOMAIN		PERCENTAGE OF EXAMINATION
1.0
2.0
3.0
4.0
5.0
Total

Database Fundamentals		
Database Deployment			
Database Management and Maintenance
Data and Database Security		
Business Continuity			

24%
16%
25%
23%
12%
100%

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

1.0 Database Fundamentals
1.1

Compare and contrast database structure types.
• Relational vs. non-relationaldatabases• Linear vs. non-linear format• NoSQL types- Document databases- Key-value stores

1.2- Amazon DynamoDB- CosmosGiven a scenario, develop, modify, and run SQL code.
• Data definition language (DDL)• Data manipulation language(DML)• Set-based logic• Transaction control languages(TCLs)• Atomicity, consistency, isolation,durability (ACID) principles

1.3- Column-oriented databases- Graph databases• Tools- Cassandra- MongoDB- Neo4j• American National Standards
Institute (ANSI) Structured Query
Language (SQL)• Programming with SQL- Triggers- Stored procedures- Functions- Views

Compare and contrast scripting methods and scripting
environments.
• Script purpose and runtime location- Server side
- Client side
• Languages- PowerShell- Python• Command-line scripting- Linux- Windows

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

1.0 | Database Fundamentals

1.4

Explain the impact of programming on database operations.
• Object-relational mapping (ORM)- Hibernate- Entity Framework- Ebean• Process to gauge impact- Review SQL code generated byORM- Confirm validity of code
- Determine impact to databaseserver- Provide solutions/alternate
approach, as needed

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

2.0 Database Deployment
2.1

Compare and contrast aspects of database planning and design.
• Requirements gathering- Number of users- Storage capacity
oSizeoSpeedoType- Database objectives
oUse cases/purposes• Database architecture factors- Inventory of needed assets

2.2

Gap analysis- Cloud-based vs. on-premises- Types of cloud-hostedenvironments:oPlatform as a service (PaaS)o
Software as a service (SaaS)oInfrastructure as a service(IaaS)- Database schemaoLogical   oPhysicalView- Data sources- System specifications• Design documentation- Data dictionary- Entity relationships- Data cardinality- System requirementsdocumentation
ooExplain database implementation, testing, and deployment
phases.
• Acquisition of assets• Phases of deployment- Installation and configuration   oDatabase prerequisites   oProvisioning   oUpgrading   oModifying   oImporting• Database connectivity- Database server location- Networking concepts
oDomain name service (DNS)   oClient/server architecture° Firewall and perimeter network considerations° Static and dynamic internet protocol (IP) 		
addressing
oPorts/protocols• Testing- Database quality check (columns, tables, fields)- Code execution- Schema meets original requirements- Syntax errors- Stress testing   oStored procedures stress test   oApplication stress test
- Notification triggers and alerts- Version control testing- Regression testing- Negative testing• Validate- Index analysis- Data mapping- Data values- Queries- Referential integrity/integrity validation- Scalability validation

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

3.0 Database Management andMaintenance
3.1

Explain the purpose of monitoring and reporting for databasemanagement and performance.
• System alerts/notifications- Growth in size/storage limits- Daily usage- Throughput- Resource utilization   oCentral processing unit(CPU) usage   oMemory      oDisk space

3.2

Operating system (OS)performance- Baseline configuration/trending- Monitoring job completion/failure- Replication- Database backup alerts• Transaction log files• System log files   oExplain common database maintenance processes.
• Query optimization• Index optimization• Patch management- Updates- Security and maintenance patches• Database integrity checks- Table locking techniques• Data corruption checks• Periodic review of audit logs
• Performance tuning- Transaction volumes

3.3• Deadlock monitoring• Connections and sessions- Concurrent connections- Failed/attempted connections• Load balancing• Change management- Release schedules- Capacity planning- Upgrades- Vulnerability remediation- Change approval- Communication- Database refresh

Given a scenario, produce documentation and use relevant tools.
• Data dictionaries• Entity relationship diagram (ERD)• Maintenance documentation• Standard operating procedure (SOP) documentation- Organizational compliance documentation- Third-party compliance documentation• Tools- Unified modeling language (UML) editors- Word processors- Spreadsheet tools

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

3.0 | Database Management and Maintenance

3.4

Given a scenario, implement data management tasks.
• Data management- Modify data
- Define data
- Append columns- Create new data sets
- Views/materialized views- Index creation- Create data tables- Create data relationships• Data redundancy• Data sharing

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

4.0 Data and Database Security
4.1

Explain data security concepts.
• Encryption- Data in transit   oClient-side encryption   oIn-transit encryption   oServer-side encryption- Data at rest
• Data masking- Data discovery• Data destruction techniques

4.2• Data security audit- Expired accounts- Connection requests• Code auditing- SQL code
- Credential storage checks

Explain the purpose of governance and regulatory compliance.
• Data loss prevention• Data retention policies• Data classification- Personally identifiable information (PII)/personal
health information (PHI)- Payment Card Industry Data Security Standard (PCIDSS)• Global regulations- General Data Protection Regulation (GDPR)• Regional regulations

4.3

Given a scenario, implement policies and best practices related
to authentication and authorization.
• Access controls- Rights and privileges- Least privilege• Password policies• Service accounts• Identity and access management

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

4.0 | Data and Database Security

4.4

Explain the purpose of database infrastructure security.
• Physical- Access control   oBiometrics- Surveillance- Fire suppression- Cooling system• Logical- Firewall- Perimeter network- Port security

4.5

Describe types of attacks and their effects on data systems.
• SQL injection• Denial of service (DoS) attacks• On-path attacks• Brute-force attacks• Phishing• Malware- Ransomware

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0Copyright © 2022 CompTIA, Inc. All rights reserved.

5.0 Business Continuity
5.1

Explain the importance of disaster recovery and relevanttechniques.
• Disaster recovery (DR) planning- DR documentation   oManuals   oSystem security plan   oContinuity of operations plan   o
Build documentation- DR techniques      oReplication   oLog shipping

5.2

High availability
Mirroring• DR plan testing  oRecovery point objective (RPO)  oRecovery time objective (RTO)• Transition/failback to normal operations  o  oExplain backup and restore best practices and processes.
• Full backup vs. incremental- Differential• Database dumping• Schedule and automate backups• Test backups• Validate backup hash• Storage location- On-site vs. off-site• Retention policy- Purge vs. archive cycles

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0Copyright © 2022 CompTIA, Inc. All rights reserved.

CompTIA DataSys+ DS0-001 Acronym List
The following is a list of acronyms that appears on the CompTIA
DataSys+ DS0-001 exam. Candidates are encouraged to review
the complete list and attain a working knowledge of all listed acronyms
as part of a comprehensive exam preparation program.
Acronym

Spelled OutAcronym

Spelled OutACID

Atomicity Consistency Isolation andDurability
American National Standards InstituteCentral Processing Unit
Create Read Update Delete
Direct-attached Storage
Database
Database as a Service
Database Management Service
Data Control Language
Data Definition Language
Dynamic Host Configuration Protocol
Data Loss Prevention
Data Manipulation Language
Domain Name Service
Denial of Service
Disaster Recovery
Entity Relationship Diagram
File Transfer Protocol
General Data Protection Regulation
Infrastructure as a Service
Input/Output Per Second
Internet Protocol
Lightweight Directory Access Protocol
My Structured Query Language
Network-attached Storage
Not Only Structured Query Language
Object-relational Mapping
Operating System
Platform as a Service
Payment Card Industry Data Security
Standard

PHIPHPPIIRAM
REST
RPO
RTO
SaaSSAN
SOP
SQL
SSD
SSH
TCL
TCP/IP

Personal Health Information
Hypertext Preprocessor
Personally Identifiable Information
Random Access Memory
Representational Transfer State
Recovery Point Objective
Recovery Time Objective
Software as a Service
Storage Area Network
Standard Operating Procedure
Structured Query Language
Solid State Drive
Secure Shell
Transaction Control Language
Transmission Control Protocol/Internet
Protocol
Unified Modeling Language
Virtual Local Area Network
Virtual Private Cloud
Virtural Extensible LAN

ANSICPU
CRUD
DAS
DB
DBaaS
DBMS
DCL
DDL
DHCP
DLP
DML
DNSDoS
DRERD
FTP
GDPR
IaaS
IOPS
IP
LDAP
MySQL
NAS
NoSQL
ORM
OSPaaSPCI DSS

CompTIA DataSys+ DS0-001 Certification Exam: Exam Objectives Version 4.0
Copyright © 2022 CompTIA, Inc. All rights reserved.

UML
VLAN
VPC
VXLAN

CompTIA DataSys+ DS0-001
Hardware and Software List
CompTIA has included this sample list of hardware and software to assist
candidates as they prepare for the DataSys+ DS0-001 certification exam.
This list may also be helpful for training companies that wish to create alab component for their training offering. The bulleted lists below each
topic are sample lists and are not exhaustive.
Equipment• Desktop/laptop
Software• Free software/SQL environment to run scripts (e.g. MariaDB, DBeaver, SSMS)• Programming languages to practice connecting to a database (e.g., SQL, Python, PowerShell)• Text editing software (e.g., Notepad++, Visual Studio code)• UML modeling tools
Other• Sample database (e.g., .csv files, Northwind) to practice imports• Samples of technical (procedural or descriptive) documentation (e.g., data dictionary, ERD)

© 2022 CompTIA, Inc., used under license by CompTIA, Inc. All rights reserved. All certification programs and education related to suchprograms are operated exclusively by CompTIA, Inc. CompTIA is a registered trademark of CompTIA, Inc. in the U.S. and internationally.
Other brands and company names mentioned herein may be trademarks or service marks of CompTIA, Inc. or of their respective owners.
Reproduction or dissemination prohibited without the written consent of CompTIA, Inc. Printed in the U.S. 09776-Jul2022