A Structured Query Language (SQL) database is hosted on a hardened, secure server.

Vendor: APICS
Product: CPIM-8.0
Update on: Dec 14, 2025
Questions: 585

APICS CPIM-8.0 Question Answer

A Structured Query Language (SQL) database is hosted on a hardened, secure server. All unused ports are locked down, but external connections from untrusted networks are still required to be allowed through. What is the BEST way to ensure transactions to/from this server remain secure?

Secure SQL service port with a Transport Layer Security (TLS) certificate.

Use Multi-Factor Authentication (MFA) for all logins to the server.

Secure SQL service port with a Secure Sockets Layer (SSL) certificate.

Scan all connections to the server for malicious packets.