Microsoft DP-300 Exam Questions- 2022 Updated

In this blog, we are going to cover Microsoft Azure Database Administrator Associate DP-300 Exam Questions that give you an idea and understanding that generally what type of questions are asked in the DP-300 Associate-level Exam.

Azure Database Administrator Associate [DP-300] Certificate is important This includes administering knowledge around T-SQL for administrative management purposes. Participants successfully completing the DP-300 examination allows individuals to Manage, Secure, and introduce optimization around modern relational database solutions.

Azure Database Administrator is responsible for managing database, availability, and Security, and they need to monitor the performance and optimization of modern relational database solutions. They should have knowledge of using T-SQL They are computer system administrators who can maintain a successful database environment.

If you are preparing for the Microsoft Azure Database Administrator Associate Certification Then check your readiness to these questions for Azure Database Administrator Certification.

Let’s Discuss the Questions:

Q.1 You have to migrate an on-premises database named domain-db to an Azure SQL Managed Instance. You have carried out the following tasks so far.
• Created an SMB network share
• Ensure all firewall rules had been set on the source and destination server-side

You have to perform an online migration. Costs should be minimized wherever possible. Which of the following needs to be stored in the SMB network share that the database migration service would use?

A) Transaction files
B) VHD files
C) Database Backup files
D) Log files

Explanation:

Correct Answers: C

In the SMB file share, you have to store the full database backup and the subsequent log files. The Database migration service requires this.

The other options are incorrect because the files required by the Database migration service are the backup files.

Read: Microsoft Azure Certification Path

Q.2 You have to deploy Microsoft SQL Server on an Azure virtual machine. You are going to be using Premium SSD’s for storage of the data and log files. Separate disks are going to be used for the storage of each set of files. You have to decide on the right caching policy to apply for the disks. Which of the following is the caching policy that should be applied for the disks holding the data files for optimum performance?

A) None
B) Read Caching
C) Read / Write Caching
D) Write Caching

Explanation:

Correct Answers: B

As per the recommendation given by Microsoft, below are the guidelines when it comes to Premium SSD disks used for the storage of data and log files.

• For data files – Enable read caching
• For TempDB data files – Enable read caching
• For log files – Caching should not be enabled

Since this is the clear guidance given by Microsoft, all other options are incorrect.

Q.3 You have to meet the requirement of “An SLA of 99.99% must be met for all Azure deployments” when it comes to the deployment of the logistics-db. Which of the following would you use as the Azure resource for the availability of the group listener?

A) Azure Application Gateway
B) Azure Standard Load Balancer
C) Azure Functions
D) Azure Logic Apps

Explanation:

Correct Answers: B

When you configure an availability group on a set of virtual machines for SQL Server, you will need to use Windows Failover clusters. Here we need an Azure Load Balancer with a floating IP address that would be used for the connection. Here the machines can be placed in an availability zone for an SLA of 99.99%.

The other options are incorrect since the Microsoft blog post mentioned in the below URL clearly mentions that we need to use the Azure Load Balancer for the failover.

Q.4 Your company has an Azure SQL database-managed instance named domain-db. A Microsoft SQL Server Agent job runs on the database. You have to ensure that an automatic email notification is sent once the job completes.

You decide to enable SQL Server Agent from SQL Server Configuration Manager.

Would this fulfill the requirement?

A) Yes
B) No

Explanation:

Correct Answer: B

You have to make use of a Database Mail profile from SQL Server Management Studio for this requirement.

Q.5 You have to ensure the identity used to encrypt PII data via the Key Vault has the required permissions to do so. Which of the following needs to be configured for this requirement?

A) Role-based access control
B) IAM
C) Key Vault Access policies
D) Azure Security Center

Explanation:

Correct Answer: C

You can make use of Key Vault access policies. Here you can ensure that identities have access to the encryption keys in the key vault.

Options A and B are incorrect since these are used for managing the key vault.
Option D is incorrect since this is used for seeing the security posture of your Azure-based resources.

Q.6 Your company has a set of Azure SQL databases hosted on a logical server. They want to enable SQL auditing for the database.

Which of the following can be used to store the audit logs? Choose 3 answers from the options given below.

