FC0-U61 · Question #595
An administrator must select a data storage program to support an application. The program should include a management system to maintain structured data. Which of the following will the…
The correct answer is A. Relational. This question asks for the type of data storage system best suited for structured data with a management system.
Question
An administrator must select a data storage program to support an application. The program should include a management system to maintain structured data. Which of the following will the administrator MOST likely use?
Options
- ARelational
- BSpreadsheet
- CNoSQL
- DFlat file
How the community answered
(25 responses)- A72% (18)
- B4% (1)
- C8% (2)
- D16% (4)
Why each option
This question asks for the type of data storage system best suited for structured data with a management system.
A relational database management system (RDBMS) is designed to store and manage structured data in tables with predefined schemas, enforcing relationships between data points, and providing robust management features for data integrity, querying, and security. This makes it ideal for applications requiring structured data with strong consistency.
A spreadsheet program can store structured data but lacks the robust management, concurrency, integrity enforcement, and scalability features required for a complex application's backend.
NoSQL databases are designed for unstructured or semi-structured data, offering flexibility and scalability, but they do not typically focus on maintaining strictly structured data with predefined relationships in the same way as relational databases.
A flat file stores data in a simple, unstructured, or minimally structured text file without a built-in management system for data integrity, indexing, or complex querying.
Concept tested: Database types for structured data
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
Topics
Community Discussion
No community discussion yet for this question.