SK0-004 · Question #643
A server that can store extensible schema and communicate using SQL for describing transactions to be performed is commonly called a:
The correct answer is A. database server. A database server stores structured data using an extensible schema and uses SQL as its standard language for defining and executing transactions against that data.
Question
A server that can store extensible schema and communicate using SQL for describing transactions to be performed is commonly called a:
Options
- Adatabase server
- Bdirectory server
- Cweb server
- Dmessaging server
How the community answered
(19 responses)- A95% (18)
- D5% (1)
Why each option
A database server stores structured data using an extensible schema and uses SQL as its standard language for defining and executing transactions against that data.
Database servers are specifically designed to hold data organized into an extensible schema (tables, columns, data types) and expose SQL as the standard interface for transaction operations such as SELECT, INSERT, UPDATE, and DELETE, which precisely matches both characteristics described in the question.
A directory server stores hierarchical object records such as users and computers and communicates using LDAP, not SQL.
A web server delivers HTTP/HTTPS content to clients and is not designed to store extensible schemas or process SQL transactions.
A messaging server handles email or message-queue routing and does not use SQL for transaction communication or maintain an extensible schema.
Concept tested: Database server role and SQL transaction communication
Source: https://learn.microsoft.com/en-us/sql/relational-databases/databases/databases
Topics
Community Discussion
No community discussion yet for this question.