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

Microsoft DP-300 Dumps & Mock Exam for Success, Microsoft Azure Database Administrator | SPOTO

Prepare for success with our comprehensive range of resources including Microsoft DP-300 Dumps & Mock Exam for Success, Microsoft Azure Database Administrator | SPOTO. Our platform offers a plethora of tools such as practice tests, free tests, exam practice, online exam questions, exam questions, sample questions, exam dumps, exam questions and answers, mock exams, and exam materials. Whether you're aiming to familiarize yourself with the exam format or seeking to refine your skills, our latest practice tests can help you succeed in passing the certification exam. Dive into our courses and hands-on labs designed to kickstart your journey towards becoming an Azure SQL database specialist. The DP-300 exam stands as a pivotal component of Microsoft's new role-based certification program, serving as a prerequisite for attaining the Azure Database Administrator Associate certification. Embark on your certification journey with confidence through our comprehensive resources.

Take other online exams
Question #1
05.You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1. You plan to deploy additional instances of App1 to separate Azure regions.Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data SynC. You need to recommend a database service for the deployment. The solution must minimize administrative effort.What should you include in the recommendation?Each correct answer presents p
A. zure SQL Managed instance
B. zure SQL Database single database
C. zure Database for PostgreSQL
D. QL Server on Azure virtual machines
View answer
Correct Answer: b
Question #2
02.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.
A. et Threshold Sensitivity to High
B. et the Alert logic threshold to Dynamic
C. et the Alert logic threshold to Static
D. et Threshold Sensitivity to Low
E. et Force Plan to On
View answer
Correct Answer: bd
Question #3
You have an Azure Data Lake Storage Gen2 account named account1 that stores logs as shown in the following table. You do not expect that the logs will be accessed during the retention periods. You need to recommend a solution for account1 that meets the following requirements: Automatically deletes the logs at the end of each retention period Minimizes storage costs What should you include in the recommendation? To answer, select the appropriate options in the answer area. Each correct selection is worth o
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #4
You have the following Azure Resource Manager template. 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: C
Question #5
You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored You need to ensure that SQ Server Agent jobs running on SQL 1 can notify when a failure Occurs Which three actions should you perform in sequence 7 TO answer. move the appropriate actions from the list Of actions to answer area and arrange them in correct order.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #6
You have 10 Azure virtual machines that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?
A. Automated Backup in the SQL virtual machine settings
B. Azure Backup
C. Azure Site Recovery
D. SQL Server Agent jobs
View answer
Correct Answer: B
Question #7
09.Reference Scenario:click hereYou 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.
A. urn on auditing and write audit logs to an Azure Storage account
B. dd extended properties to the column
C. urn on Advanced Data Security for the Azure SQL server
D. pply sensitivity labels named Highly Confidential to the column
E. urn on Azure Advanced Threat Protection (ATP)
View answer
Correct Answer: acd
Question #8
You have SQL Server on an Azure virtual machine that contains a database named DB1. You have an application that queries DB1 to generate a sales report. You need to see the parameter values from the last time the query was executed. Which two actions should you perform? Each correct answer presents part of the solution. Each correct selection is worth one point.
A. Enable Last_Query_Plan_Stats in the master database
B. Enable Lightweight_Query_Profiling in DB1
C. Enable Last_Query_Plan_Stats in DB1
D. Enable Lightweight_Query_Profiling in the master database
E. Enable PARAMETER_SNIFFING in DB1
View answer
Correct Answer: C
Question #9
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. Each correct selection is worth one point.
A. Turn on auditing and write audit logs to an Azure Storage account
B. Add extended properties to the column
C. Turn on Advanced Data Security for the Azure SQL server
D. Apply sensitivity labels named Highly Confidential to the column
E. Turn on Azure Advanced Threat Protection (ATP)
View answer
Correct Answer: B
Question #10
You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only user who was created is the server administrator. You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication. 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 #11
You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic. What are two results of the configuration? Each correct answer presents a complete solution. Each correct selection is worth one point.
A. In the event of a datacenter or Azure regional outage, the databases will fail over automatically
B. In the event of an outage, the databases in the primary instance will fail over immediately
C. In the event of an outage, you can selectively fail over individual databases
D. In the event of an outage, you can set a different grace period to fail over each database
E. In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour
View answer
Correct Answer: B
Question #12
04.Reference Scenario:click hereYou 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?
A. n Azure SQL Database elastic pool
B. QL Server on Azure virtual machines
C. n Azure SQL Database managed instance
D. zure SQL databases
View answer
Correct Answer: a
Question #13
07.Reference Scenario:click hereYou 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.What should you use to minimize downtime and data loss during the migration?
A. istributed availability groups
B. atabase mirroring
C. og shipping
D. atabase Migration Assistant
View answer
Correct Answer: d
Question #14
03.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. ocally-redundant storage (LRS)
B. ead-access geo-redundant storage (RA-GRS)
C. one-redundant storage (ZRS)
D. eo-redundant storage
View answer
Correct Answer: d
Question #15
You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the secondary replica?
A. Restore with Recovery
B. Restore with Norecovery
C. Restore with Standby
View answer
Correct Answer: B
Question #16
You plan to perform batch processing in Azure Databricks once daily. Which type of Databricks cluster should you use?
A. automated
B. interactive
C. High Concurrency
View answer
Correct Answer: A
Question #17
06.Reference Scenario:click hereYou 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?
A. uery Store
B. etrics
C. uery Performance Insight
D. lerts
View answer
Correct Answer: a
Question #18
You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1. You need to recommend an authentication solution for Pool1. The solution must support multi-factor authentication (MFA) and database-level authentication. Which authentication solution or solutions should you include in the recommendation? To answer, select the appropriate options in the answer area. Each correct selection is worth on
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #19
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 Data Lake Storage account that contains a staging zone. You need
A. Yes
B. No
View answer
Correct Answer: A
Question #20
You have an Azure SQL database named DB1. You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled. During a database audit, you discover that none of the fields contain more than 150 characters. You need to ensure that you can apply page compression to Table1. What should you do?
A. Configure the columns as sparse
B. Change the column type to nvarchar (MAX)
C. Change the column type to varchar (MAX)
D. Change the column type to varchar (200)
View answer
Correct Answer: A
Question #21
08.Reference Scenario:click hereYou 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
A. erver audit specification
B. QL Server audit
C. atabase audit specification
D. server principal
View answer
Correct Answer: ac
Question #22
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 16 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb. What is the total number of data files that tempdb should contain?
A. 2
B. 4
C. 8
D. 64
View answer
Correct Answer: B
Question #23
You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables in Pool1. The structure and data types vary by file. You need to load the files into the tables. The solution must maintain the source data types. What should you do?
A. Load the data by using PySpark
B. Load the data by using the OPENROWSET Transact-SQL command in an Azure Synapse Analytics serverless SQL pool
C. Use a Get Metadata activity in Azure Data Factory
D. Use a Conditional Split transformation in an Azure Synapse data flow
View answer
Correct Answer: A
Question #24
01.You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements. What should you do?
A. reate an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group
B. dd a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event huB
C. dd a diagnostic setting that logs Timeouts and streams to an Azure event huB
D. reate an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group
View answer
Correct Answer: d

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.