Security+ Question of the Week: NoSQL vs. SQL Database

What is the primary distinction between a NoSQL database and a SQL database?

A. One supports structure query language expressions, while the other does not.
B. One handles structured data, while the other handles big data.
C. One is implemented using open source technologies, while the other uses commercial code.
D. One is useful for private networks, while the other is used only in the cloud.

Reveal Answer

The correct answer is B.

The primary distinction between a NoSQL database and a SQL database is that one handles structured data, while the other handles big data. In most cases, even NoSQL databases support structured query language (SQL) expressions. In fact, the term NoSQL is a bit disingenuous as it should be called Non-relational as the database is not a standard relational table but a collection of numerous heterogeneous data sets. NoSQL databases and SQL databases can be implemented with either open source or commercial code solutions. Also, neither is limited to private networks or cloud only.

 

Related Courses
Security+ Prep Course (SY0-401)
Security+ Certification Boot Camp (SY0-401)

Security+ Question of the Week (SY0-401) Series

• Security+ Question of the Week: Deploying a Firewall
• Security+ Question of the Week: Flood Guard
• Security+ Question of the Week: iSCSI
• Security+ Question of the Week: Wireless MAC Filtering
• Security+ Question of the Week: Quantitative Analysis
• Security+ Question of the Week: Contracts
• Security+ Question of the Week: System Clock
• Security+ Question of the Week: Security Breach Incident Response
• Security+ Question of the Week: Reduce Electrostatic Discharge
• Security+ Question of the Week: Planting Malware
• Security+ Question of the Week: Network Hardening
• Security+ Question of the Week: Fuzzing
• Security+ Question of the Week: Single Sign‐On
• Security+ Question of the Week: Digital Envelope
• Security+ Question of the Week: Confining Communications to a Subnet
• Security+ Question of the Week: DoS Tool
• Security+ Question of the Week: Intranet Defense
• Security+ Question of the Week: War Driving
• Security+ Question of the Week: User Rights and Permissions Checks
• Security+ Question of the Week: Third Party Partnerships
• Security+ Question of the Week: Indicator of Integrity
• Security+ Question of the Week: Incident Response Procedure
• Security+ Question of the Week: Good Password Behavior
• Security+ Question of the Week: Tailgating
• Security+ Question of the Week: Differential Backup
• Security+ Question of the Week: Government and Military
• Security+ Question of the Week: Backdoor
• Security+ Question of the Week: Wrong Name or Address
• Security+ Question of the Week: Increase in Email Hoaxes
• Security+ Question of the Week: Suspicious Location-Based Messages
• Security+ Question of the Week: Session Hijack
• Security+ Question of the Week: Definition of a Threat
• Security+ Question of the Week: Dismiss Alarms
• Security+ Question of the Week: NoSQL vs. SQL Database

from
CERTIVIEW