The most likely causes of the reporting application not working are that the access permissions for the service account used by the reporting application were not changed, and that the reporting application’s mapping to the database location was not updated. These two factors could prevent the reporting application from accessing the new database server. The other options are either irrelevant or unlikely to cause the problem. References:  CompTIA DataSys+ Course Outline , Domain 3.0 Database Management and Maintenance, Objective 3.2 Given a scenario, troubleshoot common database issues.

The correct answers are E. MongoDB and F. Cosmos . CompTIA DataSys+ clearly differentiates between relational databases , which require predefined schemas, and non-relational (NoSQL) databases , which support flexible or schema-less data models. A schema-less database allows data to be stored without enforcing a fixed table structure, making it ideal for rapidly changing data requirements, unstructured data, or applications with evolving schemas.

MongoDB is a document-oriented NoSQL database that stores data in flexible, JSON-like documents. Each document in a MongoDB collection can have a different structure, allowing developers to add or remove fields without modifying a predefined schema. DataSys+ highlights document stores like MongoDB as well-suited for modern applications that require agility, scalability, and the ability to handle semi-structured or unstructured data.

Cosmos (commonly referring to Azure Cosmos DB) is a globally distributed NoSQL database service that supports multiple data models, including core (SQL) API, MongoDB API, and other non-relational models. It is designed for high availability, horizontal scalability, and schema flexibility. DataSys+ includes cloud-based NoSQL platforms such as Cosmos as examples of databases that do not enforce rigid schemas.

Options A , B , C , and D —PostgreSQL, MariaDB, MySQL, and SQL Server—are all relational database management systems (RDBMS) . These systems require predefined schemas with fixed table definitions, column data types, and constraints before data can be stored. While some relational systems support limited JSON storage, they are still fundamentally schema-based and do not meet the requirement described in the question.

CompTIA DataSys+ emphasizes selecting database technologies based on data structure and application needs. When schema flexibility is required, NoSQL solutions are preferred. Therefore, the tools best suited for creating a database without a predefined schema are MongoDB and Cosmos , making options E and F the correct and fully verified answers.

The instruction that is found on a Linux command-line script and represents a system shell is #!/bin/bash. This instruction is called a shebang or a hashbang, and it indicates the interpreter that should be used to execute the script. In this case, the interpreter is /bin/bash, which is the path to the bash shell, a common system shell for Linux. A system shell is a program that provides an interface for users to interact with the operating system, either through commands or scripts. A system shell can also perform various tasks, such as file management, process control, variable assignment, etc. The other options are either incorrect or not typical for this purpose. For example, /bin/bash is the path to the bash shell, but it does not indicate the interpreter for the script; #/bin/shell is not a valid shebang or a path to a system shell; > /bin/sh is a redirection operator followed by a path to a system shell, but it does not indicate the interpreter for the script. References:  CompTIA DataSys+ Course Outline , Domain 2.0 Database Deployment, Objective 2.2 Given a scenario, create database objects using scripting and programming languages.

The administrator should use peer-to-peer replication to achieve this objective. Peer-to-peer replication is a type of replication that allows data to be distributed across multiple database instances that are equal partners, or peers. Each peer can read and write data that will be synchronized across all peers. This provides high availability, scalability, and load balancing for the application. The other options are either not suitable for this scenario or do not support bidirectional data synchronization. For example, failover clustering provides high availability but does not distribute the workload across multiple instances; log shipping provides disaster recovery but does not allow writing data to secondary instances; availability groups provide high availability and read-only access to secondary replicas but do not support peer-to-peer replication. References:  CompTIA DataSys+ Course Outline , Domain 5.0 Business Continuity, Objective 5.3 Given a scenario, implement replication of database management systems.

The service that is responsible for assigning, managing, and reclaiming IP addresses on a TCP/IP-based network is DHCP. DHCP, or Dynamic Host Configuration Protocol, is a service that automatically assigns IP addresses and other network configuration parameters, such as subnet mask, default gateway, DNS server, etc., to computers or devices on a network. DHCP helps simplify the administration and management of IP addresses on a network, as well as avoid conflicts or errors caused by manual or duplicate assignments. DHCP also allows computers or devices to release or renew their IP addresses when they join or leave the network. The other options are either different services or not related to IP addresses at all. For example, DNS, or Domain Name System, is a service that translates domain names into IP addresses and vice versa; LDAP, or Lightweight Directory Access Protocol, is a service that provides access to directory information such as users, groups, or devices on a network; ISMTP is not a valid acronym or service. References:  CompTIA DataSys+ Course Outline , Domain 2.0 Database Deployment, Objective 2.1 Given a scenario, select an appropriate database deployment method.

The document that should be used to analyze the database’s structure is an ERD. An ERD, or Entity Relationship Diagram, is a graphical representation of the entities (tables), attributes (columns), and relationships (constraints) in a database. An ERD helps to visualize the structure and design of the database, as well as the dependencies and associations among the tables. An ERD can also help to evaluate the level of normalization of the database, which is a process that organizes data into tables and columns to reduce redundancy and improve consistency. By using an ERD, a database professional can consider denormalizing a database, which is a process that introduces some redundancy or duplication of data to improve performance or simplify queries. The other options are either different types of documents or not related to the database’s structure. For example, an SOP, or Standard Operating Procedure, is a document that describes the steps and procedures for performing a specific task or operation; a data dictionary is a document that describes the metadata (information about data) of a database; a UML diagram is a graphical representation of a software system or its components using the Unified Modeling Language (UML). References:  CompTIA DataSys+ Course Outline , Domain 2.0 Database Deployment, Objective 2.2 Given a scenario, create database objects using scripting and programming languages.

The correct answer is B. Rights and privileges . CompTIA DataSys+ clearly distinguishes between different categories of security controls, and access to shared resources such as folders is governed primarily by authorization mechanisms , specifically rights and privileges. In this scenario, access is restricted so that only authorized users can view or modify the shared folder, which directly reflects the enforcement of permissions.

Rights and privileges define what actions an authenticated user is allowed to perform on a system or resource. For shared folders, this typically includes read, write, modify, or full control permissions assigned to users or groups. DataSys+ emphasizes the principle of least privilege , which ensures users are granted only the minimum level of access required to perform their job functions. Applying appropriate rights and privileges protects sensitive data from unauthorized access and accidental modification.

Option A , password policies, control how passwords are created and managed, such as complexity, expiration, and reuse rules. While password policies help verify a user’s identity during authentication, they do not determine which resources a user can access after logging in. Option C , service accounts, are specialized non-human accounts used by applications or services and are unrelated to user access to shared folders. Option D , firewall policy, controls network-level traffic and determines which connections are allowed or blocked between systems, not access to files or folders once a connection is established.

CompTIA DataSys+ materials emphasize that security is layered, with authentication confirming identity and authorization enforcing access. In this case, users are already authenticated, and the restriction applies at the resource level. That makes rights and privileges the relevant control.

Therefore, the policy applied to ensure only authorized users can access the shared folder is rights and privileges , making option B the correct and fully verified answer.