DP 200 & 201: Implementing and Designing Azure Data Solution Practice Questions Part 1

A company wants to make use of Azure Databricks and Azure Data Lake Storage Gen2. As a data engineer, you have to ensure that the data in the Data Lake Storage is accessed by using a service principal from Azure Databricks. Which of the following would you implement for this requirement?

A company is planning to set up an Azure SQL database. The database will be used to store sensitive data. Below are the requirements for the data store.
• Only the application accessing the data can perform the encryption.
• The client application must have the access keys for encrypting and decrypting the data.
• The data must not appear in plaintext in the database.
• The strongest encryption method must be used on the database.
• The application should be able to search on select data values.
Which of the following would you use as the encryption method for Searchable data?

A company is planning to build a solution that would contain the below layers.

You have to decide on which services will be used for each layer.
Which of the following would you choose as the service to use Service B?

A company wants to create multiple Cosmos DB accounts. Each account has different requirements. Below are the requirements for each account.
Ipsaccount-stag: This account should be able to store log records.
Ipsaccount-prod: This account should be able to store Social media mentions.
Which of the following would you use as the API for the Ipsaccount-stag account?

A company has an on-premise Microsoft SQL Server. They want to migrate the database to Azure SQL Databases.
Which of the following should be the underlying storage type for the exported data?

A company is planning to set an Azure SQL Database. The database contains tables and columns that contain sensitive data. The company wants to have a solution in place that would accomplish the following requirements.
• Ensure the database is encrypted at rest.
• Ensure that when sensitive data is accessed from the columns, it is encrypted in transit.
Which of the following would you use for the following requirement?
Ensure the database is encrypted at rest.

A company is planning to design a solution in Azure. The solution would be based on the Kappa architecture as shown below.

Which of the following could be used for Layer 1?

A company wants to migrate data from an on-premise Mongo DB Instance to Azure Cosmos DB – Mongo API. During the testing phase, they discovered that too much time is being taken for the migration process. Which of the following can they implement to reduce the migration time? Choose 2 answers from the options given below.

A company wants to engineer a solution. The solution would have the following requirements.
• Ingest data from an on-premise SQL Server.
• Create pipelines that can integrate data and also run notebooks.
• Be able to develop notebooks that can be used to transform data.
• Be able to load the data into a massively parallel processing data for analysis.
Which of the following would you use as the service to integrate the on-premise data onto the cloud?

Case Study
Overview
A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations
• New York
• Manchester
• Singapore
• Melbourne
Current Environment
• The current solution stores millions of images on a physical server that is located in the New York office
• Around 2 TB of images are added every day
• Currently, the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queried by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data
Proposed Environment
• All of the images and any customer data needs to be transferred to Azure
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally
You need to meet the storage requirements for the image tagging data. Which of the following would you configure for the data store in the New York location?

A company is designing a solution that would make use of a Spark job to perform batch processing. The jobs must run once a day. One should also be able to display status information as the job runs.
Which of the following would you use for the triggering of jobs?

Your company is making use of an Azure SQL database. The database comes under heavy load during the last month of the year. You need to scale the Azure SQL database during this time manually. Which of the following would you implement for this requirement?

A company is planning to use an Azure SQL data warehouse. They have 2 fact tables named Ips_sales and Ips_invoice. Below are the details on each table.
Ips_sales
• The table would be 500 GB in size.
• A column named SalesDate would be used extensively in the WHERE clause in queries.
• A column named Sales Product would be used extensively in JOIN operations.
• A column named SalesRegion is used for grouping.
• Around 75% of the records are related to one of the 40 region values of the SalesRegion column.
Ips_invoice
• The table would be 6 GB in size.
• A column named SalesDate and SalesProduct would be used extensively in the WHERE clause in queries.
• A column named SalesRegion is used for grouping.
• You need to ensure that query performance is optimized for each table.
Which of the following would you use as the Distribution type for the Ips_sales table?

Your company wants to design a data processing solution by using Spark jobs on an Azure HDInsight cluster. This solution will be used to provide real-time information for an online training system. The solution must also be able to display the following summary information.
• Information on course sales group by course category and price range
• Reflect new course purchases
• Ensure optimal performance
Which of the following can be used as the data format?

Case Study
Overview
A company currently works with the local transportation sector. The company is responsible for building solutions that will help in improvement of traffic and safety.
Current Requirements

