Exam 98-364 topic 1 question 162 discussion

Actual exam question from Microsoft's 98-364

Question #: 162
Topic #: 1

John works as a Database Administrator for DataOneWorld Inc.
The company has a SQL Server database.
John wants to insert records in a table where the database is structured in a fixed format.
Which of the following data models will he use to accomplish the task?

A. Object relational data model
B. Entity-Relationship Model
C. Network data model
D. Relational model

Show Suggested Answer

Suggested Answer: D 🗳️

by rogeriosolano at June 28, 2022, 1:35 p.m.

Comments

Submit Cancel

rogeriosolano

2 years, 11 months ago

Selected Answer: D

A relational model uses a collection of tables to represent both data and the relationship between those data. Every table has multiple columns, and each column has a unique name. A relational model is an example of a record-based model. Record-based models are so named because the database is structured in a fixed format. Each table in the database contains records of a particular type and each record type defines a fixed number of fields or attributes. This model is the most widely used data model, and most database systems are based on this model.

upvoted 1 times

...