1Y0-401 · Question #141
Which database product should the architect recommend for production deployment?
The correct answer is A. SQL Server. For a production deployment, SQL Server is the recommended database product due to its robust features, scalability, and high-availability options essential for enterprise-level applications.
Question
Options
- ASQL Server
- BAccess
- CSQL Server Express
- DOracle database
How the community answered
(43 responses)- A93% (40)
- B2% (1)
- D5% (2)
Why each option
For a production deployment, SQL Server is the recommended database product due to its robust features, scalability, and high-availability options essential for enterprise-level applications.
SQL Server is a full-featured relational database management system designed for enterprise-level production environments. It offers advanced scalability, security, high availability, and performance features crucial for mission-critical applications.
Microsoft Access is a desktop database designed for small-scale personal or departmental use, lacking the scalability, security, and concurrency features required for production deployments.
SQL Server Express is a free, entry-level version of SQL Server with significant limitations on database size, CPU cores, and RAM, making it unsuitable for most production deployments with growing data and user demands.
While Oracle Database is an enterprise-grade product, without additional context indicating an existing Oracle infrastructure or specific requirements that preclude SQL Server, SQL Server is generally the primary production database choice within a Microsoft-focused environment, which is often implied by these questions.
Concept tested: Database selection for production environments
Source: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019
Topics
Community Discussion
No community discussion yet for this question.