DP-300 Practice Test Questions – Administering Relational Databases on Microsoft Azure

The only way to achieve DP-300 exam certification is to get DP-300 Practice Test Questions only at PassQuestion. PassQuestion ensures the quality and value of the DP-300 Practice Test Questions, let you can pass the Administering Relational Databases on Microsoft Azure exam successfully in your first studying. In addition, PassQuestion provides you with high-quality DP-300 Practice Test Questions to help you learn more about the examination of information, learning more knowledge of the entire examination, complete your dream of entering the IT Dream. Let you become a person with future.

DP-300 Practice Test Questions – Administering Relational Databases on Microsoft Azure

1. You have an Azure SQL database that contains a table named factSales.

FactSales contains the columns shown in the following table.

FactSales has 6 billion rows and is loaded nightly by using a batch process.

Which type of compression provides the greatest space reduction for the database?

 
 
 
 

2. You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance.

What should you use to minimize downtime and data loss during the migration?

 
 
 
 

3. You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases.

Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

 
 
 
 
 

4. You have a new Azure SQL database. The database contains a column that stores confidential information.

You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed.

Which three actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

 
 
 
 
 

5. You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.

You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:

– Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.

– Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.

What should you create on VNet1?

 
 
 
 

6. You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.

You need to record whenever users query the CustomerPII table.

Which two options should you enable? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

 
 
 
 

7. You have an Azure virtual machine based on a custom image named VM1.

VM1 hosts an instance of Microsoft SQL Server 2019 Standard.

You need to automate the maintenance of VM1 to meet the following requirements:

– Automate the patching of SQL Server and Windows Server.

– Automate full database backups and transaction log backups of the databases on VM1.

– Minimize administrative effort.

What should you do first?

 
 
 
 

8. You receive numerous alerts from Azure Monitor for an Azure SQL database.

You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

 
 
 
 
 

9. You have an Azure SQL database named sqldb1.

You need to minimize the amount of space by the data and log files of sqldb1.

What should you run?

 
 
 
 

10. You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected. You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1.

What should you do?

 
 
 
 

Microsoft Azure Administrator AZ-104 Practice Test Questions

Leave a Reply

Your email address will not be published. Required fields are marked *