Administering Microsoft Azure SQL Solutions DP-300 Exam Questions
Preparing for the DP-300 exam is simple with CertsPoint. We offer easy-to-understand study materials that help you learn the most important exam topics. You can study using our PDF questions, practice online with a real exam-style test, or use the desktop practice software. Choose the study method that works best for you and prepare at your own pace.
At CertsPoint, we keep our DP-300 practice questions up to date. Whenever the exam syllabus or objectives change, we update our study materials so you always learn the latest topics. This helps you save time, avoid outdated content, and feel more confident when you take your exam.
Question #6 (Topic: All Exam Questions)
You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from
October 1 to January 1 each year.
During peak usage, the database will require the following:
24 cores
500 GB of storage
124 GB of memory
More than 50,000 IOPS
During periods of off-peak usage, the service tier of Azure SQL Database will be set to Standard.
Which service tier should you use during peak usage?
Correct Answer: A
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-singledatabases#
business-critical---provisioned-compute---gen4
Question #7 (Topic: All Exam Questions)
HOTSPOT
You have an Azure subscription.
You need to deploy an Azure SQL resource that will support cross database queries by using an Azure
Resource Manager (ARM) template.
How should you complete the ARM template? To answer, select the appropriate options in the
answer area.
NOTE: Each correct selection is worth one point.
A.
Correct Answer: A
Explanation:
Reference:
https://docs.microsoft.co
Question #8 (Topic: All Exam Questions)
HOTSPOT
You have the following Azure Resource Manager template.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
A.
Correct Answer: A
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-templatequickstart
Question #9 (Topic: All Exam Questions)
HOTSPOT
You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the
Azure Database Migration Service.
You need to create a backup of DB1 that is accessible to the Azure Database Migration Service.
What should you run for the backup and where should you store the backup? To answer, select the
appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
A.
Correct Answer: A
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online
Question #10 (Topic: All Exam Questions)
You have an Azure subscription that contains a server named Server1. Server1 hosts two Azure SQL
databases named DB1 and DB2.
You plan to deploy a Windows app named App1 that will authenticate to DB2 by using SQL authentication.
You need to ensure that App1 can access DB2. The solution must meet the following requirements:
App1 must be able to view only DB2.
Administrative effort must be minimized.
What should you create?
Correct Answer: D
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-usersmaking
your-database-portable?view=sql-server-ver15