AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company wants to migrate a Windows-based application from on premises to the AWS Cloud. The application has three tiers: an application tier, a business tier, and a database tier with Microsoft SQL Server. The company wants to use specific features of SQL Server such as native backups and Data Quality Services. The company also needs to share files for processing between the tiers.
How should a solutions architect design the architecture to meet these requirements?
Other
Community
UAnonymous
A
Host all three tiers on Amazon EC2 instances. Use Amazon FSx File Gateway for file sharing between the tiers.
B
Host all three tiers on Amazon EC2 instances. Use Amazon FSx for Windows File Server for file sharing between the tiers.
C
Host the application tier and the business tier on Amazon EC2 instances. Host the database tier on Amazon RDS. Use Amazon Elastic File System (Amazon EFS) for file sharing between the tiers.
D
Host the application tier and the business tier on Amazon EC2 instances. Host the database tier on Amazon RDS. Use a Provisioned IOPS SSD (io2) Amazon Elastic Block Store (Amazon EBS) volume for file sharing between the tiers.
Explanation:
Explanation
Correct Answer: B
Why Option B is correct:
-
SQL Server Specific Features Requirement: The company needs specific SQL Server features like native backups and Data Quality Services (DQS). Amazon RDS for SQL Server has limitations on certain SQL Server features, including Data Quality Services. Hosting SQL Server on EC2 instances provides full access to all SQL Server features.
-
Windows-based Application: The application is Windows-based, and Amazon FSx for Windows File Server is specifically designed for Windows file sharing, supporting SMB protocol, Windows NTFS permissions, and Active Directory integration.
-
File Sharing Requirement: Amazon FSx for Windows File Server provides fully managed Windows file servers that can be accessed by multiple EC2 instances across tiers, making it ideal for sharing files between application, business, and database tiers.
Why other options are incorrect:
-
Option A: Amazon FSx File Gateway is a hybrid storage service that connects on-premises applications to Amazon FSx file systems in AWS. It's not designed for sharing files between cloud-native tiers.
-
Option C: Amazon RDS for SQL Server doesn't support Data Quality Services (DQS), and Amazon EFS is a Linux-based file system that doesn't support Windows file sharing protocols (SMB).
-
Option D: Amazon RDS doesn't support Data Quality Services, and Amazon EBS volumes are block storage devices that can only be attached to a single EC2 instance at a time, making them unsuitable for file sharing between multiple tiers.
Key AWS Services Used:
- Amazon EC2: For hosting all three tiers with full control over SQL Server features
- Amazon FSx for Windows File Server: For managed Windows file sharing between tiers
Architecture Design:
- Deploy all three tiers (application, business, database) on separate EC2 instances
- Install SQL Server on the database tier EC2 instance with full feature access
- Create an Amazon FSx for Windows File Server file system
- Mount the FSx file system to all EC2 instances for cross-tier file sharing
- Implement appropriate security groups and IAM roles for access control
Comments
Loading comments...