You have to deploy an Azure SQL database named db1 for your company. The databases must meet the following security requirements When IT help desk supervisors query a database table named customers, they must be able to see the full number of each credit card When IT help desk operators query a database table named customers, they must only see the last four digits of each credit card number A column named Credit Card rating in the customers table must never appear in plain text in the database system. Only client applications must be able to decrypt the information that is stored in this column Which of the following can be implemented for the Credit Card rating column security requirement?

You are planning an Azure solution that will host production databases for a high-performance application.
The solution will include the following components:
* Two virtual machines that will run Microsoft SQL Server 2016, will be deployed to different data centers in the same Azure region, and will be part of an Always On availability group.
* SQL Server data that will be backed up by using the Automated Backup feature of the SQL Server IaaS Agent Extension (SQLIaaSExtension) You identify the storage priorities for various data types as shown in the following table.

Which storage type should you recommend for each data type? To answer, drag the appropriate storage types to the correct data types. Each storage type 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.
NOTE: Each correct selection is worth one point.

You are designing a data pipeline that will integrate large amounts of data from multiple on-premises Microsoft SQL Server databases into an analytics platform in Azure. The pipeline will include the following actions:
* Database updates will be exported periodically into a staging area in Azure Blob storage.
* Data from the blob storage will be cleansed and transformed by using a highly parallelized load process.
* The transformed data will be loaded to a data warehouse.
* Each batch of updates will be used to refresh an online analytical processing (OLAP) model in a managed serving layer.
* The managed serving layer will be used by thousands of end users.
You need to implement the data warehouse and serving layers.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains 100 virtual machines in the North Europe Azure region.
You replicate the virtual machines to the West Europe region by using Azure Site Recovery.
You plan to perform disaster recovery testing once a month. The testing will be performed during an eight- hour period, during which the virtual machines will be accessed, and their functionality validated. The virtual machines will be shut down when testing is not being performed.
You need to estimate the costs of the Site Recovery solution per month. Which costs should the estimate include?

You need to design a highly available Azure SQL database that meets the following requirements:
Failover between replicas of the database must occur without any data loss.
The database must remain available in the event of a zone outage.
Costs must be minimized
Which deployment option should you use?