nerdexam
CompTIA

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.

Database Fundamentals

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)
  • A
    72% (18)
  • B
    4% (1)
  • C
    8% (2)
  • D
    16% (4)

Why each option

This question asks for the type of data storage system best suited for structured data with a management system.

ARelationalCorrect

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.

BSpreadsheet

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.

CNoSQL

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.

DFlat file

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

#database types#relational databases#structured data

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice