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

Unlock Success with Microsoft DP-300 Pracatice Questions, Microsoft Azure Database Administrator | SPOTO

Embark on a journey to success with our unparalleled resources: Unlock Success with Microsoft DP-300 Practice Questions, Microsoft Azure Database Administrator | SPOTO. Delve into a vast array of tools 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 designed to equip you with the skills needed to triumphantly pass the certification exam. Explore our meticulously crafted courses and immersive hands-on labs tailored to kickstart your progression towards mastering Azure SQL database expertise. The DP-300 exam stands as a cornerstone of Microsoft's new role-based certification program, serving as an essential milestone in obtaining the esteemed Azure Database Administrator Associate certification. Take the first step towards realizing your certification goals with our comprehensive resources at your fingertips.
Take other online exams
Question #1
This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, whileothers 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 inthe review screen.You have two Azure SQL Database servers named Server1 and Server2. Each server contains
A. Yes
B. No
View answer
Correct Answer: B
Question #2
You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure. Which service should you use?
A. zure SQL Edge
B. zure SQL Database
C. QL Server on Azure Virtual Machines
D. zure SQL Managed instance
View answer
Correct Answer: C
Question #3
You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL database named SQLDB1. You need to replicate DB1 to SQlDC1. Which type of replication should you use?
A. eer-to-pec
B. erge
C. ransactional
D. napshot
View answer
Correct Answer: C
Question #4
You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements: Support failovers that do not require client applications to change their connection strings. Replicate the database to a secondary Azure region. Support failover to the secondary region. What should you include in the recommendation?
A. failover groups
B. transactional replication
C. Availability Zones
D. geo-replication
View answer
Correct Answer: D
Question #5
This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, whileothers 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 inthe review screen.You have an Azure SQL database named Sales.You need to implement disaster recovery for S
A. Yes
B. No
View answer
Correct Answer: B
Question #6
You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?
A. Azure SQL Database Premium
B. Azure SQL Database serverless
C. Azure SQL Database managed instance Business Critical
D. Azure SQL Database Standard
View answer
Correct Answer: B
Question #7
You have a new Azure subscription.You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage,applications that connect to DB1 must be able to connect without having to update the connection strings.Which two actions should you perform? Each correct answer presents part of the solution. Each correct selection is worth one point.
A. From the properties of DB1, configure geo-replication
B. From the properties of Server1, add a failover group
C. Create a new Azure SQL Database server named Server2
D. From the properties of Server1, configure retention for DB1
E. Create a new Azure SQL Database instance named DB2
View answer
Correct Answer: BC
Question #8
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. What should you use to minimize downtime and data loss during the migration?
A. distributed availability groups
B. database mirroring
C. log shipping
D. Database Migration Assistant
View answer
Correct Answer: A
Question #9
This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, whileothers 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 inthe review screen.You have an Azure SQL database named Sales.You need to implement disaster recovery for S
A. Yes
B. No
View answer
Correct Answer: A
Question #10
You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2019 database namedDB1.You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance ofApp1 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?
A. Azure SQL Managed instance
B. Azure SQL Database single database
C. Azure Database for PostgreSQL
D. SQL Server on Azure virtual machines
View answer
Correct Answer: B
Question #11
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table. FactSales has 6 billion rows and is loaded nightly by using a batch process. Which type of compression provides the greatest space reduction for the database?
A. page compression
B. row compression
C. columnstore compression
D. columnstore archival compression
View answer
Correct Answer: D
Question #12
You Save an Azure SCX database named DB1. You need to query the fragmentation information of data and indexes for the tables in D61. Which command should you run? A. B. C. D.
A. ption A
B. ption B
C. ption C
D. ption D
View answer
Correct Answer: A
Question #13
You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.What should you run as part of the implementation?
A. CREATE LOGIN and the FROM WINDOWS clause
B. CREATE USER and the FROM CERTIFICATE clause
C. CREATE USER and the FROM LOGIN clause
D. CREATE USER and the ASYMMETRIC KEY clause
E. CREATE USER and the FROM EXTERNAL PROVIDER clause
View answer
Correct Answer: E
Question #14
You have an Azure subscription that uses a domain named contoso.com.You have two Azure VMs named DBServer1 and DBServer2. Each of them hosts a default SQL Server instance. DBServer1
A. Configure the primary endpoint as TCP://DBServer1
B. Configure the primary endpoint as TCP://DBServer1
C. Configure the primary endpoint as TCP://DBServer1
D. Configure the primary endpoint as TCP://DBServer1
View answer
Correct Answer: C
Question #15
You have an Azure SQL database named sqldb1. You need to minimize the possibility of Query Store transitioning to a read-only state. What should you do?
A. Double the value of Data Flush interval
B. Decrease by half the value of Data Flush Interval
C. Double the value of Statistics Collection Interval
D. Decrease by half the value of Statistics Collection interval
View answer
Correct Answer: B
Question #16
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 duringscaling operations.What should you use?
A. two Azure SQL Databases in an elastic pool
B. two databases hosted in SQL Server on an Azure virtual machine
C. two databases in an Azure SQL Managed instance
D. two single Azure SQL databases
View answer
Correct Answer: A
Question #17
You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. Each correct selection is worth one point.
A. total size of all the databases
B. geo-replication support
C. number of concurrently peaking databases * peak CPU utilization per database
D. maximum number of concurrent sessions for all the databases
E. total number of databases * average CPU utilization per database
View answer
Correct Answer: D
Question #18
You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQLServer tier. All the tiers run on Hyper-V virtual machines.Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability totest failover to Azure without affecting the current environment.What should you include in the reco
A. Azure Backup
B. Azure Information Protection
C. Windows Server Failover Cluster
D. Azure Site Recovery
View answer
Correct Answer: D
Question #19
You have an Azure subscription. You create a logical SQL server that hosts four databases Each database will be used by a separate customer. You need to ensure that each customer can access only its own database. The solution must minimize administrative effort Which two actions should you perform? Each correct answer presents part of the solution Each correct selection is worth one point.
A. reate a network security group (NSG)
B. reate a server-level firewall rule
C. reate a private endpoint
D. reate a database-level firewall rule
E. eny public access
View answer
Correct Answer: CD
Question #20
You have a single availability set that contains two SQL Server on Azure Virtual Machines instances. The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1. You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements: * Provide an availability SLA * Minimize costs. What should y
A. virtual network name (VNN) resource
B. Basic Azure Load Balancer
C. distributed network name (DNN) resource
D. n Azure Standard Load Balancer
View answer
Correct Answer: C

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.