A) Azure Storage accounts
B) Azure SQL database
C) Azure SQL data warehouse
D) Azure Log Analytics
E) Azure Event Hubs

Explanation:

Correct Answers: A, D, and E

When you enable auditing for an Azure SQL database, below are the options available for Azure SQL auditing.

Since this is clear from the implementation, all of the other options are incorrect.

Q.7 Your company has a set of Azure SQL Databases as part of its Azure subscription. You have to apply 10 in-built Azure policies to both existing and new Azure SQL Databases. The solution must minimize administrative effort. Which of the following would you implement for this requirement? Choose 3 answers from the options given below.

A) Duplicate the Azure Policy definitions
B) Run Azure Policy remediation tasks
C) Create an Azure Blueprints assignment
D) Create an Azure policy initiative
E) Create an Azure Policy assignment

Explanation

Correct Answers: B, D, and E

The set of steps need to be in the following order.

• First, create an Azure policy initiative. Here you can then add multiple policy assignments.
• Then add the assignments to the initiative
• Then run Azure Policy remediation tasks for the existing databases

Option A is incorrect since we need to use existing Azure policy definitions.
Option C is incorrect since we need to use Azure policy initiatives and not Azure Blueprints.

Q.8 Which of the following can be used to migrate the PostgreSQL database onto Azure?

A) Azure Backup
B) Azure Site Recovery
C) Azure Database Migration Service
D) Azure Logic Apps

Explanation:

Correct Answer: C

The Azure Database Migration Service can be used to perform a migration onto Azure Databases for PostgreSQL with minimal downtime.

The other options are incorrect since they can’t be used to migrate an existing PostgreSQL database onto Azure Database for PostgreSQL.

Q.9 Your company has a SQL Server Instance hosted on an Azure virtual machine.

You have to perform a backup of the SQL Server Instance

Which of the following Azure service can be used for this requirement?

A) Azure geo-replication
B) Azure Backup
C) Failover groups
D) Azure SQL Managed Instance

Explanation:

Correct Answer: B

The Azure Backup service can be used to take backups of SQL Server data on Azure virtual machines

Option A is incorrect since this is used for the replication of data for an Azure SQL Database
Option C is incorrect since this is normally used for recovery purposes
Option D is incorrect since this is used for hosting a SQL database in Azure.

Q.10 Your company has a Microsoft SQL Server 2019 instance on their on-premises environment. The instance has a 2-TB database named domain-db. You have to migrate the database to an Azure SQL Managed Instance. You have to minimize downtime and data loss during the migration. Which of the following can be used for this requirement?

A) Distributed availability groups
B) Database mirroring
C) Log shipping
D) Database Migration Assistant

Explanation:

Correct Answer: A

With distributed availability groups, your SQL Server environment spans two separate availability groups. In the migration, you can stop the data traffic to the primary availability group. Synchronous data movement can then be enabled for the availability group. This ensures that there will be no data loss.

Option B is incorrect since this is used to keep a copy of a SQL Server production database on a standby server
Option C is incorrect since this is used to send transaction log backups from a primary database onto a secondary database
Option D is incorrect since this tool is used to evaluate whether the source can be migrated onto a destination environment.

Download the Complete DP-300 Exam Questions

When you have tested your knowledge by answering these DP-300 exam questions, I hope you have a clear stand in terms of your DP-300 exam preparation.

Note: K21Academy also offers a complete DP-300 Exam Questions Prep Guide where learners get to practice questions to test their Azure DP-300 exam preparation before the actual exam.

To download the complete DP-300 Azure Data Analyst Associate Exam Questions guide click here.

Related/References

• Exam DP-300: Microsoft Azure Database Administrator Associate
• Microsoft Certified Azure Database Administrator Associate(Hands-On Labs)
• Azure SQL Deployment Options | SQL Managed Instance | SQL Database| SQL On VM

Next Task For You

In our Azure Database Administrator training program, we will cover all the exam objectives, Hands-On Labs, and practice tests. If you want to begin your journey towards becoming a Microsoft Certified: Azure Database Administrator Associate by check our FREE CLASS.