The purpose of this Sample Question Set is to provide you with information about the Administering Microsoft Azure SQL Solutions exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the DP-300 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Administering Azure SQL Solutions Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Certified - Azure Database Administrator Associate certification exam.
These sample questions are simple and basic questions that represent likeness to the real Microsoft DP-300 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Microsoft Administering Azure SQL Solutions Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.
Microsoft DP-300 Sample Questions:
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.
You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine. In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?
You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?
You have a version-8.0 Azure Database for MySQL database. You need to identify which database queries consume the most resources. Which tool should you use?
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance.
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.
You have a new Azure SQL database. The database contains a column that stores confidential information.
Answers:
Question: 01 Answer: d |
Question: 02 Answer: b, d |
Question: 03 Answer: d |
Question: 04 Answer: a |
Question: 05 Answer: b |
Question: 06 Answer: a |
Question: 07 Answer: d |
Question: 08 Answer: a, c |
Question: 09 Answer: a, c, d |
Question: 10 Answer: d |
Note: For any error in Microsoft Certified - Azure Database Administrator Associate (DP-300) certification exam sample questions, please update us by writing an email on feedback@edusum.com.