The company is currently managing the following systems

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data
• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The Length of the vehicle in meters
A sample of the data sent is shown below
{
“time” : “2019-10-15T22:15:25.72511745”,
“location” : {
“type” : “Point”,
“coordinates”:[ 22.4, 2.4] },
“speed” : 44.5,
“plate_number” : “22333W”,
“length” : 5.2
}
The traffic sensors will also capture images of the vehicle from time to time
Requirements
Below are the various requirements for the various systems
The Traffic Sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report data would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data

Security

• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application
• It must be ensured that all data is replicated to multiple geographic locations to prevent any sort of data loss.

You have to design the “Company_planning” database. You decide to include a non-clustered columnstore index to improve performance. Is this an ideal implementation?

A company is planning to deploy two Cosmos DB databases named ipsdb1 and ipsdb2. Below are the requirements for the databases.
Costs must be minimized for both databases.
The database ipsdb1 must meet an SLA of 99.99% for both reads and writes.
The database ipsdb2 must meet an SLA of 99.99% for writes and 99.999% for reads.
Which of the following would you implement for the database ipsdb1?

A company is planning to deploy two Cosmos DB databases named ipsdb1 and ipsdb2. Below are the requirements for the databases.
Costs must be minimized for both databases.
The database ipsdb1 must meet an SLA of 99.99% for both reads and writes.
The database ipsdb2 must meet an SLA of 99.99% for writes and 99.999% for reads.
Which of the following would you implement for the database ipsdb2?

A company has set an Azure SQL data warehouse. They want to ensure that users use two-factor authentication when they access data from the data warehouse using SQL Server Management Studio. Which of the following would you implement for this requirement?

You have an Azure Storage Account of the kind general purpose v2. You have to grant anonymous access permission to access the blobs in a specific container only. Which of the following should you use for this requirement?

You are going to create an Azure SQL data warehouse that is going to container customer data. You need to design a solution with the following requirements.
Provide the ability for data engineers to view all the rows for the customers.
The data engineers should not be able to view the credit card information of the customers.
Which of the following would you implement for this requirement? Select 2 options.

A company wants to implement a big data solution on the Azure platform. The solution must meet the following requirements.
• Must be optimized to carry out batch processing activities
• Must support autoscaling
• Must support scaling at the cluster level
Which of the following would you implement for this requirement?

A company has an Azure SQL Data warehouse. The company wants to have a solution in place wherein the data would be available at the time of a data center failure. The recovery point objective for the data should be an hour. Which of the following would you implement for this solution? Choose 3 answers from the options given below.

A company has an Azure Data Lake Storage Gen 2 account that is used to store data used by data engineers. The data engineers would query the data by using notebooks from Azure data bricks. The folders in the Data Lake storage account would be secured by ensuring that users only have access to the folders they require.
Which of the following would you use as the authentication method for Azure Databricks?

A company has an Azure Data Lake Storage Gen 2 account used to store data used by data engineers. The data engineers would query the data by using notebooks from Azure data bricks. The folders in the Data Lake storage account would be secured by ensuring that users only have access to the folders they require.
Which of the following would you use as the authentication method for Data Lake storage?

A company is planning to set up an Azure SQL database. The database will be used to store sensitive data. Below are the requirements for the data store.
• Only the application accessing the data can perform the encryption.
• The client application must have the access keys for encrypting and decrypting the data.
• The data must not appear in plaintext in the database.
• The strongest encryption method must be used on the database.
• The application should be able to search on select data values.
Which of the following would you use as the encryption method for Searchable data?

A company is planning to design a solution in Azure. The solution would be based on the Lambda architecture as shown below.

Which of the following service would you use for Layer 2?

A company is planning to design a solution in Azure. The solution would be based on the Lambda architecture as shown below.

Which of the following service would you use for Layer 3?

Your company is planning on transferring data from an Azure Data Lake Storage account. The data will be transferred using Azure Data Factory. The data will then be loaded into a data warehouse in Azure Synapse using PolyBase. The data in the Azure Data Lake Storage account will be accessed via a virtual network service endpoint.
Which of the following should be used as the authentication method to access the data in the Azure Data Lake Storage account?

A company is planning to build a solution that would contain the below layers.

You have to decide on which services will be used for each layer.
Which of the following would you choose as the service to use Service A?

A company is planning to build a solution that would contain the below layers.

You have to decide on which services will be used for each layer.
Which of the following would you choose as the service to use Service C?

A company is planning to build a solution that would contain the below layers.

You have to decide on which services will be used for each layer.
Which of the following would you choose as the service to use Service D?

