DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Success Secrets: Microsoft DP-300 Exam Questions & Mock Tests, Microsoft Azure Database Administrator | SPOTO

Unlock the pathway to success with our exclusive offering: Success Secrets: Microsoft DP-300 Exam Questions & Mock Tests, Microsoft Azure Database Administrator | SPOTO. Dive into a wealth of resources including practice tests, free tests, exam practice, online exam questions, exam questions, sample questions, exam dumps, exam questions and answers, mock exams, and exam materials. Our latest practice tests are meticulously crafted to guide you towards triumph in passing the certification exam. Explore our curated courses and immersive hands-on labs tailored to kickstart your journey towards mastering Azure SQL database expertise. The DP-300 exam, a cornerstone of Microsoft's new role-based certification program, is a vital step towards acquiring the prestigious Azure Database Administrator Associate certification. Seize the opportunity to excel in your certification endeavors with our comprehensive resources at your disposal.

Take other online exams
Question #1
You have an Azure SQL database named db1. You need to retrieve the resource usage of db1 from the last week. How should you complete the statement? To answer, select the appropriate options in the answer area. Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: B
Question #2
You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL. Which service should you use?
A. Azure SQL Database
B. SQL Server on an Azure Virtual Machine
C. Azure SQL Managed Instance
D. Azure Database for MySQL
View answer
Correct Answer: B
Question #3
You have an Azure SQL database. You run the following PowerShell script. For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: B
Question #4
You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to identify which deployment and resiliency options meet the following requirements: Support user-initiated backups. Support multiple automatically replicated instances across Azure regions. Minimize administrative effort to implement and maintain business continuity. What should you identify? To answer, select the appropriate options in the answer area. Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #5
You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a user named user1@contoso.com and an Azure SQL managed instance named SQLMI1. You need to ensure that user1@contoso.com can create logins in SQLMI1 that map to Azure AD service principals. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
A. Mastered
B. Not Mastered
View answer
Correct Answer: C
Question #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. Each correct selection is worth one point.
A. server audit specification
B. SQL Server audit
C. database audit specification
D. a server principal
View answer
Correct Answer: A
Question #7
This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure SQL database named Sales. You need to implement disaster recovery
A. Yes
B. No
View answer
Correct Answer: E
Question #8
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. Each correct selection is worth one point. Hot Area:
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #9
You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytics in a star schema. You plan to have a fact table for website visits. The table will be approximately 5 GB. You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance. What should you recommend? To answer, select the appropriate options in the answer area. Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #10
You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL Server 2017 Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux. You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration. What should you do? To answer, select the appropriate options in the answer area. Each correct s
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #11
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?
A. a VPN gateway
B. a service endpoint
C. a private link
D. an ExpressRoute gateway
View answer
Correct Answer: B
Question #12
You have an Azure SQL database. Users report that the executions of a stored procedure are slower than usual. You suspect that a regressed query is causing the performance issue. You need to view the query execution plan to verify whether a regressed query is causing the issue. The solution must minimize effort. What should you use?
A. Performance Recommendations in the Azure portal
B. Extended Events in Microsoft SQL Server Management Studio (SSMS)
C. Query Store in Microsoft SQL Server Management Studio (SSMS)
D. Query Performance Insight in the Azure portal
View answer
Correct Answer: D
Question #13
You have 50 Azure SQL databases. You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure. What should you do?
A. Create a diagnostic setting for the activity log that has the Security log enabled
B. For the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled
C. Create an alert rule that uses a Metric signal type
D. Create an alert rule that uses an Activity Log signal type
View answer
Correct Answer: D
Question #14
This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure SQL database named Sales. You need to implement disaster recovery
A. Yes
B. No
View answer
Correct Answer: BC
Question #15
You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements. What should you include in the plan?
A. Configure the Deleted databases settings for ResearchSrvOL
B. Deploy and configure an Azure Backup server
C. Configure the Advanced Data Security settings for ResearchDBL
D. Configure the Manage Backups settings for ResearchSrvOL
View answer
Correct Answer: A
Question #16
You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases. You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss. What should you use?
A. log shipping
B. Always On availability groups
C. Database Migration Assistant
D. Backup and Restore
View answer
Correct Answer: A
Question #17
You have an Azure subscription that contains the resources shown in the following table. App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs. What should you do?
A. Increase the number Of vCores allocated to db1
B. Disable auto-pause delay for dbl
C. Decrease the auto-pause delay for db1
D. Enable automatic tuning for db1
View answer
Correct Answer: D
Question #18
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?
A. locally-redundant storage (LRS)
B. read-access geo-redundant storage (RA-GRS)
C. zone-redundant storage (ZRS)
D. geo-redundant storage
View answer
Correct Answer: B
Question #19
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?
A. DBCC SHRINKDATABASE
B. sp_clean_db_free_space
C. sp_clean_db_file_free_space
D. DBCC SHRINKFILE
View answer
Correct Answer: C
Question #20
Your company uses Azure Stream Analytics to monitor devices. The company plans to double the number of devices that are monitored. You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load. Which metric should you monitor?
A. Input Deserialization Errors
B. Late Input Events
C. Early Input Events
D. Watermark delay
View answer
Correct Answer: A

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.