Which three actions should you perform?
You deploy a Microsoft SQL Server instance on a Microsoft Azure virtual machine by using a template.
You plan to deploy a PHP-based app in an Azure web app. The web app will use a database on the virtual
machine. The web app and the virtual machine will be on the same Azure virtual network.
You need to ensure that the web app can access the SQL Server database.
Which three actions should you perform? Each correct answer presents part of the solution.
Which two actions should you perform?
You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine.
You need to ensure that all SQL Server audits are written to the Windows Security log.
Which two actions should you perform? Each correct answer presents part of the solution.
Which command should you execute?
Your company has two offices located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York
office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft Azure SQL database. Currently, only the users in the London office use the database.
You plan to provide the users in the New York office with access to the database.
You need to ensure that the New York office users can access the database.
Which command should you execute?
Which two components should you configure?
You have a Microsoft Azure SQL database.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.
Which Azure endpoint ports should you open?
DRAG DROP
You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database.
You need to configure firewall rules to meet the following requirements:
Access the database remotely.
Manage the server remotely by using Windows PowerShell.
Manage the server remotely by using Remote Desktop.
Which Azure endpoint ports should you open? To answer, drag the appropriate ports to the correct types of
access. Each port may be used once, more than once, or not at all. You may need to drag the split bar between
panes or scroll to view content.
Select and Place:
Which three actions should you perform?
You have a Microsoft SQL Server instance on a Microsoft Azure virtual machine.
The members of an Active Directory group named HelpDesk can log in to the SQL Server instance.
You need to ensure that the members of HelpDesk can query dynamic management views and gather
performance metrics from the SQL Server instance.
Which three actions should you perform? Each correct answer presents part of the solution.
Which three events should you include in the recommendation?
###BeginCaseStudy###
Testlet 1
Overview
Contoso, Ltd. is a national scientific research company that has sales, marketing, and research departments.
Contoso has a main office in Dallas and more than 20 satelliteoffices across the United States. Some
employees work off-site at customer locations.
Сontoso is expected to double in size during the next two years.
Existing Environment
The Microsoft SQL Server environment contains the servers configured as shown in the following table.
Contoso currently uses SQL Server 2008 R2 on all of the database servers. SQL01 currently requires six cores
and 50 GB of memory.
Once a day, database snapshots are taken on the mirror to provide ad hoc reporting and to load thedata
warehouse.
One report is used for ad hoc reporting by using the mirrored copy of the OLTP database.
Research Gen II is a Windows application that users currently access by using Remote Desktop.
Requirements
Business Goals
Contoso identifies the following business goals:
Minimize the costs associated with purchasing hardware and software.
Prevent any negative impact on performance when moving database platforms to the cloud.
Audit user access to and query execution on all of the databases in the research department.
Planned changes
Contoso plans to implement the following changes:
Upgrade SQL03 from SQL Server 2008 R2 to SQL Server 2014 on Windows Server 2012 R2.
Migrate SQL01 and SQL02 to Infrastructure as a Service (IAAS) on SQL Server 2014.
Leverage cloud services for a disaster recovery location and for high availability.
Replace Research Gen II with a cloud-based application named One Research. The database for this
application will be migrated to a cloud service.
Departmental RequirementsSenior research project leaders must be able to upload databases to the cloud. Initially, the databases will be
less than 3 GB. Some databases may grow to 50 GB. The databases must be recoverable to any point during
the past two weeks.
The research project leaders must monitor the performance of their databases. They must view statistics, such
as query performance and overall database performance.
The marketing department plans to use cloud services to host web applications for marketing campaigns. The
databases for the web applications have the requirements shown in the following table.
Technical Requirements
Contoso identifies the following technical requirements:
OLTP will be offloaded to Microsoft Azure virtual machines.
The data for One Report must not be more than l5 minutes old.
All of the databases for the OLTP system must be implemented on solid state drives (SSDs).
A solution for the OLTP system must be created to provide disaster recovery and reporting between SQL01
and SQL02.
All databases, except for the research and marketing databases, must be recoverable to any point during
the last 30 days.
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and
an Azure virtual machine named SQL04.
###EndCaseStudy###
You need to recommend an auditing solution that meets the business goals.
Which three events should you include in the recommendation? Each correct answer presents part of the
solution.
Which task should you instruct the leaders to use from …
###BeginCaseStudy###
Testlet 1
Overview
Contoso, Ltd. is a national scientific research company that has sales, marketing, and research departments.
Contoso has a main office in Dallas and more than 20 satelliteoffices across the United States. Some
employees work off-site at customer locations.
Сontoso is expected to double in size during the next two years.
Existing Environment
The Microsoft SQL Server environment contains the servers configured as shown in the following table.
Contoso currently uses SQL Server 2008 R2 on all of the database servers. SQL01 currently requires six cores
and 50 GB of memory.
Once a day, database snapshots are taken on the mirror to provide ad hoc reporting and to load thedata
warehouse.
One report is used for ad hoc reporting by using the mirrored copy of the OLTP database.
Research Gen II is a Windows application that users currently access by using Remote Desktop.
Requirements
Business Goals
Contoso identifies the following business goals:
Minimize the costs associated with purchasing hardware and software.
Prevent any negative impact on performance when moving database platforms to the cloud.
Audit user access to and query execution on all of the databases in the research department.
Planned changes
Contoso plans to implement the following changes:
Upgrade SQL03 from SQL Server 2008 R2 to SQL Server 2014 on Windows Server 2012 R2.
Migrate SQL01 and SQL02 to Infrastructure as a Service (IAAS) on SQL Server 2014.
Leverage cloud services for a disaster recovery location and for high availability.
Replace Research Gen II with a cloud-based application named One Research. The database for this
application will be migrated to a cloud service.
Departmental RequirementsSenior research project leaders must be able to upload databases to the cloud. Initially, the databases will be
less than 3 GB. Some databases may grow to 50 GB. The databases must be recoverable to any point during
the past two weeks.
The research project leaders must monitor the performance of their databases. They must view statistics, such
as query performance and overall database performance.
The marketing department plans to use cloud services to host web applications for marketing campaigns. The
databases for the web applications have the requirements shown in the following table.
Technical Requirements
Contoso identifies the following technical requirements:
OLTP will be offloaded to Microsoft Azure virtual machines.
The data for One Report must not be more than l5 minutes old.
All of the databases for the OLTP system must be implemented on solid state drives (SSDs).
A solution for the OLTP system must be created to provide disaster recovery and reporting between SQL01
and SQL02.
All databases, except for the research and marketing databases, must be recoverable to any point during
the last 30 days.
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and
an Azure virtual machine named SQL04.
###EndCaseStudy###
You need to tell the research project leaders how to migrate their databases.
Which task should you instruct the leaders to use from SQL Server Management Studio?
What should you enable?
###BeginCaseStudy###
Testlet 1
Overview
Contoso, Ltd. is a national scientific research company that has sales, marketing, and research departments.
Contoso has a main office in Dallas and more than 20 satelliteoffices across the United States. Some
employees work off-site at customer locations.
Сontoso is expected to double in size during the next two years.
Existing Environment
The Microsoft SQL Server environment contains the servers configured as shown in the following table.
Contoso currently uses SQL Server 2008 R2 on all of the database servers. SQL01 currently requires six cores
and 50 GB of memory.
Once a day, database snapshots are taken on the mirror to provide ad hoc reporting and to load thedata
warehouse.
One report is used for ad hoc reporting by using the mirrored copy of the OLTP database.
Research Gen II is a Windows application that users currently access by using Remote Desktop.
Requirements
Business Goals
Contoso identifies the following business goals:
Minimize the costs associated with purchasing hardware and software.
Prevent any negative impact on performance when moving database platforms to the cloud.
Audit user access to and query execution on all of the databases in the research department.
Planned changes
Contoso plans to implement the following changes:
Upgrade SQL03 from SQL Server 2008 R2 to SQL Server 2014 on Windows Server 2012 R2.
Migrate SQL01 and SQL02 to Infrastructure as a Service (IAAS) on SQL Server 2014.
Leverage cloud services for a disaster recovery location and for high availability.
Replace Research Gen II with a cloud-based application named One Research. The database for this
application will be migrated to a cloud service.
Departmental RequirementsSenior research project leaders must be able to upload databases to the cloud. Initially, the databases will be
less than 3 GB. Some databases may grow to 50 GB. The databases must be recoverable to any point during
the past two weeks.
The research project leaders must monitor the performance of their databases. They must view statistics, such
as query performance and overall database performance.
The marketing department plans to use cloud services to host web applications for marketing campaigns. The
databases for the web applications have the requirements shown in the following table.
Technical Requirements
Contoso identifies the following technical requirements:
OLTP will be offloaded to Microsoft Azure virtual machines.
The data for One Report must not be more than l5 minutes old.
All of the databases for the OLTP system must be implemented on solid state drives (SSDs).
A solution for the OLTP system must be created to provide disaster recovery and reporting between SQL01
and SQL02.
All databases, except for the research and marketing databases, must be recoverable to any point during
the last 30 days.
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and
an Azure virtual machine named SQL04.
###EndCaseStudy###
You need to ensure that the performance statistics for the research department are collected. What should you
enable?
What should you identify?
###BeginCaseStudy###
Testlet 1
Overview
Contoso, Ltd. is a national scientific research company that has sales, marketing, and research departments.
Contoso has a main office in Dallas and more than 20 satelliteoffices across the United States. Some
employees work off-site at customer locations.
Сontoso is expected to double in size during the next two years.
Existing Environment
The Microsoft SQL Server environment contains the servers configured as shown in the following table.
Contoso currently uses SQL Server 2008 R2 on all of the database servers. SQL01 currently requires six cores
and 50 GB of memory.
Once a day, database snapshots are taken on the mirror to provide ad hoc reporting and to load thedata
warehouse.
One report is used for ad hoc reporting by using the mirrored copy of the OLTP database.
Research Gen II is a Windows application that users currently access by using Remote Desktop.
Requirements
Business Goals
Contoso identifies the following business goals:
Minimize the costs associated with purchasing hardware and software.
Prevent any negative impact on performance when moving database platforms to the cloud.
Audit user access to and query execution on all of the databases in the research department.
Planned changes
Contoso plans to implement the following changes:
Upgrade SQL03 from SQL Server 2008 R2 to SQL Server 2014 on Windows Server 2012 R2.
Migrate SQL01 and SQL02 to Infrastructure as a Service (IAAS) on SQL Server 2014.
Leverage cloud services for a disaster recovery location and for high availability.
Replace Research Gen II with a cloud-based application named One Research. The database for this
application will be migrated to a cloud service.
Departmental RequirementsSenior research project leaders must be able to upload databases to the cloud. Initially, the databases will be
less than 3 GB. Some databases may grow to 50 GB. The databases must be recoverable to any point during
the past two weeks.
The research project leaders must monitor the performance of their databases. They must view statistics, such
as query performance and overall database performance.
The marketing department plans to use cloud services to host web applications for marketing campaigns. The
databases for the web applications have the requirements shown in the following table.
Technical Requirements
Contoso identifies the following technical requirements:
OLTP will be offloaded to Microsoft Azure virtual machines.
The data for One Report must not be more than l5 minutes old.
All of the databases for the OLTP system must be implemented on solid state drives (SSDs).
A solution for the OLTP system must be created to provide disaster recovery and reporting between SQL01
and SQL02.
All databases, except for the research and marketing databases, must be recoverable to any point during
the last 30 days.
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and
an Azure virtual machine named SQL04.
###EndCaseStudy###
You are evaluating the use of active geo-replication for one of the research department databases.
You need to identify which service tier to use for the database. The solution must meet the departmentrequirements and the business requirements.
What should you identify?