Pass the CompTIA CompTIA DataSys+ DS0-001 Questions and answers with CertsForce

The statement that contains an error is option B. This statement is missing the FROM clause, which specifies the table or tables from which to retrieve data. The FROM clause is a mandatory clause in a SELECT statement, unless the statement uses a subquery or a set operator. The correct syntax for option B would be:

SELECT EmpId FROM employee WHERE EmpId=90030 AND DeptId=34

Copy

The other options are either correct or valid SQL statements. For example, option A selects the employee ID from the employee table where the employee ID is equal to 90030; option C selects all columns from the employee table where the employee ID is equal to 90030; option D selects the employee ID from the employee table without any filter condition. References: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.2 Given a scenario, execute database tasks using scripting and programming languages.

The SQL command that the administrator should use to ensure that records from the two tables are not duplicated is option A. This command uses the UNION clause to combine the records from the legacy table and the newer table into a single result set. The UNION clause also eliminates any duplicate records that may exist in both tables, and sorts the result by default. The other options either do not produce the desired result or have syntax errors. For example, option B would join the records from the two tables based on a common column, but not remove any duplicates; option C would return only the records that are common to both tables, but not the ones that are unique to each table; option D would produce a Cartesian product of the records from the two tables, which would increase the number of duplicates. References: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.2 Given a scenario, execute database tasks using scripting and programming languages.

The script that would set the database recovery model for sys.database is option A. This script uses the ALTER DATABASE statement to modify the recovery model of the sys.database to full with no wait. The other options either have syntax errors, use incorrect keywords, or do not specify the recovery model correctly. References: CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.1 Given a scenario, perform common database maintenance tasks.

The cloud storage option that provides users with endpoints to retrieve data via REST API is object. Object storage is a type of cloud storage that stores data as objects, which consist of data, metadata, and a unique identifier. Object storage does not use any hierarchy or structure to organize data, but rather uses flat namespaces that allow users to access data using the unique identifier. Object storage also provides users with endpoints to retrieve data via REST API (Representational State Transfer Application Programming Interface), which is a standard way of communicating with web services using HTTP methods (such as GET, POST, PUT, DELETE) and formats (such as JSON, XML). Object storage is suitable for storing large amounts of unstructured data that do not require frequent changes or complex queries. The other options are either different types of cloud storage or not related to cloud storage at all. For example, network file storage is a type of cloud storage that stores data as files in folders using protocols such as NFS (Network File System) or SMB (Server Message Block); ephemeral storage is a type of temporary storage that stores data only for the duration of a session or process; iBIock is not a valid acronym or type of cloud storage. References: CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.1 Given a scenario, select an appropriate database deployment method.

The correct answers are A. Firewall and B. Strong passwords. CompTIA DataSys+ differentiates security controls into logical (technical) and physical infrastructure security measures. Logical security measures are implemented through software, configuration, and system controls to protect data, systems, and network resources from unauthorized access or misuse.

A firewall is a core logical infrastructure security control. It enforces security rules that regulate incoming and outgoing network traffic based on predefined policies. In database environments, firewalls are used to restrict access to database servers, limit exposed ports, and allow connections only from trusted IP addresses or networks. DataSys+ emphasizes firewalls as a first line of defense in protecting databases from unauthorized access and network-based attacks.

Strong passwords are another essential logical security measure. They are part of authentication controls that ensure only authorized users can access systems and databases. Strong password requirements—such as minimum length, complexity, expiration, and reuse restrictions—help mitigate attacks like brute-force attempts, credential stuffing, and unauthorized privilege escalation. DataSys+ highlights strong authentication controls as foundational to protecting database environments.

Option D, port security, can be ambiguous, but in CompTIA context it is often associated with network switch configurations and is more infrastructure-specific; however, the exam most clearly classifies firewall and authentication mechanisms as logical controls. Options C, E, and F—key cards, camera systems, and time locks—are all physical security controls. These protect the physical facility or hardware but do not directly enforce access through software or system logic.

CompTIA DataSys+ stresses a layered security approach, where logical controls protect data and systems, while physical controls protect facilities. In this question, the focus is explicitly on logical infrastructure security, making Firewall and Strong passwords the most accurate and clearly aligned answers.

Therefore, the correct selections are A and B.