DP-300 Exam Question 91
You have an Azure SQL managed instance named SQLMI1 that has the following settings:
- vCores: 4
- Service tier: General Purpose
- Hardware generation: Standard-series (Gen5)
You discover that memory pressure on SQLMI1 is high.
You need to reduce the memory pressure on SQLMI1. The solution must minimize costs.
What should to do?
- vCores: 4
- Service tier: General Purpose
- Hardware generation: Standard-series (Gen5)
You discover that memory pressure on SQLMI1 is high.
You need to reduce the memory pressure on SQLMI1. The solution must minimize costs.
What should to do?
DP-300 Exam Question 92
Hotspot Question
You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 93
You have an Azure subscription that contains a Standard SKU Azure SQL database named DB1.
You need to enable point-in-time recovery (PITR) backups for DB1. The solution must maximize how long the backups are retained.
Which retention period should you configure?
You need to enable point-in-time recovery (PITR) backups for DB1. The solution must maximize how long the backups are retained.
Which retention period should you configure?
DP-300 Exam Question 94
You have a data warehouse in Azure Synapse Analytics.
You need to ensure that the data in the data warehouse is encrypted at rest.
What should you enable?
You need to ensure that the data in the data warehouse is encrypted at rest.
What should you enable?
DP-300 Exam Question 95
Hotspot Question
You have an Azure Data Lake Storage Gen2 container.
Data is ingested into the container, and then transformed by a data integration application. The data is NOT modified after that. Users can read files in the container but cannot modify the files.
You need to design a data archiving solution that meets the following requirements:
- New data is accessed frequently and must be available as quickly as
possible.
- Data that is older than five years is accessed infrequently but must
be available within one second when requested.
- Data that us older than seven years is NOT accessed. After seven
years, the data must be persisted at the lowest cost possible.
- Costs must be minimized while maintaining the required availability.
How should you manage the data? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have an Azure Data Lake Storage Gen2 container.
Data is ingested into the container, and then transformed by a data integration application. The data is NOT modified after that. Users can read files in the container but cannot modify the files.
You need to design a data archiving solution that meets the following requirements:
- New data is accessed frequently and must be available as quickly as
possible.
- Data that is older than five years is accessed infrequently but must
be available within one second when requested.
- Data that us older than seven years is NOT accessed. After seven
years, the data must be persisted at the lowest cost possible.
- Costs must be minimized while maintaining the required availability.
How should you manage the data? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
