You have an Azure SQL database named DB1 that contains multiple tables.
You need to improve the performance of DB1. The solution must minimize administrative effort.
What should you use?
The latest changes and updates from the administration for this exam.
Latest Update: Jun 10 2026
All questions are working fine.
You have an Azure SQL database named DB1 that contains multiple tables.
You need to improve the performance of DB1. The solution must minimize administrative effort.
What should you use?
Case Study
This is a case study. In the real exam, 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.
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 WebApp1 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 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 web 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 the Standard pricing tier of Azure App Service.
⦿ 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.
Question
To meet the authentication requirements of Fabrikam, What is the minimum number of Azure tenants required for the implementation?
Case Study
This is a case study. In the real exam, 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.
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 WebApp1 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 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 web 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 the Standard pricing tier of Azure App Service.
⦿ 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.
Question
To meet the authentication requirements of Fabrikam, What is the minimum number of custom domains required for the implementation?
Case Study
This is a case study. In the real exam, 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.
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 WebApp1 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 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 web 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 the Standard pricing tier of Azure App Service.
⦿ 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.
Question
To meet the authentication requirements of Fabrikam, What is the minimum number of conditional access policies required for the implementation?
Your company provides customer support for multiple Azure subscriptions and third-party hosting providers.
You are designing a centralized monitoring solution. The solution must provide the following services:
◉ Collect log and diagnostic data from all the third-party hosting providers into a centralized repository.
◉ Collect log and diagnostic data from all the subscriptions into a centralized repository.
◉ Automatically analyze log data and detect threats.
◉ Provide automatic responses to known events.
Which Azure service should you include in the solution?
You are designing an access policy for your company.
Occasionally, the developers at the company must stop, start, and restart Azure virtual machines. The development team changes often.
You need to recommend a solution to provide the developers with the required access to the virtual machines. The solution must meet the following requirements:
◉ Provide permissions only when needed.
◉ Use the principle of least privilege.
◉ Minimize costs.
Which of the following would go into Slot1?
You are designing an access policy for your company.
Occasionally, the developers at the company must stop, start, and restart Azure virtual machines. The development team changes often.
You need to recommend a solution to provide the developers with the required access to the virtual machines. The solution must meet the following requirements:
◉ Provide permissions only when needed.
◉ Use the principle of least privilege.
◉ Minimize costs.
Which of the following would go into Slot2?
You have the Free edition of a hybrid Azure Active Directory (Azure AD) tenant. The tenant uses password hash synchronization.
You need to recommend a solution to meet the following requirements:
◉ Prevent Active Directory domain user accounts from being locked out as the result of brute force attacks targeting Azure AD user accounts.
◉ Block legacy authentication attempts to Azure AD integrated apps.
◉ Minimize costs.
Which of the following would go into Slot1?
You have the Free edition of a hybrid Azure Active Directory (Azure AD) tenant. The tenant uses password hash synchronization.
You need to recommend a solution to meet the following requirements:
◉ Prevent Active Directory domain user accounts from being locked out as the result of brute force attacks targeting Azure AD user accounts.
◉ Block legacy authentication attempts to Azure AD integrated apps.
◉ Minimize costs.
Which of the following would go into Slot2?
A company deploys Azure Active Directory (Azure AD) Connect to synchronize identity information from their on-premises Active Directory Domain Services (AD
DS) directory to their Azure AD tenant. The identity information that is synchronized includes user accounts, credential hashes for authentication (password sync), and group memberships. The company plans to deploy several Windows and Linux virtual machines (VMs) to support their applications.
The VMs have the following requirements:
◉ Support domain join, LDAP read, LDAP bind, NTLM and Kerberos authentication, and Group Policy.
◉ Allow users to sign in to the domain using their corporate credentials and connect remotely to the VM by using Remote Desktop.
You need to support the VM deployment.
Which service should you use?