A company currently stores data about its customers. The different properties of the customer data are shown below.

The data is going to be stored in an Azure Cosmos DB container. The queries on the data will be filtered by using the Customer Category and the Customer Surname.

Which of the following would you use as the Partition Key?

A company currently stores data about its customers. The different properties of the customer data are shown below.

The data is going to be stored in an Azure Cosmos DB container. The queries on the data will be filtered by using the Customer Category and the Customer Surname.

Which of the following would you use as the Item ID?

A company is planning on implementing an Azure data warehousing solution. A snippet of the tables in the data warehouse is shown below.

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table.
Which of the following would you use as the underlying table type for the Ips_employee table?

A company is planning on implementing an Azure data warehousing solution. A snippet of the tables in the data warehouse is shown below.

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table.
Which of the following would you use as the underlying table type for the Ips_ fact table?

A company is planning on implementing an Azure data warehousing solution. A snippet of the tables in the data warehouse is shown below.

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table.
Which of the following would you use as the underlying table type for the Ips_ Customer table?

A company is planning on implementing an Azure data warehousing solution. A snippet of the tables in the data warehouse is shown below.

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table.
Which of the following would you use as the underlying table type for the Ips_ Course table?

A company wants to create multiple Cosmos DB accounts. Each account has different requirements. Below are the requirements for each account.
Ipsaccount-stag: This account should be able to store log records.
Ipsaccount-prod: This account should be able to store Social media mentions.
Which of the following would you use as the API for the Ipsaccount-prod account?

A company is designing an application that would be used to store images. They are going to be using Azure blob storage. They have the following requirements when it comes to the storage of images.
• When an image is first uploaded, it would be accessed frequently.
• After a week, the images would not be accessed frequently. But if accessed, it would need to be available within 30 seconds.
• After a year, the data would not be accessed that frequently, but it would need to be available within 5 minutes if it was accessed.
• The data storage costs must be minimized.
Which of the following would you choose as the storage tier for the images for the first week?

A company is designing an application that would be used to store images. They are going to be using Azure blob storage. They have the following requirements when it comes to the storage of images.
• When an image is first uploaded, it would be accessed frequently.
• After a week, the images would not be accessed frequently. But if accessed, it would need to be available within 30 seconds.
• After a year, the data would not be accessed that frequently, but it would need to be available within 5 minutes if it was accessed.
• The data storage costs must be minimized.
Which of the following would you choose as the storage tier for the images after a month?

A company is designing an application that would be used to store images. They are going to be using Azure blob storage. They have the following requirements when it comes to the storage of images.
• When an image is first uploaded, it would be accessed frequently.
• After a week, the images would not be accessed frequently. But if accessed, it would need to be available within 30 seconds.
• After a year, the data would not be accessed that frequently, but it would need to be available within 5 minutes if it was accessed.
• The data storage costs must be minimized.
Which of the following would you choose as the storage tier for the images after a year?

Your company wants to design a system that would consist of an Azure virtual machine and an Azure SQL database. The database would not have any Internet connectivity. You need to implement a solution that would ensure that the virtual machine could access the database. Which of the following would you implement for this requirement?

A company wants to design a data store that would be used to store telemetry data. Which of the following could be used as the underlying data store?

Your company is planning to use the Azure SQL database and Azure storage accounts for an application. The application would extract data, convert the data to text documents and store them in the storage account. The text documents must be accessible from an SMB network share. Which of the following would you use as the underlying service type for the Azure storage account?

A company has an on-premises Microsoft SQL Server. They want to migrate the database to Azure SQL Databases.
Which of the following would they use as the file type for exporting the on-premise database?

A company has an on-premises Microsoft SQL Server. They want to migrate the database to Azure SQL Databases.
Which of the following should be the underlying storage type for the exported data?

Your company currently stores data in different types of Azure cloud-based databases. The company wants to consolidate the data into a single relational database. The data would be ingested at a set time of the day. Which of the following could be a recommendation to implement this requirement?

A company wants to implement an Azure Databricks cluster. The cluster configuration needs to meet the following requirements.
• Multiple users must be able to use the cluster
• Overall costs must be reduced
• Query latency should be minimized
Which of the following should be implemented as the cluster configuration for this requirement?

A company wants to migrate an on-premise MySQL database that is 800 GB in size. The database needs to be migrated to the Azure Database for MySQL. The migration must be performed in such a way that it would minimize interruptions to applications that use the database. Which of the following would you use to fulfill this requirement?

