CompTIA ITF+ (FC0-U61) — Question 141

A database administrator would like to create a visual diagram of the layout of a new relational database. Which of the following should the administrator use?

Answer options

• A. Flowchart schema
• B. Physical schema
• C. Logical schema
• D. Table schema

Correct answer: B

Explanation

The correct answer is B, as a Physical schema provides a detailed representation of how data is stored in a database, including tables, indexes, and relationships. The other options, such as Flowchart schema, Logical schema, and Table schema, do not accurately depict the physical layout and storage specifics of the database.