nerdexam
Citrix

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.

Design XenDesktop Infrastructure Components

Question

Which database product should the architect recommend for production deployment?

Options

  • ASQL Server
  • BAccess
  • CSQL Server Express
  • DOracle database

How the community answered

(43 responses)
  • A
    93% (40)
  • B
    2% (1)
  • D
    5% (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.

ASQL ServerCorrect

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.

BAccess

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.

CSQL Server Express

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.

DOracle database

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

#database selection#SQL Server#production environment

Community Discussion

No community discussion yet for this question.

Full 1Y0-401 Practice