A company wants to use the Azure SQL database service. Business apps will be accessing the database. They want to create an Azure SQL database-managed instance. They want to ensure that the database can automatically recover from a full or partial loss of the Azure SQL database service in the primary region. Which of the following can help achieve this requirement?

A company is making use of Azure stream analytics for a solution. They want to ensure that the solution remains available even in the event of Azure service updates. Which of the following should they implement for this requirement? Choose 2 answers from the options given below.

A company needs to design a solution that would require to perform analytics and visualization on a large data set. The solution should use notebooks, automate clusters and provide the ability to use Power BI to visualize the data. Which of the following would you use for this requirement?

Case Study

Overview

A company currently has the following virtual machines in their on-premise data centre

Requirements

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements

• The server ips_sql3 requires an initial IOPS of 35000
• The servers ips_sql1 and ips_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure
• A regional disaster recovery strategy must also be in place
• The database backups must be retained for 7 years
• The server ips_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server ips_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for ips_sql2 must be reduced when it is not being used during non-peak hours

Which of the following would you use as the disk type for server ips_sql3 when it is migrated to Azure?

Case Study

Overview

A company currently has the following virtual machines in their on-premise data centre

Requirements

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements

• The server ips_sql3 requires an initial IOPS of 35000
• The servers ips_sql1 and ips_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server ips_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server ips_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for ips_sql2 must be reduced when it is not being used during non-peak hours

Which of the following would you choose as the database service tier?

Case Study

Overview

A company currently has the following virtual machines in their on-premise data centre

Requirements

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements

• The server ips_sql3 requires an initial IOPS of 35000
• The servers ips_sql1 and ips_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure
• A regional disaster recovery strategy must also be in place
• The database backups must be retained for 7 years
• The server ips_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server ips_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for ips_sql2 must be reduced when it is not being used during non-peak hours

You have to ensure that data can be accessed from the on-premise network for the Azure SQL Databases. Which of the following would you use as the tool to access the data?

Case Study

Overview

A company currently has the following virtual machines in their on-premise data centre

Requirements

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements

• The server ips_sql3 requires an initial IOPS of 35000
• The servers ips_sql1 and ips_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure
• A regional disaster recovery strategy must also be in place
• The database backups must be retained for 7 years
• The server ips_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server ips_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for ips_sql2 must be reduced when it is not being used during non-peak hours

You have to ensure that data can be accessed from the on-premise network for the Azure SQL Databases. Which of the following would you use as the port number to connect to the database?

Case Study

Overview

A company currently has the following virtual machines in their on-premise data centre

Requirements

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements

• The server ips_sql3 requires an initial IOPS of 35000
• The servers ips_sql1 and ips_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server ips_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server ips_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for ips_sql2 must be reduced when it is not being used during non-peak hours

The company wants to ensure that data is encrypted when it is stored in the Azure SQL database. Which of the following could be used for this requirement?

Case Study

Overview

A company currently has the following virtual machines in their on-premise data centre

Requirements

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements

• The server ips_sql3 requires an initial IOPS of 35000
• The servers ips_sql1 and ips_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure
• A regional disaster recovery strategy must also be in place
• The database backups must be retained for 7 years
• The server ips_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server ips_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for ips_sql2 must be reduced when it is not being used during non-peak hours

One of the databases is going to store sensitive data. You have to implement a solution that would be used to identify the sensitive data and monitor access to the data. Which of the following would you implement for this requirement? Choose 3 answers from the options given below.

Case Study

Overview

A company currently has the following virtual machines in their on-premise data centre

Requirements

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements

• The server ips_sql3 requires an initial IOPS of 35000
• The servers ips_sql1 and ips_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure
• A regional disaster recovery strategy must also be in place
• The database backups must be retained for 7 years
• The server ips_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server ips_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for ips_sql2 must be reduced when it is not being used during non-peak hours

You have to ensure that a backup strategy is present for the serve ips_sql1 and ips_sql2. Which of the following would you implement?

Case Study

Overview

A company currently has the following virtual machines in their on-premise data centre

Requirements

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements

• The server ips_sql3 requires an initial IOPS of 35000
• The servers ips_sql1 and ips_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure
• A regional disaster recovery strategy must also be in place
• The database backups must be retained for 7 years
• The server ips_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server ips_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for ips_sql2 must be reduced when it is not being used during non-peak hours

You need to implement disaster recovery for the data analysis solution. Which of the following would you implement for this requirement? Choose 3 answers from the options given below.