FC0-U61 · Question #541
Which of the following is the MOST likely benefit of a structured database?
The correct answer is A. Higher security. Structured databases, by definition, enforce strict data types, relationships, and constraints, which inherently allows for better control over data access and integrity, leading to higher security. This structure facilitates the implementation of granular access controls and val
Question
Which of the following is the MOST likely benefit of a structured database?
Options
- AHigher security
- BFaster accumulation
- CEasily searchable
- DFewer storage requirements
How the community answered
(28 responses)- A86% (24)
- B7% (2)
- C4% (1)
- D4% (1)
Why each option
Structured databases, by definition, enforce strict data types, relationships, and constraints, which inherently allows for better control over data access and integrity, leading to higher security. This structure facilitates the implementation of granular access controls and validation rules.
Structured databases enforce schema, data types, and relationships, which inherently allows for more robust security measures through strict access controls, data validation, and integrity constraints. This structure makes it easier to define and enforce who can access what data, how it can be modified, and prevents certain types of data corruption or unauthorized insertion.
"Faster accumulation" is vague; while structured databases are efficient for specific operations, their primary benefit is not necessarily faster data accumulation compared to unstructured data scenarios which might just dump data.
While structured databases are easily searchable due to their organized nature, this is a consequence of their structure rather than the most likely primary benefit. Unstructured data can also be searchable with proper indexing.
Structured databases often have more overhead in terms of storage for schema, indexes, and relationships compared to simply storing raw, unstructured data, so they typically do not have fewer storage requirements.
Concept tested: Benefits of structured databases - Security
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-security-overview
Topics
Community Discussion
No community discussion yet for this question.