SK0-003 · Question #137
Which of the following servers would execute SQL?
The correct answer is A. Database Server. A Database Server is specifically designed to store, manage, and execute queries on databases, which are typically written in SQL.
Question
Which of the following servers would execute SQL?
Options
- ADatabase Server
- BDNS Server
- CNAS Server
- DWeb Server
How the community answered
(30 responses)- A87% (26)
- B3% (1)
- C7% (2)
- D3% (1)
Why each option
A Database Server is specifically designed to store, manage, and execute queries on databases, which are typically written in SQL.
A Database Server is purpose-built to host databases and run database management systems (DBMS) like SQL Server, MySQL, or PostgreSQL, which process and execute SQL commands for data manipulation and retrieval.
A DNS Server translates domain names to IP addresses and does not execute SQL.
A NAS (Network Attached Storage) Server provides file-level data storage services to other computers on a network and does not execute SQL.
A Web Server hosts websites and web applications, serving content via HTTP/HTTPS, and while it might interact with a database, it does not itself execute SQL.
Concept tested: Server roles and their primary functions
Source: https://learn.microsoft.com/en-us/sql/sql-server/what-is-sql-server?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.