You have a Microsoft SQL Server instance that hosts a database named DB1. You plan to back up DB1 to Microsoft Azure Blob storage. You need to configure the required access to Azure blob storage for the planned backup. Which…
Your organization contains several Microsoft Azure SQL databases. You need to ensure that an administrator is notified when SQL injection is detected on one of the databases. Which two features should you enable? Each correct answer presents part of the…
You plan to deploy two Microsoft Azure virtual machines that will run Microsoft SQL Server. You need to ensure that users can continue to access the data on the SQL servers during Azure planned maintenance events. Which three components should…
Note: This question-is part of a series of questions that present the same scenario. Each question-in the series contains a unique solution that might meet the stated goals. Some question-sets might have more than one correct solution, while others might…
You are designing a cloud architecture for an organizational data mart that has an uncompressed data size of 1.1TB. The data size is static. Users from Europe, Asia, and North America will access the data for reporting purposes. You need…
Your company’s data warehouse contains several Microsoft SQL Server instances. You need to prevent unauthorized users from restoring backups of SQL Server database. What should you implement? A. BitLocker Drive Encryption (BitLocker) B. Cell-level encryption C. Transparent Data Encryption (TDE)…
You plan to deploy a highly available Microsoft SQL Server solution in Microsoft Azure to two virtual machines. Each virtual machine contains an OS disk and four data disks. You plan to configure both virtual machines to share a single…
You plan to migrate a 150-GB on-premises database to a Microsoft Azure virtual machine. The domains in your network are untrusted. The network has 1.5 Mbps of available bandwidth. You need to migrate the data to the Azure virtual machine…
You plan to migrate an on-premises database to Microsoft Azure. The planned deployment will include an Always On Failover Cluster Instance of Microsoft SQL Server. You need to implement a storage solution for the planned deployment. Which storage should you…
You need to recommend a high-availability solution in Microsoft Azure that meets the following requirements: – Must host a distribution database – Must be stored in the East US region – Must be available if a single node fails –…