The index that the developer should use to prevent duplicate values from being inserted is unique. A unique index is a type of index that enforces the uniqueness of the values in one or more columns of a table. A unique index ensures that no two rows in the table have the same value or combination of values in the indexed columns. A unique index helps to maintain data integrity and avoid data duplication or inconsistency. The other options are either not related or not effective for this purpose. For example, a single column index is a type of index that involves only one column of a table, but it does not prevent duplicate values unless it is also unique; an implicit index is a type of index that is automatically created by the database system when a constraint or a primary key is defined on a column or columns of a table, but it does not prevent duplicate values unless it is also unique; a composite index is a type of index that involves two or more columns of a table, but it does not prevent duplicate values unless it is also unique. 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 two options that have data manipulation and procedural scripting power are PL/SQL and T-SQL. PL
/SQL, or Procedural Language/Structured Query Language, is an extension of SQL that adds procedural features to SQL for Oracle databases. PL/SQL allows users to create and execute stored procedures, functions, triggers, packages, etc., using variables, loops, conditions, exceptions, etc., in addition to SQL commands. PL
/SQL helps improve the performance, functionality, modularity, and security of SQL queries and applications.
T-SQL, or Transact-SQL, is an extension of SQL that adds procedural features to SQL for Microsoft SQL Server databases. T-SQL allows users to create and execute stored procedures, functions, triggers, etc., using variables, loops, conditions, exceptions, etc., in addition to SQL commands. T-SQL helps improve the performance, functionality, modularity, and security of SQL queries and applications. The other options are either not related or not having both data manipulation and procedural scripting power. For example, PQL, or Power Query Language, is a data analysis and transformation language for Microsoft Power BI and Excel; Advanced SQL is a term that refers to the advanced features or techniques of SQL, such as subqueries, joins, aggregations, etc.; SQL, or Structured Query Language, is a standard language for manipulating and querying data in relational databases, but it does not have procedural features. 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 correct answers are C. Entity Framework and E. Hibernate. CompTIA DataSys+ defines Object- Relational Mapping (ORM) tools as software frameworks that allow developers to interact with relational databases using object-oriented programming concepts instead of writing raw SQL queries. ORM tools map database tables to application objects, rows to object instances, and columns to object attributes, simplifying database access and improving developer productivity.
Entity Framework is a widely used ORM tool in the Microsoft ecosystem, commonly paired with .NET applications. It enables developers to define data models in code and allows the framework to automatically generate SQL queries, manage relationships, and handle CRUD (Create, Read, Update, Delete) operations.
DataSys+ highlights ORM tools like Entity Framework as a way to reduce repetitive SQL coding while maintaining consistency and abstraction between application logic and the database layer.
Hibernate is a popular ORM framework used primarily in Java-based applications. Similar to Entity Framework, Hibernate manages database interactions by mapping Java objects to relational database structures. It handles SQL generation, transaction management, and caching, making it a core example of an ORM solution referenced in DataSys+ learning objectives.
Option A, PL/SQL, and option D, T-SQL, are procedural SQL languages, not ORM tools. They are used to write stored procedures, functions, and scripts that execute directly within the database. Option B, XML, is a data format used for data representation and exchange, not for object-relational mapping. Option F, PHP, is a general-purpose programming language that can use ORM tools but is not itself an ORM framework.
CompTIA DataSys+ emphasizes understanding the distinction between database languages, programming languages, and abstraction frameworks like ORMs. Entity Framework and Hibernate clearly fit the definition of ORM tools by bridging object-oriented applications and relational databases.
Therefore, the correct and fully verified answers are C and E.

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.

The first task that the administrator should perform is to create a new service account exclusively for the business intelligence application. This will ensure that the application has the appropriate permissions and credentials to access the company's transactional data. The other options are either unnecessary, inefficient, or insecure. For example, building a separate data warehouse would require additional resources and time, setting up a nightly FTP data transfer would expose the data to potential breaches, sending the TNS names file would not guarantee that the application can connect to the database, and opening a new port on the database server would create a vulnerability for attackers. References: CompTIA DataSys+ Course Outline, Domain
2.0 Database Deployment, Objective 2.1 Given a scenario, install and configure database software and tools.