Design Data Storage

You have 100 servers that run Windows Server 2012 R2 and host Microsoft SQL Server 2014 instances. The instances host databases that have the following characteristics:

• The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.
• Stored procedures are implemented by using CLR.

You plan to move all the data from SQL Server to Azure.

You need to recommend an Azure service to host the databases. The solution must meet the following requirements:

• Whenever possible, minimize management overhead for the migrated databases.
• Minimize the number of database changes required to facilitate the migration.
• Ensure that users can authenticate by using their Active Directory credentials.

What should you include in the recommendation?

You have 70 TB of files on your on-premises file server.

You need to recommend solution for importing data to Azure. The solution must minimize cost.

What Azure service should you recommend?

You have an Azure subscription that contains 100 virtual machines.

You plan to design a data protection strategy to encrypt the virtual disks.

You need to recommend a solution to encrypt the disks by using Azure Disk Encryption. The solution must provide the ability to encrypt operating system disks and data disks.

What should you include in the recommendation?

You have data files in Azure Blob storage.

You plan to transform the files and move them to Azure Data Lake Storage.

You need to transform the data by using mapping data flow.

Which Azure service should you use?

You have an Azure virtual machine named VM1 that runs Windows Server 2019 and contains 500 GB of data files.

You are designing a solution that will use Azure Data Factory to transform the data files, and then load the files to Azure Data Lake Storage.

What should you deploy on VM1 to support the design?

You deploy Azure App Service Web Apps that connect to on-premises Microsoft SQL Server instances by using Azure ExpressRoute.

You plan to migrate the SQL Server instances to Azure.

• Migration of the SQL Server instances to Azure must:
• Support automatic patching and version updates to SQL Server.
• Provide automatic backup services.
• Allow for high-availability of the instances.
• Provide a native VNET with private IP addressing.
• Encrypt all data in transit.
• Be in a single-tenant environment with dedicated underlying infrastructure (compute, storage).

You need to migrate the SQL Server instances to Azure.

Which Azure service should you use?

You plan to store data in Azure Blob storage for many years. The stored data will be accessed rarely.

You need to ensure that the data in Blob storage is always available for immediate access. The solution must minimize storage costs.

Which storage tier should you use?

You are designing a SQL database solution. The solution will include 20 databases that will be 20 GB each and have varying usage patterns.

You need to recommend a database platform to host the databases. The solution must meet the following requirements:

• The compute resources allocated to the databases must scale dynamically.
• The solution must meet an SLA of 99.99% uptime.
• The solution must have reserved capacity.
• Compute charges must be minimized.

What should you include in the recommendation?

You have an app named App1 that uses two on-premises Microsoft SQL Server databases named DB1 and DB2.

You plan to migrate DB1 and DB2 to Azure.

You need to recommend an Azure solution to host DB1 and DB2. The solution must meet the following requirements:

• Support server-side transactions across DB1 and DB2.
• Minimize administrative effort to update the solution.

What should you recommend?