Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirement, existing environment, and problem statements. If the case study has an
All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview -
Fabrikam, Inc. is an engineering company that has offices throughout Europe. The company has a main office in London and three branch offices in Amsterdam,
Berlin, and Rome.
Existing Environment -
Active Directory Environment -
The network contains two Active Directory forests named corp.fabrikam.com and rd.fabrikam.com. There are no trust relationships between the forests.
Corp.fabrikam.com is a production forest that contains identities used for internal user and computer authentication.
Rd.fabrikam.com is used by the research and development (R&D) department only.
Network Infrastructure -
Each office contains at least one domain controller from the corp.fabrikam.com domain. The main office contains all the domain controllers for the rd.fabrikam.com forest.
All the offices have a high-speed connection to the Internet.
An existing application named WebApp1 is hosted in the data center of the London office. WebApp1 is used by customers to place and track orders.
WebApp1 has a web tier that uses Microsoft Internet Information Services (IIS) and a database tier that runs Microsoft SQL Server 2016. The web tier and the database tier are deployed to virtual machines that run on Hyper-V.
The IT department currently uses a separate Hyper-V environment to test updates to WebApp1.
Fabrikam purchases all Microsoft licenses through a Microsoft Enterprise Agreement that includes Software Assurance.
Problem Statements -
The use of Web App1 is unpredictable. At peak times, users often report delays. At other times, many resources for WebApp1 are underutilized.
Requirements -
Planned Changes -
Fabrikam plans to move most of its production workloads to Azure during the next few years.
As one of its first projects, the company plans to establish a hybrid identity model, facilitating an upcoming Microsoft Office 365 deployment.
All R&D operations will remain on-premises.
Fabrikam plans to migrate the production and test instances of WebApp1 to Azure.
Technical Requirements -
Fabrikam identifies the following technical requirements:
Web site content must be easily updated from a single point.
User input must be minimized when provisioning new app instances.
Whenever possible, existing on-premises licenses must be used to reduce cost.
Users must always authenticate by using their corp.fabrikam.com UPN identity.
Any new deployments to Azure must be redundant in case an Azure region fails.
Whenever possible, solutions must be deployed to Azure by using platform as a service (PaaS).
An email distribution group named IT Support must be notified of any issues relating to the directory synchronization services.
Directory synchronization between Azure Active Directory (Azure AD) and corp.fabrikam.com must not be affected by a link failure between Azure and the on- premises network.
Database Requirements -
Fabrikam identifies the following database requirements:
Database metrics for the production instance of WebApp1, must be available for analysis so that database administrators can optimize the performance settings.
To avoid disrupting customer access, database downtime must be minimized when databases are migrated.
Database backups must be retained for a minimum of seven years to meet compliance requirements.
Security Requirements -
Fabrikam identifies the following security requirements:
Company information including policies, templates, and data must be inaccessible to anyone outside the company.
Users on the on-premises network must be able to authenticate to corp.fabrikam.com if an Internet link fails.
Administrators must be able authenticate to the Azure portal by using their corp.fabrikam.com credentials.
All administrative access to the Azure portal must be secured by using multi-factor authentication.
The testing of WebApp1 updates must not be visible to anyone outside the company.
You need to recommend a strategy for migrating the database content of WebApp1 to Azure.
What should you include in the recommendation?
Introductory Info
Question
Click on the arrows to vote for the correct answer
A. B. C. D.B
Based on the technical and database requirements, there are several ways to migrate the database content of WebApp1 to Azure. However, some options may not meet all the requirements. Therefore, the recommended strategy should consider all the technical requirements and comply with the database requirements.
Option A - Use Azure Site Recovery to replicate the SQL servers to Azure: Azure Site Recovery (ASR) is a disaster recovery solution that replicates workloads from on-premises servers to Azure. It can replicate the entire virtual machine or just the data disks. However, ASR is not designed for database migration, and it does not provide the ability to perform database backups, retention, or performance analysis. Therefore, Option A does not meet the database requirements.
Option B - Use SQL Server transactional replication: SQL Server transactional replication is a technology that replicates changes made to a database in near real-time to one or more destination databases. It can be used to migrate a database to Azure by replicating the data to an Azure SQL Database or an Azure SQL Managed Instance. However, transactional replication requires setting up replication agents, managing replication subscriptions, and ensuring data consistency. It also may not minimize database downtime during migration. Therefore, Option B may not meet the technical requirements and may be complex to implement.
Option C - Copy the VHD that contains the Azure SQL database files to Azure Blob storage: Copying the VHD that contains the Azure SQL database files to Azure Blob storage can be a viable option for migrating databases to Azure. It can be performed using the Azure Storage Explorer or Azure PowerShell cmdlets. Once the VHD is uploaded to Azure Blob storage, it can be attached to an Azure virtual machine running SQL Server. However, this option may require downtime during the migration process, and it may not comply with the security requirements if the VHD is not encrypted. Additionally, it may not provide database metrics and backup retention. Therefore, Option C may not meet all the technical and database requirements.
Option D - Copy the BACPAC file that contains the Azure SQL database files to Azure Blob storage: Copying the BACPAC file that contains the Azure SQL database files to Azure Blob storage is a recommended strategy for migrating databases to Azure. A BACPAC file is a self-contained database backup file that includes schema, data, and metadata. It can be exported from an on-premises SQL Server or an Azure SQL Database. Once the BACPAC file is uploaded to Azure Blob storage, it can be imported to an Azure SQL Database or an Azure SQL Managed Instance. This option is simple to implement, requires minimal downtime, and meets all the technical and database requirements. Additionally, it can provide database metrics and backup retention by using Azure SQL Database features. Therefore, Option D is the recommended strategy for migrating the database content of WebApp1 to Azure.
In conclusion, Option D - Copy the BACPAC file that contains the Azure SQL database files to Azure Blob storage - should be included in the recommendation as it meets all the technical and database requirements, minimizes downtime, and complies with the security requirements.